CSV import
Import your data from a CSV file.
First line of the CSV file must contain field names. Fields must be comma-separated, lowercase ("title", not "Title"), text fields that contain comma must be surrounded with double quotes "...".
Before importing the CSV file create all fields in Database > Edit fields section.
Also, if you import the Location field, first choose the language of addresses in Database > Edit fields > Location > Language.
Formatting
| MapSVG field type | How to import from CSV | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Select, Radio | Import as "value" numbers or text "labels". Whatever works for you. Example: if you have an "area" select field with the following options in MapSVG:
Incorrect CSV values
| ||||||||
| Checkbox | Import as 1/0 or true/false. Correct CSV values
Incorrect CSV values
| ||||||||
| Location | Import as "lat,lng" coordinates or as an "address" string. If you import an address - it gets converted to coordinates. If you import coordinates - they get converted to an address. And then both values (address & coordinates) are stored in the _Location_ field. Please note that Google allows only 50 requests per second to the Geocoding API (which converts address to coordinates or the other way around) so if you're importing many locations - it can take quite a long time, so be patient and don't reload the page. Also, Geocoding API has a limit of 2500 requests per day. Correct CSV values
Incorrect CSV values (coordinates are outside of the correct range -90,-180 .. 90,180)
| ||||||||
| Regions | Import as comma-separated list of region IDs. Correct CSV values (on example of /geo-calibrated/usa.svg file)
Incorrect CSV values
|