Database Design Report XML Output Grammar

| Script Section 61
Records
Import
Records
{for ODBC data source :
<Profile DataType="ODBC"
FirstRowIsData="True"
dsn={Dsn} UserName={UserName}
password={Password} flags={flags}
QueryType="Query">
<QueryCalc>
<DisplayCalculation>
<Chunk type="FunctionRef">Abs</Chunk>
<Chunk type="NoRef">(13)</Chunk>
</DisplayCalculation>
<Calculation>
<![CDATA[CalcString]]>
</Calculation>
</QueryCalc>
<Query>{QueryText}</Query>
</Profile>
}
<UniversalPathList>
{PathList}</UniversalPathList>
<ImportOptions method="UpdateOnMatch"
SplitRepetitions="True"
AutoEnter="True" AddRemainingRecords="True"
CharacterSet="Windows"/>
<Table name={Table} id="1"/>
<TargetFields>
<Field name={FieldName} id="1" map="Import"/>
<Field/>
<Field name={FieldName} id="2" map="Match"/>
...
</TargetFields>
</Step>
<ImportOptions method> can
be:
1 Add
1 Update
1 UpdateOnMatch
<ImportOptions
SplitRepetitions> can be:
1 True
1 False
<ImportOptions AutoEnter>
can be:
1 True
1 False
<ImportOptions
AddRemainingRecords> can
be:
1 True
1 False
<ImportOptions CharacterSet>
can be:
1 Windows
1 DOS
1 Macintosh
1 Unicode
1 UnicodeBE
1 UTF-8
1 ShiftJIS
1 ChineseSimplified
1 ChineseTraditional
<Field Map> can be:
1 Import
1 Match
1 DoNotImport
<Chunk type> can be:
1 NoRef
1 FunctionRef
1 FieldRef
1 CustomFunctionRef
{PathList} can consist of
multiple absolute or
relative paths, the first
valid one of which is
used at execution time.
For a request to import
into a new table:
<Table> element is absent.
{FieldName} for each
<Field> element child of
<TargetFields> element is
index of field from data
source to import into that
target field. Each target
field's actual name will
be determined by the
name of the
corresponding source
field in the same position
(as previously
established in the 'Import
Mapping' dialog) when
the script step is
eventually performed.
Area Name XMLGrammar XMLValues XMLDescription
(continued
from
previous
page)
)