Valuemapping CSV import

[former_member22609]

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!

[former_member22609]

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

[ab13]

Hi,

What worked for me is creating the csv file using notepad first (like first few lines). Then, opening it and editing via Excel. Because if I create in Excel and save it as .csv, it doesn't recognize it as correctly formatted even though it has the same content as the one I made (creating using notepad first).

Hope this helps!

Kr,

abby

[former_member668780]

Hi Abby,

Thanks a lot for your comment.

I was struggling with this issue but it resolves as I created csv file from notepad.

Thanks a ton.

Regards,

Pooja

[StefNoyens]

You need to check that the encoding is 'UTF-8' and not something else like 'UTF-8-BOM'.

[BarnabasRadics]

Thanks Abby. This solved the issue perfectly.

Selecting UTF-8 on Excel did not work but this did