SetConnect

Boka demo Om oss

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