Add states in kentico cms_state table

Sultan Ahmed asked on December 4, 2017 10:31

Hi All,

Kentico has country and states table created by default and countries table has all countries data where as states table i.e CMS_State has data only for only USA states, do any one has scripts or any data so that we can utilize those for adding all states with respect to country in kentico(for me presently Canada and Australian states are required)

Kentico states table columns are

StateDisplayName, StateName, StateCode, CountryID,StateGUID,StateLastModified

Any help/suggestions are much appreciated.

countries state

Recent Answers

Jan Hermann answered on December 4, 2017 13:24

You don't have to insert anything to database directly. Just navigate to Countries application, edit the country you need to add states to and switch to States tab.

0 votesVote for this answer Mark as a Correct answer

Sultan Ahmed answered on December 4, 2017 13:40 (last edited on December 4, 2017 13:46)

@Jan Herman thanks for your response, You mean for each country if we want to add states then We need to go to receptive country then switch to states tab and then and add all of its states one by one through UI. It would be very time taking process if we need to add states for each country.

Can their could be any other approach so that we can save time and do it faster.

0 votesVote for this answer Mark as a Correct answer

Jan Hermann answered on December 4, 2017 13:55

Oh, I thought you didn't know about the UI approach. Of course if you need to import many states for many countries you can do it either by an SQL script, using our API in some foreach loop or using the Kentico Import tookit you have installed together with your Kentico.

0 votesVote for this answer Mark as a Correct answer

Sultan Ahmed answered on December 6, 2017 07:20

So we need to collect data of states and add by either of options listed above. It would be help full if we have any such script file or export version of that data. If anyone has any such can post here.

0 votesVote for this answer Mark as a Correct answer