Answers.Body: <p>I'm not certain exactly what solved the problem, but its working - I believe the change that made it work came from:</p>
  <p>Administer -&gt; Localization -&gt; Languages, Currency, Locations</p>
  <p>and including states under &quot;Available States and Provinces&quot;</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-10T21:38:30.960Z
Answers.Text: ah right. so you had not enabled the States that you were trying to import. a bit surprised to here that impacts on imports but good to know. guess if it did let you import them, but were disabled, then you would not see the data anyway
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-10T19:25:13.917Z
Answers.LastActivityDate: 2021-08-10T19:25:13.917Z
Answers.UserDisplayName: flantascience
Body: <p>I've got CiviCRM installed on WordPress and am getting this error for almost every contact that I import from a list of 250 contacts:</p>
  <p>&quot;Error when importing contacts: Invalid value for field(s) : State/Province&quot;</p>
  <p>The error is showing up for states which use longform state names &quot;Florida&quot; as well as the abbreviated form &quot;FL&quot;.</p>
  <p>Any idea where I should look to solve this?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-27T19:44:12.290Z
Comments.Text: you say "almost every contact" which seems odd. have you checked that you do not have white space in the data you are importing? Could you convert your values to 1008 (the ID for florida) before you import
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-29T22:26:10.980Z
Comments.Text: I have some cells of my CSV file which are empty.  They show up as "" in the file, so I'm not sure if that's what you mean by whitespace.  I tried the import using "1008" instead of "FL" and got the same "Invalid value for field(s) : State/Province" error.
Comments.UserDisplayName: flantascience
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-30T02:52:09.933Z
Comments.Text: in your db can you access civicrm_state_province field and confirm the expected values for eg Florida are present
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-30T02:52:41.813Z
Comments.Text: by space i meant eg "Florida " ie whitespace before/after the text that would need trimming to get rid of it
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-07-30T02:54:03.443Z
Comments.Text: also do a search in civi of someone in Florida, then export using Primary Fields and confirm what is being exported for the State value
Comments.UserDisplayName: petednz - fuzion
Tags: <wordpress><error><import>
Title: Error when importing contacts: Invalid value for field(s) : State/Province
ThreadText: # Error when importing contacts: Invalid value for field(s) : State/Province
  
  (Asked by: username_0 on 2021-07-27)
  
  I've got CiviCRM installed on WordPress and am getting this error for almost every contact that I import from a list of 250 contacts:
  
  "Error when importing contacts: Invalid value for field(s) : State/Province"
  
  The error is showing up for states which use longform state names "Florida" as well as the abbreviated form "FL".
  
  Any idea where I should look to solve this?
  
  **Tags:** wordpress, error, import
  
  > **Comments:**
  > **username_1**: you say "almost every contact" which seems odd. have you checked that you do not have white space in the data you are importing? Could you convert your values to 1008 (the ID for florida) before you import  
  > **username_0**: I have some cells of my CSV file which are empty.  They show up as "" in the file, so I'm not sure if that's what you mean by whitespace.  I tried the import using "1008" instead of "FL" and got the same "Invalid value for field(s) : State/Province" error.  
  > **username_1**: in your db can you access civicrm_state_province field and confirm the expected values for eg Florida are present  
  > **username_1**: by space i meant eg "Florida " ie whitespace before/after the text that would need trimming to get rid of it  
  > **username_1**: also do a search in civi of someone in Florida, then export using Primary Fields and confirm what is being exported for the State value  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2021-08-10. Score: 2
  
  I'm not certain exactly what solved the problem, but its working - I believe the change that made it work came from:
  
  Administer -> Localization -> Languages, Currency, Locations
  
  and including states under "Available States and Provinces"
  
  > **Comments:**
  > **username_1**: ah right. so you had not enabled the States that you were trying to import. a bit surprised to here that impacts on imports but good to know. guess if it did let you import them, but were disabled, then you would not see the data anyway  
  
  ---
  
  