Export

From ADempiere ERP Wiki

Jump to: navigation, search

Table of Contents | Functionality | Export | History

Export will open a save dialog where you can save data as an XLS spreadsheet. The saved file will then be opened in the appropriate software.

Contents

Access

Icon: Image:Icon_Export24.png
Menu: File→Export
Short Cut: none

Restrictions

To enable exports, the user's role must have Can Export checked in the Role Window.

Description

The Export function will export the data in the current window or report to a XLS file. When the button is clicked, a save dialog (java file chooser) will appear where you can select an existing file or name a new one. At the moment, only XLS file extensions are allowed. If you select a file with a different extension, the software will show an error. The export function will create or overwrite the file selected.

If you generate the export from a report, the file chooser will not appear. Instead, the software will create a file in the default temporary file directory with the name Report_(some random characters).xls. The default temporary-file directory is specified by the system property java.io.tmpdir. On UNIX systems the default value of this property is typically "/tmp" or "/var/tmp"; on Microsoft Windows systems it is typically "C:\WINDOWS\TEMP".

The XLS file will contain all data returned by the current query/report and all columns that have the "printed" flag set.

UTF 16 encoding is used.

For Developers

The software that controls this dialog is found in

  • base/src
    • org.adempiere.impexp.AbstractExcelExporter.java
  • client/src
    • org.compiere.apps.APanel.java
    • org.compiere.apps.AExport.java
Personal tools