Reltio Connect

 View Only
  • 1.  Replace special character at the time of data Load

    Posted 25 days ago
    Hi Experts ,

    How can we replace a special character  which can be present at any place in a string  with an another character at the time of data load in the tenant in both bulk data load /UI activity ?

    Please let me know.

    ------------------------------
    Utsa Das
    Syneos
    ------------------------------


  • 2.  RE: Replace special character at the time of data Load

    Reltio Employee
    Posted 25 days ago
    Hi Utsa,

    Can you please explain what you mean by UI activity?  i.e. how would any system intercept the keystroke of a user?

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 3.  RE: Replace special character at the time of data Load

    Posted 24 days ago
    Hi,

    Actually I meant to say here if anyone is adding a data from Reltio UI /or bulk data load activity through data modeler then how to replace a particular special character into another one for a field?

    And as mentioned ,this special character can be present anywhere in the string .

    ------------------------------
    Utsa Das
    Syneos
    ------------------------------



  • 4.  RE: Replace special character at the time of data Load

    Reltio Employee
    Posted 23 days ago
    - I think you mean data loader vs. data modeler.......

    Your best bet is to have a process listen to the queue for any create/update events.  Then search the attribute(s) you are interested in for the character.  if found, do a find/replace on the character and update the attribute in Reltio.  

    You can do this process with RIH or any other integration tool.

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 5.  RE: Replace special character at the time of data Load

    Posted 22 days ago
    Hi Utas,

    Answering above scenario as per my understanding.
    Dealing Special characters can be done via two methods as below :

    1. Identifying Special characters after load via UI or API's:
      Use of validation function to display it near the profile or pick the same using profile statistics dashboard

    2. Usage of LCA 
      We have hooks to configure when LCA must be implemented. For example - we can use "Before save" hook to validate the profile & prevent or perform validation like (splitting, removing, replacing, adding) the same record before loading by showing warning or error message.
    These two points are top of my mind, will be happy to hear new ones.

    ------------------------------
    Chetan P
    Freshworks
    ------------------------------



  • 6.  RE: Replace special character at the time of data Load

    Posted 22 days ago
    Hi ,

    Can we use the custom java cleanser to achieve the requirement ?

    Is there any useful video or document to implement the same ?

    ------------------------------
    Utsa Das
    Syneos
    ------------------------------



  • 7.  RE: Replace special character at the time of data Load

    Posted 22 days ago
    Hi Utsa,

    I believe we can use Custom Java cleanser through help from Reltio Support team.
    Please find the below documentation to understand better to implement requirement.

    LCA Framework - https://docs.reltio.com/en/model/customize-data-tasks-with-lcas/life-cycle-actions
    Hooks available in LCA - https://docs.reltio.com/en/model/customize-data-tasks-with-lcas/life-cycle-actions/lca-hooks
    LCA Configuration - https://docs.reltio.com/en/model/customize-data-tasks-with-lcas/life-cycle-actions/lca-configuration


    ------------------------------
    Chetan P
    Freshworks
    ------------------------------