>The Filemaker I am running ebase from is version 4.1v1. So, does this mean >Carl's solution won't work?
I think we have messages crossing in the ether, but I want to be sure you got the exchange between Carl and me where he catches me talking before thinking. Carl's solution does work - ebase has built in the complicated set field script I talk about and will do what you need. > >Thanks, Kathleen >----- Original Message ----- >From: "Dave Shaw" <[EMAIL PROTECTED]> >To: "TechRocks Support" <[EMAIL PROTECTED]> >Sent: Friday, October 11, 2002 8:43 AM >Subject: [support] Re: National Change of Address > > >Carl, that's inspired, I had been thinking of the import\update, but >hadn't thought it through to using the ebase import routine to >update. I'll add, since Kathleen didn't mention in the original post >which version of FileMaker she is using, that the import\update >feature is not available on version 4. If she is using 4 it would >still be possible to get the data in to ebase, but it would be way >more complicated, using a relookup or a script with set field steps. > >>If you can include your ebase record number field in the tab >>delimited export, and that field can be returned to you, you can >>then simply reimport the data back into ebase using the ebase import >>routine. When you do the dupe check with the existing ebase data, >>check for dupes based on record number. Then, make sure all the >>import records come up as dupes, spot check several of the records >>to make sure they truly match up properly, and set all records to >>Update. For the last step of the import, make sure the radio >>buttons for the Update records are set to replace the ebase address >>data for address/delivery, address secondary, city, state/province, >>zip, zip +4, etc. (check the "Y" option, not "N" or the only if >>empty option). Do the import. This should leave the existing >>records intact and only update the fields you specify (the address >>fields). Payments and other data will remain attached to the proper >>records. >> >>Oh, and one more thing, make sure to make a backup before doing the >>import, so you have an up-to-date file to return to if anything goes >>awry... >> >>Carl Paulsen >>8 Hamilton St. >>Dover, NH 03820 >>603-749-2310 >>[EMAIL PROTECTED] >> >> >> >>Kathleen Ackley wrote: >> >>>I would like to get our database updated with the National Change of >>>Address Service. However, I am a little confused about how I am going to >>>get that information back into Ebase. I will be providing them with a >>>typical tab-delimited file that only contains the address information for >>>our members. They will update it and send it back to me. Then, how do I >>>take that file and update Ebase? Must I do it manually? What have other >>>folks done? Thanks! >>> >>>Kathleen >>> >>>------------------ 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.unsub%% >>>--------------------------------------------------------------------- >>>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.unsub%% >>--------------------------------------------------------------------- >>ebase - Relationship Management for Nonprofits, http://www.ebase.org >>--------------------------------------------------------------------- > > >-- >-- >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.unsub%% >--------------------------------------------------------------------- > 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.unsub%% >--------------------------------------------------------------------- > ebase - Relationship Management for Nonprofits, http://www.ebase.org >--------------------------------------------------------------------- -- -- 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 ---------------------------------------------------------------------
