| Navigation: Templates > Guide to all Templates > Code Templates >====== FromXML code template ====== |    |
This code template is used to import an XML file's contents into a designated target structure. It is similar to the Import From XML code template, but provides additional settings for more control as to the input contents.
Select Structure
Press the ellipsis button to select a valid label of a GROUP, FILE, VIEW or QUEUE to hold the contents of the import XML file.
Import file
Press the ellipsis button to select a valid XML source file to import. If you wish to select this file name at runtime, check the Select import file at runtime check box. You may also specify a variable here (Example: !FilenameVariable).
Mapping file (optional)
Press the ellipsis button to select a valid XML mapping file to use during import. In Clarion terms, mapping refers to associating an XML tag or schema to a database column name. If you wish to select this file at runtime, check the Select mapping file at runtime check box. You may also specify a variable here (Example: !FilenameVariable).
Root Tag:
Enter a hard coded string value, or specify a variable that will identify the root tag name (using the !variablename format) to begin the import from.
Row Tag:
Enter a hard coded string value, or specify a variable that will identify the row tag name (using the !variablename format) to begin the import from.
Use Schema on import
There are two ways to describe the elements of an XML document. The default is to use a DTD (Document Type Definition) to define the legal building blocks of an XML document. It defines the document structure with a list of legal elements. The alternative method is to use an XML Schema. Check this box to designate the Schema on import instead of the DTD.
Perform a silent import
Check this box if you wish to suppress error generation during the import process.
Customize Columns
Press this button that displays a list box interface where you can add custom mapping from the XML Tag Name to an existing column in your database.
Column
Select a valid label from the drop list. The elements contained here are reads from the Select Structure value.
XML Tag Name
Enter the target tag name to match to the selected column.
Picture
Enter a default picture to use to format the imported XML data.
XML Data Format
Select from Text, Cdata, or Base64. The default is Text.
XML Style
Select Tag-based or Attribute-based. This setting controls the XML formatted output style.