Both the imported Excel file and the Import Wizard 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, whether during server validation or the Wizard process.

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. Export them to a .epc file, and import using the Import from EPC Wizard.

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 Modeler 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.
     
  • must be an integer.*
    The audit sample size value found in the affected cell address is not recognized as an integer. Modify the appropriate information 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:

Audit Schedule sheet:

  • Scheduled Date
  • Deadline Date
  • Actual Audit Date

Audit Issues sheet:

  • Raised On

Audit CAPA sheet:

  • Due Date

Modify the appropriate cells and try the import again. 

The format of [estimated effort value] is wrong. The format should be 0 00:00:00.
The estimated effort 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
  • Residual Risk Impact
  • Residual Risk Likelihood
     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.

Import Wizard 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.

The control column is required, please select it.
In the Align Columns section of the Import from Excel Wizard, the control column must be aligned if one of the following sheets was selected in the Select Sheets section:

  • Audit CAPA
  • Audit Issues
  • Audit Plan
  • Audit Results
  • Audit Schedule

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

The import needs to checkout the object [object name] but it is already checked out. Please make sure the object to overwrite is checked in before starting the import.
An object to be overwritten was checked out before the import was started. Close the Import Wizard, check in the appropriate objects, and try the import again. 

An error occurred while trying to find a node on the server.
An error occurred while trying to find data on the server. Try the import again.

The selected destination is deleted. The import is canceled.
An error occurred while importing data to the destination. Try the import again.

  • is not an EPC [object name] type.*
    Please make sure that the imported type values exist on the server.
  • is not an EPC [object name] category.*
    Please make sure that the imported category values exist on the server.

There are multiple objects that already exist with identifier [identifier].
Multiple identifiers exist within the database. The duplicate identifiers must be searched for and modified such that the objects now have new identifiers (be sure to mirror these changes in the Excel file if you wish to overwrite imported data).

A node with identifier [Identifier] already exists in the system. You must select the import option ‘Overwrite’.
Because an identifier already exists in the Modeler, the option to overwrite must be selected during the Import Wizard process.

An error occurred while reading the Excel File.
Verify if the file is not corrupted. If not, try again. If so, choose another file.

An error occurred while checking in row.
An error occurred while checking in data. Try the import again.

Error while creating the import set.
An error occurred while creating an import object set. Try the import again.

Error while creating the import folder.
An error occurred while creating an import object folder. Try the import again.

Need more help with this?
Visit the Support Portal

Thanks for your feedback.