>Let me see if I understand your recommendation - >1. I use the Export command to export every file in ebase.
The export command affects only the found set. You first need to be sure that every file has a found set of all records. Open every file and hit the Find All button before exporting the data. Note that exporting to a "merge file" will be most useful, because the filenames are exported with the data, making the import step much easier. >2. I have NO .103 files listed in my ebase files. For example, my names >file is listed as names_ -- and the oddities are all listed as >names_103converted. The file that has my data is the names_ one. >QUESTION: So, do I just eliminate all the files in the ebase files folder? Walt's previous message deals with seeing the filename extensions. Once you are done with this process, of migrating the data to a new ebase file set, just drag the entire directory with the faulty files to the recycle bin. >3. I download empty ebase .103 files from the web site. >4. I import all the files I exported. If you have exported to a merge file, you can just select the "matching names" option when you import to get the right data into the right field. You will have to create matching field in your new files for any fields you have created in your ebase file set. >5. I reset the last serial number used in each file >QUESTION: How do I reset the serial numbers? Never heard of them. You said >details are in the archives. Do you mean the message archives. > Here's a procedure I saved many moons ago to import info from v100 to v102. In your case just substitute "old files" for v 1.00, and "new files" for v1.02. ----------------------------------- You must import the information from v1.00 into v1.02 for the following files: names_ custom_ profile_ summary_ actions_ contact_ deleted_ notes_ paymnts_ pledges_ solicit_ srcdefs_ staff_ zip_ To do this, I'd first open v1.00. Then, do a Find All in each of the above files (when you import from a Filemaker file, you only get the records that are in that file's current found set). If one of the files that you need isn't open, then open it using the File->Open on Filemaker's horizontal menu. When navigating from one file to the next, use the Window pulldown on Filemaker's menu. DO NOT USE THE EBASE SCRIPTS AND BUTTONS TO GET FROM ONE FILE TO THE OTHER. You may wind up changing your found set in one of the files for which you've already found all records. This would not be good. Next, open v1.02. Import into each of the above files from the corresponding v1.00 file based on matching field names. Make sure that the "Perform Auto Enter" option is NOT checked. Now you need to reset the serial fields that exist in certain files. The files and their corresponding serial fields are: names_ Record Number paymnts_ Receipt Number actions_ action number notes_ note number contact_ contact number pledges_ pledge key staff_ staff id number To reset these fields, you need to first know what the highest value is. Each of these files has a layout named "All Fields"; get into Layout Mode, navigate to that layout, get into Find Mode, place your cursor into the appropriate serial field and select Edit->Paste Special->From Index. You'll see a list of every index entry. Go to the bottom of the list and write down that number. Now, select File->Define->Fields and select the appropriate serial field. Click Options. On the Auto-Enter tab, you'll see the next value. Manually enter the correct number (the number you wrote down plus one). Perform this sequence for each of the files/fields listed above. -- -- 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 ---------------------------------------------------------------------
