Issues with mailing address csv import
I am trying to import a csv of organizations with a mailing address field.
After importing, the address field is blank for about half of the newly imported organizations. Why? Does the text need to be a perfect match with the text string in Google Maps? Some other reason?
I manually added some of the failed addresses without selecting the recommended auto fill from Google and it still seems to work fine (i.e. Google Maps still pulls up the correct location within Pipedrive, just the way it would if you were searching on the Google Maps website).
Any pointers out there?
Comments
-
Did you map all of the address fields separately [ie: address 1, city, state, zip, etc] or all in 1 field?
if all in 1 field that may be the cause of some of the issues
0 -
Boris Tsibelman said:
Did you map all of the address fields separately [ie: address 1, city, state, zip, etc] or all in 1 field?
if all in 1 field that may be the cause of some of the issues
ah okay i'll give that a shot. thanks @Boris Tsibelman !
0 -
Did mapping those fields fix the problem?I have attempted an import multiple times and many of the city, state, and zip codes do not populate. despite being mapped properly. Im talking hundreds or thousands of my 10,000 row import that has all the info populated. There is something about the way that pipedrive handles address imports. An import of the same spreadsheet into hubspot fully populates and takes less that a minute. In pipedrive it takes over a half hour and is missing tons of address data. Pipedrive support has tested it on their end and they have the same issue.
0 -
Last 3 days I had extensive contact with the peeps of Pipedrive, they took the import-problem to the engineers and it seems completely fixed now.
I'm very happy they took the time to get to the heart of the problem and solved this issue.
I'm curious if this also solves your problem @Brian Lance & @Pipedrive User 164
0
