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 ---------------------------------------------------------------------
