CiviCRM Community Forums (archive)

Whenever I do an import, some contacts end up with foreign countries and cities in the address, even though the zip code was correctly imported. Is there any way to automate fixing this data?

sorry, yes, I mean the country and state are wrong. The city and zip code are correct, so it is easy to fix the problem after the fact...but not when you have thousands of records and are not sure how long this problem has been going on.

Here is an import I just did. The import data (sanitized with xxx to replace identifiable stuff):

"Company","Address","City","State","ZIP Code","Country","Phone","Fax","Title","First Name","Last Name","E-mail Login"

"xxx","1234 xxx","Jackson","TN","38302-0700","","xxx-xxx-xxxx","xxx-xxx-xxxx","Manager","John","Smith",""

The resulting imported record has John Smith living in:
City, State, Postal, Country
Jackson, Tājūrā' wa an Nawāhī al Arbāh, 38302-0700, Libyan Arab Jamahiriya

i suspect your easiest option is to delete all the newly imported contacts. Add a country field to each line of the import file and repeat the import process

lobo

Ah, I see now.  I don't typically run into this problem because I start by not enabling any countries (besides US) and then enabling them selectively based on the errors I get during import.  In your case, Civi saw the "TN" for state, didn't know the country, and picked the first state it had with a "TN".

Do you have an easy way of identifying these records?  You can fix the country by exporting the IDs, opening it in LibreOffice Calc (or Excel) and adding a second column "Country" and filling it with "United States", then doing an "Update" import.  However, I can't think of an easy way to fix the state - unless you still have the original import records, and can correlate the "broken" contacts with the original import?  If so, just reimport the matching field (probably external identifier or e-mail address), the state, and the country.  Use an "update" import.  And of course, test on a dev server