Exporting elements

You can export the contents of a view in table structure to Microsoft Excel 2003, Excel 2007, Excel 2010 and CSV formats. You can move elements from one workspace or installation to another. The CSV format is the default option for export. In Excel export, you can export 32767 characters for each cell. There is no limit to export on the number of characters per cell in the CSV format. 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

Procedure

  1. Click Display and select a view in which you find the elements you want to export.
  2. Select the 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.
  5. Click Open to open the file and view or edit its content.
  6. Click Save to save the file.
    Note:
    1. 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.
    2. If the number of cells exceeds the limit, the option to export to Excel 2003 is unavailable due to memory constraints. The default limit is 20000. You can change this default limit in the application settings on the SQL page of the Advanced menu. Update the value of the setting: update projectsetting set value='30000' where name='excel.export.limit'.

Feedback