How do I...?

Import an address into "Location" field?

I have received errors on my attempt to import locations: "Invalid POINT value". I have old data with addresses that I would like to tie to the location field....how do I do this?

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Michael shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Michael commented  ·   ·  Flag as inappropriate

    Thank you! However, I am still having trouble when trying to add location to existing records...

    It seems that I will have to export and delete all records, then add lat/long to the exported file, then import it as "Add Only".
    I'm wondering why the system does not seem to recognize the lat/long as an update...

  • Justin Mauldin commented  ·   ·  Flag as inappropriate

    Hi Michael,

    Thank you for reaching out to us with your question.

    When importing data into a Location Field on your table, you have to have one field on your file that has the longitude and latitude coordinates separated by a comma in it to get a successful import and mapping of the point into the field.

    If you are trying to import the actual address in your file, you will need to convert your address to longitude and latitude coordinates (outside of the TrackVia system) and then attempt your import again.

    Below, is a link to an article we have in our knowledge base that helps walk you through the needed setup for a successful import, as well as, some other details about Location fields.

    http://help.trackvia.com/knowledgebase/articles/494231-how-to-plot-a-record-on-a-map

    Thanks again,

    Justin

Feedback and Knowledge Base