Thanks Scott and Jake. I will look into this now and let you know how we fair.
On Jan 23, 11:24 am, "Jake Churchill" <[EMAIL PROTECTED]> wrote: > The types.cfc which you should have extended has a CreateData() function > which essentially assigns a new object ID. I often create a custom script > that reads in the file and inserts records one by one. Use the CreateUUID() > function to generate a new object id > > _____ > > Jake Churchill > Team Leader > 11204 Davenport, Ste. 100 > Omaha, NE 68154http://www.cfwebtools.com > 402-408-3733 x103 > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > > Behalf Of Jeff > Sent: Wednesday, January 23, 2008 10:21 AM > To: farcry-dev > Subject: [farcry-dev] Importing Excel records into new SQL table (Need > ObjectIDs) > > We created a new database table via adding a new type (.cfc file). > We've also created the associated admin form in farcry so that add/ > edit records. However, for the initial population, we want to import > the 134 records into the SQL table from Excel via Enterprise Manager. > If we do this, each record will not be assigned an ObjectID. Is there > a way to manually generate ObjectIDs? Or better yet, does farcry have > a way to import new records into a new database table? > > Thanks. > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.19.9/1238 - Release Date: 1/22/2008 > 8:12 PM > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.19.9/1238 - Release Date: 1/22/2008 > 8:12 PM --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
