0

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

Much obliged!

 

-l.

3 replies

null
    • Robert.2
    • 5 yrs ago
    • Reported - view

    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)

    • Robert.2
    • 5 yrs ago
    • Reported - view

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

    • Laura
    • 5 yrs ago
    • Reported - view

    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.

Login to reply

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 2369Views