Creating a new contact with State

SHANE EBERT asked on December 29, 2017 21:59

Hello, when I create a new contact in Kentico 10, I put in "Wisconsin" for the state and it gives me an error saying it needs an "interger number." Is there a number/id that Kentico recognizes for each state?

contact management

Correct Answer

Trevor Fayas answered on January 2, 2018 15:42

Sadly you'll probably need to replace "Wisconsin" with the actual state ID.

To find the state IDs, you can go to Reporting in Kentico, and create a report with a Table that has the SQL of

Select StateID, StateDisplayName from CMS_State order by StateDisplayName

This will give you a table you can reference the proper StateID for the given state.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Trevor Fayas answered on December 30, 2017 07:08

It's a reference to the CMS_State table, so yeah there's an ID that associates with the State.

What form are you entering this into? It should probably be replaced with a state selector (like a drop down).

0 votesVote for this answer Mark as a Correct answer

SHANE EBERT answered on January 2, 2018 15:38

The place where I am having the biggest issues is when importing contacts with a file that has a column for a state.

0 votesVote for this answer Mark as a Correct answer