SetConnect

rsOutput2File

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;

Column-name
Column-type Description
OrderId
Integer Order in which the translation will take place
Enabled
yes/no enable or disable record
inString
Memo The string in the source-data that must be translated to outString
outString
Memo The replacement-string
Description
Text Optional description-field

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.

Valid options:

Normal
normal (unchanged)
Hyperlink
data will be displayed as a hyperlink (web or email)
note: "http://" and/or "mailto:" must be included in the data
AutoDetect

the plugin will autodetect if the data is "normal" or a hyperlink
note: "http://" and/or "mailto:" must be included in the data

Numberformat
Normal
save value to cell "as-is", without changing the numberformat
Detect
adjust the numberformat of the cell based on the detected datatype of the value
Recordset

adjust the numberformat of the cell based on the datatype of the recordset column

Worksheet

adjust the numberformat of the cell based on the numberformat of the worksheet cell (can only be used in combination with "Update Existing Workbook")

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.

Documentation

Release notes