>Hello, > >Thanks so much for your advice and help. > >I have read through the archives about re-setting the auto-enter >index but I am still unclear as to exactly WHERE I find this and >WHEN I reset it in the process of importing and WHAT I re-set it to.
Where -- is in the define fields dialog box. Select the menu item File>Define Fields, select the field Record Number and click the Auto-enter tab. You can enter a number there for the next number to be assigned. When -- is any time before you import the new records. What -- is usually one higher than the highest number already in your database. In your case, since it's a new data set, you'll want to set it to the lowest number to be assigned - 1? One caution just occurred to me. The process will assign serial numbers in sequence. If your existing record numbers aren't sequential, that is if there are gaps in the sequence, the resulting ebase record numbers won't match. Also, the records in the source file must be sorted in sequence for the numbers to match. These complications are what I had in mind when I said in a previous post that it would be troublesome to match the numbers. >I would like to get the LEGACY RECORD NUMBER to match the displayed >RECORD (serial) NUMBER on the screen in the new version. I will >start with a fresh copy of the 1.03 ebase files and import my legacy >names file again. >WHERE do I find the place to change the auto-enter index? Can you >please give me a step by step? The archives you found should have detailed instructions on how to do each of these steps. >WHAT do I change it to in this case? Do I change it to start with 1 >or with 0? what ever you want the number of your first record to be. >WHEN in the process do I change it? My idea is to open the names >file in my fresh version of ebase and delete the dummy record. Then >I would go to the auto-enter index (following your answer to the >question above of WHERE this is) and change the index number and >then go to the ADMIN screen and go through the import process. When >I move the imported file into ebase do I have checked or un-checked >the box regarding the auto-enter status. (I can't remember the >exact wording of this dialogue box.) Check it, so the auto-enter process happens. >Assuming that this import and move is successful I will then import >my payment records into the payment file. Do I need to go through >this auto-enter change again? If yes, is it the same process? No, ebase matches the payment import to the legacy id, and assigns correct record numbers based on that match. -- -- 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 ---------------------------------------------------------------------
