I only have one question regarding use of GeoMaps. I would like to import all cities in Finland including geo coordinates into Smarten, so that I can place those to into Finnish map for data visualization. Here is example of data I’m planning to import:
| City | County | Latitude | Longitude |
| Akaa | FI-08 | 61.169000 | 23.858000 |
| Alahärmä | FI-10 | 63.233000 | 22.850000 |
| Alajärvi | FI-08 | 63.000000 | 23.817000 |
| Alastaro | FI-03 | 60.957000 | 22.860000 |
The manual says, that column 2 should be the ISO-code. Can you please let me know if this one above is the correct format? Also, should there be some header row in the excel. When I tried to import cities the first time without any column header line, it did not import the first row at all.
The excel file should have this format while uploading -
Import the two excel attached one by one from the admin panel (ISO is used only for States or County, where the regions are defined. You can get the region highlighted, if ISO code is provided in the County excel file.)
1) For cities, select the city in drop down
2) Similarly, while uploading the counties, select the county from the drop down
Similarly, you can do it for State or Area or Zipcode.
Once done, you can build the cube which has the data with city, county and other measure (eg sales values, cost, etc)
Make sure city name, county name in the data matches exactly as per the names in both the excel files.
Define the location hierarchies in the cube (County > City) or (Country > City) after the cube rebuild process is carried out.
Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten version you may be using.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article