export / import

Contents

saveas=typ=file

Export in the following formats:

excel, html, text, clipboard, dbase,csv, wmf, psr

dw_2.saveas=excel=c:\temp\test.xls

excel (or xls) = formated excel

exceldata = all data without format to excel

dbase = dbase3-format

text = text-format

csv = csv-format

html = HTML TABLE, TR, and TD elements

clipboard = copy to clipboard

wmf = Windows Meta Format

pdf = pdf-format - only if driver for this functionality installed

xml = Extensible Markup Language (XML)

emf = Enhanced Metafile Format

dif = Data Interchange Format

sylk = Microsoft Multiplan format

wks = Lotus 1-2-3 format

psr = Powersoft Report (PSR) format

dbstring = copy in beas-own dbstring-format. You can import this string with dw_x.importfromdbstring

if filename is empty, beas save this in value "value"

saveasascii

dw_1.saveasascii=filename=separatorcharater(optional)=quotecharacter(optional)=lineending(optional)=retainnewlinchar(optional)

Saves the contents of a DataWindow into a standard ANSI text file.

saveasformattedtext

dw_1.saveasformattedtext=filename=encoding(optional)=separatorcharater(optional)=quotecharacter(optional)=lineending(optional)=retainnewlinchar(optional)

Saves the contents of a DataWindow into a standard text file with custom formatting.

loadpsr=file

Load psrfile into the current window (only data, not formats)

Example:

// savescript

dw_1.saveas=psr=test.psr

// loadscript

dw_1.loadpsr=test.psr

The items from source and destination must be the same!

Only psr-Files!

importfromdbstring=<value>

import from value, which is exportet widh "saveas=dbstring"

Example

dw_1.saveas=dbstring

dw_2.importfromdbstring=<value>

importfromdbfile=<filename>

Import from file in beas dbstring-format

Saves the contents of a DataWindow into a standard ANSI text file.

SaveAsAscii formats the text and saves column headers in the form in which they are displayed in the DataWindow instead of as the column name, include computed columns and group totals

dw_1.saveasascii=filename=separatorcharater(optional)=quotecharacter(optional)=lineending(optional)=

retainnewlinchar(optional)

Returns the filename in <value> Parameter

Parameter	Description
filename	A string whose value is the name of the file in which to save the contents. if the filename is not spacified a window will be opend to enter the filename. dw_1.saveasascii
separatorcharacter (optional)	A string whose value is the character to be used to delimit values. If you omit separatorcharacter, the default is a tab character.
quotecharacter (optional)	A string whose value is the character to be used to wrap values. If you omit quotecharacter, the default is double quote. For blank you have to asign „no“ dw_1.saveasascii=filename==no==0
Lineending (optional)	A string whose value is placed at the end of each line. If you omit lineending, the default is a carriage return plus a newline character (~r~n).
retainnewlinechar (optional)	A string value (internal boolean) that determines whether line feed and carriage return characters contained within the row are converted to white space. Values are: True : true , 1, t - line feed and carriage return characters within the row are not converted to white space False (default) : false , 0, f - line feed and carriage return characters within the row are converted to white space

Saves the contents of a DataWindow into a standard text file with custom formatting.

SaveAsAscii formats the text and saves column headers in the form in which they are displayed in the DataWindow instead of as the column name, include computed columns and group totals

dw_1.saveasformattedtext=filename=encoding(optional)=separatorcharater(optional)=

quotecharacter(optional)=lineending(optional)=retainnewlinchar(optional)

Returns the filename in <value> Parameter

Parameter	Description
filename	A string whose value is the name of the file in which to save the contents. if the filename is not spacified a window will be opend to enter the filename. dw_1.saveasformattedtext
Encoding (optional)	Character encoding of the file to which the data is saved. If you do not specify an encoding parameter, the file is saved in ANSI format. Values are:· EncodingANSI! (default)· EncodingUTF8!· EncodingUTF16LE!· EncodingUTF16BE!
separatorcharacter (optional)	A string whose value is the character to be used to delimit values. If you omit separatorcharacter, the default is a tab character.
quotecharacter (optional)	A string whose value is the character to be used to wrap values. If you omit quotecharacter, the default is double quote. For bank you have to asign „no“ dw_1.saveasformattedtext =filename==no==0
Lineending (optional)	A string whose value is placed at the end of each line. If you omit lineending, the default is a carriage return plus a newline character (~r~n).
retainnewlinechar (optional)	A string value (internal boolean) that determines whether line feed and carriage return characters contained within the row are converted to white space. Values are: True : true , 1, t - line feed and carriage return characters within the row are not converted to white space False (default) : false , 0, f - line feed and carriage return characters within the row are converted to white space