Customizing Export to Excel of Columns in a Table

As installed, the Export to Excel feature in X-CAD Design Management pages exports only certain default columns of a table to MS Excel.

The following section lists the steps required to customize Export to Excel feature to include any required column of a table on exporting to MS Excel.

  1. Run the following MQL commands.
    Run MQL from the Live Collaboration Server folder or from 3DSpace. For more information, see Installation and Setup | Administrate | 3DEXPERIENCE Platform | 3DSpace | Collaboration and Approvals | Administrative Utilities | Running MQL
  2. Search for DSCGeneric table :

    MQL>list table system DSCGeneric;

    MQL>print table 'DSCGeneric' system !history;

  3. Modify setting of required column.

    MQL>modify table DSCGeneric system column modify name <COLUMN_NMAE> setting Export true;

    eg:

    MQL>modify table DSCGeneric system column modify name 'Description' setting Export true;

  4. Repeat step 3 for all required columns.
    For more information, see MQL Concepts ->Modeling Web Elements -> Tables