Hey quick confirmation... Are the objectids auto-created if I write custom scripts to transfer data from the existing db to the FC db?
On Dec 3, 3:44 pm, tilespace <[EMAIL PROTECTED]> wrote: > 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 -- 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 -~----------~----~----~----~------~----~------~--~---
