Both the imported Excel file and the Importing process are validated against inconsistencies and errors. When at least one error is found, the import validation fails and an error report is presented so that the problems can be rectified. Below are the error messages related to issues that could cause problems with your import.
General
Unsupported File Type
EPC only supports the import of .xlsx type Excel files.
Document Format: SOP
While SOP type documents may be exported, they cannot be re-imported using the Import from Excel Wizard. To import these files, first export them to a .epc file then re-import the epc file in the environment.
Excel file issues
Multiple objects in the file with [identifier] for the object [object name].
Multiple identifiers exist within the specified sheets in the imported Excel file. Find the duplicate identifiers and either delete them or modify them (be sure to mirror these changes in the EPC if you wish to overwrite imported data).
The [name] field must not be empty for the object [object name].
Name values cannot be empty. Refer to the cell addresses and assign them a name.
The [object name] identifier must not exceed [number] characters.
There are two identifier character limits in EPC:
- Process identifiers have a character limit of 36
- All other EPC object identifiers have a character limit of 255
Make sure to refer to the cell addresses and modify them accordingly.
The relationship [relationship name] identifier must not exceed [number] characters.
EPC object identifiers must not exceed 255 characters. Refer to the cell addresses and modify them accordingly.
The [object name] [name] must not exceed [number] characters.
There are two name character limits in EPC:
- Resource first, middle, and last names have a character limit of 84
- All other EPC object names have a character limit of 450
Make sure to refer to the cell addresses and modify them accordingly.
The relationship [relationship name] must not exceed [number] characters.
The same name character limits apply to associations as well (see above). Refer to the cell addresses and modify them accordingly.
Invalid URL
The cell contains an invalid URL. The valid formats are:
- http://
- https://
- ftp://
Refer to the cell addresses and modify them accordingly.
Invalid path
The cell contains an invalid file link path. The valid formats are:
- file:/
- file:// (for shared network files)
Refer to the cell addresses and modify them accordingly.
This row has both an empty URL and file link value but only one field can be empty.
Both the URL and file link values for that row are empty. Either one must contain a non-empty value.
This cell has an empty [URL/file link] field.
If only one of either the URL or file link attribute was aligned in the Align Columns section, the value cannot be empty.
A document has either a file link or a URL value, not both.
If both URL and file link attributes were aligned in the Align Columns section, only one value can be empty.
- is not a [frequency] type.**
The frequency type found in the affected cell address is not recognized as an EPC frequency type. Modify the appropriate cells and try the import again.
The date is of an invalid format. The format should be YYYY-MM-DD.
The date value found in the affected cell address is not recognized as a valid date format. The accepted date format is: YYYY-MM-DD. The following fields adhere to the aforementioned format:
The format of [time value attribute] is wrong. The format should be 0 00:00:00.
The time value found in the affected cell address is not recognized as a valid time format. The accepted time format is: 0 00:00:00. Modify the appropriate cells and try the import again.
The value for [impact or likelihood value] must be between 1 and 5 for the object [object name]
The impact or likelihood value found is not recognized as an integer between 1 and 5. The columns which require fields to adhere to the aforementioned format are:
- Gross Risk Impact
- Gross Risk Likelihood
- Gross Risk Detectability
- Residual Risk Impact
- Residual Risk Likelihood
- Residual Risk Detectability
Modify the appropriate information and try the import again.
Cannot import [residual impact or likelihood value] when the attribute [Override residual risk auto-calculation] is not selected; [Override residual risk auto-calculation] must have value X in the same row.
In order to import residual risk impact or likelihood values, the value for the adjoining field under the column “Override residual risk auto-calculation” must be “X”. Additionally the aforementioned column must be aligned during the Align Columns step. Modify the appropriate information and try the import again.
The value for [control or risk value] is not recognized for the attribute [control or risk attribute].
The value found is not recognized as a control or risk attribute.
When the attribute [control attribute] is aligned, the attribute [control attribute] must have value X for the object [object name].
Certain columns require a true value (denoted by a value of “X”) in the adjoining cells in order to be imported successfully. The special requirements are:
- If the “Control Activity Type” column is aligned in the Align Columns section of wizard, then the “Control Activities” cell must have a true (X) value.
- If the “IT Assertions” and/or “IT Control Type” column is aligned, then the “IT Control” cell must have a true value (X).
- If the “Valuation & Allocation Attributes” column is aligned, then the “Valuation & Allocation” cell must have a true (X) value.
Excel Import Process
Section: Select Sheets
You must select at least one sheet.
At least one sheet must be selected.
You must select a root object when you select a sheet.
When a sheet is selected, a root object must be assigned.
You can only select the following root object(s) once.
The root objects can only be assigned once in this section.
Section: Align Columns
You can only assign each EPC Attribute once per object for the following sheet(s):
The EPC attributes can only be aligned once per selected object.
You cannot just select associations for the object [object name].
In order to import associations, the root object (from the EPC Object/Association drop down list) and its identifier attribute (from the EPC Attribute drop down list) must also be aligned.
When you overwrite, you must align the identifier column for the object [object name].
If the option to overwrite was selected, the identifier attribute must be aligned once per selected module in this section.
You must align the Name column for the object [object name].
The name attribute must be aligned once per selected module during the Align Columns section.
You must select a column for file link or URL for the object [object name].
Either the URL or file link attribute must be aligned if the document root object was selected.
When the attribute [control attribute] is aligned, the attribute [control attribute] must also be aligned for the object [object name]
Certain columns are interdependent and must be aligned together in the Align Columns step for a successful import of the respective data. The required alignments are:
- If “Control Activity Type” is aligned, then “Control Activities” must also be aligned.
- If “IT Assertions” and/or “IT Control Type” is aligned, then “IT Control” must also be aligned.
- If “Valuation & Allocation Attributes” is aligned, then “Valuation & Allocation” must also be aligned.
Server side
Server side issues usually occur during the import, such as an error creating an set, object due to different reasons. In this case you will have an import failure notification. Please contact your administrator.
Post your comment on this topic.