Ok cool... Thank you!
On Dec 3, 4:40 pm, "Blair McKenzie" <[EMAIL PROTECTED]> wrote:
> 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 -- 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
-~----------~----~----~----~------~----~------~--~---
