System Architect Essentials 8.1 issue importing the service provider list in exercise configuring reference data
Hi,
Upon importing the provided service provider .csv file, Pega only recognizes one field to be present in the header allthough they are all there. Seems Pega is not correctly parsing the csv header for the mapping of the fields for some reason?
This happens to me on the Data Type page, Records Tab then clicking the import button. Then selecting the file to be uploaded. The consequent mapping screen shows just One sourcefield (CSV) it being the full header line of the csv file.
Any ideas, hints or tips appreciated.
Regards,
Leo
Ordina
NL
Just for your information, replacing the Comma separator with Semicolon solves this problem...
F1rst Tecnologia
BR
The source field does not allow replacing the comma because it is not editable.
Dictu
NL
Hi,
with semicolons in the CSV, I still get the same error as Leo, see attachment
Please advise. I would expect the seperator to be configurable..
Pega 8.1.3, training system.
Regards,
Arno
Dictu
NL
Please advise..
Sopra Steria Group
FR
Just like said @LDEBLAAUW, replace "," by ";". The thing is, depending with what you're going to make the changes and save (Excel, notepad, notepad++ etc...), the results will not be exactly the same.
I first made changes using Excel (it was opening Excel by default), but it wasn't working.I downloaded again the CSV --> Right click--> Open with --> notepad++. Made the changes and then it works just fine.
CGI
NL
Replacing the "," with ";" didn't work in Excel but did work for me with Notepad++. Thanks for the help!
P & G
PL
Hi, would You be able to tell me how to manage this exercise - I do not know how to download and from where this csv fiel :
Download the Service-provider-list.csv file listed in the Related content section to a directory of your choice