Import from Excel bug

[Andy Bowen]

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

[jmuehleisen]

Andy,

This is confirmed as a bug. I've fixed this and the fix will be available beginning in 5.25 beta 8.

Thanks for reporting this one!