SAP Knowledge Base Article - Public

2071528 - Beta Goal Import Error Messages - Goal Management

Symptom

This article explains the Beta Goal Import error messages.

Environment

SAP SuccessFactors Goal Management

Resolution

Below you can find some common errors you may encounter when importing Goals via Beta Goal Import. If you encounter any errors not listed here, please contact Product Support.

Invalid Enum

Processing Error :
Parsing Validations: 1
Field Name : state  Invalid Enum :

This error happens when an invalid enum value was imported. For enum field, the enum values should be used. One possible reason for this error is that field labels were used instead of field values.

In the example below, "In Progress" is the state field label, "On track" is the state field value.

<enum-value value="On Track" style="background:green;color:white">
<enum-label>In Progress</enum-label>

The enum value "On track" should be used instead of the enum label "In Progress".

Note: The enum label is visible in goal management page, but the enum value is defined in Goal Template XML, it only can be checked from Provisioning. If unsure what the field values are, please contact partner or submit a ticket to Product Support to check it.

Category does not exist

Processing Error :
Parsing Validations: 1
Field Name : category Category does not exist.

This error happens when Category ID is missing or not correct. Please provide a correct Category ID in the imported file.

More information about how to get Goal Category ID can be found in KBA 2457184.

due Parsing Error

Processing Error :
Parsing Validations: 1
Field Name : due Parsing Error

This error may be due to invalid date formats in your file. You must have all date fields in this format mm/dd/yyyy. If when importing you get the error message "due parsing error", open the original file in NotePad and check the date format. Even though the format might look correct via excel, you need to confirm that by opening in notepad. A format like yyyy-mm-dd can cause this error.

linkdoc Parsing Error

Parsing Validations: 1
Field Name : linkdoc Parsing Error

The file needs to use the correct syntax to be successfully imported. Use the following format in your CSV file when importing URL values in that field:  [[URL][Label]].

Note: You need to use brackets [[]] like this and then replace the words "URL" or "Label" with what you want displayed

Processing Errors: "Number of columns for the data rows does not match the number of columns on the header"

Processing Error :
Error in CSV file format.       1
Number of columns for the data row does not match the number of columns in header.

This is caused by losing field delimiters (commas) on that row. To troubleshoot, your data is best to open the file in notepad and check the syntax. You will likely find that at the row reported the commas are missing or not correct causing the number of reported columns to be wrong. Since a column in a csv file is represented by "," if your file is missing these at this row, or maybe you have text with commas in it, it will cause incorrect file structure.

For example:
column 1, column 2, this is column 3, and this is column 4 = 4 columns
column 1, column 2 this is column 3 and this is column 4 = 2 columns as there is only 1 comma separator.
column 1, column 2, "this is column 3, and this is column 4" = 3 columns since we have quotes around "this is column 3, and this is column 4" the commas between the quotes are not treated as separators.

Validation error encounter. Unknown system field (line: 1)

Validation error encounter. Import Process abort. Nothing is created or updated. Please correct the following error(s) and try again.
Unknown system field :
(line : 1 )

This occurs when the import file is not correctly saved as a CSV file. Check to see if it has been accidentally saved as an XLS (or other) file. Save the file as a CSV file and re-import.

See Also

Keywords

Beta Goal Import, error, Processing Error, Parsing Validations, due Parsing Error, linkdoc Parsing Error, Invalid Enum, Category does not exist, Unknown system field , KBA , csg_q , LOD-SF-GM-REP , Reporting and Data Imports Exports , Problem

Product

SAP SuccessFactors Performance & Goals all versions