|
ODBC Export Plugin |
|
|
|
|
|
ODBC Export Plugin |
|
|
|
|
It enables the export of the characteristics of variables and expressions through the ODBC connection to different databases.
Construction of the window of plugin settings:
1. ODBC settings:
| • | Connection string: the string containing the parameters needed for connection. |
| • | Connection string wizard: by clicking on the button a wizard of some steps will help us to set up a connection string easily and we can modify its most frequently used options. |
| • | Connection test: we perform a trial connection with the actually specified connections string. |
2. Other:
| • | Enable logging: recording the most important events into the Windows Event Log. |
| • | Displaying message windows during running: displaying message windows concerning the successful export (requires user interaction). |
3. Expressions and variables:
| • | By the Enable Export option we can specify if we want to export expressions and/or variables. |
| • | Select the New Table tab, if you want to create a new table in the ODBC data resource for expressions/variables. In this case the format of table name will be "<groupname>-<exp/var>-<timestamp>" - if for instance we export the variables of group untitledGroup_0 on 11. 09. 2009. at 8:38:30 AM, then the name of the file will be untitledGroup_0-var-20090911083830. The Accessible Attributes and the List of Attributes to be Exported include the fields of expressions and variables. The plugin will write out only the items of the List of Attributes to be Exported in the order given bellow. |
We have to choose the To Existing Table tab if the data table is already exists in the data source in which we want to export. After adding the connection string and clicking on the Table Names Reading we have to select the suitable data table, then by clicking on the Align Columns a window will appear in which we can determine which field will present with expression- or variable attribute. Any text can be assigned to the columns of the target table, and then it will be presented in each row as a constant. If we skip one field from alignment, then there will not be anything.
All our expressions and variables have several other attributes - besides their value - which we can export.
See also:
