Using Variables in a script

Hi DN buds

I am trying to create a workflow where files are placed into a watch folder, from there a 'data export' lists all the file names (attached D1).

The files are sent to a watch folder and 'data output' as xml as well as the files themselves (d2)

A script kicks in to merge the files together to form an xml output (d3)

 

This all works except for 1 element, I would  like to use the "WATCHFOLDERSUBPATH" variable in the script to be able to populate the script to replace the "400" with the variable (see example xml and script below)

 

xml

<?xml version="1.0" encoding="UTF-8" ?>

<ScanBatch>

<BatchName>400</BatchName>

<UserName>Marc Wilmington</UserName>

<ScanStartDateTime>5/12/20229:16 AM</ScanStartDateTime>

<ScanEndDateTime>5/12/20229:16 AM</ScanEndDateTime>

<BatchCount></BatchCount>

<ScanBatchID>400</ScanBatchID>

<DocumentType>.pdf</DocumentType>

<Extra1>MW-051232816</Extra1>

<Extra2></Extra2>

<Documents>

<Document>sdferfhjhj</Document>

<Document>ferhj - Copy</Document>

<Document>ferhj</Document>

<Document>ffrrffj - Copy</Document>

<Document>ffrrffj</Document>

<Document>hfer</Document>

<Document>hgfg</Document>

<Document>hhththhhyry</Document>

<Document>hyrhyrhrh</Document>

<Document>iyewg</Document>

<Document>krsjy</Document>

</Document>

</ScanBatch>

 

 

 

script

Dim strInputPath1, strInputPath2, strInputPath3, strOutputPath

Dim txsInput1, txsInput2, txsInput3, txsOutput

Dim FSO

 

Set FSO = CreateObject("Scripting.FileSystemObject")

 

strInputPath1 = "C:\Output\CPS\KM\400\KM_400.txt"

strInputPath2 = "C:\Output\CPS\KM\400\400.txt"

strInputPath3 = "C:\KMDonotDelete\CPS\XML_File_End\XMLEnd.txt"

strOutputPath = "C:\Output\CPS\KM\400\Final\KMCPS40.xml" 

' For the timestamp I use Now (today's date). Can also choose some other date. 

 

Set txsInput1 = FSpenTextFile(strInputPath1, 1)

Set txsInput2 = FSpenTextFile(strInputPath2, 1)

Set txsInput3 = FSpenTextFile(strInputPath3, 1)

Set txsOutput = FSO.CreateTextFile(strOutputPath)

 

txsOutput.Write txsInput1.ReadAll

txsOutput.Write txsInput2.ReadAll

txsOutput.Write txsInput3.ReadAll

 

txsInput1.Close

txsInput2.Close

txsInput3.Close

txsOutput.Close

 

 

I'm just unsure of how to declare Doc Nav variables in the script.

 

Cheers

 

Marc