Hmmmm... Yeah that's what I was afraid of... And yes it's non-FC data that I need to put into the FC db...
Ok, thanks Blair! On Dec 3, 3:29 pm, "Blair McKenzie" <[EMAIL PROTECTED]> wrote: > I take it the data is non-farcry? I've had to do this in the past and it > came down to a set of cf scripts to do the transformation process. Get old > data in a query, loop over records, create new structs, save to FarCry. The > advantage of this approach is that all of the system properties are > automatically populated. > > If the data set is particularly large you could also use SQL scripts, but > you would have to manually set system properties and create a function for > generating unique UUIDs for objectid. > > Blair > > On Dec 4, 2007 9:24 AM, tilespace <[EMAIL PROTECTED]> wrote: > > > > > > > Hello - > > It's me :) We've finally finished the site and have spent a week > > testing it (developers and data entry people) and everything's cool. > > We're now at the point where I'm at a loss - importing existing data > > (about 3 years worth) from a custom MSSQL database into the FC > > database. Obviously none of the fields in the live db are as straight > > forward as the FC db so has anyone come across this yet? Is there a > > tool or sumtin that we could run or do we need to do it by hand (via > > the export wizard)? > > > Any suggestions would be welcomed! > > > Oh! The data is such as this: > > Page data > > Custom types data (which will be populated by multiple tables in some > > instances) > > Etc- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
