Database::rsOutput2File | ||||||||||||||||||||
Description | ||||||||||||||||||||
Output the contents of the recordset which is referenced by "Source Handle" to a textfile, spreadsheet, Microsoft Excel, Microsoft Word or XML file. The "Internal Translation Table" is used to perform character-translation on the source-data before it is output to the file. The combobox contains a list of tables which are available in the INTERNAL-database. The structure of a "Translation Table" has to be as follows;
Use [Chr(nnn)] to specify specific ascii-codes and [CrLf] for carriage-return-linefeed. |
||||||||||||||||||||
![]() |
||||||||||||||||||||
Options | ||||||||||||||||||||
Source
Handle |
Name of the handle which references the desired source-recordset. | |||||||||||||||||||
Internal Conversion Table |
The name of the table that is to be used to apply character-translation during the output of the data from the recordset to the file. | |||||||||||||||||||
Fixed
Length |
When checked, all fields will be exported with a fixed length. If the field is not configured in the "Forced Fixed-length list" then the original field-length of the source-field will be used. The space-character is used as padding. | |||||||||||||||||||
Add
Column Names |
When checked, the first line will contain the column-names of the recordset. | |||||||||||||||||||
Add
Record Number |
When checked, the first column will contain the record-number. | |||||||||||||||||||
Auto
Create Directories |
When checked, missing directories will automatically be created. | |||||||||||||||||||
Forced
Fixed-length List |
In
this list field (column)names can be configured together with the type and
the length of the output. Syntax: fieldname:type:length fielname:name of the field type: s=string-value, n=numerical value (string-value will be "left-aligned" and numerical-value will be "right-aligned") length: the fixed-length of the output-data (padded with spaces). |
|||||||||||||||||||
rsOutput2File - Textfile | ||||||||||||||||||||
![]() |
||||||||||||||||||||
Options | ||||||||||||||||||||
Output
Textfile |
Name of the output textfile. | |||||||||||||||||||
Create
New File |
When checked, a new outputfile will be created, overwriting the old file. | |||||||||||||||||||
Column
Delimiter |
The
character that will be used as a delimiter when writing the data to the
file. example: field1,field2,field3 (delimiter is ,) |
|||||||||||||||||||
Header |
String to write as a header to the file. | |||||||||||||||||||
End
of Record |
String to use at the end of each record (example: <CrLf>). | |||||||||||||||||||
Footer |
String to write as a footer to the file. | |||||||||||||||||||
End
of File |
String to write at the end of the file. | |||||||||||||||||||
Encoding |
The encoding of the outputfile. | |||||||||||||||||||
rsOutput2File - Spreadsheet | ||||||||||||||||||||
![]() |
||||||||||||||||||||
Options | ||||||||||||||||||||
Output
file |
Name of the output file. | |||||||||||||||||||
Worksheet |
The name of the worksheet. | |||||||||||||||||||
rsOutput2File - Microsoft Excel | ||||||||||||||||||||
![]() |
||||||||||||||||||||
Options | ||||||||||||||||||||
Output
Excelfile |
Name of the output excel file. | |||||||||||||||||||
Worksheet |
The named of the desired worksheet. | |||||||||||||||||||
Update
Existing Workbook |
When checked, will update the existing workbook (not create a new excel file). | |||||||||||||||||||
Create
Worksheet |
When checked, will create the specified worksheet in the selected workbook. | |||||||||||||||||||
Clear
Cells Only |
When checked, will only clear the selected cell-range. | |||||||||||||||||||
Start
Cell / Start Row |
Cell-range which will be updated with the data referenced by [handle]. | |||||||||||||||||||
Cell
Type |
Sets
the cell-type of the cells that will be updated.
|
|||||||||||||||||||
Numberformat |
|
|||||||||||||||||||
Clear
Cells |
Cell-range which will be cleared. | |||||||||||||||||||
rsOutput2File - Microsoft Word | ||||||||||||||||||||
![]() |
||||||||||||||||||||
Options | ||||||||||||||||||||
Output
Wordfile |
Name of the output word file. | |||||||||||||||||||
Portrait
/ Landscape |
Make document in portrait or landscape. | |||||||||||||||||||
Column
Delimiter |
The
character that will be used as a delimiter when writing the data to the
file. example: field1,field2,field3 (delimiter is ,) |
|||||||||||||||||||
Header |
String to write as a header to the file. | |||||||||||||||||||
End
of Record |
String to use at the end of each record (example: <CrLf>). | |||||||||||||||||||
Footer |
String to write as a footer to the file. | |||||||||||||||||||
End
of File |
String to write at the end of the file. | |||||||||||||||||||
rsOutput2File - XML | ||||||||||||||||||||
![]() |
||||||||||||||||||||
Options | ||||||||||||||||||||
XML
output file |
Name of the XML output file. | |||||||||||||||||||
Include
inline XSD schema... |
If enabled, the XSD schema will be included in the XML file. | |||||||||||||||||||
Use
SQLserver XML |
If enabled, the built-in XML exporter of the SQLserver driver will be used. | |||||||||||||||||||
Format
XML |
If enabled, will format the XML into a visually "pleasing" format. | |||||||||||||||||||
XSD
schema output file |
Optional filename for the XSD schema. |