Business architect training, Exercise: Configuring reference data
When I try to import the downloaded CSV-file 81-service-provider-list, I get the enclosed error message. The message is this: "Error: Must specify a field to match existing records by", and on top of the page it says: Source CSV file has 1 fields. 1 field will be skipped if not matched.
Anyone that has a tip on what the problem is and how to correct it?
Pegasystems Inc.
US
Hello,
Sorry about your error. Perhaps your csv file was corrupted. I have attached the file here, please download it using Chrome, change the file extension from .pdf to .csv and follow the steps of the exercise again. If you continue to have problems please email [email protected] for additional help.
Regards,
Lu
KPMG
DE
Hi Lu,
I am facing the same Problem - the provided .csv only ontains data in one field, the import works but produces an almost empty view (see attachment). Are you sure the .pdf you have attached is the right one? It seems to be some sort of guide, not a list of Service Providers...
Thanks,
Matthias
Pegasystems Inc.
US
Can you open the downloaded file in a text editor? The problem may be with the CSV format for users in locales where the comma is used as a decmal.
If the file has a full set of records - there should be 57 records, if I recall correctly, plus the header row that labels the columns - then the problem is with the import, and not with the file itself.
KPMG
DE
Yes, I've just opened the csv with a simple text Editor and it showed the data correctly, with the head row
pyGUID,pxCreateDateTime,pxCreateOperator,pxCreateOpName,pxCreateSystemID,pxUpdateOperator,pxUpdateOpName,pxUpdateSystemID,pxUpdateDateTime,Name,Street,City,State,Latitude,Longitude,Address,LatLong
and 57 rows of this structure:
,,,,,,,,,AAA,856 Lexington St,Waltham,MA,42.3946657,-71.2368401,,
So as you said, it's probably the import, not the file that causes this error.
Pegasystems Inc.
IN
Hello!
This is an old post which has not seen any recent activity.
Please create a new post to seek resolutions to your query.
If it helps, you can add this post as a reference to the new one.
Thanks,
Pallavi M | Moderator | Pega Collaboration Center
Pegasystems Inc.
US
There is no issue with the csv file. I just downloaded and imported the csv into my exercise environment. Try downloading it again from the course.
Thank you,
Bill Rathert
Updated: 16 May 2020 8:39 EDT
Capgemini
ES
Hi,
I had the same error.
Maybe is related to the system configuration.
It was solved for me replacing, in csv file, the separator "," by ";"