NF11 Export SQL Insert Scripts
From iDempiere en
Goal: UX/Functional
Developer: Hengsin
Feature Ticket: IDEMPIERE-5624
Description
- Add zip - SQL Insert scripts zip archive option to the Export dialog.
- The new export type will export data as SQL insert scripts and create a zip file that includes Oracle and PostgreSQL (oracle/*.sql and postgresql/*.sql) scripts.
- ID value is exported as integer value for official ID and as nextfunc (for primary key) or toRecordId(for foreign key) for non official ID.
Export Dialog
- New option added to export dialog open from the Export toolbar button.
SQL Export Type Options
- With Export current row only turn on, user can choose to select the immediate child tabs as part of the exported zip archive.
- When Export current row only is turn off (i.e all rows), only current header tab will be exported to the zip archive.
Security
- Accessible to Advanced Role only
- Skip column that's secure, encrypted or with the name password
Limitations
The exporter doesn't handle binary type (image, blob, etc).
Sample Export Files
Attached to https://idempiere.atlassian.net/browse/IDEMPIERE-5624:
- Orders.zip - With Export current row only off.
- OrderAndLines.zip - With Export current row only on and Order Lines selected.
