Click for sample file

The City Import can be used to add cities to the system.

The City Import is available at the system level. To run a system level import, click on the Configuration tab and locate the Import Data menu item under the Import / Export menu group.

The City Import allows users to mass create Cities for one or more countries.

The import file must be a comma delimited(.csv) file. An excel file can easily be saved as a comma delimited(.csv) file by selecting the File >> Save As option and changing the Save As Type field to “CSV (Comma Delimited) (*.csv)”. The import file must follow the exact order as presented below; if this order is not exact the import will be unsuccessful.

Every row in the file will have the same number of columns. If an error occurs on any row, the City will not be created. The import screen will display any errors that occur and will provide record counts for the number of rows processed (attempted) and number of rows succeeded.

The import file should have 3 headers and the data should be formatted as shown below. The country and state/province names must match the values in the Equus Platform. The names can be validated by reviewing the Countries screen located on the Configuration tab. If the names do not match, the import will error.

You may include a 4th column, Inactive; the import will always import the city as active, regardless of what value you have in that last column.