Answers.Body: <p>You MUST un-set the “Default Country” on the Administer &gt; Localization &gt; Languages, Currency, Locations page before importing non-US addresses. Unsetting this value (which I had set to United States) allow the import to proceed without getting the error. This seems like a bug in the import module (?).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-27T02:39:04.153Z
Answers.LastActivityDate: 2022-11-27T02:39:04.153Z
Answers.UserDisplayName: Mark
Body: <p>I'm importing contacts from a legacy system and am running into a wall importing addresses from non-US countries. For instance, for Canada, I'm trying to import a Canadian province. I've tried both the full name and the two-character abbreviation (e.g. &quot;Saskatchewan&quot; or &quot;SK&quot;) and neither works. I have confirmed that the provinces are correctly included in the civicrm_state_province database table. The import error states:</p>
  <pre><code>Invalid value for field(s) : State
  </code></pre>
  <p>What am I doing wrong?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-12-01T13:15:32.210Z
Comments.Text: This sounds like a bug. If you can provide steps to reproduce, ideally with a small sample file, please open an issue on https://lab.civicrm.org/dev/core
Comments.UserDisplayName: bgm
Tags: <import>
Title: Issue importing state/province from non-US countries
ThreadText: # Issue importing state/province from non-US countries
  
  (Asked by: username_0 on 2022-11-27)
  
  I'm importing contacts from a legacy system and am running into a wall importing addresses from non-US countries. For instance, for Canada, I'm trying to import a Canadian province. I've tried both the full name and the two-character abbreviation (e.g. "Saskatchewan" or "SK") and neither works. I have confirmed that the provinces are correctly included in the civicrm\_state\_province database table. The import error states:
  
  ```
  Invalid value for field(s) : State
  
  ```
  
  What am I doing wrong?
  
  **Tags:** import
  
  > **Comments:**
  > **username_1**: This sounds like a bug. If you can provide steps to reproduce, ideally with a small sample file, please open an issue on https://lab.civicrm.org/dev/core  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-11-27. Score: 4
  
  You MUST un-set the “Default Country” on the Administer > Localization > Languages, Currency, Locations page before importing non-US addresses. Unsetting this value (which I had set to United States) allow the import to proceed without getting the error. This seems like a bug in the import module (?).
  
  
  ---
  
  