Import Data via the Clipboard

Use your Windows clipboard to exchange data types (such as activity templates) from other programs with various Tilos Explorer lists so that you have consistent data between the two. You can copy data from another program, such as MS Project or ASTA Primavera, paste it into Microsoft® (MS) Excel, copy to the clipboard, and then import it into Tilos.

Using existing Tilos data from your project and libraries enables you to add equivalent data types to Activities in other programs before importing those projects into Tilos. Exporting and importing using your clipboard makes this exchange quick and easy. Data can be used to create formulas and macros, amend a project schedule, or edit library entries, such as assigning Activity templates to MS Project Activities. Working with such exported data gives colleagues who do not have Tilos or MSP a way to edit project data.

Importing using the clipboard is not a substitute for native importers or a subset of their functionality; you would have to copy and paste exactly the same data that is in, for example, MS Project or Primavera. Instead, the intent is to transfer available information from those other programs through MS Excel to make it available for use as data types in your Tilos project data or library list views. Whether the data is project data or library data, the purpose of importing via the clipboard is the same; it is to make data types (not specific data) from elsewhere available to your Tilos project.

Note: You cannot delete items via the clipboard. You can, however, change the data of existing items and re-import them into Tilos.

Note: Graphic objects and data, such as images, symbols, vector lines, and vector line endings, are not importable via the clipboard; only textual list items are valid.

Types of items can be imported using the clipboard

  • Project Data >Distance Axis Definitions > Equations

  • Project Data >Distance Axis Definitions > Equations > Equation Properties

  • Project Data > Distance Axis Definitions > Distance Grids > Distance Grid Properties

  • Project Data > Distance Axis Definitions > Mass Areas

  • Project Data > Distance Axis Definitions > Mass Haulage

  • Project Data > Time Axis Definitions > Time Grids > Time Grid Properties

  • Project Data > Graphic Libraries > Layers

  • Project Data > Categories

  • Library > Resources and Accounts > Resources

  • Library > Resources and Accounts > Accounts

  • Library > Resources and Accounts > Delivery Centres

  • Library > Other Libraries > Currencies

  • Library > Other Libraries > Units

  • Library > Other Libraries > Link Categories

  • Library > Other Libraries > Sector Types

  • Library > Other Libraries > Users

  • Library > Other Libraries > Mass Types

  • Library > Other Libraries > Haulage Types

Configure a list view

Use these steps to set up what is visible in a list view.

  1. Right-click a column header and select Setup.

  2. Click < until all of the fields have been removed.

  3. Click >> to re-add all fields.

  4. Click OK.

  5. To copy just the currently visible list fields to the clipboard, simply by right-clicking a table's column header and selecting Copy Data to Clipboard.

Import into a list view to the clipboard

  1. Copy from MS Excel or a similar tabular program to the clipboard by selecting cells and pressing the shortcut Control + C.

  2. With one of the Tilos Explorer > Project Data or Library lists open, click the Import from Clipboard button.

  3. In the Fields for Clipboard Import/Export dialog, check/uncheck boxes for all of the fields you want to include/exclude in the import.

Note: If the Fields for Clipboard Import/Export dialog does not appear, all available fields in the list are imported.

Note: The Read-only values cannot be imported, for example, a label is not allowed to be overwritten by an imported label.

  1. To rearrange the order of the imported columns, change any of the non-Read-only Column Numbers or Column Letters. You can also use the buttons to change column order.

  2. To see what is ready for import, check the Hide unselected rows box. Also, review the Clipboard preview at the bottom of the pane to see the order and fields that will be imported.

  3. Click OK. The data is pasted into your open Tilos list.

Next topic: ---