How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

XSD for (export) settings

Hej


I want to create a xml settings file (for exports). Is there an xsd for guidance?

So far, I have got the following.

 

<?xml version="1.0" encoding="UTF-8"?>
<DbVisualizer>
  <ExportSettings>
    <AppendFile>true</AppendFile>
    <CsvColumnDelimiter>;</CsvColumnDelimiter>
    <CsvIncludeColumnHeader>false</CsvIncludeColumnHeader>
    <CsvIncludeColumnHeaderPerResult>false</CsvIncludeColumnHeaderPerResult>
    <CsvIncludeSQLCommand>Don't Include</CsvIncludeSQLCommand>
    <DateFormat>yyyy-MM-dd</DateFormat>
    <DecimalNumberFormat>Unformatted</DecimalNumberFormat>
    <DecimalNumberSeparator>.</DecimalNumberSeparator>
    <Destination>File</Destination>
    <Encoding>UTF-8</Encoding>
    <Format>CSV</Format>
    <QuoteTextData>Double</QuoteTextData>            
    <ShowNullAs>ω</ShowNullAs>
    <TimeFormat>HH:mm:ss.SSSSSS</TimeFormat>
    <TimeStampFormat>yyyy-MM-dd HH:mm:ss.SSSSSS</TimeStampFormat>
  </ExportSettings>
</DbVisualizer>

 However, the AppendFile element gets ignored.


Varma hälsningar


Thiemo

4 CommentsSorted by Oldest First

Hej!


We don't have an xsd available for ExportSettings, but the various options are documented in the user guide: https://www.dbvis.com/docs/ug/working-with-sql/using-client-side-commands/export-export-query-result/


Note that some of them are transient, meaning they can be used in the GUI and the @export client-side command but will not be saved to or read from the settings file. At the moment of writing, these are AppendFile, ExcelSheetName, SqlBeginIdentifier, SqlEndIdentifier, SqlMultiRowInsertTemplate, SqlQualifier and TableName.


Hope this helps!


Hälsningar,

Dmitry

1 person likes this
Hej Dmitry Thanks for pointing out. To it suffices. Maybe a column in the doc to mar the transient ones might help others. Varma hälsningar Thiemo

Ideally, we would not like to promise anything about the internal settings format and would like to have the freedom to change it as we find fit. I will take it up for discussion though, thanks for the suggestion! 

1 person likes this
I totally understand that you don't eagerly display internals to the pubic. I was under the impression that if you document the use of a settings file for export by @export in the user guide, details of the settings could not be internal. My bad. Then, maybe, a hint in the documentation that one should generate the settings file by the grid export feature, might be appropriate and that manually maintained files were not supported.
Login or Signup to post a comment
More topics in Support
See all 1316 topics