Tompkins, Hmmmmm. I'm surprised Dave's suggestion didn't work. There may be something else going on here for which an upgrade WON'T help, but in the event you are set on upgrading BEFORE figuring out the problem, here's a quick synopsis (should be accurate but I'm not working through this as I write it so I may be missing a step or so). You don't want to use the built-in import routine as it isn't designed to handle an upgrade - not enough fields, can't match field names, etc. Also, you'll need Filemaker for at least one step before you can use the database:
1. Get a clean copy of ebase. 2. Open it with Master password. 3. Go to the Filemaker menu at top of screen 4. Go to File->Import records 5. In the import dialog, select the names.102 file 6. In the mapping dialog, select matching by field name in the upper right option 7. Make sure the fields line up with each other and are checked for importing. 8. Make sure auto-enter is checked. 9. Go ahead with the import. 10. Click Find All. 11. Scroll to the last record in the database and note the record number. 12. In the new ebase, go into File->Define->Fields (not sure of the syntax for FMP 5) and select the Record Number field. THIS IS THE STEP YOU'LL NEED FILEMAKER FOR. 13. Click on the Options button and in the dialog screen for Auto Enter, enter one or more value higher than the highest record number in your database in the Serial Number option - this will make sure when ebase assigns new record numbers it doesn't try to use one already in use. Also make sure the counter is set to increment by 1. 13. Close out of these dialog boxes. 14. Run the Create Related Records script. 15. Do the same for each of the files in the database, making sure to look for the equivalent "record" number fields in each of the other files - e.g. in the Payments file it's called Receipt Number, in Notes it's Note Number, etc. (not all will have such record numbers, but many do - they are the auto-entered, serial fields). That should do it. Have I forgotten anything here folks? No warranties expressed or implied... Carl [EMAIL PROTECTED] wrote: > > Thanks for the help Dave. Unfortuneatly, the suggestions did not work. > Argh. I would very much like to just upgrade this v102 to a clean v103, > which I imagine would resolve this and other issues. > > Can you suggest the best way to upgrade? When I use the ebase Import > function on a names.102 file, the Import fields are incomplete and I lose > several important pieces. I feel there must be an easier way to upgrade > than using the Import tool. Please suggest. > > Thanks, > > Tompkins > > > Dave Shaw > <dshaw@h4consu To: "TechRocks Support" ><[EMAIL PROTECTED]> > lting.com> cc: > Subject: [support] Re: Disappearing >Email Text in Preview > 10/31/2001 > 06:03 PM > Please respond > to "TechRocks > Support" > > > > >I'm experiencing a problem using the email function of ebase v.102. Below > >are details. > > > >- I create my "found set" of records to contact via email > >- I select Output, Email > >- After clearing the PS & CC fields, I select the first option to "Create > >text from scratch" > >- I type the subject, body, postscript and CC text, then click PREVIEW > >- On PREVIEW, the body text is not there, it has disappeared. > > Very good job of explaining what you have done. > > >How do I fix this so that the text appears in preview mode? > > Unfortunately, when I do what you specify above, the body text is > visible. I can click back and forth between the Edit and Preview and > the text is visible both ways. Here's my best guess on what's > happening. > - when you type the body text into the email layout, you are typing > into a global field, which is in the names file and is common to all > records. > - when you click Preview, the body text is copied into a field in a > related file, custom_.102, in records related to the found set of > names records. > - my guess is that at some time you imported a bunch of records > incorrectly. When you use the ebase import procedure, the related > records in the custom, profile, and summary files are created as part > of the process. When you use FileMaker's import tools rather than the > ebase procedure, these records are not created. So, there is no > related record in the custom file to copy the body text into. > > I can reproduce what you have described by adding a record to the > names file incorrectly, so I'm pretty confident that's what is wrong. > Here's how to fix it. > > - Go to the home screen > - Hit the gray Find All button to select all the records in your file > - Select the menu item Scripts>Check for Related Records. This will > run through your entire file, and if the related records in custom, > profile, and summary don't exist, they will be created. > - Now try typing an email body text as you describe. > -- > -- > 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 > --------------------------------------------------------------------- > > ------------------ > 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 > --------------------------------------------------------------------- -- Carl Paulsen New Hampshire Rivers Council 54 Portsmouth Street Concord, NH 03301 603-228-6472 603-228-0423 Fax [EMAIL PROTECTED] ------------------ 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 ---------------------------------------------------------------------
