Genius! Thanks. It took some working finding all the files which required
the automatic serial number modification; however, once I fixed each file,
the new version is working beatifully.
Thanks Dave, Carl & Walt for your assistance.
Carl Paulsen
<c_paulsen@nhr To: "TechRocks Support"
<[EMAIL PROTECTED]>
ivers.org> cc:
Subject: [support] Re: Disappearing Email
Text in Preview
11/01/2001
01:51 PM
Please respond
to "TechRocks
Support"
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
