XML file connections involve importing data from static XML files. The data shall be imported within a Form that either exists already or has been designed specifically for the purposes of data import. 


Sample Connection 




Field Details:


  1. Connection Name: Display name of the connection.
  2. Connection Method: Set to XML File, available options (Database, Database - No Import, Form, Java, Manual, Text File, View, XML File, Xquery)
  3. Target Form: Form where the data will be imported
  4. Process: Which process to associate for each record that has been imported
  5. Status: Is the record to be imported in the first step of the process (New) or the last step (Completed)
  6. File To Import: If the connection is not being run on a schedule, then, a file can be uploaded for import (file contents to be tab delimited)
  7. Import File Directory: If the connection is being run on a schedule, then, a file import directory can be specified where all xml files in that directory shall be imported
  8. XML Alias Map: In order for the system to know which tag corresponds to which field (or repeating section and grid) in the Target Form a mapping between the tags and form fields needs to be performed
    • XML Tag: The tag name within the file. For each connection the root element must be specified (if the a single document is imported per file), or the repeating element that signifies the start of each new document/electronic record.
    • Corresponding Form Element: Field, Repeating Section or Repeating Grid design name that corresponds to the tag name
    • Element Type: Automatically determined if the Corresponding Form Element is found (options are Field, Repeating Section, Repeating Grid, Special, Error)
  1. Run this Schedule?: If set, then the connection will run at the specified schedule, otherwise the connection shall run on each save.
  2. Start Time: Date and time when the connection shall be scheduled from
  3. Update Frequency: The repeat frequency combined with the Update Freuency (Units), for e.g if the connection is to be run hourly then set this field to 1 and the Units field to Hours
  4. Update Frequency (Units): Days, Hours and Minutes. Used in combination with Update Frequency field
  5. Most Recent Update: This is the Date and Time when the connection was last run