Addresses Importing Backwards

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

Christopher Gibbins November 17, 2016 21:06 Not planned

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

Sara Høeg Højlund-Rasmussen June 07, 2018 13:44

Please sign in to leave a comment.

12 comments

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

Rainer Grabowski November 18, 2016 09:49 0 votes

Hi Christopher,

We do have an open bug on this. I've made a note to update you here when we have a fix ready.

/Jacquelyn - Podio

Jacquelyn May November 18, 2016 19:40 0 votes

What is the status of this bug fix?

I am experiencing this same bug 9 months later

John Martien July 01, 2017 17:13 0 votes

Hi John,

No news to share on this one yet, we have been prioritizing bugs that affect a larger number of people. I've just asked our developers to take another look at this one and will be sure to update you here when we have a fix. Sorry for the wait!

/Jacquelyn - Podio

Jacquelyn May July 13, 2017 21:46 0 votes

Still happening for me, also going on for 2 years now. Two different organizations.

Phong To July 19, 2017 20:48 0 votes

I'm having this issue too. Which means I cannot import my prospects as I then have to go in and re-type each one manually in order to get the data corrected - So now I'm left with having to just enter them all manually (could be a few, could be a few thousand.) HELP!

PHG Admin September 01, 2017 19:23 0 votes

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.

John Martien September 08, 2017 12:33 0 votes

please, please, please fix this.

Phong To October 13, 2017 00:09 0 votes

fwiw, the issue only occurs if you upload the address into a multi-line address field, single line fields do not have the issue on imported addresses. please fix this, seems like it should be easy.

Phong To November 09, 2017 23:17 0 votes

Looks like this bug still hasn’t been resolved - trying to import 2K addresses on the premium version for a client…

Richard Linden December 31, 2017 10:29 0 votes

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.

Chad Urbshott May 24, 2019 00:44 0 votes