Uploaded file contains one or more unknown columns which will be ignored

The listed columns are not imported to ITP, but other valid columns are imported normally.

Uploaded files must follow ITP's template and column placement. Columns that are not part of ITP's templates are not recognized and will not be uploaded.

The error message should list all instances of omitted columns.

Ensure you are importing data using the associated ITP template.

1. Navigate to the page you wish to import data to.
2. Click the Actions button, then select:
   
   • Export <Page name> Template... to download a blank template.
   • Export <Page name>... to download all current data in template format.
3. Templates are in the .CSV filetype, which can be edited using Excel.
   • All columns accepted by ITP will be included in the template.

Invalid Formatting of uploaded data

The listed values are not uploaded into ITP, which may leave gaps in your dataset.

ITP has identified data that is incorrectly formatted. As explained in the previous entry, ITP uses templates for data imports. Each template column requires a specific type of data (i.e. text, numerical, etc.). Failure to match the correct value type for a column is the most common cause of this error.

The error message should list all instances of improperly formatted data.

Investigate your data and confirm that all column data is correctly formatted for its respective column.

• Numbers: no formatting, punctuation, or symbols (600000)
• Text: no punctuation (Executive). Spaces are allowed if necessary (Accounts Payable)
• Date: For more information, see Troubleshoot invalid date formats in ITP 
• Excel equations or functions are invalid

Could not resolve one or more references to another table

The data listed in the error is not imported to ITP because it cannot be correlated to existing Reference Data.

Imported data must correlate with your Reference Data, which acts as a key to link Departments, Accounts, and IDs. The non-required data you are importing cannot be found in your Reference Data.

The error message should list all instances of data that cannot be correlated to Reference Data.

1. Verify that all values in your imported file correlates to your published Reference Data. If not, update your Reference Data.

   • For more information, see  Manage reference data dimensions.

2. Select Update Reference Data only for the budgets you wish to apply changes to.

3. Import your data again and confirm that your Reference Data changes are successful.

Setting unknown lookup value to the default

In Reference Data, you can create custom lists and dimensions.
Once established, these custom elements act in the same way as all other Reference Data.

This error is functionally the same as the previous error, "Could not resolve one or more references to another table:", but specific to custom lists and dimensions.

1. Verify that all values in your imported file correlates to your published custom lists and dimensions. If not, update your custom information and import it into ITP.
2. Click Update Reference Data only for the budgets you wish to apply changes to.
3. Import your data again and confirm that your Reference Data changes are successful.

Uploaded files contains more than one column with alias names that are reserved for the same column.

First encountered column of duplicates will be used: <Column1>. Duplicate column will be omitted: <Column2>

<Column1> is imported while <Column2> is not imported to ITP.

ITP has detected multiple column names matching the name of a template column.

In the example image, there are two columns identified called "Cost Center Code" and "Cost Center." Both columns include the required column name "Cost Center."

ITP will default to the first column that matches in order from left to right when reading the .CSV file. Any additional column matches will not be imported.

If you wish to use one name over the other, switch the order the columns so your preferred name will be read first (in order from left to right).

Invalid Cost Center and Cost Object Mappings

Departments and Projects can be associated with specific Cost Centers. If so, only those Cost Centers are considered valid.

Your imported data is associating Cost Centers with Departments that are not explicitly permitted in your current settings.

For Departments

• Go into Departments Reference Data and update the associated Cost Center Codes.
• You can leave the Cost Center Code column blank to allow all Cost Centers.

For Projects without Investment Planning

• Go into Projects Reference Data and update the associated Cost Center Codes.

For Projects with Investment Planning:

• Go to the Project Listing view and modify the Cost Center Code column.

NOTE: For Projects, you can enable the Allow Any Cost Center option to disable the mapping restriction. This option is available in Project Reference Data or Project Listing, depending on whether you have Investment Planning.

Could not resolve one or more references to another table

Imported data must correlate with your Reference Data, which acts as a key to link Departments, Accounts, and IDs. The required data you are importing cannot be found in your Reference Data.

The error message should list all instances of data that cannot be correlated to Reference Data.

1. Verify that all values in your imported file correlates to your published Reference Data. If not, update your Reference Data.

   • For more information, see  Manage reference data dimensions.

2. Select Update Reference Data only for the budgets you wish to apply changes to.

3. Import your data again and confirm that your Reference Data changes are successful.

Uploaded data includes items that have been delegated from other cost objects, these items will be excluded

Delegated costs occur when a project has ended and its upkeep costs have moved to a different Department. Delegated costs will still appear in their original Department as greyed out, read-only rows.

Delegated costs data must be updated where the cost has been delegated.

Identify where the cost has been delegated. You must update these costs in their delegated location, not their source location.

For more information, see Delegate project costs.

We're sorry, but we cannot publish the... dimension

because one or more reference tables are using values that are no longer present in the version you want to publish

Publishing Error
Reference Data that previously existed in ITP or ITFMF is now missing. Because elements of your report depend on that Reference Data, a major error is produced and the publish operation fails.

No Changes Detected: 1 error detected in <Dataset>, including the following: Uploaded file did not contain any columns in the header row:

CT to ITP Integration Error

This issue may be caused by:

• An error in the Cost
  Transparency Integration
  settings or configuration.
• One or more imported tables
  are Checked Out in Cost Transparency.

Navigate to IT Planning, click the Settings Menu, then click Cost Transparency Integration. Verify the following:

1. All tables are spelled and named correctly in the Plan Integration, Actuals Integration, and Reference Data Integration sections.
2. The Import From field is set to Development.

Navigate to Cost Transparency and verify the following:

1. All tables are Checked In.
2. Set the current Fiscal Year to Open.

No Changes Detected: 1 error detected in <Dataset>, including the following: Empty Header:

CT to ITP Integration Error

IT Planning is pulling data from the current month in Cost Transparency. The month must be open in CT; otherwise the integration cannot find any data.

1. Navigate to Cost Transparency.
2. Open the Current Month in CT.
3. Click Save.
4. Return to IT Planning and try importing again.