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 are limited to Application Parameter value” is displayed in the generated csv file. Please narrow your search results and then select the Export option again. Please note that row and column limits are also set by Microsoft Excel and other similar products.
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.