If you used the standard import routines built into ebase (Admin->Screen
2-> ) *and* you mapped your ID from your legacy database, then the old ID
is stored in the names_.10x field named "LegacyID". You can create a
relationship from names_.10x to the legacy database based upon the
"LegacyID" field in names_.10x matching the ID field from your legacy file;
name the relationship "Legacy".
Now that you have this relationship, get to the "Activist" screen. Hit the
"Find All" button. Now, place your cursor into the "Activist?" field and
select Scripts->FMPro Replace Command. Replace with the Volunteer Y/N
field from the relationship named "Legacy". Next, do likewise with the
memo field.
This is really kind of cool because you're driving the replacement from the
names_.10x file, but you're actually replacing data in the profile_.10x
file with information in the legacy file.
>We have been using ebase for two months now. There is some information in
>our legacy database that I did not import when we first set up because it
>was not critical and I wanted a better understanding of how it might fit.
>So what we have in the legacy database is a volunteer y/n field and a
>volunteer memo field that is a history of the member's volunteer efforts
>over the years. I thought (late on Friday night!) that it might be possible
>to import those fields into the "activist?" and "volunteer activist memo"
>fields on the activist page. I backed up the database and spent some time
>trying this. Our legacy data is also in filemaker. I didn't have much luck
>and had to go back and undo what I did do. I was using address and names as
>matching fields. Record numbers no longer match up between the current and
>the legacy databases so those can't be used. And of course what I'm trying
>to do is import into the profile module not the names module, and there
>aren't really any good record markers like name, address, or record id in
>the profile module to insure that the new information is getting dropped in
>the right place. Does anyone have any advice about how to handle this? I
>would really like to be able to see who is volunteering this year and which
>project they are working on or have worked on in the past. I suppose we
>could resort to manual data entry but that seems so unadventurous. Is my
>only option to use the user fields and the custom layout?
>Thanks for your help.
---------------------------------------------------------------------
Jack Noll - ebase consultant and wildlife advocate
Check out a *great* program at www.beardogs.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
---------------------------------------------------------------------
