Reltio Connect

 View Only

  • 1.  Phone, Mobile Phone Standardisation Best Practices

    Posted 11-18-2021 13:55
    Hi Walt,

    Thanks for the response - 

    1.  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.
    2. 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.


    Many Thanks,
    Rupam Dutta     





    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
    Reltio Community

    Reltio Connect

    Re: Phone, Mobile Phone Standardisation Best Practices
    Nov 16, 2021 2:32 PM
    Walt Feldman
    Hi Rupam,

    1.  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?
    2. 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. 
    3. 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.
    4. 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  
    -------------------------
    Original Message:
    Sent: 11-16-2021 10:37



     
    You are receiving this notification because you followed the Question 'Phone, Mobile Phone Standardisation Best Practices'. If you do not wish to follow this, please click here.

    Update your email preferences to choose the types of email you receive

    Unsubscribe from all participation emails


  • 2.  RE: Phone, Mobile Phone Standardisation Best Practices

    Founding Member
    Posted 11-18-2021 17:36
      |   view attached
    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
    ------------------------------

    Attachment(s)

    csv
    country dialing codes.csv   8 KB 1 version


  • 3.  RE: Phone, Mobile Phone Standardisation Best Practices

    Posted 11-26-2021 07:32
    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
    Reltio Community

    Reltio Connect

    Post New Message
    Re: Phone, Mobile Phone Standardisation Best Practices
    Reply to Group Reply to Sender
    Nov 18, 2021 5:36 PM  |    view attached
    Walt Feldman
    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
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  
    -------------------------------------------
    Original Message:
    Sent: 11-18-2021 13:54



     
    You are receiving this notification because you followed the 'Phone, Mobile Phone Standardisation Best Practices' message thread. If you do not wish to follow this, please click here.

    Update your email preferences to choose the types of email you receive

    Unsubscribe from all participation emails



    Original Message


Related Content