Timeline for Error when importing contacts: Invalid value for field(s) : State/Province
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 10, 2021 at 19:25 | answer | added | flantascience | timeline score: 2 | |
| Jul 30, 2021 at 2:54 | comment | added | petednz - fuzion♦ | 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 | |
| Jul 30, 2021 at 2:52 | comment | added | petednz - fuzion♦ | by space i meant eg "Florida " ie whitespace before/after the text that would need trimming to get rid of it | |
| Jul 30, 2021 at 2:52 | comment | added | petednz - fuzion♦ | in your db can you access civicrm_state_province field and confirm the expected values for eg Florida are present | |
| Jul 29, 2021 at 22:26 | comment | added | flantascience | 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. | |
| Jul 27, 2021 at 19:44 | comment | added | petednz - fuzion♦ | 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 | |
| Jul 27, 2021 at 19:36 | history | asked | flantascience | CC BY-SA 4.0 |