Geocoder returns lat/long with comma and points
I'll appreciate some clue or solution for the next strange issue we're facing.
Our environment is: SAP Data Services 4.2 SP05, with de Data Quality package and the Spanish directory.
We want to cleansing + geocoding the direction of the business partners in the ERP environment of our customer. We've found that in some cases, the latitude / longitude is retrieved by a decimal number built with a comma despite of the point we expect between the integer and the decimal part of the decimal number retrieved. In other words, in some cases, always the same BusPartners, the value retrieved has the form of: '00,00000' despite of '00.0000'
To take into account: next images shows the of the geocoder object output.
Example 1 - Result with comma:
- Street. barri Segalers
- HouseNo. 2
- Postcode. 08261
- Locality. Cardona
- Country. ES
Example 2 - Result with point (correct one)
- Street. ps Comerç
- HouseNo. 92
- Postcode. 08203
- Locality. Sabadell
- Country. ES
That's the XML output:
<VALUE>The result from geo-coding is ambiguous. There is no choice available because the address data was not clearly specified.</VALUE>
OK. So, after the global data cleansing done in the step before joining in the geocoder...the normalized direction couldn't be found in the GeoCoder.
Is there any option or way to customize the form of the data retrieved by the geocoder in DS or in the IMG customizing in the ERP? I don't know where I should keep on looking for solving it.
Could be the directory out of date?
*Could be related: The Code Page is set up to UTF-8 (as the DQ user guide points) in the SAP DS Locale Selector, the language and territory is set up by default.
Thank you very much in advance to everyone,
Message was edited by: Néstor Martínez
Néstor Martínez replied
It was solved in new releases.