2

I have a mailing list of about 1,500 names. I have imported them into CiviCRM using a CSV spreadsheet file. The country field for all these names in my spreadsheet are all labeled United States. A good portion of my addresses after the import into CiviCrm are now listed as another country. Some show South Africa, etc. I've tried the import several times to no avail, but my original list is correct.

Any suggestions how to fix this? Thanks

Mark

|improve this question
3

(You're relatively new here BTW so welcome!) It sounds as though your import sheet did not specify a country, but your site allows for multiple countries and thus multiple states/provinces. Even if the United States is your default country, I've found that the import routine will pick the first country it finds in the list of countries with similar state abbreviations, rather than hitting the correct one. The workaround to this is pretty simple; include a column for country in your import and populate it with United States (or the appropriate country).

Hope this helps!

|improve this answer
  • yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-) – petednz - fuzion♦ Dec 12 '18 at 21:50

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.