cancel
Showing results for 
Search instead for 
Did you mean: 

Valuemapping CSV import

0 Kudos

Hello Integrators!

I've been trying to find out the correct CSV template to upload value mappings in the CPI Web IDE. The documentation is not really clear on this and I have not yet found a topic on this on the community.

It's a complete new integration, and I have no PI system available(the documentation suggest that the PI export has the correct layout).

I tried:

agency1|identifier1,agency2|identifier2
sourceValue,targetValue

And

agency1|identifier1,sourceValue,agency2|identifier2,targetValue

But none of these worked. Can someone provide me with an example file?

Thanks!

0 Kudos

Hi Manoj,

Thanks for your reply, unfortunattly it doesn't work in CPI. This is how de mapping looks lik in the Web IDE:


I added the entry manually to illustrate my expectation


This is what I put in my CSV:

I also tried BRITTISH|GBR,GBR|BRITTISH in row 2 columns B and C but that's also not accepted.

I'm starting to wonder if I can even add value mappings with an upload; maybe it's only meant as initial upload?

Kr.

Ivo

View Entire Topic
AlanWaters
Participant

Hi there,

I created the pictured Excel (valuemappingcreator-excel.png) that generates the correct CSV format when you enter the relevant parameters. Simply enter the agency/identifier info, enter the source and target values, and copy and paste the blue text cells into another Excel sheet, and save that sheet as CSV. This will allow you to import directly into SCI.

It won't allow me to attach the Excel 😞 so you would need to create the formulae yourself.

Hope this helps.

Alan