Master Table, Create by TSV String<\/div>
Creates a new master file (OptionsXML) by referring to the TSV String. The specified column data are set as Master IDs, and the other data is set as Master Labels. By placing a [Update Choices] in the downstream process, the update task can be automated.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A: Set TSV String *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Set Column-Number that will be Master-IDs (eg. “0”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B2: Set Separator between Label elements (eg. “*”)#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C0: Set Name of Master File (eg. “foo.xml”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- C1: Select FILES DATA for Master File (append) *<\/span><\/li>\n
- C2: Select STRING DATA for List of Master IDs (update)<\/li>\n
- C3: Select STRING DATA for List of Master Labels (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\/\/ \n\/\/ Notes:\n\/\/ When [service task (update option master)] is placed downstream\n\/\/ - add Select-Type data item and refer to the ID-list and the Label-list\n\/\/ - https:\/\/support.questetra.com\/bpmn-icons\/service-task-choices-update\/\n\/\/ - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208\n\/\/ \n\/\/ Notes(ja):\n\/\/ \u4e0b\u6d41\u306b\uff3b\u30b5\u30fc\u30d3\u30b9\u30bf\u30b9\u30af\uff08\u9078\u629e\u80a2\u30de\u30b9\u30bf\u66f4\u65b0\uff09\uff3d\u3092\u914d\u7f6e\u3059\u308b\u5834\u5408\n\/\/ - \u5225\u9014\u3001\u9078\u629e\u80a2\u578b\u30c7\u30fc\u30bf\u3092\u5b9a\u7fa9\u3057\u3001ID\u4e00\u89a7\u3068Label\u4e00\u89a7\u3092\u53c2\u7167\u3055\u305b\u307e\u3059\n\/\/ - https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-choices-update\/\n\/\/ - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208\n\/\/ \n\/\/ id = value, label = display\n\n\/*\n Questetra BPMS V12.0 (released 2020-05-11)\n - configs.getObject()\n - engine.findData()\n - engine.setData()\n*\/\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strTsv = configs.get( "strSetConfA" ) + ""; \/\/ required\nconst strColumnId = configs.get( "strSetConfB1" ) + ""; \/\/ required\nlet strSeparator = configs.get( "strSetConfB2" ) + ""; \/\/ not\nconst strMasterName = configs.get( "strSetConfC0" ) + ""; \/\/ required\nconst pocketFilesMaster = configs.getObject( "SelectConfC1" ); \/\/ required\nconst pocketStrOptionIds = configs.getObject( "SelectConfC2" ); \/\/ not\nconst pocketStrOptionLabels = configs.getObject( "SelectConfC3" ); \/\/ not\n\nif( strTsv === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {TSV A} is empty \\n" );\n}\nconst numColumnId = parseInt( strColumnId );\nengine.log( " AutomatedTask StringColumnId:" + \n " String {B1}: " + numColumnId );\nif( isNaN( numColumnId ) ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {Column-Number B1} is not an integer \\n" );\n}\nengine.log( " AutomatedTask SeparatorInLabel:" + \n " String {B2}: " + strSeparator );\nif( strSeparator === "" ){\n engine.log( " AutomatedTask ConfigWarning:" +\n " Config {strSeparator B2} is empty or not configed" );\n\/\/ strSeparator = "*";\n}\nif( strMasterName === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {MasterFile Name C0} is empty \\n" );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet filesMaster = engine.findData( pocketFilesMaster ); \nif( filesMaster === null ){\n filesMaster = new java.util.ArrayList();\n \/\/ java.util.ArrayList\n \/\/ - com.questetra.bpms.core.event.scripttask.QfileView\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet strOptionIds = "";\nlet strOptionLabels = "";\n\nconst arrStrTsv = strTsv.split("\\n");\nengine.log( " AutomatedTask StringTsv: " + \n arrStrTsv.length + " lines" );\n\nlet arrTmpRow;\nfor( let i = 0; i < arrStrTsv.length; i++ ){\n arrTmpRow = arrStrTsv[i].split("\\t");\n if( arrTmpRow.length < 2 ){\n throw new Error( "\\n AutomatedTask UnexpectedTsvError:" +\n " #of columns is less than 2 at line " + i + " \\n" );\n }\n if( arrTmpRow.length < numColumnId ){\n throw new Error( "\\n AutomatedTask UnexpectedTsvError:" +\n " #of columns is less than Col-Num at line " + i + " \\n" );\n }\n for( let j = 0; j < arrTmpRow.length; j++ ){\n if( j === numColumnId ){\n strOptionIds += arrTmpRow[j] + "\\n";\n }else{\n strOptionLabels += arrTmpRow[j] + strSeparator;\n }\n }\n if( strSeparator.length !== 0 ){\n strOptionLabels = strOptionLabels.slice( 0, (- strSeparator.length) );\n }\n strOptionLabels = strOptionLabels + "\\n";\n}\nstrOptionIds = strOptionIds.slice( 0, -1 );\nstrOptionLabels = strOptionLabels.slice( 0, -1 );\n\nlet xmlNew = '<?xml version="1.0" encoding="UTF-8"?><items>\\n';\nlet arrOptionIds = strOptionIds.split("\\n");\nlet arrOptionLabels = strOptionLabels.split("\\n");\nfor( let i = 0; i < arrOptionIds.length; i++ ){\n xmlNew += '<item value="';\n xmlNew += arrOptionIds[i];\n xmlNew += '" display="';\n xmlNew += arrOptionLabels[i];\n xmlNew += '" \/>\\n';\n}\nxmlNew += "<\/items>";\n\nfilesMaster.add(\n new com.questetra.bpms.core.event.scripttask.NewQfile(\n strMasterName, "text\/xml", xmlNew\n )\n);\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( pocketFilesMaster, filesMaster ); \/\/ FILES\nif( pocketStrOptionIds !== null ){ \/\/ STRING\n engine.setData( pocketStrOptionIds, strOptionIds );\n}\nif( pocketStrOptionLabels !== null ){ \/\/ STRING\n engine.setData( pocketStrOptionLabels, strOptionLabels );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure><\/div>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- Master-Table-Create-by-Tsv-String-2021.xml<\/a><\/li><\/ul>\n\n\n\n
2021-07-29 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/master-table-create-by-tsv-string-2021\/<\/a>
<\/i> The Add-on import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- When a [Update Choices] is placed downstream;
- Add a Select-Type Data Item and refer to the ID list and the Label list<\/li>
- https:\/\/support.questetra.com\/bpmn-icons\/service-task-choices-update\/<\/a><\/li>
- https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208<\/a><\/li><\/ul><\/li><\/ol>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/master-table-create-by-tsv-en-1.png?ssl=1\")
<\/figure>\n\n\n\n![\"Creates](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Create-by-TSV-String-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208<\/a><\/li><\/ul><\/li><\/ol>\n\n\n\n
- When a [Update Choices] is placed downstream;
- <\/i><\/span> B1: Set Column-Number that will be Master-IDs (eg. “0”) *<\/span>#{EL}<\/sup><\/span><\/li>\n