Setup of grids to export and their settings

Export flag

To add a grid to the list of grids to export, you must add a flag /Export to this grid.

By adding this flag, you will give information to Milliman Mind that it must be added to the Export Manager.

A new button Export manager will then appear on the action bar (after a run).

/ExportSettings grid

You have the possibility to define export settings directly in the flag manager, but they will apply to all grids exported. If you want to define specific settings set for a grid, you will need to define a new grid in your model with the /ExportSettings flag: this grid must be unique and must follow a precise format. You can download the following template: Export_Settings.csv.

It should be flagged with /ExportSettings and have the following columns:

• GridName
  Name of the grid on which to apply export settings.
• ExportByInstance
  true (or 1): Export one file per instance
  false (or 0): Export all instances in one file
• ExportNoInstanceKeys
  true (or 1): Do not add an InstanceKey column to your exported file
  false (or 0): Add an InstanceKey column to your exported file

• ExportByLoop
  true (or 1): Export one file per loop index
  false (or 0): Export all loops in one file

• ExportNoLoopKeys
  true (or 1): Do not add a loop index column to your exported file
  false (or 0): Add a loop index column to your exported file

• Separator
  The separator of CSV/TXT file

• Culture
  The culture code of the selected export culture

• Headers
  true (or 1): Add headers to your exported file
  false (or 0): No headers in the exported file

• SubHeaders
  true (or 1): Add headers per loop index
  false (or 0): Headers only at beginning of file

• IncludeHiddenData
  true (or 1): Include in the exported file all hidden data (Hidden column, rows, ...)
  false (or 0): Exclude all hidden data 

• FileNamePattern
   Define a filename pattern for your export. It can include the following tags (you can use all, none, or just some of them):

  • {ModelName}

  • {GridName}

  • {InstanceName}

  • {LoopsLabels}

  • {yyyyMMdd}

• FileExtension
  The file extension of the exported file (.csv/.txt)

• Locked
  This grid has its settings locked on these values (true/false or 0/1)

• AllowScientificFormat
  Allow to use of scientific notation for number exports when needed (true/false or 0/1)

If one set is not filled in this table, the global settings (for all grids, at the manager level) will be used.

Please also note that the four first settings can also be applied with the following flags: /EXPORTNOINSTANCEKEYS, /EXPORTNOLOOPKEYS, /EXPORTBYINSTANCE, /EXPORTBYLOOP, but the table settings will override them if they exist.

Use the Export Manager

When you will click on the Export Manager button in the action bar, this popup will appear:

You will be able to select which grids you want to export with the predefined settings from /ExportSettings grid (you can see them by hovering the blue switch button), and all the Loop/Instances settings with checkboxes.

If you click on the Export Choices button for each line, you will be able to select which instances and loops you want to export:

Additional parameters

Please note that you need to have the following right to access this feature:
Project export manager settings access

More options are available globally (delimiter, culture, preserving tree structure, and file prefix/suffix) if you have the correct right (Export Settings Update right) defined by your administrator. Please note that by default, specific settings override global settings. You can access them by clicking on the Show global settings arrow. Please note also that Prefix/suffix options are always accessible.

Export CSV/TXT files

When everything is ready, just click on the green button Export and download CSV files on the bottom-right to start your export (all files will be downloaded in one ZIP file).

Export Excel files

You can also export an Excel file with updated results by clicking on the button Export & Download Excel file on the bottom-left corner.

Update /ExportSettings grid

Please note that you need to have the following right to access this feature:
Project export manager settings save

You can update (if you have the Export Settings Update right) the export settings grid in the Model manager, like other unique tables (instances, translations, ...).

Simply export the table as a CSV, edit it then import the new version.

Export of individual grid

You can still use the single grid export if you want to export the content of only one grid. Check this article for more information: CSV export of table‍