Enhancements

Option to add city, state, and country from Admin panel

Context: Currently there is a dependency on the sustenance team to add city, state and country data to masters.

Solution: A new page (Admin cPanel -> Administration -> City Master -> City data upload) has been added to Admin cPanel to upload city, state and country data.

• There are options to choose and upload the file here. 

• Format is .xlsx with 2 sheets

  • Sheet 1: City, State, Country in base (English) language

  • Sheet 2: Multilingual translation of city, state, country

Sheet 1: English language:

• The columns in the table are as follows:

  • City

  • State

  • Country

  • State Code

• The hierarchy to be followed while uploading the file are as follows:

  • Country

  • State along with the State Code

  • City

• Validation pointers for upload:

  • Cannot upload a new state along with a new country at once, likewise for a new city.

  • For a state to be added, the corresponding country must exist already. Likewise for a city to be added, the corresponding state and country must exist already. 

  • If the higher hierarchies are satisfied, then the next level can be uploaded in bulk with multiple rows.

Sheet 2: Multilingual translation:

• The columns in the table are as follows:

  • City

  • State

  • Country

  • Language code

  • City translation

  • State translation

  • Country translation

• The first three columns are always in the base language (English).

• The last three columns will be the corresponding city, state, country translation based on the language code in the 4th column.

• Supports multiple uploads for city, state and country at the same time without hierarchy checks.