<outbox active="true"
prodPath="C:/Pagero/companyName1_prod/"
testPath="C:/Pagero/companyName1_test/"
workPath="C:/Pagero/work/companyName1/"
subDocAware="false"
masterDocRegexp="(.*)\.xml"
subDocRegexp="(.*)\.pdf"
subDocPresentationRegexp="(.*)\.png">

 <fpclient>
 <log mode="FILE" path="c:/Temp/log/filsplitter.log">
 <filename pattern="MERFL.*xml">
 <defaultEncoding charset="ISO-8859-15">
 <path verbose="false">
 <incomming path="c:/Temp/incoming"/>
 <outgoing path="c:/Temp/outgoing"/>
 <temporary path="c:/Temp/temp"/>
 <backup path="c:Temp/backup"/>
 </path>
 <xmltag verbose="false">
 <removeTag pattern="^S[O-P].*"/>
 <splitTag pattern="Finvoice"/>
 <attachmentTag pattern="InvoiceFreeText" group="(.*)" filename="${1}"/>
 <savedBatchDataTag pattern="sectionInfo"
 appendAfterSplit="&lt;/section&gt;&lt;/batch&gt;"/>
 <CSVTag header="TRUE" csvIdentifier="14" useCSVIndex="TRUE"
 invoiceIdentifier="/Finvoice/InvoiceDetails/AgreementIdentifier"/>
 <modTag xpath="/Finvoice/BuyerPartyDetails/BuyerOrganisationName"
 action="BEFORE" value="A"/>
 <modTag xpath="/Finvoice/BuyerPartyDetails/BuyerOrganisationName"
 action="AFTER" value="B"/>
 <modTag xpath="/Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode"
 action="REPLACE" value="C"/>
<modTag xpath="/Finvoice/BuyerPartyDetails/buyerExtra" action="CREATE"
value="D"/>
<modTag
xpath="/Finvoice/MessageTransmissionDetails/MessageSenderDetails/FromIntermediator"
action="BEFORE" value="1" useCSV="TRUE" useCSVIndex="TRUE"/>
<modTag
xpath="/Finvoice/MessageTransmissionDetails/MessageSenderDetails/FromIntermediator"
action="AFTER" value="InvoiceNumber" useCSV="TRUE" useCSVIndex="FALSE"/>
<modTag
xpath="/Finvoice/MessageTransmissionDetails/MessageSenderDetails/FromIntermediator[2]"
action="REPLACE" value="3" useCSV="TRUE" useCSVIndex="TRUE"/>
</xmltag>
</fpclient>

This example will search for files in C:/Temp/incoming/in path that have filename MERFL.*.xml, i.e. MERFL_123.xml. When a file is found we will remove SOAP tag and split content in different files.

Every new file have starttag and endtag Finvoice. Filesplitter will match invoice with attachment with help of tag InvoiceFreeText. Filesplitter will also identify a CSV file for invoice. Information in CSVTag tells Filesplitter how CSV is connected to an invoice. Index in CSV file should match value /Finvoice/InvoiceDetails/AgreementIdentifier in Invoice.

Values in CSV is used to enrich values in invoice. When all files successfully have been parsed, split invoices will be created in C:/Temp/outgoing and original files will be moved to C:/Temp/backup.

Description of tags and attributes in configurationfile

You can enrich XML with static text or with values in a CSV file. If you enrich XML with static text you only need to add modTags to configurationfile and set xpath, action and value.
For example

<modtag xpath="/Finvoice/BuyerPartyDetails/ByerOrganisationName" action="BEFORE"
value="A"/>
<modTag xpath="/Finvoice/BuyerPartyDetails/BuyerOrganisationName" action="AFTER"
value="B"/>
<modTag xpath="/Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode" action="REPLACE"
value="C"/>
<modTag xpath="/Finvoice/BuyerPartyDetails/buyerExtra" action="CREATE" value="D"/>

Here we will try to find xpath /Finvoice/BuyerPartyDetails/BuyerOrganisationName and add value A before and B after existing value. We also try to find xpath
/Finvoice/BuyerPartyDetails/BuyerOrganisationTaxCode and replace existing value with C. The last line will create a new tag if xpath is valid and set value D.

To enrich XML with a CSV you need to add CSVtag and describe how to connect CSV with invoice. You can connect csv file with value inside csv or use its filename. To use its filename you should add attribute
csvFilenameIdentifier and set it to TRUE. Now Filesplitter will try to find value in invoice and match it to CSV filename.
To match CSV with invoice based on information inside files you must use attribute csvIdentifier and useCSVIndex.

With these two attributes Filesplitter will try to find value in CSV with given index or name and match to a invoice value that exist in given xpath. In modTag we set useCSV to true. We can then set useCSVIndex to true and value to a index number or we set useCSVIndex to falseand value to header name.
Filesplitter will now lookup value in CSV and enrich XML with found value.
CSV file must use “;” to separate values in file.

For example

<CSVTag header="TRUE" csvIdentifier="14" useCSVIndex="TRUE"
invoiceIdentifier="/Finvoice/InvoiceDetails/AgreementIdentifier"/>
<modTag
xpath="/Finvoice/MessageTransmissionDetails/MessageSenderDetails/FromIntermediator"
action="AFTER" value="InvoiceNumber" useCSV="TRUE" useCSVIndex="FALSE"/>
<modTag
xpath="/Finvoice/MessageTransmissionDetails/MessageSenderDetails/FromIntermediator[2]"
action="REPLACE" value="3" use CSV="TRUE" useCSVIndex="TRUE"/>

Here we will connect CSV file with help of index 14 and xpath
/Finvoice/InvoiceDetails/AgreementIdentifier.
If they have same value they are connected and csv will be used to enrich invoice. First modTag will append value in CSV that have header invoiceNumber second modtag will replace value in
/Finvoice/MessageTransmissionDetails/MessageSenderDetails/FromIntermediator [2] with value in index 3 in CSV file.

Here is an example how a configuration of CSVTag can look like when matching with CSV filename.

<CSVTag header="TRUE" csvFilenameIdentifier="TRUE"
invoiceIdentifierGroups="[a-z0-9A-Z-]*\ ([a-z0-9A-Z-]*)."
invoiceIdentifierFilename="${1}.csv"
invoiceIdentifier="/Finvoice/InvoiceDetails[1]/InvoiceFreeText[1]"/
>

First will invoiceIdentifier get the value between xml tags. Then will we apply this reg expr. [a-z0-9A-Z-]*\ ([a-z0-9A-Z-]*). On value and get one group. After this we format our value with invoiceIdentifierFilename and use values inside groups that we have parsing out. I.e. value is “Test 123 ABC” then group 1 will get value 123 and last we apply ${1}.csv and get 123.csv as final value.

To run both Filesplitter and Serverconnect use FileSplitt_AND_ServerConnect.bat
To disable command prompt to be shown we use invis.vbs that takes the bat file as argument, i.e.

Run both Filesplitter and Serverconnect –
“C:\WINDOWS\system32\wscript.exe<install path>\invis.vbs<install path>\FileSplitt_And_ServerConnect.bat

Example configfile for TEAPPS.

<fpclient
 <log mode="FILE" path="/tmp/fileSplitter/log/startconf.log"/>
 <filename pattern="teappsInvoice.*xml"/>
 <defaultEncoding charset="ISO-8859-15"/>
 <path verbose="false">
 <incomming path="/tmp/fileSplitter/incoming"/>
 <outgoing path="/tmp/fileSplitter/outgoing"/>
 <temporary path="/tmp/fileSplitter/temp"/>
 <backup path="/tmp/fileSplitter/backup"/>
 </path>
 <xmltag verbose="false">
 <removeTag pattern="^S[OP].*"/>
 <splitTag pattern="^INVOICE$"/>
 <!--BGC-Invoice save batchdata when split →
 <saveBatchDataTag pattern="^INVOICES$"
 appendAfterSplit="&lt;/INVOICES&gt;&lt;/CONTENT_FRAME&gt;&lt;/INVOICE_CENTER&gt;"/>
 </xmltag>
 </fpclient>

Example configfile for BGCInvoice

<fpclient>
<log mode="FILE" path="/tmp/fileSplitter/log/startconf.log"/>
<filename pattern="BGCInvoice.*xml"/>
<defaultEncoding charset="ISO-8859-15"/>
<path verbose="false">
<incomming path="/tmp/fileSplitter/incoming"/>
<outgoing path="/tmp/fileSplitter/outgoing"/>
<temporary path="/tmp/fileSplitter/temp"/>
<backup path="/tmp/fileSplitter/backup"/>
</path>
<xmltag verbose="false">
<removeTag pattern="^S[OP].*"/>
<splitTag pattern="^document$"/>
<!--BGC-Invoice save batchdata when split →
<saveBatchDataTag pattern="sectionInfo" appendAfterSplit="&lt;/section&gt;&lt;/batch&gt;"/>
</xmltag>
</fpclient>