Skip to main content Skip to complementary content

Validating XML files

Procedure

  1. Drop the following components from the Palette to the design workspace: tFileList, tDTDValidator, tMap, tFileOutputDelimited.
  2. Connect the tFileList to the tDTDValidator with an Iterate link and the remaining component using a main row.
  3. Set the tFileList component properties, to fetch an XML file from a folder.
    Click the plus button to add a filemask line and enter the filemask: *.xml. Remember Java code requires double quotes.
    Set the path of the XML files to be verified.
    Select No from the Case Sensitive drop-down list.
  4. In the tDTDValidator Component view, the schema is read-only as it contains standard log information related to the validation process.
    In the Dtd file field, browse to the DTD file to be used as reference.
  5. Click in the XML file field, press Ctrl+Space bar to access the variable list, and double-click the current filepath global variable: tFileList.CURRENT_FILEPATH.
  6. In the various messages to display in the Run tab console, use the jobName variable to recall the job name tag. Recall the filename using the relevant global variable: ((String)globalMap.get("tFileList_1_CURRENT_FILE")). Remember Java code requires double quotes.
    Select the Print to Console check box.
  7. In the tMap component, click the [...] button next to Map Editor and drag and drop the information data from the standard schema that you want to pass on to the output file.
  8. Once the Output schema is defined as required, add a filter condition to only select the log information data when the XML file is invalid.
    Follow the best practice by typing first the wanted value for the variable, then the operator based on the type of data filtered then the variable that should meet the requirement. In this case: 0 == row1.validate.
  9. Then connect (if not already done) the tMap to the tFileOutputDelimited component using a Row > Main connection. Name it as relevant, in this example: log_errorsOnly.
  10. In the tFileOutputDelimited Basic settings, define the destination filepath, the field delimiters and the encoding.
  11. Save your Job and press F6 to run it.
    On the Run console the messages defined display for each of the files. At the same time the output file is filled with the log data for invalid files.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here