imported>Gfis: /* Example for output in MS-Excel */ proper image

2016-09-02T08:55:02Z

Example for output in MS-Excel: proper image

← Older revision		Revision as of 08:55, 2 September 2016
Line 48:		Line 48:
	...		...
	=== Example for output in MS-Excel ===		=== Example for output in MS-Excel ===
	[[File:~~File~~.jpg\|caption Schema list in Excel worksheet]]		[[File:List-mtsv.jpg\|caption Schema list in Excel worksheet]]

	The columns of the Excel worksheet are filled as follows:		The columns of the Excel worksheet are filled as follows:

imported>Gfis: better tables

2016-09-02T08:50:42Z

better tables

Show changes

imported>Gfis: from documentation.html

2016-09-02T08:32:30Z

from documentation.html

New page

== SchemaList - List the Element Tree of a W3C XML Schema ==
Starting with the first xs:element definition, the type hierarchy of a W3C schema file is recursively expanded. The output is a linear, indented list of the unfolded possible substructures, the leaf XML elements and their attributes.

Optionally values may be generated, and the tool can generate comments which show the schema type, data type, restrictions and annotations attached to the elements. With value generation and a selection of the first choice, the output will be a well-formed XML instance which usually validates against the input schema. This representation has the big advantage that it shows both the schema design and a real instance of that schema, both combined in a single XML document.

The schema list can be shown as HTML (the default), plain text, pure XML or in tab separated format which is suitable for MS-Excel. For HTML, the start tags have a link showing the XPath to the element. In Excel, columns can easily be hidden or appended. Such a worksheet is then a good base for the development of additional restrictions, mapping rules and the like.

The tool may be called on a commandline or from a web page. The following optional settings may be specified:
* '''<tt>-c</tt>''' show comments with types, restrictions, patterns etc.
* '''<tt>-e enc</tt>''' source file encoding, default: UTF-8
* '''<tt>-e enc</tt>''' target file encoding, default: UTF-8
* '''<tt>-f</tt>''' show first alternative of choices only
* '''<tt>-m mode</tt>''' output mode: "html" (default), "plain", "tsv" (for MS-Excel) or "xml"
* '''<tt>-s</tt>''' show start tags only (no end tags)
* '''<tt>-v</tt>''' generate element values

These options may be combined. Typical settings are:

* '''<tt>-cvf</tt>''' generate a well-formed, commented XML instance from the schema
* '''<tt>-s</tt>''' only show the minimal indented element structure without end tags
* '''<tt>-cv -m tsv</tt>''' generate an Excel worksheet with comments and values
* '''<tt>-v -m xml</tt>''' show elements with values in the browser's XML representation (elements can be collapsed)
* '''<tt>-vf -m plain</tt>''' generate a concise XML instance file which may be stored and validated

In the web interface, the user specifies the desired options and uploads the input schema file to the application on the web server.
=== Example for HTML output (-cv -m html) ===
<[[documentation/data:text/plain,/Document|Document]] xmlns="urn:sepade:xsd:pain.001.001.02">
    <[[documentation/data:text/plain,/Document/pain.001.001.02|pain.001.001.02]]>
        <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr|GrpHdr]]>
            <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/MsgId|MsgId]]>Max35Text</MsgId>
            <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/CreDtTm|CreDtTm]]>2007-06-29T05:30:00Z</CreDtTm>
            <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/NbOfTxs|NbOfTxs]]>09</NbOfTxs>
            <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/CtrlSum|CtrlSum]]>1</CtrlSum>
            <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/Grpg|Grpg]]>GRPD</Grpg>
            <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty|InitgPty]]>
                <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Nm|Nm]]>Max70Text</Nm>
                <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/PstlAdr|PstlAdr]]>
                    <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/PstlAdr/AdrLine|AdrLine]]>Max70Text</AdrLine>
                    <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/PstlAdr/Ctry|Ctry]]>AZ</Ctry>
                </PstlAdr>
                <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Id|Id]]>
                    <[[documentation/data:text/plain,|__unresolvedChoice__]]>
                      <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Id/OrgId|OrgId]]>
                          <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Id/OrgId/BIC|BIC]]>COBADEFF</BIC>
                          <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Id/OrgId/IBEI|IBEI]]>AZBDFHJNP0</IBEI>
                          <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Id/OrgId/BEI|BEI]]>BEIADEFF</BEI>
                          <[[documentation/data:text/plain,/Document/pain.001.001.02/GrpHdr/InitgPty/Id/OrgId/EANGLN|EANGLN]]>0909090909090</EANGLN>
...
=== Example for output in MS-Excel ===
[[Image:documentation/list-mtsv.jpg|frame|none|alt=list-mtsv.jpg|caption schema list in Excel worksheet]]

The columns of the Excel worksheet are filled as follows:
<nowiki><table>
<tbody>
<tr class="odd">
<td align="left">A</td>
<td align="left">indented elements with generated values</td>
</tr>
<tr class="even">
<td align="left">B</td>
<td align="left">cardinality, multiplicity: minOccurs and maxOccurs</td>
</tr>
<tr class="odd">
<td align="left">C</td>
<td align="left">schema type</td>
</tr>
<tr class="even">
<td align="left">D</td>
<td align="left">elementary XML datatype</td>
</tr>
<tr class="odd">
<td align="left">E</td>
<td align="left">restrictions: string lengths, number ranges, patterns, value enumerations</td>
</tr>
<tr class="even">
<td align="left">F</td>
<td align="left">annotations attached to the element</td>
</tr>
<tr class="odd">
<td align="left">G</td>
<td align="left">absolute XPath to this element node</td>
</tr>
<tr class="even">
<td align="left">H</td>
<td align="left">a single ";" in all relevant (non-descriptive) rows, useful for hiding rows</td>
</tr>
</tbody>
</table></nowki>

=== Special Rows ===
There are two sorts of special rows which are useful for the description of the schema, but which will not lead to a valid XML instance.

# With option <tt>"-c"</tt>, any attribute is shown on separate line starting with "@", since attributes also have types, restrictions etc.</>
# Without option <tt>"-f"</tt>, any <tt><xs:choice></tt> leads to an artificial element <tt><__unresolvedChoice__></tt> in order to make visible that this choice must still be resolved to yield a valid XML instance. This resolution could be realized by an XSLT stylesheet or by manual editing.
=== Value Generation ===
The tool tries to generate validating values for the most common cases. This works rather well for the [http://www.iso20022.org ISO 20022] message schemata relevant to SEPA (camt, pacs, pain families), but it will possibly fail for complicated patterns or different application areas.

The values are generated with a fixed set of rules which depend on the elementary data type, sometimes the schema type, and the restrictions. The following table shows these rules:
<nowiki><table>
<thead>
<tr class="header">
<th align="left">Datatype</th>
<th align="left">Restriction, Schema Type</th>
<th align="left">Generated Value</th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td align="left">boolean</td>
<td align="left"> </td>
<td align="left">true</td>
</tr>
<tr class="even">
<td align="left">decimal</td>
<td align="left"> </td>
<td align="left">1</td>
</tr>
<tr class="odd">
<td align="left">dataTime</td>
<td align="left"> </td>
<td align="left">2007-06-29T04:30:00Z   (?)</td>
</tr>
<tr class="even">
<td align="left">date</td>
<td align="left"> </td>
<td align="left">2007-06-29</td>
</tr>
<tr class="odd">
<td align="left">NCName</td>
<td align="left"> </td>
<td align="left">NCName</td>
</tr>
<tr class="even">
<td align="left">decimal</td>
<td align="left"> </td>
<td align="left">1</td>
</tr>
<tr class="odd">
<td align="left">string</td>
<td align="left">(pattern)</td>
<td align="left">(the characters from the pattern repeated up to a minimal length)</td>
</tr>
<tr class="even">
<td align="left">string</td>
<td align="left">(length)</td>
<td align="left">(schema type name truncated or padded with letters)</td>
</tr>
<tr class="odd">
<td align="left">string</td>
<td align="left">(enumeration)</td>
<td align="left">(the first alternative)</td>
</tr>
<tr class="even">
<td align="left">string</td>
<td align="left">CurrencyCode</td>
<td align="left">EUR</td>
</tr>
<tr class="odd">
<td align="left">string</td>
<td align="left">IBANIdentifier</td>
<td align="left">DE28500400000123456589</td>
</tr>
<tr class="even">
<td align="left">string</td>
<td align="left">BICIdentifier</td>
<td align="left">COBADEFF</td>
</tr>
<tr class="odd">
<td align="left">string</td>
<td align="left">BEIIdentifier</td>
<td align="left">PUTMDEEM</td>
</tr>
<tr class="even">
<td align="left">string</td>
<td align="left">CHIPSUniversalIdentifier</td>
<td align="left">CH012345</td>
</tr>
</tbody></nowki>
</table>

Xtool/SchemaList - Revision history

imported>Gfis: /* Example for output in MS-Excel */ proper image

imported>Gfis: better tables

imported>Gfis: from documentation.html