on 10-05-2018 1:04 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.