 | | | | Re: Phone, Mobile Phone Standardisation Best Practices | | | Hi Rupam,
- Because country dialing code is unambiguous, if the country is known it can easily be looked up. I have fixed this case outside of Reltio with simple match country code (i.e. iso-3166) to the dialing code outside of Reltio. Then load the values into Reltio via Data Loader. Or do you mean the iso-3166 is missing?
- From my experience, it is best to strip all of this punctuation. It tends to be used irregularly, and that only leads to more problems.
- If the phone number is "incomplete", i.e. it is 9 digit, but country is US, so you expect 10 - this is a problem best solved with input validation. Reltio would never know what digit to add in.
- Same process to correct the dialing code as to fill in missing. Or do you mean the iso-3166 is wrong?
Regards,
Walt | | | Reply to Group Online View Thread |
2.
RE: Phone, Mobile Phone Standardisation Best Practices
Hi Rupam, I used a lookup table like the one attached. I did not attempt to do this inside of Reltio. I matched the countries to the dialing codes externally to Reltio, and loaded the corrected phone numbers into Reltio via data loader. Regards, Walt ------------------------------ Walt Feldman Solutions Architect Tenerity ------------------------------
Original Message:
Sent: 11-18-2021 13:54
From: Rupam Dutta
Subject: Phone, Mobile Phone Standardisation Best Practices
Hi Walt,
Thanks for the response -
- Because country dialing code is unambiguous, if the country is known it can easily be looked up. I have fixed this case outside of Reltio with simple match country code (i.e. iso-3166) to the dialing code outside of Reltio. Then load the values into Reltio via Data Loader. Or do you mean the iso-3166 is missing? [Rupam] What reference have you used to match country code to the dialing code outside, I'm trying to use Country Code attribute Under Reltio 'Phone' nested attribute by passing ISO-2 country code from the source. Country information is present in source but sometimes the phone number already has dialing code and sometimes not.
- From my experience, it is best to strip all of this punctuation. It tends to be used irregularly, and that only leads to more problems. [Rupam] Yes, stripping these off in the integration process.
On Tue, Nov 16, 2021 at 7:34 PM Walt Feldman via Reltio Community < Mail@reltio.com> wrote: Hi Rupam, Because country dialing code is unambiguous, if the country is known it can easily be looked up. I have fixed this case outside of... -posted to the "Reltio Connect" community | Re: Phone, Mobile Phone Standardisation Best Practices | | | Hi Rupam,
- Because country dialing code is unambiguous, if the country is known it can easily be looked up. I have fixed this case outside of Reltio with simple match country code (i.e. iso-3166) to the dialing code outside of Reltio. Then load the values into Reltio via Data Loader. Or do you mean the iso-3166 is missing?
- From my experience, it is best to strip all of this punctuation. It tends to be used irregularly, and that only leads to more problems.
- If the phone number is "incomplete", i.e. it is 9 digit, but country is US, so you expect 10 - this is a problem best solved with input validation. Reltio would never know what digit to add in.
- Same process to correct the dialing code as to fill in missing. Or do you mean the iso-3166 is wrong?
Regards,
Walt | | | Reply to Group Online View Thread | | | | |
3.
RE: Phone, Mobile Phone Standardisation Best Practices
Thanks Walt, I've found the nested attribute Country Code under Phone useful, inserting both phone number and iso-2 country in Phone formatting the number correctly but dialing code still not visible if the same is missing in source, exploring a rdm feasibility to convert country code to dialing code bases on a reference (similar you shared above).
Thanks Rupam On Thu, Nov 18, 2021 at 10:37 PM Walt Feldman via Reltio Community < Mail@reltio.com> wrote: Hi Rupam, I used a lookup table like the one attached. I did not attempt to do this inside of Reltio. I matched the countries to the dialing... -posted to the "Reltio Connect" community Original Message: Sent: 11/18/2021 5:36:00 PM From: Walt Feldman Subject: RE: Phone, Mobile Phone Standardisation Best Practices Hi Rupam, I used a lookup table like the one attached. I did not attempt to do this inside of Reltio. I matched the countries to the dialing codes externally to Reltio, and loaded the corrected phone numbers into Reltio via data loader. Regards, Walt ------------------------------ Walt Feldman Solutions Architect Tenerity ------------------------------
This thread already has a best answer. Would you like to mark this message as the new best answer?
| | | |