>I have imported my legacy files from my old ebase on an old computer >into my new ebase on my new computer. When working with the >imported data before moving it into ebase the "Record ID"s matched >up with the "Serial #"s. And the Record ID was imported. I went >ahead and moved the import into ebase. When I open my names file in >ebase the numbers are one off. When I go to Home or Data Entry the >"Serial #" now reads "2" for the record which has record ID "1" >because of the Dummy entry which exists at the start of the new >program. >We use these record ID's actively so it would be a bit of a pain to >change all the numbers to one higher. > >Is there a way to import the data so that it will write over this >Dummy entry? I deleted it before I imported but it obviously >"remembers" that it was there. > >Or is there a way to change this serial number now so it will >correspond with the Record Number? I can not currently find out >where to see the Record ID number. >Please help. Thanks
The normal ebase import process stores your existing record number in a field called "Legacy ID" and assigns a new record number consistent with its internal system. It has to do this in order to avoid importing record numbers from various sources that are duplicates of records already in the system. The issue isn't writing over the dummy entry. ebase doesn't infill unused numbers. When you deleted the dummy record the auto-enter number for new records was still set at 2. I don't know how much of a pain it would be to change the usage of record number, but I suspect it would be less than changing the number. You would need to delete the dummy record, change the auto-enter index on the record number field, and import records again. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
