Locatd - Requirements for import files
In order to be able to import locations to the "Locatd" app, the import file must adhere to a number of requirements. The easiest way to get going, is to ensure you have at least one location in the app, and export it. When you open the exported CSV file, you can easily add new locations as new rows in the CSV document, and see how what type of content the different columns should have.
CSV fields
An import file must have the following CSV fields:
- Id (do not change)
- Name
- Brand
- Address
- Zip code
- City
- State
- Country
- Phone
- VAT no
- Latitude
- Longitude
In addition to this, any custom attributes will be added as columns. If you e.g. have a custom attribute "Free wi-fi", this will be the name of the column. As mentioned above, the simplest way to see how the data is formatted, and to add new locations, is by exporting the existing locations, and follow the same structure.
As noted above, the only column that should not be edited, is the first column "Id", as this refers to an ID in the database. If a row does not have an id, the given location will be created, and if a row has an id, the given location will be updated.
Validations
The data entered must be valid. The list below shows some examples of validations made when importing data:
- Location name is mandatory and must be unique
- Address, zip code, city and country are mandatory fields
- We must be able to translate the entered address to a longitude and latitude