Product Information
SAP Cloud Integration – CSV Import in Value Mapping
Introduction
SAP Cloud Integration version 2.40 supports import of CSV file in Value Mapping. You can import the existing/exported SAP Process Integration (SAP PI) value mapping CSV file into SAP Cloud Integration Value Mapping.
Consider an empty value mapping editor as shown below. Please ensure that you are editing it.
You can now see a new button Import
Importing CSV in new value mapping
If you have an exported CSV file from SAP Process Integration (SAP PI), you can import that file in value mapping. Clicking on Import opens a file selection dialog.
You can select the CSV file to import. After import, the value mapping shall be created as shown below:
Importing CSV in existing value mapping
You can import a CSV within the existing value mapping. In such case, the newly imported CSV value mapping is merged with the existing mappings. Let’s see how this works.
Here’s a value mapping that already contains some entries.
After importing (ex: the same CSV file with airline agency entries), it will be merged with the existing agency-identifier entries.
You can see the new row in Bi-Directional Mapping section.
The import feature will save you a lot of time as you can reuse the CSV files exported from your PI system, if you are using the same value mappings.
Very interesting post
Is it possible to have the CSV file sample ?
I don't have access to SAP PI, and i am very interested on this file structure.
Thank you
Hi Guillaume,
This feature is meant to import the CSV files which were exported by PI.
Nevertheless, kindly check the documentation for more information
Thanks
Deepak
Please refer this thread response
https://answers.sap.com/questions/655048/valuemapping-csv-import.html
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
Hi Hitesh,
If I understand your requirement correctly, you want to have the entry as 1,Aosta (and so on) in the mapping table cell at left hand column, correct?
Please clarify.
Thanks
Deepak
No, just trying to help others
These 1 2 ....are only for formatting, they are needed for importing csv i value mapping.
Hi,
We tried this but is not working.
Do you know if something change?
Hi, your format is correct though I might ask you to check the file format. Encoding should be Unicode (UTF-8) and file type should be CSV (Comma delimited).