Geographic Address breaks when uploading csv

When I upload a csv, all the data validates and goes through, but my geographic address rows are all empty and therefore markers are not populating on my map.

When I tried creating new rows manually in the database, using a couple of the exact same geographic addresses as a test, the addresses work, so it seems that the issue is specifically due to uploading a csv of addresses.

It’s not feasible for me to manually upload this data. Any idea what the issue and fix might be here? Been searching all over the forums but cannot find an answer, unfortunately.

Thanks!

Sharing a couple of sample lines of your csv can be useful :slight_smile:

1 Like
Geographic Location Store Name Timestamp Active
61 W Houston St, New York, NY 10012 Van Leeuwen January 3, 2023 12:00 AM yes
152 W 10th St, New York, NY 10014 Van Leeuwen January 3, 2023 12:00 AM yes
E 79th St and Flatlands Ave, Brooklyn, New York, 11236 Nike Store January 3, 2023 12:00 AM yes

I had to anonymize the data but the csv looks something like this. Text fields work, timestamp works, booleans work, but geography doesn’t work for some reason.

Thanks!

You could upload the address as text, and then run a back end workflow to copy it to a Geographic Address field?

FWIW I use Parabola to upload addresses and it works OK (apart from the one person with a Christmas based business who had their address as “The NorthPole”). So it must just be csv.

Another thought is that the commas in the address may be causing issues.

1 Like

I have the same issue. Used to work fine before though. Glad to have your feedback if you find a solution !

1 Like