Import from Excel bug
Posted: Fri Jun 04, 2004 5:24 pm
There's an error in the "Import from Excel" routine. It occurs when you are mapping the fields. The 16th and 17th fields of the source file (that is, the top two in the right-hand column) automatically map to the same Donor Manager field.
Say your 16th field is "Business Phone #." You map it to Donor Manager's "Work Phone" field. Your 17th field is "E-mail Address" so you map it to the "E-mail" field of Donor Manager. But when you do the import, field #16 will automatically set itself to "E-mail" as well. So in the end, you'll lose all your email addresses in the import because Donor Manager's Email field will contain all your business phone numbers. (Apparently whichever one is first in the list is the one that gets respected by the import routine.)
Say your 16th field is "Business Phone #." You map it to Donor Manager's "Work Phone" field. Your 17th field is "E-mail Address" so you map it to the "E-mail" field of Donor Manager. But when you do the import, field #16 will automatically set itself to "E-mail" as well. So in the end, you'll lose all your email addresses in the import because Donor Manager's Email field will contain all your business phone numbers. (Apparently whichever one is first in the list is the one that gets respected by the import routine.)