Walt and Dave, THANK YOU so much for the hand holding. It's just what I need to begin the process.
I unchecked the box that kept the file name extensions from being displayed. I have files with TWO different extensions. the names_ type files have the .103 extension. the names_103converted type files have the .fp5 extension. I'll get myself another cup of coffee (for the process and the rainy rainy rainy weather we're having today in the marvelous Pacific Northwest) and forge ahead with your recommendations. I think I can sort it all out. Thanks for clarifying! Any further words of wisdom before I begin? Marion > >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 ---------------------------------------------------------------------
