The Export to Simple Table will export the data, according to the rules applied, to a Simple Table that has been applied to a Project.
The data exported will only be available, if required, to the current specification from which it was started.
Tables, using the Simple Table template in the Define Tables task, can have new records inserted or existing records updated by creating an Export to Simple Table document.
Before you begin
When creating an Export to Simple Table document a table that uses the Simple Table template must exist in the project.
With your project open in DriveWorks Administrator go to Stage 4. Output Rules> Documents.
Control fields determine if a row is inserted, updated, or ignored.
Common Fields can make it easier to export to multiple rows where certain columns always have the same value in each row.
For these columns, you may only want to build one rule, instead of a separate rule for each row. To do this, mark the column as a Common Field, and DriveWorks will automatically use the same rule for the column in all rows.
The wizard will close and the Data Export Rows table will open in the Documents window.
With the Data Export Rows table open in the Documents window:
As with all documents the automatic release is covered by the Release Documents task. When using the default specification flow this task is applied to the Completed state on the Enter State Event.
A manual release can be applied by having a macro button on the user form and assigning the Release Documents task to a specification macro.
DriveWorks Tech Tips Portal
Shows how you can copy data from one Simple Table to another, remove selected rows and clear the whole table using macros.
Editing Table Data
This project shows how to add, edit and delete data from a Simple Table. The methods used in this can be transferred to Group Tables and also SQL Tables.
Export To Group And Simple Tables
Demonstrates how to export data from a specification into either a Simple or Group Table for later use.