Hi,
Here is my issue:
I am trying to import csv file containing several data types including geographic address. Everything works fine, I even get the error message for address not recognized as an address to fix, but at the end no data is showing in the field address.
Try adjusting some of the age range data. I’m guessing that field is messing up the import. Try it by splitting up the CSV and only trying to import the addresses. See if it works.
So I’ve tried a lot of different things, it seems that it is really the upload of geographic address data types that is an issue. I am exploring issues with the google api quotas.
What you could do is use @troy.roberge’s suggestion of importing the .CSV but with your Address column mapping to a temporary field in your database like, “Address (Text)” and set the type to text.
Then if it imports (which it sounds like you’re even having trouble with that, which is odd), you can create a field in your database like, “Address (Geographic),” set up a backend API workflow to then bulk update the old “Address (Text)” to the new “Address (Geographic).”
It’s an issue cause its trying to do address validation on every single address imported, better to just get the data in a text field and mirror it over and double check its work, it could still lookup and match the wrong address if your text address was slightly incorrect.