Export

From ADempiere
Revision as of 21:33, 21 December 2010 by Sarafudheen (Talk)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Table of Contents{{#if: Functionality| | Functionality }}{{#if: | | [[{{{3}}}]] }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Export{{#if: History| | 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.

Access

Icon: Icon Export24.png
Menu: →Export }}{{#if: | → }}{{#if: | → }}
Short Cut: none

Restrictions

To enable exports, the user's role must have Can Export checked in the {{#if: |{{{2}}}|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