Overview

You can use this module to export a list of persistent objects from your Mendix app using OQL. To use this, there is a need for set up Mx Model Reflection, setting up Excel templates from the frontend and OQL module. Associated objects will be exported as per OQL query. 

Documentation

Description

You can use this module to export a list of persistent objects from your Mendix app using OQL. To use this, there is a need for set up Mx Model Reflection, setting up Excel templates from the frontend and OQL module. Associated objects will be exported as per OQL query. 

Typical usage scenario

Large amount of information or record export into excel file is a memory intensive process using current marketplace module. So, if you want to export large set of record into single excel file using minimum JVM memory then this module will help you.

Features and limitations

The goal of this module was to create a Excel file for large amount of record using OQL query. 

Features:

ExportOQLToExcel: Export Excel Java action with following configuration parameter

- Statement: The OQL statement to be executed. See the OQL module for usage.

- ReturnEntity: The type parameter should be a specialization of FileDocument.

- SheetName: Exported excel file default work sheet name

- ShouldLocalizeDate: Localize or UTC date format

- BatchSize: Batch record size which will be used for record processing bucket size. Maximum number or record will available in JVM memory as per patch size configuration.

- isCustomHeade: Flag for customize excel header row fields name

- CustomHeades: Custom headers fields name with || separator

Limitations to this module:

Only OQL based export supported.

Dependencies

Developed this module using Mendix 9.24.16.

Dependence module are,

• Community Commons
• Mx Model Reflection
• Excel Exporter
• OQL