Question Re: Valuemapping CSV import in Technology Q&A

Valuemapping CSV import

former_member22609 — Fri, 05 Oct 2018 12:04:12 GMT

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!

Re: Valuemapping CSV import

former_member22609 — Sat, 06 Oct 2018 18:14:35 GMT

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

Re: Valuemapping CSV import

manoj_khavatkopp — Sat, 06 Oct 2018 19:24:14 GMT

Hi Ivo ,

Below format worked for me in CPI.

Br,

Manoj

Re: Valuemapping CSV import

former_member606719 — Mon, 17 Jun 2019 22:21:35 GMT

Hi All,

I am trying to import a CSV file to upload value mappings in SAP Cloud Platform Integration. I have formatted the csv file as shown in the attached screenshot, but the import is not working. Could you please let me know on the correct file format?

Thanks,
Shreyasee

Re: Valuemapping CSV import

SridharRaju — Tue, 18 Jun 2019 16:57:33 GMT

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.

Re: Valuemapping CSV import

former_member606719 — Tue, 18 Jun 2019 17:50:25 GMT

Please refer to Sridhar's comment post below for solution to the question on csv format. This question has been answered by Sridhar in the below post.

Re: Valuemapping CSV import

ab13 — Tue, 23 Jul 2019 02:34:42 GMT

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

Re: Valuemapping CSV import

former_member668780 — Tue, 14 Apr 2020 12:17:49 GMT

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

Re: Valuemapping CSV import

StefNoyens — Wed, 16 Jun 2021 10:34:37 GMT

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

Re: Valuemapping CSV import

former_member708009 — Mon, 04 Oct 2021 11:45:49 GMT

Use this heading

In front

needed

Re: Valuemapping CSV import

hemanthky — Fri, 10 Feb 2023 18:50:51 GMT

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/

Re: Valuemapping CSV import

BarnabasRadics — Tue, 27 Jun 2023 03:31:42 GMT

Thanks Abby. This solved the issue perfectly.

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

Re: Valuemapping CSV import

AlanWaters — Tue, 27 Jun 2023 09:31:22 GMT

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