You can export the contents of a view in table structure
to Microsoft Excel and
CSV format. 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 8 KB of characters for each cell. 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, you must be an administrator.
- You can select field separator corresponding to your regional
computer settings from .
Procedure
- Click Display and select a view
in which you find the elements you want to export.
- Select the Table structure.
- Optional: Create a filter to export a subset
of the elements or to export a subset of the attributes.
- Click Export.
- Click Open to open the file and
view or edit its content.
- 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 .
- Scroll down to XLS and click Advanced.
- Clear the Browse in same window check box
and click OK.
- If the number of cells exceeds the limit, the option to export
to Excel will be not available. 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'.