Admin Right Menu > Country > Load Address Data.
JS Jobs provides interface for loading address data (cities and states) into database using SQL files.
This portion has a back link that takes to control panel, page title and right menu button.
This portion has JoomSky logo and download button that can be used to get address data files from Joomsky.
This portion has fields that can be used to manage diffrent aspects of data import. The fields are Action: this field has two options keep data and discard data. Keep data means the existing cities and states will remain in the tables, discard data means existing cities and states will removed before inserting data. File: This field is used to specify which file is gonna be used (joomsky file or some other). Data Contain : This fields specifies what the file contains (what you want to insert/update), the options are cities, states and city & states File *: This field is used to specify the file that will be used for loading data.
This portion has 'Load Address Data' button, after data file has been selected a click on this button will populate (update) tables in the database.
if user has changed country ids from database there will be unexpected results.