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.
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.
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.
