{"id":88935,"date":"2021-02-17T13:30:00","date_gmt":"2021-02-17T04:30:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=88935"},"modified":"2023-08-04T17:14:19","modified_gmt":"2023-08-04T08:14:19","slug":"master-table-update","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/master-table-update\/","title":{"rendered":"Master Table, Update"},"content":{"rendered":"\n\n<div style=\"text-align: center; background: #FFF4CC; margin: 1em; padding: 1em;\">\n<h3><span class=\"material-icons\">warning<\/span> PAGE UPDATED<\/h3>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/master-table-update-2023\/\">https:\/\/support.questetra.com\/en\/addons\/master-table-update-2023\/<\/a>\n<\/div>\n\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Master Table, Update<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">(C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/master-table-update\/\">https:\/\/support.questetra.com\/en\/addons\/master-table-update\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li> A: Set Name of Master File (e.g. &#8220;foo.xml&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> B1: Set ID (Value) to be added<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> B2: Set Label (Display) to be added<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C1: Select FILE DATA for New Master File (append)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> C2: Select STRING DATA for List of Master IDs (update)<\/li>\n<li> C3: Select STRING DATA for List of Master Labels (update)<\/li>\n<li> D1: Select FILE DATA to Backup Current Master (append)<\/li>\n<li> D2: Select STRING DATA to Backup Deleted ID-Label (update)<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ Nashorn Script (engine type: 1)\n\/\/ \n\/\/ Notes:\n\/\/ It is also possible to add multiple ID-Labels in bulk\n\/\/ Name of created file are &quot;Foo.xml&quot; and &quot;Foo-backup.xml&quot;\n\/\/ If the specified master file does not exist, only new file will be created.\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\/\/ \u8907\u6570\u306eID-Label\u3092\u307e\u3068\u3081\u3066\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\n\/\/ \u751f\u6210\u3055\u308c\u308b\u30d5\u30a1\u30a4\u30eb\u540d\u306f &quot;Foo.xml&quot; \u304a\u3088\u3073 &quot;Foo-backup.xml&quot; \u3068\u306a\u308a\u307e\u3059\n\/\/ \u30de\u30b9\u30bf\u30fc\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u65b0\u898f\u30d5\u30a1\u30a4\u30eb\u304c\u751f\u6210\u3055\u308c\u307e\u3059\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 &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strMasterName         = configs.get( &quot;strSetConfA&quot;  ); \/\/ required\nconst strComingOptionIds    = configs.get( &quot;strSetConfB1&quot; ); \/\/ required\nconst strComingOptionLabels = configs.get( &quot;strSetConfB2&quot; ); \/\/ required\nconst pocketNewMaster       = configs.getObject( &quot;SelectConfC1&quot; ); \/\/ required\nconst pocketNewOptionIds    = configs.getObject( &quot;SelectConfC2&quot; ); \/\/ not\nconst pocketNewOptionLabels = configs.getObject( &quot;SelectConfC3&quot; ); \/\/ not\nconst pocketBackupMaster    = configs.getObject( &quot;SelectConfD1&quot; ); \/\/ not\nconst pocketDeletedIdLabels = configs.getObject( &quot;SelectConfD2&quot; ); \/\/ not\n\nif( strMasterName === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {MasterFile Name A} is empty \\n&quot; );\n}\nif( strComingOptionIds === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {OptionID B1} is empty \\n&quot; );\n}\nif( strComingOptionLabels === &quot;&quot; ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {OptionLabel B2} is empty \\n&quot; );\n}\nlet arrComingOptionIds    = strComingOptionIds.split(&#39;\\n&#39;);\nlet arrComingOptionLabels = strComingOptionLabels.split(&#39;\\n&#39;);\nif( arrComingOptionIds.length !== arrComingOptionLabels.length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; {OptionIds B1} {OptionLabels B2} must be same \\n&quot; );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet filesNewMaster = engine.findData( pocketNewMaster ); \nif( filesNewMaster === null ){\n  filesNewMaster = new java.util.ArrayList();\n  \/\/ java.util.ArrayList\n  \/\/ - com.questetra.bpms.core.event.scripttask.QfileView\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst jarrOptions = itemDao.findAll( strMasterName, true );\n\/\/ return &quot;List&lt;ItemView&gt;&quot; (java.util.ArrayList)\n\/\/ M319: Register an Options-XML file to which the Process Model Definitions Refer\n\/\/ M319: Options-XML: \u8907\u6570\u306e\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u5b9a\u7fa9\u304b\u3089\u53c2\u7167\u3055\u308c\u308b\u9078\u629e\u80a2XML\n\/\/ R2300 com.questetra.bpms.core.event.scripttask.ItemDaoWrapper\n\nlet strNewOptionIds    = &quot;&quot;;\nlet strNewOptionLabels = &quot;&quot;;\nlet strDeletedIdLabels = &quot;&quot;;\nlet xmlBackup = &#39;&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;&lt;items&gt;\\n&#39;;\nif( jarrOptions.size() - 0 === 0 ){\n  engine.log( &quot; AutomatedTask OptionsXML: &quot; + \n            strMasterName + &quot; not found&quot; );\n  strNewOptionIds    += strComingOptionIds;\n  strNewOptionLabels += strComingOptionLabels;\n}else{\n  engine.log( &quot; AutomatedTask OptionsXML: &quot; + \n            strMasterName + &quot;: &quot; +\n            jarrOptions.size() + &quot; options&quot; );\n  strNewOptionIds    += strComingOptionIds + &quot;\\n&quot;;\n  strNewOptionLabels += strComingOptionLabels + &quot;\\n&quot;;\n\n  let flagMatch = 0;\n  for( let i = 0; i &lt; (jarrOptions.size() - 0); i++ ){\n    xmlBackup += &#39;&lt;item value=&quot;&#39;;\n    xmlBackup += jarrOptions.get(i).getValue();\n    xmlBackup += &#39;&quot; display=&quot;&#39;;\n    xmlBackup += jarrOptions.get(i).getDisplay();\n    xmlBackup += &#39;&quot; \/&gt;\\n&#39;;\n    for( let j = 0; j &lt; arrComingOptionIds.length; j++ ){\n      if( (jarrOptions.get(i).getValue() + &quot;&quot;) === arrComingOptionIds[j] ){\n        flagMatch = 1;\n        break;\n      }\n    }\n    if( flagMatch === 0 ){\n      strNewOptionIds    += jarrOptions.get(i).getValue() + &quot;\\n&quot;;\n      strNewOptionLabels += jarrOptions.get(i).getDisplay() + &quot;\\n&quot;;\n    }else{\n      strDeletedIdLabels += jarrOptions.get(i).getValue() + &quot;\\t&quot; +\n                            jarrOptions.get(i).getDisplay() + &quot;\\n&quot;;\n    }\n    flagMatch = 0;\n  }\n  strNewOptionIds    = strNewOptionIds.slice( 0, -1 );\n  strNewOptionLabels = strNewOptionLabels.slice( 0, -1 );\n  strDeletedIdLabels = strDeletedIdLabels.slice( 0, -1 );\n}\nxmlBackup += &quot;&lt;\/items&gt;&quot;;\n\nlet xmlNew = &#39;&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;&lt;items&gt;\\n&#39;;\nlet arrNewOptionIds    = strNewOptionIds.split(&quot;\\n&quot;);\nlet arrNewOptionLabels = strNewOptionLabels.split(&quot;\\n&quot;);\nfor( let i = 0; i &lt; arrNewOptionIds.length; i++ ){\n  xmlNew += &#39;&lt;item value=&quot;&#39;;\n  xmlNew += arrNewOptionIds[i];\n  xmlNew += &#39;&quot; display=&quot;&#39;;\n  xmlNew += arrNewOptionLabels[i];\n  xmlNew += &#39;&quot; \/&gt;\\n&#39;;\n}\nxmlNew += &quot;&lt;\/items&gt;&quot;;\n\nfilesNewMaster.add(\n  new com.questetra.bpms.core.event.scripttask.NewQfile(\n    strMasterName, &quot;text\/xml&quot;, xmlNew\n  )\n);\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( pocketNewMaster, filesNewMaster ); \/\/ FILES\nif( pocketNewOptionIds !== null ){     \/\/ STRING\n  engine.setData( pocketNewOptionIds, strNewOptionIds );\n}\nif( pocketNewOptionLabels !== null ){  \/\/ STRING\n  engine.setData( pocketNewOptionLabels, strNewOptionLabels );\n}\nif( pocketBackupMaster !== null ){     \/\/ FILES\n  let filesBackupMaster = engine.findData( pocketBackupMaster ); \n  if( filesBackupMaster === null ){\n    filesBackupMaster = new java.util.ArrayList();\n  }\n  let dateNow = new Date();\n  let strYYYYMMDDHHMM = &quot;&quot;;\n      strYYYYMMDDHHMM += dateNow.getFullYear();\n      strYYYYMMDDHHMM += (&#39;0&#39; + (dateNow.getMonth() + 1)).slice(-2);\n      strYYYYMMDDHHMM += (&#39;0&#39; + dateNow.getDate()).slice(-2);\n      strYYYYMMDDHHMM += (&#39;0&#39; + dateNow.getHours()).slice(-2);\n      strYYYYMMDDHHMM += (&#39;0&#39; + dateNow.getMinutes()).slice(-2);\n  let strBackupName = &quot;&quot;;\n  let arrNameParts = strMasterName.split(&#39;.&#39;);\n  if( arrNameParts.length === 1 ){\n    strBackupName += strMasterName + &quot;-&quot; + strYYYYMMDDHHMM;\n  }else{\n    for( let i = 0; i &lt; arrNameParts.length - 1; i++ ){\n      strBackupName += arrNameParts[i];\n    }\n    strBackupName += &quot;-&quot; + strYYYYMMDDHHMM;\n    strBackupName += &quot;.&quot; + arrNameParts[arrNameParts.length - 1];\n  }\n  filesBackupMaster.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strBackupName, &quot;text\/xml&quot;, xmlBackup\n    )\n  );\n  engine.setData( pocketBackupMaster, filesBackupMaster );\n}\nif( pocketDeletedIdLabels !== null ){  \/\/ STRING\n  engine.setData( pocketDeletedIdLabels, strDeletedIdLabels );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACqUlEQVRYR8WX30tTYRjHP8cLiwaV\niyKaRKTIUKQM1mXQkG68S7oo66IabOZNQZLgjYIISVAXkhu4JhTb3f4ALwxiV1lqF5MVQl0UCGlL\nxClu7sTZ6W3nh9Pt5HbO1Q7n+fHd9\/k+z\/O+EjY\/Utn5QxxB5joSV5HpQOIc0PDXP43MNyTmkXmL\nRBw\/mXJi7w8gwmm2eQIEgMPlBAW2gCD1POUuy3v57A0gSACJZ4CjzMRGsw1kHhMgWMq\/NIAQL4Fe\ni4mNbhP4ebBbrN0BBIkicfOAkqthZGIEuGWMaQZwsP98Xyb0ANSaTyheXWe7cB5yks1nSSwnaDnW\ngsvhskRK6neK2Z+zgolerSaKAFS1LwnBJW8kaW1oZT27Tl+ij4GLA4V3K084Fcb3zidcN6inWXRH\nEUCI58BDYVVFAEqKF\/h5pPxQAShDBla1fT56eZRGRyObuU0inyN4XV7cx91WCGDmxwxTX6a0vsqc\nOKEMKxVAkNtIvNZaeM94CzX\/Xw3syDssrC6wmF7Ug5e5Q4A3goEwcE9rUeUSKKle4ee+YGAOiY6a\nApCZJ8AlwcAvzWIp4Ji8MonnlIeVrRUG3w\/Sfb6bTlcndVJdRTrI5XMFDY0nx41+afw4BQDZ+FVo\nIJPLMP19Gs9Jj6U5UFIDSkI\/UkkANdCADoCpBDUAoClBEJMIo94obc421rbXGPowhM\/tK7xX+uTl\nPLGlGGOfxoxtqBOhqQ0rTWTBXteGpkFkLEH\/hX7ane0W8oBhF4ilpBtEplFcZQ0YRrG6D3TLKH4t\nTtPRJpQ2HJkboae5x5IGlNDxr3GGPw5r2TMsI+WTYR1b4ro8pxLrWF1K\/w4k5cWyYCVT4kAiYtl6\nJBMgbD2UVoeJCo\/lRSZsvJgIELZezbQit+1yaqHTKnH5A\/BLQDDnE9nfAAAAAElFTkSuQmCC\" alt=\"\"\/><\/figure>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1mxWIedBa-GdhYwSWcTv9b0xVsoY4m69A\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Master-Table-Update.xml<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1049\" height=\"801\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/master-table-update-ja-1-en.png?resize=1049%2C801&#038;ssl=1\" alt=\"\" class=\"wp-image-101971\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/master-table-update-ja-1-en.png?w=1049&amp;ssl=1 1049w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/master-table-update-ja-1-en.png?resize=413%2C315&amp;ssl=1 413w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/master-table-update-ja-1-en.png?resize=825%2C630&amp;ssl=1 825w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/master-table-update-ja-1-en.png?resize=768%2C586&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"88938\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/master-table-update\/attachment\/master-table-update-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"Master-Table-Update-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream.\" class=\"wp-image-88938\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>It is also possible to add multiple ID-Labels in bulk<\/li>\n\n\n\n<li>Name of created file are &#8220;Foo.xml&#8221; and &#8220;Foo-YYYYMMDDHHMM.xml&#8221;<\/li>\n\n\n\n<li>If the specified master file does not exist, only new file will be created.<\/li>\n\n\n\n<li>When [service task (update option master)] is placed downstream\n<ol class=\"wp-block-list\">\n<li>add Select-Type data item and refer to the ID-list and the Label-list<\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-choices-update\/\">https:\/\/support.questetra.com\/bpmn-icons\/service-task-choices-update\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208\">https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"8oGtb1Jvjx\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/master-table-backup\/\">Master Table, Backup<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cMaster Table, Backup\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/master-table-backup\/embed\/#?secret=JiAvZalpKQ#?secret=8oGtb1Jvjx\" data-secret=\"8oGtb1Jvjx\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream.<\/p>\n","protected":false},"author":2,"featured_media":88936,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[372],"faq_section":[],"class_list":["post-88935","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-itemdao"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":4,"uagb_excerpt":"Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-n8r","jetpack-related-posts":[{"id":89073,"url":"https:\/\/support.questetra.com\/en\/addons\/master-table-update-to-delete-options\/","url_meta":{"origin":88935,"position":0},"title":"Master Table, Update to Delete Options","author":"IMAMURA, Genichi","date":"2021-02-17","format":false,"excerpt":"Deletes unnecessary Options and Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. No error occurs even if the deletion ID does not exist. For automation, place [Service Task (Choices Update)] downstream.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Master Table: Update to Delete Options","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-to-Delete-Options-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-to-Delete-Options-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-to-Delete-Options-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-to-Delete-Options-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-to-Delete-Options-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":89039,"url":"https:\/\/support.questetra.com\/en\/addons\/master-table-create-by-tsv-string\/","url_meta":{"origin":88935,"position":1},"title":"Master Table, Create by TSV String","author":"IMAMURA, Genichi","date":"2020-06-15","format":false,"excerpt":"Creates a new master file (OptionsXML) by referring to TSV String. The specified column data are set as Master IDs, and the others are set as Master Labels. For automation, place [Service Task (Choices Update)] downstream.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Master Table, Create by TSV String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Create-by-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Create-by-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Create-by-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Create-by-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Create-by-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":149121,"url":"https:\/\/support.questetra.com\/en\/addons\/master-table-update-2023\/","url_meta":{"origin":88935,"position":2},"title":"Master Table: Update","author":"IMAMURA, Genichi","date":"2023-08-04","format":false,"excerpt":"Creates a new master file (OptionsXML) by referring to the master table on Workflow Platform. A new ID-Label will be added to the first line. Rows with the same ID are deleted. For automation, place [Service Task (Choices Update)] downstream.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Master Table: Update","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82492,"url":"https:\/\/support.questetra.com\/en\/addons\/string-decode-using-master-table\/","url_meta":{"origin":88935,"position":3},"title":"String, Decode using Master Table","author":"IMAMURA, Genichi","date":"2021-02-17","format":false,"excerpt":"Converts ID string to Label string with referring \"Choice Master\" shared within the workflow platform. If there is no matching ID, it is converted to an empty string.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"String, Decode using Master Table","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/String-Decode-using-Master-Table-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/String-Decode-using-Master-Table-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/String-Decode-using-Master-Table-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/String-Decode-using-Master-Table-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/String-Decode-using-Master-Table-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83104,"url":"https:\/\/support.questetra.com\/en\/system-settings\/app-shared-add-on\/","url_meta":{"origin":88935,"position":4},"title":"System Settings &#8211; App-shared Add-on","author":"Peter Glover","date":"2020-03-11","format":false,"excerpt":"Uploaded data can be stored and then referred to by multiple Apps.","rel":"","context":"In &quot;System Settings&quot;","block_context":{"text":"System Settings","link":"https:\/\/support.questetra.com\/en\/category\/system-settings\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Gear_upload-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Gear_upload-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Gear_upload-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Gear_upload-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/Gear_upload-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75420,"url":"https:\/\/support.questetra.com\/en\/templates\/customer-master-data-sync-process-20160719\/","url_meta":{"origin":88935,"position":5},"title":"Customer Master Data Sync Process","author":"Hirotaka NISHI","date":"2021-01-14","format":false,"excerpt":"Synchronizes \"Customer Master\" managed in Google Spreadsheet, automatically. Automatically Starts 1:00 every night, connects to Google spreadsheet API, and acquires \"Customer list\". The acquired customer list is reformatted and updated as \"Customer Master (Options XML)\" on the Workflow platform. It also corresponds to a manually starting by a person or\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-Update-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/88935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=88935"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/88935\/revisions"}],"predecessor-version":[{"id":149128,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/88935\/revisions\/149128"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/88936"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=88935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=88935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=88935"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=88935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}