Skip to main content

Create Ticket Import Data Source Using a MS Project Excel File

Note: Projects must create a data source to link their files to prior to using the ticket import feature

Written by Sarah Cusack

To create a MS Project ticket import data source:

  1. Click the three-dotted button next to the project name.

  2. Select Project Settings.

  3. Under the Data Sources drop down menu, click Create New Data Source.

  4. Enter a Data Source Name (for example, MS Project File).

  5. From the Data Source Type dropdown, select MS Project Excel.

  6. Choose a Data Source Date Format.

  7. Select a Ticket Time Resolution:

    • Day – Import ticket durations in days.

    • Time/Hours – Import ticket durations in hours and minutes for plans with Precision Time Planning enabled.

  8. (Optional) Enter a WBS Separator if needed. This is not required for MS Project Excel data sources.

  9. Click Save.

For more information on how to import tickets into Touchplan in a MS Project Excel format click here.

Did this answer your question?