[support] RE:Names

Fri, 09 Feb 2001 08:36:03 -0800

Title: [support] RE:Names
Dear Mr. Daniels,
 
Thank you for your suggestion.  I will give that a try.
 
Sincerely,
 
Lori A. Rianda
Big Brothers Big Sisters
 
-----Original Message-----
From: Walt Daniels [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 8:04 PM
To: TechRocks Support
Subject: [support] RE:Names

Pick some other text field that you don't currently have any data in to use as a temp for the three way swap. Possible candidates are salutation or ctry. You didn't mention what wound up in middle name - perhaps that is unused. Perhaps you don't use name2 fields at all. The status field is another text field that almost certain has nothing in it.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Shaw
Sent: Thursday, February 08, 2001 8:03 PM
To: TechRocks Support
Subject: [support] RE:Names

Dear Dave,
 
Thank you for your response.  Unfortunately, we do not have FileMaker.  Will I need to re-import all the data?

Yes, it sure looks like it.

Regrets,


 
Sincerely,
 
Lori A. Rianda
Big Brothers Big Sisters

-----Original Message-----
From: Dave Shaw [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 7:22 AM
To: TechRocks Support
Subject: [support] RE:Names
To whom it may concern,

 
I have a question regarding the recent import of data into our new e-base program.  It seems that all the files
are listed as last name first. 

Do you mean "fields" not "files"? That is, each file (names_.102, for example) has records for all the folks you expect, but in each record you are seeing the last name where the first name belongs and vice versa.
Is there a way of correcting this without going back and re-importing all the data?

 

If that's the case, the data is in the file, just in the wrong place. This can be corrected with three uses of the FileMaker Replace command. It will need FileMaker, though, not just the runtime.
- Back  up your files in case something goes awry.
- Create a new temporary field
- Use FileMaker's Replace command to copy the first name into the new field in all records
- Use it again to copy the last name into the first name field (overwriting the existing first name data)
- Use it again to copy the temporary field into the first name field
--
Dave Shaw     Northwest Classics, Inc
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------

--
Dave Shaw    Northwest Classics, Inc
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------

Reply via email to