Thank you, Holly,
I think I understand, and I'll try it later today.
So what are the ebase update and replace commands for? Do I need FMP to do
the FMP update command, or is it somewhere in ebase that I don't see?
Later, I plan to export ebase data to .csv files for an NCOA update. Which
command would I use to import the new data?
Thank you,
Andy
-----Original Message-----
From: Holly Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 7:33 AM
To: TechRocks Support
Subject: [support] RE: importing legacy from multiple files
Andrew -
I've been through this same issue. When ebase says "update," it doesn't
mean update the way FileMaker means update. That's because when ebase was
created, FileMaker didn't have an update feature. You can't add information
to specific fields to exisiting records this way.
However, if your separate files contain information for the same unqie
individuals, and in the same order (i.e. the phone number for Bob Smith
appears in sequentially in the same place as Bob Smith's Address), you can
use the FileMaker update feature. It's a strikingly similar process to
importing through ebase, but you won't get to check your data before it's
moved into the database, once you import it, it's in there. So be careful.
And, you should continue to use the ebase import functionality when
importing new records, so that they get unqie ebase IDs and all the proper
data is stored in the proper tables.
Let me know if you want more specifics for using the FileMaker update
feature.
Holly Ross
TechRocks
Consultant
212.812.4293
f) 202.318.0577
mailto:[EMAIL PROTECTED]
http://www.techrocks.org
> -----Original Message-----
> From: Andrew Ziem [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 12:00 AM
> To: TechRocks Support
> Subject: [support] importing legacy from multiple files
>
>
> Hi,
>
> I'm having a problem. =) I want to import legacy data that's split in
> several files: names, addresses and phone numbers.
>
> I've imported the names succesfully. They still are in the import menu
> and haven't been moved in with the main records. How do I update the
> address fields (which are blank now) with the files from the address list?
>
> I ask ebase to import a file: I set it to update, identify the address
> list file, set the mode to "update" (not "add new recorsd"), setup the
> fields (including the Record ID field), and go. It doesn't work.
> Afterwards, all the records' address fields are still blank.
>
> I tried both the "update" and "replace" mode. Neither helped.
>
> Should I move the names into the main records and then add the addresses?
>
> Thanks!
>
>
> Andy
>
> ------------------
> 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
---------------------------------------------------------------------
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
------------------
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
---------------------------------------------------------------------
