You can copy and paste this module export into your scenario. This will paste the modules shown in my screenshots above.
-
Copy the code below by clicking the copy button when you mouseover the top-right of the code block
-
Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV to paste in the canvas.
-
Click on each imported module and save it. You may need to remap some variables.
Modules JSON Export
{
"subflows": [
{
"flow": [
{
"id": 55,
"module": "util:ComposeTransformer",
"version": 1,
"parameters": {},
"mapper": {
"value": "@Actor (=CustNo,SupNo,Nm,Ad1,Ad2,Ad3,PNo,PArea,Phone,Fax,MailAd,BsNo,BGiro,Ctry,Lang,Cur,CPmtTrm,SPmtTrm)\n\"10458\";\"0\";\"Vesterlandet GÂrd / D. Hansen\";\"Vesterlandet 226\";\"\";\"\";\"8407\";\"Sortland\";\"\";\"\";\"vesterlandetgaard@gmail.com\";\"926967878\";\"\";\"47\";\"47\";\"\";\"15\";\"15\"\n\n@IMPORT_METHOD(3)\n\n@WaBnd (ValDt, SrcTp, Descr)\n\"20240326\" \"12\" \"Quick3 Import\"\n@WaVo (VoNo,VoDt,ValDt,VoTp,Txt,DbAcNo,DbTrnCl,DbTxCd,CrAcNo,CrTrnCl,CrTxCd,Am,InvoNo,DueDt,VatAm,R1,R2,R7,CID,Txt2,AGRef)\n\"100489\";\"20240326\";\"20240326\";\"11\";\"Utg.faktura\";\"10458\";\"0\";\"0\";\"0\";\"0\";\"0\";\"33818.00\";\"100489\";\"20240405\";\"\";\"\";\"\";\"\";\"001045801004890\";\"\";\"\";;\n\"100489\";\"20240326\";\"20240326\";\"11\";\"Utg.faktura\";\"0\";\"0\";\"0\";\"7740\";\"0\";\"0\";\"0.50\";\"\";\"\";\"\";\"\";\"\";\"\";\"\";\"\";\"\";;\n\"100489\";\"20240326\";\"20240326\";\"11\";\"Utg.faktura\";\"0\";\"0\";\"0\";\"3000\";\"0\";\"3\";\"30937.50\";\"\";\"\";\"\";\"1\";\"\";\"\";\"\";\"\";\"\";;\n\"100489\";\"20240326\";\"20240326\";\"11\";\"Utg.faktura\";\"0\";\"0\";\"0\";\"3001\";\"0\";\"3\";\"2880.00\";\"\";\"\";\"\";\"1\";\"\";\"\";\"\";\"\";\"\";;"
},
"metadata": {
"designer": {
"x": 268,
"y": -3095
},
"restore": {},
"expect": [
{
"name": "value",
"type": "text",
"label": "Text"
}
]
}
},
{
"id": 56,
"module": "regexp:Parser",
"version": 1,
"parameters": {
"pattern": "@Actor[^\\n]+\\s+\"(?<CustNo>[^\"]*)\";\"(?<SupNo>[^\"]*)\";\"(?<Nm>[^\"]*)\";\"(?<Ad1>[^\"]*)\";\"(?<Ad2>[^\"]*)\";\"(?<Ad3>[^\"]*)\";\"(?<PNo>[^\"]*)\";\"(?<PArea>[^\"]*)\";\"(?<Phone>[^\"]*)\";\"(?<Fax>[^\"]*)\";\"(?<MailAd>[^\"]*)\";\"(?<BsNo>[^\"]*)\";\"(?<BGiro>[^\"]*)\";\"(?<Ctry>[^\"]*)\";\"(?<Lang>[^\"]*)\";\"(?<Cur>[^\"]*)\";\"(?<CPmtTrm>[^\"]*)\";\"(?<SPmtTrm>[^\"]*)\"[\\w\\W]+@WaBnd[^\\n]+\\s+\"(?<ValDt>[^\"]*)\" \"(?<SrcTp>[^\"]*)\" \"(?<Descr>[^\"]*)\"",
"global": false,
"sensitive": true,
"multiline": false,
"singleline": false,
"continueWhenNoRes": false
},
"mapper": {
"text": "{{55.value}}"
},
"metadata": {
"designer": {
"x": 572,
"y": -3096,
"name": "Extract Actor and WaBnd"
},
"restore": {},
"parameters": [
{
"name": "pattern",
"type": "text",
"label": "Pattern",
"required": true
},
{
"name": "global",
"type": "boolean",
"label": "Global match",
"required": true
},
{
"name": "sensitive",
"type": "boolean",
"label": "Case sensitive",
"required": true
},
{
"name": "multiline",
"type": "boolean",
"label": "Multiline",
"required": true
},
{
"name": "singleline",
"type": "boolean",
"label": "Singleline",
"required": true
},
{
"name": "continueWhenNoRes",
"type": "boolean",
"label": "Continue the execution of the route even if the module finds no matches",
"required": true
}
],
"expect": [
{
"name": "text",
"type": "text",
"label": "Text"
}
],
"interface": [
{
"type": "text",
"name": "CustNo",
"label": "CustNo"
},
{
"type": "text",
"name": "SupNo",
"label": "SupNo"
},
{
"type": "text",
"name": "Nm",
"label": "Nm"
},
{
"type": "text",
"name": "Ad1",
"label": "Ad1"
},
{
"type": "text",
"name": "Ad2",
"label": "Ad2"
},
{
"type": "text",
"name": "Ad3",
"label": "Ad3"
},
{
"type": "text",
"name": "PNo",
"label": "PNo"
},
{
"type": "text",
"name": "PArea",
"label": "PArea"
},
{
"type": "text",
"name": "Phone",
"label": "Phone"
},
{
"type": "text",
"name": "Fax",
"label": "Fax"
},
{
"type": "text",
"name": "MailAd",
"label": "MailAd"
},
{
"type": "text",
"name": "BsNo",
"label": "BsNo"
},
{
"type": "text",
"name": "BGiro",
"label": "BGiro"
},
{
"type": "text",
"name": "Ctry",
"label": "Ctry"
},
{
"type": "text",
"name": "Lang",
"label": "Lang"
},
{
"type": "text",
"name": "Cur",
"label": "Cur"
},
{
"type": "text",
"name": "CPmtTrm",
"label": "CPmtTrm"
},
{
"type": "text",
"name": "SPmtTrm",
"label": "SPmtTrm"
},
{
"type": "text",
"name": "ValDt",
"label": "ValDt"
},
{
"type": "text",
"name": "SrcTp",
"label": "SrcTp"
},
{
"type": "text",
"name": "Descr",
"label": "Descr"
}
]
}
},
{
"id": 57,
"module": "regexp:Parser",
"version": 1,
"parameters": {
"pattern": "\"(?<VoNo>[^\"]*)\";\"(?<VoDt>[^\"]*)\";\"(?<ValDt>[^\"]*)\";\"(?<VoTp>[^\"]*)\";\"(?<Txt>[^\"]*)\";\"(?<DbAcNo>[^\"]*)\";\"(?<DbTrnCl>[^\"]*)\";\"(?<DbTxCd>[^\"]*)\";\"(?<CrAcNo>[^\"]*)\";\"(?<CrTrnCl>[^\"]*)\";\"(?<CrTxCd>[^\"]*)\";\"(?<Am>[^\"]*)\";\"(?<InvoNo>[^\"]*)\";\"(?<DueDt>[^\"]*)\";\"(?<VatAm>[^\"]*)\";\"(?<R1>[^\"]*)\";\"(?<R2>[^\"]*)\";\"(?<R7>[^\"]*)\";\"(?<CID>[^\"]*)\";\"(?<Txt2>[^\"]*)\";\"(?<AGRef>[^\"]*)\";;",
"global": true,
"sensitive": true,
"multiline": false,
"singleline": false,
"continueWhenNoRes": false,
"ignoreInfiniteLoopsWhenGlobal": false
},
"mapper": {
"text": "{{55.value}}"
},
"metadata": {
"designer": {
"x": 820,
"y": -3098,
"name": "Extract WaVo"
},
"restore": {},
"parameters": [
{
"name": "pattern",
"type": "text",
"label": "Pattern",
"required": true
},
{
"name": "global",
"type": "boolean",
"label": "Global match",
"required": true
},
{
"name": "sensitive",
"type": "boolean",
"label": "Case sensitive",
"required": true
},
{
"name": "multiline",
"type": "boolean",
"label": "Multiline",
"required": true
},
{
"name": "singleline",
"type": "boolean",
"label": "Singleline",
"required": true
},
{
"name": "continueWhenNoRes",
"type": "boolean",
"label": "Continue the execution of the route even if the module finds no matches",
"required": true
},
{
"name": "ignoreInfiniteLoopsWhenGlobal",
"type": "boolean",
"label": "Ignore errors when there is an infinite search loop",
"required": true
}
],
"expect": [
{
"name": "text",
"type": "text",
"label": "Text"
}
],
"interface": [
{
"type": "text",
"name": "VoNo",
"label": "VoNo"
},
{
"type": "text",
"name": "VoDt",
"label": "VoDt"
},
{
"type": "text",
"name": "ValDt",
"label": "ValDt"
},
{
"type": "text",
"name": "VoTp",
"label": "VoTp"
},
{
"type": "text",
"name": "Txt",
"label": "Txt"
},
{
"type": "text",
"name": "DbAcNo",
"label": "DbAcNo"
},
{
"type": "text",
"name": "DbTrnCl",
"label": "DbTrnCl"
},
{
"type": "text",
"name": "DbTxCd",
"label": "DbTxCd"
},
{
"type": "text",
"name": "CrAcNo",
"label": "CrAcNo"
},
{
"type": "text",
"name": "CrTrnCl",
"label": "CrTrnCl"
},
{
"type": "text",
"name": "CrTxCd",
"label": "CrTxCd"
},
{
"type": "text",
"name": "Am",
"label": "Am"
},
{
"type": "text",
"name": "InvoNo",
"label": "InvoNo"
},
{
"type": "text",
"name": "DueDt",
"label": "DueDt"
},
{
"type": "text",
"name": "VatAm",
"label": "VatAm"
},
{
"type": "text",
"name": "R1",
"label": "R1"
},
{
"type": "text",
"name": "R2",
"label": "R2"
},
{
"type": "text",
"name": "R7",
"label": "R7"
},
{
"type": "text",
"name": "CID",
"label": "CID"
},
{
"type": "text",
"name": "Txt2",
"label": "Txt2"
},
{
"type": "text",
"name": "AGRef",
"label": "AGRef"
},
{
"type": "uinteger",
"name": "i",
"label": "i"
},
{
"type": "any",
"name": "__IMTMATCH__",
"label": "Fallback Match"
}
]
}
},
{
"id": 58,
"module": "util:TextAggregator",
"version": 1,
"parameters": {
"rowSeparator": "",
"feeder": 57
},
"mapper": {
"value": ""
},
"metadata": {
"designer": {
"x": 1065,
"y": -3100,
"name": "Build lines JSON array items"
},
"restore": {
"parameters": {
"rowSeparator": {
"label": "Empty"
}
},
"extra": {
"feeder": {
"label": "Extract WaVo - Match pattern"
}
}
},
"parameters": [
{
"name": "rowSeparator",
"type": "select",
"label": "Row separator",
"validate": {
"enum": [
"\n",
"\t",
"other"
]
}
}
],
"expect": [
{
"name": "value",
"type": "text",
"label": "Text"
}
]
}
},
{
"id": 59,
"module": "util:ComposeTransformer",
"version": 1,
"metadata": {
"designer": {
"x": 1317,
"y": -3100,
"name": "Build combined JSON",
"messages": [
{
"category": "last",
"severity": "warning",
"message": "A transformer should not be the last module in the route."
}
]
}
}
}
]
}
],
"metadata": {
"version": 1
}
}
samliew – request private consultation
Global match must be set to NO!
