Reltio Connect

 View Only
  • 1.  S3 export of entitties

    Reltio Employee
    Posted 16 days ago
    Hi,

    I am facing issue while doing an S3 export of entities. 

    When a Lookup attribute is getting exported to S3 it populates only code in the exported file but not the description of the attribute. 

    For example Please see the below screenshot how lookup fields highlighted in yellow are showing in the UI.


    Please see the value populated for the same field after export : It doesn't contain the description of the lookup attributes that are shwoing in the UI.


    Please let me know how this issue can be fixed. My requirement is to export both code and description of the lookup attributes. 

    Thanks in Advance. 


    ------------------------------
    Sanjay Kumar
    ------------------------------


  • 2.  RE: S3 export of entitties

    Founding Member
    Posted 10 days ago

    Hi Sanjay,

    I believe there is an issue with RDM lookup code, as I can see in UI screenshot "GB" is the canonical value and "United Kingdom of ....." is showing up as lookup code.



    ------------------------------
    Ashish Rawat
    Manager
    Fresh Gravity
    Bangalore
    ------------------------------



  • 3.  RE: S3 export of entitties

    Reltio Employee
    Posted 9 days ago
    Hi Sanjay,

    As Ashish has mentioned, in RDM you have declared "GB" as the canonical value and the "United Kingdom of Great Britain and Northern Ireland" as the canonical code. Now since canonical code and value are different, you can see both in the MDM UI. However, in the csv extract, only the value property of an attribute is extracted in a column. Other information like type, uri, ov and in this case lookupCode are not exported. You can refer to the below document for more information. 

    https://docs.reltio.com/exportapi/entityexportcsvoutputformat.html

    If you want both canonical value and canonical code to be exported, maybe you can look at the option of exporting in JSON format. It will give you both code and value.

    For example : 


    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------



  • 4.  RE: S3 export of entitties

    Reltio Partner
    Posted 9 days ago
    Sanjay,
    Also, and I think this is partly what other comments are pointing out, it seems like your use of the code and value are reversed. I would've expected "GB" and "01" to have been declared in RDM as the source codes (coming into Reltio from other systems), with "United Kingdom of ....." and "Wholesale" declared as the canonical values that all source codes are coerced to by RDM and thus appear in the MDM UI without parenthesis around them. In this way, then "United Kingdom of ....." and "Wholesale" would be in the export. 

    ------------------------------
    Curt Pearlman
    PwC
    Agoura Hills CA
    ------------------------------