Addresses Importing Backwards
Not planned
Lately when we do an Execel import the addresses are importing backwards into location fields. I double checked and the field mapping is correct. We are entering the street info to the address city to city, state to state and zip to zip but when it imports its coming back in this order
City Zip State Street
-
Official comment
This is a known limitation and bug related to how we are using Google's API for the location/map field. No current plans on fixing it as the current solution would require us to significantly increase the costs of using the Google API.
We might be able to address this for paid accounts in the future if we see enough demand from the userbase. I will move this report to the "feature request" section to track votes.
Thanks a lot for reporting and sharing your feedback!
//Sara - Podio
Comment actions -
Yes, there seems to be a bug in the excel import for address fields. It doesn't happen all the time (I've imported 2k addresses and they are ok). But the address fields also show no map for imported addresses and their parts ( Street, Zip etc.) are returned in a wrong order in calculation fields and in app table view.
Please submit a support ticket (like I did), that makes this issue more urgent https://help.podio.com/hc/en-us/requests/new -
This problem is obviously not being addressed in the free version, my question is are the paid version users experiencing the same problem? This is a huge problem for anyone that is looking to import large number of records with addresses. It totally defeats the purpose of being able to do a import if you have to touch each and every record.
I was told it was a random bug, but I have tried dozens of test imports and it does it every time. It shouldn't be that difficult to fix this problem so what is the hold up???
At least provide an explanation as to why it can't be fixed and provide an alternative process or workaround
I will upgrade my instance if you can tell me that that will fix the problem.
-
I 10X this request! I import numerous addresses per month and very frustrating that they are importing out of order, then having to manually fix them.
I see the problem, which doesn't seem like a laborious repair. Under the import excel window, when you match the fields, the fields in Podio import window are out of order - the same order they are displayed after the import: City, Zip, State, Address.
-
Problem still exists.. but.. I have a workaround.
- First set up an import file where you have a column for each value, street, city, postal code etc.
- Create a new app where you can import the locations, with a reference (!) to the app where you want to use them
- Import the addresses in an app with a reference to the app where you want to trigger (and see) the map.
- Now use globiflow to exchange the addresses from the 'import' app to the app where you want the use the locations.
The exchange with gloeiflow will trigger the map.
I hope this helps.
Please sign in to leave a comment.
Comments
13 comments