Phil,
What version of ebase are you using? There was a bug in the Replace All
Find Fields script in v.1.00 and 1.02. I'll post the fix below in case
that's the case. Version 1.03 should have fixed this bug:
First, check to see if you have this problem. Get into ebase using your
master password. Once you're on the HOME screen, select
File->Define->Fields. Double-click on the field named "SUM::Current
Fiscal
Year". You will see a "Specify Calculation" dialog box appear.
The correct calculation for this field is as follows:
If( Month(gToday) >= setup::Fiscal Year Number and setup::Fiscal Year
Number > 1, Year(gToday) + 1, Year(gToday))
If the calculation for your field reads differently, you should correct
it. After doing so, you should run the "Replace All Find Fields"
script,
leaving the date blank so that it runs for your entire file.
Carl
--
Carl Paulsen
New Hampshire Rivers Council
54 Portsmouth Street
Concord, NH 03301
603-228-6472
603-228-0423 Fax
[EMAIL PROTECTED]
Phil wrote:
I have imported 44,000 names and 125,000 payments into ebase. I can't
get
the Find Fields to update, even after running the UPDATE ALL FIND
fields
script (several times.) The fields seem to update OK when I view the
payment screen for a member, or if I use the script to UPDATE CURR
FIND
fields.
Grrrr. Can't really use the system without these fields. Is it
something
to do with post/start/modified dates?
Any help would be greatly appreciated.
Thanks,
Phil
------------------
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
---------------------------------------------------------------------
