{"id":149124,"date":"2023-08-04T17:12:32","date_gmt":"2023-08-04T08:12:32","guid":{"rendered":"https:\/\/support.questetra.com\/?p=149124"},"modified":"2023-08-04T17:12:34","modified_gmt":"2023-08-04T08:12:34","slug":"master-table-update-2023","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/master-table-update-2023\/","title":{"rendered":"\u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb: \u66f4\u65b0"},"content":{"rendered":"\n

\u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb: \u66f4\u65b0<\/strong><\/h4>\n\n\n\n

translate<\/span> Master Table: Update<\/a><\/p>\n\n\n\n

\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306e\u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb\uff08OptionsXML\uff09\u3092\u53c2\u7167\u3057\u3001\u65b0\u3057\u3044\u30de\u30b9\u30bf\u30fc\u30d5\u30a1\u30a4\u30eb\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u65b0\u3057\u3044ID-Label\u306f\u5148\u982d\u884c\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002ID\u304c\u91cd\u8907\u3059\u308b\u5834\u5408\u3001\u5f53\u8a72\u884c\u306f\u524a\u9664\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u6307\u5b9a\u306e\u30de\u30b9\u30bf\u30fc\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u3001\u65b0\u898f\u306b\u751f\u6210\u3055\u308c\u307e\u3059\u3002\u4e0b\u6d41\u5de5\u7a0b\u306b\uff3b\u30b5\u30fc\u30d3\u30b9\u30bf\u30b9\u30af\uff08\u9078\u629e\u80a2\u30de\u30b9\u30bf\u66f4\u65b0\uff09\uff3d \u3092\u914d\u7f6e\u3059\u308c\u3070\u3001\u66f4\u65b0\u696d\u52d9\u3092\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
strSetConfA<\/dt>
A: \u30de\u30b9\u30bf\u30fc\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b “foo.xml”) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
strSetConfB1<\/dt>
B1: \u8ffd\u52a0\u3059\u308bID\uff08Value\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
strSetConfB2<\/dt>
B2: \u8ffd\u52a0\u3059\u308bLabel\uff08Display\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfC1<\/dt>
C1: \u65b0\u3057\u3044\u30de\u30b9\u30bf\u30fc\u30d5\u30a1\u30a4\u30eb\u304c\u683c\u7d0d\u3055\u308c\u308b\u30d5\u30a1\u30a4\u30eb\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u8ffd\u8a18) *<\/span><\/dd>\n
SelectConfC2<\/dt>
C2: \u65b0\u3057\u3044\u30de\u30b9\u30bf\u30fc\u306eID\u4e00\u89a7\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC3<\/dt>
C3: \u65b0\u3057\u3044\u30de\u30b9\u30bf\u30fc\u306eLabel\u4e00\u89a7\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfD1<\/dt>
D1: \u65e2\u5b58\u306e\u30de\u30b9\u30bf\u30fc\u30d5\u30a1\u30a4\u30eb\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u3044\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u8ffd\u8a18)<\/dd>\n
SelectConfD2<\/dt>
D2: \u524a\u9664\u3055\u308c\u305fID-Label\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u305f\u3044\u5834\u5408\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script for 'engine type: 3' ("GraalJS standard mode")\n\/\/ cf 'engine type: 2' renamed from "GraalJS" to "GraalJS Nashorn compatible mode" (at 20230526)\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 strMasterName         = configs.get( "strSetConfA"  ); \/\/ required\nconst strComingOptionIds    = configs.get( "strSetConfB1" ); \/\/ required\nconst strComingOptionLabels = configs.get( "strSetConfB2" ); \/\/ required\nconst pocketNewMaster       = configs.getObject( "SelectConfC1" ); \/\/ required\nconst pocketNewOptionIds    = configs.getObject( "SelectConfC2" ); \/\/ not\nconst pocketNewOptionLabels = configs.getObject( "SelectConfC3" ); \/\/ not\nconst pocketBackupMaster    = configs.getObject( "SelectConfD1" ); \/\/ not\nconst pocketDeletedIdLabels = configs.getObject( "SelectConfD2" ); \/\/ not\n\nif( strMasterName === "" ){\n  throw new Error( "\\n AutomatedTask ConfigError:" +\n                   " Config {MasterFile Name A} is empty \\n" );\n}\nif( strComingOptionIds === "" ){\n  throw new Error( "\\n AutomatedTask ConfigError:" +\n                   " Config {OptionID B1} is empty \\n" );\n}\nif( strComingOptionLabels === "" ){\n  throw new Error( "\\n AutomatedTask ConfigError:" +\n                   " Config {OptionLabel B2} is empty \\n" );\n}\nlet arrComingOptionIds    = strComingOptionIds.split('\\n');\nlet arrComingOptionLabels = strComingOptionLabels.split('\\n');\nif( arrComingOptionIds.length !== arrComingOptionLabels.length ){\n  throw new Error( "\\n AutomatedTask ConfigError:" +\n                   " {OptionIds B1} {OptionLabels B2} must be same \\n" );\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 "List<ItemView>" (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    = "";\nlet strNewOptionLabels = "";\nlet strDeletedIdLabels = "";\nlet xmlBackup = '<?xml version="1.0" encoding="UTF-8"?><items>\\n';\nif( jarrOptions.size() - 0 === 0 ){\n  engine.log( " AutomatedTask OptionsXML: " + \n            strMasterName + " not found" );\n  strNewOptionIds    += strComingOptionIds;\n  strNewOptionLabels += strComingOptionLabels;\n}else{\n  engine.log( " AutomatedTask OptionsXML: " + \n            strMasterName + ": " +\n            jarrOptions.size() + " options" );\n  strNewOptionIds    += strComingOptionIds + "\\n";\n  strNewOptionLabels += strComingOptionLabels + "\\n";\n\n  let flagMatch = 0;\n  for( let i = 0; i < (jarrOptions.size() - 0); i++ ){\n    xmlBackup += '<item value="';\n    xmlBackup += jarrOptions.get(i).getValue();\n    xmlBackup += '" display="';\n    xmlBackup += jarrOptions.get(i).getDisplay();\n    xmlBackup += '" \/>\\n';\n    for( let j = 0; j < arrComingOptionIds.length; j++ ){\n      if( (jarrOptions.get(i).getValue() + "") === arrComingOptionIds[j] ){\n        flagMatch = 1;\n        break;\n      }\n    }\n    if( flagMatch === 0 ){\n      strNewOptionIds    += jarrOptions.get(i).getValue() + "\\n";\n      strNewOptionLabels += jarrOptions.get(i).getDisplay() + "\\n";\n    }else{\n      strDeletedIdLabels += jarrOptions.get(i).getValue() + "\\t" +\n                            jarrOptions.get(i).getDisplay() + "\\n";\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 += "<\/items>";\n\nlet xmlNew = '<?xml version="1.0" encoding="UTF-8"?><items>\\n';\nlet arrNewOptionIds    = strNewOptionIds.split("\\n");\nlet arrNewOptionLabels = strNewOptionLabels.split("\\n");\nfor( let i = 0; i < arrNewOptionIds.length; i++ ){\n  xmlNew += '<item value="';\n  xmlNew += arrNewOptionIds[i];\n  xmlNew += '" display="';\n  xmlNew += arrNewOptionLabels[i];\n  xmlNew += '" \/>\\n';\n}\nxmlNew += "<\/items>";\n\nfilesNewMaster.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( 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 = "";\n      strYYYYMMDDHHMM += dateNow.getFullYear();\n      strYYYYMMDDHHMM += ('0' + (dateNow.getMonth() + 1)).slice(-2);\n      strYYYYMMDDHHMM += ('0' + dateNow.getDate()).slice(-2);\n      strYYYYMMDDHHMM += ('0' + dateNow.getHours()).slice(-2);\n      strYYYYMMDDHHMM += ('0' + dateNow.getMinutes()).slice(-2);\n  let strBackupName = "";\n  let arrNameParts = strMasterName.split('.');\n  if( arrNameParts.length === 1 ){\n    strBackupName += strMasterName + "-" + strYYYYMMDDHHMM;\n  }else{\n    for( let i = 0; i < arrNameParts.length - 1; i++ ){\n      strBackupName += arrNameParts[i];\n    }\n    strBackupName += "-" + strYYYYMMDDHHMM;\n    strBackupName += "." + arrNameParts[arrNameParts.length - 1];\n  }\n  filesBackupMaster.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strBackupName, "text\/xml", xmlBackup\n    )\n  );\n  engine.setData( pocketBackupMaster, filesBackupMaster );\n}\nif( pocketDeletedIdLabels !== null ){  \/\/ STRING\n  engine.setData( pocketDeletedIdLabels, strDeletedIdLabels );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/*\n\/\/ Notes:\n- It is also possible to add multiple ID-Labels in bulk\n- Name of created file are "Foo.xml" and "Foo-backup.xml"\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 "Foo.xml" \u304a\u3088\u3073 "Foo-backup.xml" \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\/ja\/articles\/360002260151-M208\n- id = value, label = display\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n