Can any one please guide me on how to upload the countries, states and cities. There is a option to choose the file but couldn't understand in which format I need to upload it and also which file (.xls, .csv).
System need sql format file i.e
INSERT INTO `#__js_job_cities_new` (cityName,name,stateid,countryid,isedit,enabled,serverid) VALUES ('City Name','City Name',State ID,Country ID,1,1,0)