Exporting Data

Many pages include an Export tool in the page toolbar that lets you export the table data to a file. The export always includes all rows currently in the table, even those on subsequent pages for paginated tables, however, it does not include rows that have been filtered out of the table using one of the table filter mechanisms.

Before you begin:
  • Select a menu command from the menu; or:
  • use any method to view a page.
Related Topics
Choosing an Export Format

  1. Click on the table page toolbar.

    If you chose CSV or Text as your preferred export format, a dialog appears asking if you want to open or save the report.

    If you chose HTML as your export format, the table data opens in a new browser window as an Excel file.

    If any of the fields on the page include an mxLink (hyperlink to an ENOVIA object), that field is converted to straight text and cannot be clicked.

    When exporting a structure compare report, you can only export to HTML format. These reports require color-coding and the other formats do not support colors.

  2. Use this table to save or open the file:

    If the export format is: Steps to open or save the file:

    CSV

    To open the file in Excel, click Open.

    The file opens in Excel if you have Excel installed. Work with the file and save it as needed.

    To save the file, click Save. The default extension is *.csv.

    HTML

    From the Excel menu in the browser, save the file as needed.

    Text

    To open the file in your default text editor, click Open.

    Work with the file and save it as needed.

    To save the file, click Save and save the file. The default extension is *.txt.

  3. If exporting Japanese text to a CSV file, follow these steps:

    Excel does not recognize UTF-8 codes, the code used by ENOVIA.

    1. In step 1, when prompted to Open or Save the file, choose Save.
    2. Using Notepad, open the file. The Japanese characters display correctly.
    3. From Notepad, select File > Save As.
    4. From the Encoding list, select Unicode.
    5. Click Save.

    You can now open the exported CSV file in Excel.