Reltio Connect

I am trying to load a simple CSV from an S3 bucket that has a single column. I mapped the column to the matching attribute to the entity type. Per the documentation, I left the crosswalk empty and was expecting it to generate a crosswalk.



All records fail to load with a CROSSWALK_NOT_FOUND error.

Hi Nik,

You'll need at least two columns, one that contains the attribute values and another that contains the crosswalk value. You can then define the source system for this data in the mapping section of the dataloader tool.

When loading dummy data, I use this formula in google sheets to generate a simulated UUID that I use as a crosswalk value.

= DEC2HEX(RANDBETWEEN(0, 4294967295), 8) & "-" &
  DEC2HEX(RANDBETWEEN(0, 65535), 4) & "-" &
  DEC2HEX(RANDBETWEEN(0, 65535), 4) & "-" &
  DEC2HEX(RANDBETWEEN(0, 65535), 4) & "-" &
  DEC2HEX(RANDBETWEEN(0, 16777215), 6) &
  DEC2HEX(RANDBETWEEN(0, 16777215), 6)

I hope this helps,

Roger

------------------------------
Roger Mukai
------------------------------

Original Message:
Sent: 06-08-2022 11:31
From: Nik Gibbens
Subject: CROSSWALK_NOT_FOUND when running a data loader job

I am trying to load a simple CSV from an S3 bucket that has a single column. I mapped the column to the matching attribute to the entity type. Per the documentation, I left the crosswalk empty and was expecting it to generate a crosswalk.



All records fail to load with a CROSSWALK_NOT_FOUND error.