Posted: 5 Aug 2019 13:50 EDT Last activity: 16 May 2020 8:39 EDT
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?
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 SelfStudySupport@pega.com for additional help.
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...
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.