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

Accepted Solutions (0)

Answers (6)

Answers (6)

ab13
Participant

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

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
Participant
0 Kudos

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

BarnabasRadics
Explorer
0 Kudos

Thanks Abby. This solved the issue perfectly.

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

former_member606719
Discoverer

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

former_member606719
Discoverer

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.

S0016260963
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

SridharRaju
Product and Topic Expert
Product and Topic Expert

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
Explorer
0 Kudos

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/

manoj_khavatkopp
Active Contributor

Hi Ivo ,

Below format worked for me in CPI.

Br,

Manoj

former_member708009
Discoverer
0 Kudos

Use this heading

,hitesh|H_h,Mali|M_i
1,Aosta|,AO
2,Chieti|,CH
3,L'Aquila|,AQ
4,Pescara|,PE
5,Teramo|,TE
6,Bari|,BA
7,Barletta-Andria-Trani|,BT
8,Brindisi|,BR
9,Foggia|,FG
10,Lecce|,LE
11,Taranto|,TA
12,Matera|,MT
13,Potenza|,PZ
14,Catanzaro|,CZ
15,Cosenza|,CS
16,Crotone|,KR
17,Reggio Calabria|,RC
18,Vibo Valentia|,VV

In front

1,

2,

3,

needed