Export Grid Results

Some pages in Advantage allow you to export either all records in the grid (including those on other pages of the grid) or only those selected in the grid (including those selected on other pages of the grid) to a CSV file. If this feature is enabled for a page, then the following actions may be available via the Grid Actions menu what records and columns are exported to the CSV file:

• The Export > Viewable Columns action exports only the records that are selected in the grid (including those selected on other pages of the grid). This action only exports the columns that can be viewed as a column on the grid or in the scalar section of the grid.  

• The Export All > Viewable Columns action  exports all records in the grid results (including those on other pages of the grid). This action only exports the columns that can be viewed as a column on the grid or in the scalar section of the grid.

• The Export > Available Columns action exports only the records that are selected in the grid (including those selected on other pages of the grid). This action exports all columns (including those fields that are not displayed on the grid or grid scalar).

• The Export All > Available Columns action exports all records in the grid results (including those on other pages of the grid). This action exports all columns (including those fields that are not displayed on the grid or grid scalar).

Warning: If a field is stored as encrypted in the Database and is used on the page, then the field’s decrypted value is displayed. The decrypted value is also exported with the Available Columns and Viewable Columns actions. If a field is masked using UI Field Security, then the field is exported as masked.

The generated CSV file can be opened in Microsoft Excel through an import wizard. Refer to the “Export Grid Results to CSV” topic under Common Business Tasks for detailed instructions on how to export the results to a CSV file and how to use an import wizard to open the file in Microsoft Excel.  

The MAX_DOWNLOAD_LINES (Max Download Lines for Download) parameter on the Application Parameters page in the Administration application sets the maximum number of lines that can be exported to the CSV file. If the total number of records exceeds this limit, then a message “Results limited to the first <limit> matching records” is displayed in the generated csv file. Please narrow your search results and then select the Export option again. Please note:

• The maximum number of rows that can be exported may differ from page to page, depending on a page specific property, downloadMaxRows, which is defined in the page xml properties and takes precedence over the MAX_DOWNLOAD_LINES parameter on the APPCTRL page. A File Based Extension or Configure Page (DESIGNER) can be used to extend this property as needed.

• The row and column limits are also set by Microsoft Excel and other similar products. 

• The above considerations apply to both “Export Grid Results to CSV” and “Export Grid Results to Spreadsheet” functionalities listed under the “Common Business Tasks” topic.

Note: While performing the Export > Viewable Columns and Export All > Viewable Columns actions, the CSV output from a page with a complex grid (a grid that has an internal scalar section with multiple tabs) limits the download of data only to the columns that are selected as primary columns by the user. The system does not support downloading the secondary columns from a page with a complex grid. As a solution, it is recommended to make the desired field that is currently in the scalar section as primary using the Configure Columns icon. This will display the field as a column in the grid, and can then be exported to a CSV file successfully.

A page with a simple grid (that is, a grid that has a single scalar and not multiple tabs), exports both Primary and Secondary data to CSV.