Troubleshooting Project Data Imports

Ensure the data you are entering in the data table and the config table is accurate. An import can fail as a whole, or only single lines within the data table can fail to import.

If the import fails to run for any lines in the data table, verify that your data and config tables meet the following requirements:

• The config table has one row identified as TRUE or YES in the Unique Identifier column.
• If you are using Last Gate Number or Last Gate Decision Name, confirm that either they both exist or both do not exist.
• All Metric System Names that are specified in the config table exist in the data table, even if they contain no data in their columns.

If the import runs, but you receive errors about some lines not being imported, verify that the data and config tables meet the following requirements:

• The Unique Identifier is truly unique. For example, if the config table sets the Project Code as the Unique Identifier, and the data table contains two projects named Project A, the second Project A does not import.
• All required metrics for a process model are included in each project creation row in the data table. If a required metric is missing, the project fails to import.
• All required metadata fields for a process model, such as Start Date or End Date, are included in each project creation row in the data table.
• The Project Code is included in each row.
• The date in the GateDateXX column for a project in the data table is a gate number within the process model. For example, if the process model has 5 gates, and the data table contains data in a GateDate06 column, the import fails because that process model does not contain a 6th gate.
• Accolade expects project codes to be imported as strings. If the project codes are numbers, or the Auto-Generate Project IDs system parameter is enabled (which creates numeric project codes), you must first upload a data table following the format described above that contains a single row of data with a project code entered as a string. After uploading the data table with a single row, upload subsequent versions of the data table that contain the true project data information.
• Project links imported using the Date - Date link type are set to the default settings for the link type if the project does not contain the date information entered for the From and To dates.