August 16, 2023

Validating XML files – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Validating XML files – Docs for ESB 6.x

Validating XML files

  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.

    Use_Case_tDTDValidator2.png

    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 tDTDValidate
    Component view, the schema is read-only as it
    contains standard log information related to the validation process.

    Use_Case_tDTDValidator3.png

    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, drag and drop the
    information data from the standard schema that you want to pass on to the output
    file.

    Use_Case_tDTDValidator4.png

  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.

    Use_Case_tDTDValidator5.png

    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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x