XML と XML 構造エクスポートオプションの定義

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  データベースデータのエクスポート >

XML と XML 構造エクスポートオプションの定義

In the Options tab for XML and XML Structure you can define the appearance of the exported files.

tab_exp-opt-xml

 

To define the extended options for XML and XML Structure export files:

1.Choose one of the following options for the format of number, date, and time values:

 

According to system locale
Compatible with Schema データ型

 

2.Choose one of the following options for the default データ型:

 

Select Elements by default to export the data as elements
Select Attributes by default to export the data as attributes

 

メモ:You can change individual columns in tables to be exported as elements or attributes in the Preview グループボックス of the ダイアログ.

 

3.If you want to exclude primary and 外部キー from the export file, activate the Exclude Primary/外部キー チェックボックス.
4.Activate the Include comments チェックボックス to include an attribute in the exported XML file that shows the SQL query used to select the data, as well as a list of comments containing one item for each column header in the database table.
5.Activate the Create elements from NULL-fields チェックボックス to include an empty element for each null value in the data being exported.
6.任意で、 select from the Substitution for NULLs ドロップダウンリスト or type in the string that should appear in the XML file when there is a NULL value in the data being exported. You can also type in a value that is not contained in the ドロップダウンリスト. This option is only available if the Create elements from NULL-fields チェックボックス is activated.
7.Select the desired encoding for the files that are generated during export from the Encoding ドロップダウンリスト.
8.If a two- or four-byte encoding is selected as the default encoding (i.e., UTF-16, UCS-2, or UCS-4), you can choose between little-endian and big-endian byte ordering.

(C) 2019 Altova GmbH