Reltio Connect

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

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

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

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