GroupId in Value mapping replication

[Former Member]

Hi Experts,

I have a PI 7.4 system, where I am trying to setup a Value mapping replication Scenario(async), where FTP is the sender, that picks a csv file, followed by a Message Mapping, that transforms the structure to the ValueMappingReplication structure. I triggered a test message, and it is getting updated in the Runtime Cache. The issue, that I am facing is, since the VMR structure, expects a hexadecimal value for the GroupId, field, I am not able to upload multiple records through the same interface.

The intention is to upload a csv file in the FTP folder, which has 1000s of records, from where both the source and target values will be available. The Mapping step, creates the necessary structure for VM data to be uploaded into XI.

When we add Value Mapping data in ID in PI, even though we maintain same Group Name, each pair(source and target) is assigned a unique Group Id automatically. How do I do that dynamically for a mass upload of data using VMR interface?

Note: The option to use NWDS is ruled out in my case.

[former_member190293]

Hi Shankar!

You can use UDF for GUID generation using java UUID class:

UUID.randomUUID().toString()

Regards, Evgeniy.