Need correct syntax for import of locations field: geographic coordinates plus name
Ninox Profile

Greetings, I'm sure you have already addressed this in the manual, but I was unable to find it. What is the correct syntax for doing a bulk locations import? currently my data is organized in CSV format as follows: 

Location, coordinates: xx.xxxx N yy.yyyy W
Location, name: City/ Town, State/ Region

Much obliged!

 

-l.

 

 

 

 

R

You might want to load your Latitude and Longitude into two number fields (+/-) meaning E/W, N/S and then use the following:

location(title, latitude, longitude)

From the manual, this creates a location value with given title (text), latitude (number) and longitude (number)

R

LocationField := location("Big Ben", 51.5007, -0.1246)

Ninox Profile

Thanks much, Robert! That's just what I was looking for.

I have a recollection that I ran across this solution in the forums at one point a while ago, but I couldn't find it this time around—possibly because I didn't have the search terms just right. In general, I have had limited success searchingthe forums. If anyone has any tips on how to get the most out of them, I'd greatly appreciate it.

Thanks again.

 

-l.

Reply