Difference between revisions of "NF11 Export SQL Insert Scripts"
From iDempiere en
(Created page with "'''Goal:''' UX/Functional '''Developer:''' Hengsin '''Feature''' '''Ticket:''' [https://idempiere.atlassian.net/browse/IDEMPIERE-5624 IDEMPIERE-5624] __TOC__ ===Descriptio...") |
|||
| Line 8: | Line 8: | ||
===Description=== | ===Description=== | ||
| − | Add | + | * 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. | ||
[[File:SQL Insert Scripts Export Types.png|800x800px|frameless|SQL Insert Scripts Export Types]] | [[File:SQL Insert Scripts Export Types.png|800x800px|frameless|SQL Insert Scripts Export Types]] | ||
| − | + | ===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. | ||
[[File:Export Current Row to SQL Insert Scripts.png|800x800px|frameless|Export Current Row to SQL Insert Scripts]] | [[File:Export Current Row to SQL Insert Scripts.png|800x800px|frameless|Export Current Row to SQL Insert Scripts]] | ||
| − | + | * When '''Export current row only''' is turn off (i.e all rows), only current header tab will be exported to the zip archive. | |
[[File:Export All Rows to SQL Insert Scripts.png|800x800px|frameless|Export All Rows to SQL Insert Scripts]] | [[File:Export All Rows to SQL Insert Scripts.png|800x800px|frameless|Export All Rows to SQL Insert Scripts]] | ||
| − | + | ===Security=== | |
| − | + | * Accessible to Advanced Role only | |
| − | === | + | * Skip column that's secure, encrypted or with the name '''password''' |
| − | |||
| − | |||
| − | * | ||
===Limitations=== | ===Limitations=== | ||
The exporter doesn't handle binary type (image, blob, etc). | 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. | ||
[[Category:New Features|F]] | [[Category:New Features|F]] | ||
[[Category:New Features w11|F]] | [[Category:New Features w11|F]] | ||
[[Category:New Features Functional]] | [[Category:New Features Functional]] | ||
Latest revision as of 04:47, 12 March 2023
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.
