Need correct syntax for import of locations field: geographic coordinates plus name
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
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)
LocationField := location("Big Ben", 51.5007, -0.1246)
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.