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 > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
