Exporting elements

You can export the contents of a view in table structure to Microsoft® Excel. You might export and import elements from and to Excel to move elements from one workspace or installation to another. However, you cannot import or export the attribute types file, history, and matrix. You can export 8 KB of characters for each cell. Exporting elements is useful when you want to move elements from one workspace or installation to another. The attribute types File, Time Grid and History cannot be exported or imported. The export and import of the attribute types Link, Link List and Matrix attribute types require special handling.

Before you begin

To export elements from Excel, you must be an administrator.

About this task

To export elements:

Procedure

  1. Click Display and select a view in which you find the elements you want to export.
  2. Select Table structure.
  3. Optional: Create a filter to export a subset of the elements or to export a subset of the attributes.
  4. Click Export. The limit on characters in each cell is 8K.
  5. Click Open to open the Excel file and view or edit its content.
  6. Click Save to save the file.
    Note: If the Excel file opens in a web browser rather than in Excel, change the following setting:
    • Open Windows Explorer and select Tools > Folder Options > File Types.
    • Scroll down to XLS and click Advanced.
    • Clear the Browse in same window check box and click OK.

Feedback