Only data managers and data architects can import managed data as CSV files from external applications.

Managed data refers to data fields that are populated exclusively by importing data from an external data source, such as a Microsoft® Excel spreadsheet. Because managed data is read-only, users cannot edit the values. This eliminates manual re-entry and user error and increases the integrity of your dashboard reports.

  1. In the web app, select Data.
  2. If available, select Upload Data. If this button is unavailable, you must create a Managed Data for Projects table in the sandbox. Go to Create data tables.
  3. Select Browse File and navigate to the location of the CSV file that you want to import. You can upload only one CSV file at a time.
  4. Select Upload. Engage uploads the data and displays it as a table on the Data page.

After you import managed data, you can use it to design forms and create dashboard reports. For more information, go to Design a form or Create a report.

Guidelines for saving a CSV file

When you create a CSV file for import, follow these guidelines.

  • Make sure that the first column of the CSV file is the Project Identifier field.
  • Make sure that the remaining columns in the CSV file appear in the order that they appear in the dialog box.
  • The CSV file must contain the same number of columns as the table for managed data, plus one column for the Project Identifier.