Export is still using all default settings, column delimiter, column header etc.... settings file is ignored. If wrong settings file name is specified there is no any error or warning?
1 Comment
Roger Bjärevall
said
over 17 years ago
[This reply is migrated from our old forums.]
Re: settingsfile option doesn't work
Stevan,
Hmm... seems to be a typo in the users guide. The property should be [b]settings[/b] instead of settingsfile. This will be fixed in the next version.
Try this:
[nobr]
[pre]
@export on;
@export set settings="c:\html.xml" filename="c:\mytest.txt";
select * from debtors;
[/pre]
[/nobr]
Regards
Roger
anonymous
@export on;
@export set settingsfile="c:\html.xml" filename="c:\mytest.txt";
select * from debtors;
There is a file html.xml in c:
<?xml version="1.0" encoding="UTF-8" ?>
- <DbVisualizer>
- <ExportSettings>
<BinaryFormat>Size</BinaryFormat>
<CsvColumnDelimiter>\t</CsvColumnDelimiter>
<CsvIncludeColumnHeader>false</CsvIncludeColumnHeader>
<CsvIncludeSQLCommand>false</CsvIncludeSQLCommand>
<CsvRowCommentIdentifier />
<CsvRowDelimiter>\r\n</CsvRowDelimiter>
<DateFormat>yyyy-MM-dd</DateFormat>
<DecimalNumberFormat>####.00</DecimalNumberFormat>
<Destination>File</Destination>
<Encoding>ISO-8859-1</Encoding>
<ExcelIncludeColumnHeader>true</ExcelIncludeColumnHeader>
<ExcelIncludeSQLCommand>false</ExcelIncludeSQLCommand>
<ExcelIntroText />
<ExcelTextOnly>false</ExcelTextOnly>
<ExcelTitle>DbVisualizer export output</ExcelTitle>
<Filename>C:\Program Files\PostgreSQL\8.2\jdbc</Filename>
<Format>CSV</Format>
<HtmlIncludeSQLCommand>false</HtmlIncludeSQLCommand>
<HtmlIntroText />
<HtmlTitle>DbVisualizer export output</HtmlTitle>
<NumberFormat>Unformatted</NumberFormat>
<QuoteTextData>None</QuoteTextData>
<ShowNullAs />
<SqlIncludeSQLCommand>false</SqlIncludeSQLCommand>
<SqlRowCommentIdentifier>--</SqlRowCommentIdentifier>
<SqlSeparator>;</SqlSeparator>
<TimeFormat>HH:mm:ss</TimeFormat>
<TimeStampFormat>dd-mm-yyyy HH:mm:ss</TimeStampFormat>
<XmlIncludeSQLCommand>false</XmlIncludeSQLCommand>
<XmlIntroText />
<XmlStyle>DbVisualizer</XmlStyle>
</ExportSettings>
</DbVisualizer>
Export is still using all default settings, column delimiter, column header etc....
settings file is ignored. If wrong settings file name is specified there is no any error or warning?