My first time trying to import CSV data into CiviCRM. The data looks something like the below (changed to not reveal actual names etc). The lines in bold are not importing.
I am guessing that in first failure (Allan Nori) the city (Boise /Hiroshima) and the country (United States / Japan) are causing the problem. In the second, probably the state/province (British Columbia (BC)). And in the third, the state/province (Maryland & District of Columbia (DC)).
For the middle one, I guess I can just eliminate the part in parenthesis ((BC)), although it might be nice if the contact would also come up on searches for BC.
I'm not sure about the best way to handle the other two. In the first case, the person lives part of the year in Boise, Idaho, and part of the year in Hiroshima, Japan. In the other, Chevy Chase is actually in Maryland, but the person also wants to come up on searches for District of Columbia (or DC).
Any advice on the best way to handle such situations would be appreciated.
(By the way, these are not all the columns. I do have email and other data in other columns, but I don't think those are important for this issue.)