NF11 Export SQL Insert Scripts

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.

Illustration with Screen Shot

New option added to export dialog open from the Export toolbar button.

Dialog for the "zip - SQL Insert scripts zip archive" export type. 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.

Samples

Samples 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.

Limitations

The exporter doesn't handle binary type (image, blob, etc).