XML Create Template

Flow Location

C:\VIPTDM\ParseXMLJSon\xml_to_template

Submit through Executor Form

No

Use as part of models and TDA

Yes

Used in Solutions

Template

Operation XML Create Template 1 – Initial Scan

Parse xml to get a control file.

Parameters

Parameter

Description

Internal

parXMLFilePath

The path to the input xml.
Example input:“C:\VIPTDM\ParseXMLJSon\xml_to_template\Example1.txt”

N

parCSvPathControl

This is the control filePath where control files are output. The user may specify a folder where the output control csv is “parCSvPathControl /control_[input filename].csv” or just specify the full csv file path to output to.

Example input:

“C:\VIPTDM\ParseXMLJSon\xml_to_template\”

or

“C:\VIPTDM\ParseXMLJSon\xml_to_template\control_Example1.csv”

y

parMode

“parse” or “generate_template” , for the initial scan we need to parse. So parMode=”parse”


Table 1: Parameters for XML Create Template 1 – Initial Scan solution.

Output Data

A control file like this:

Figure 1 : Control File example

How to use the component for creation of control file

First, the parameters must be populated as shown in Table 1 . Then a user can run the process from VipExecutor/TemplateManagement/XML Create Template – 1 – Initial Scan,  the user needs to provide the xml example file. This is shown in Figure 1.

Figure 2: UI for the example file entry.

After execution the Control file is returned like in Figure 1 and also created in parCSvPathControl

Operation XML Create Template 2 – Create Template

Use xml input file with control file to get a Template file from the original xml.

Parameters

Parameter

Description

Internal

parXMLFilePath

The path to the xml.
Example input:“C:\VIPTDM\ParseXMLJSon\xml_to_template\Example1.txt “

N

parVariationType

Do we want to take data values with csv or use parameters


Example input: “csv” or “parms”

y

parCSvPathControl

This is the control filePath that control where files are output. The user may specify a folder where the output control csv is “parCSvPathControl /control_[input filename].csv” or just specify the full csv file path to output to.


Example input:

“C:\VIPTDM\ParseXMLJSon\xml_to_template\”

or

“C:\VIPTDM\ParseXMLJSon\xml_to_template\control_Example1.csv”

N

parTemplateFilePath

This is the filepath where the template is output. The user must populate this with a folder and the created template will have the path            folder/[input filename].template.

y

parMode

“parse” or “generate_template” , to create template we need to parse. So parMode=”generate_template”


Table 2: Parameters for xml Create Template 2 solution.

Output Data

A template file like this:

Figure 3: Example Template

How to use the component for creation of template

First, the parameters must be populated as shown in Table 2 . Then a user can run the process from VipExecutor/TemplateManagement/XML Create Template – 2,  the user needs to provide the XML example file and control csv file This is shown in Figure 4.

Figure 4: UI for the example file entry.

After execution, a template file is returned like in Figure 3 and also created in parTemplateFilePath.