Uploading addresses do not work unless column names match exactly as in geocoder

Permanently deleted user

May 10, 2016 23:47

GVH 2.6, Essentials 4.5 - Encountered another issue related to geocoding. My geocoding is configured as below...

 

_img_ alt="Geocoding Configuration" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906600000000Bpf&feoid=Body&refid=0EM60000000DGnJ" _/_img_

 

If I upload CSV or Excel file with addresses, for some reason, the column names have to match those in the geocoder. For example, if I upload CSV whose street column is named "Address" (see below)...

 

_img_ alt="Table mapping" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906600000000Bpf&feoid=Body&refid=0EM60000000DGnO"_/_img_

 

The addresses are rejected. However if I rename the column name to "Street", it works fine. Did I miss any configurations??? Thanks for any help.

 

Masao

0

• 

  Permanently deleted user

  May 13, 2016 16:15

  Just upgraded to 2.6.1 and 4.5.1, and the issue is not fixed yet.

  0
• 

  Permanently deleted user

  May 25, 2016 15:08

  Bug number is GE-8077

  0
• 

  Dan Giersz

  August 17, 2017 18:26

  Is this still an issue? The names match and it keeps throwing the error:

   

  Exception has been thrown by the target of an invocation. Error occurred while performing batch geocode: 400 - Unable to complete operation.

   

  It worked once on about a dozen records, but hasn't worked since (I've tried 1000, 500, 100, 10, 5...)

  0
• 

  Permanently deleted user

  August 18, 2017 00:05

  Yes, GE-8077 is unresolved. I'll raise this issue with the Essentials team.

  0
• 

  Dan Giersz

  January 22, 2018 16:59

  Any update on this?

  Even when my files have the correct field names in the header, I still recieve the error...

  0
• 

  Permanently deleted user

  January 23, 2018 16:15

  After upgrading to GVH 2.10.1, my original issue seem to be resolved. Is the bug resolved?

  0
• 

  Dan Giersz

  January 23, 2018 17:18

  We're on GE 4.9.1 and GVH 2.10.1 and still receive the error.

  0
• 

  Permanently deleted user

  January 24, 2018 16:18

  It seems like you are having a different issue. I have an impression that in general address uploading seems buggy. Another minor issue I encountered was the column names are not picked up automatically except one (I forgot which one, maybe "City").

   

  What file format are you loading?

  0
• 

  Dan Giersz

  January 24, 2018 16:37

  I tried an XLSX.

   

  We had only one column name getting picked up as well, until we modified the json file to match the column names/geocoder fields we are using. (change the autoDetectionTerms under the viewmodel of the UploadData module, we changed "Region" to "State" and it started picking up the State column, etc.).

  0

Please sign in to leave a comment.