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

[SridharRaju]

Shreyasee,

In your above csv file, Replace country with Abu Dhabi, country_2 with Admiralty islands, country3 with Afghanistan, and so on...save it and try importing...It should work. See attached screenshot format, FYI. And also make sure NO duplicate values.

[hemanthky]

Even this didn't work. I tried saving the file in "CSV(comma delimited)" format instead of "CSV(UTF-8 comma delimited)" format and then in the web options I choose encoding as Unicode UTF-8. Then it worked even the values repeated .

Please go through this link https://blogs.sap.com/2020/09/10/sap-cloud-platform-integration-cpi-part-12-value-mapping/