The createData (takes properties as a struct) function will create the objectid if the property struct doesn't already have it. setData is the same as 'update', and expects an objectid.
The database itself won't automatically populate the objectid field. Blair On Dec 4, 2007 11:00 AM, tilespace <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
