Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa (Questetra BPMS: Process, Extract as TSV)<\/div>
\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u4e00\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f “0,2,3” \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002”\u30d5\u30a1\u30a4\u30eb\u578b” \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001”\u9078\u629e\u578b” \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> U: HTTP\u8a8d\u8a3c\u8a2d\u5b9a\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span><\/li>\n
- <\/i><\/span> B: \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4URL\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044(${var[applicationRoot]} or https:\/\/<\/a>..\/) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C: \u6848\u4ef6\u306e\u30d7\u30ed\u30bb\u30b9ID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 ( \u4f8b “123” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> D: \u62bd\u51fa\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306eID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 ( \u4f8b “0,2,3” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> E: \u62bd\u51fa\u3055\u308c\u305fTSV\u6587\u5b57\u5217\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/li>\n
- <\/i><\/span> F: \u62bd\u51fa\u3055\u308c\u305fTSV\u6587\u5b57\u5217\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u8ffd\u8a18)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\/\/ about Questetra Workflow API\n\/\/ See https:\/\/online-demo-ja.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API\n\/\/ or "https:\/\/{YOUR}.questetra.net\/s\/swagger\/index.html"\n\n\/\/ about Questetra OAuth2 (for System Admin)\n\/\/ Get ID&Secret: System Settings > API Clients > OAuth2 Clients > Add OAuthw Client\n\/\/ (config "Redirect URL" = "https:\/\/s.questetra.net\/oauth2callback" )\n\/\/ (Scope: "read" or "any" )\n\/\/ Set ID&Secret: Workflow App > Detail > OAuth2 Setting > (Get Refresh Token)\n\n\/\/ Notes:\n\/\/ Tab code and line feed code in Workflow data will be deleted.\n\/\/ Workflow\u30c7\u30fc\u30bf\u5185\u306e\u30bf\u30d6\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u62bd\u51fa\u6642\u306b\u524a\u9664\u3055\u308c\u307e\u3059\n\/\/ Specify "Title" to extract Title and "Id" to extract ID. ( e.g. "Title,Id,0,2,3" )\n\/\/ \u6848\u4ef6\u30bf\u30a4\u30c8\u30eb\u306e\u62bd\u51fa\u306b\u306f "Title" \u3092\u3001ID\u306e\u62bd\u51fa\u306b\u306f "Id" \u3092\u6307\u5b9a\u3057\u307e\u3059 ( \u4f8b "Title,Id,0,2,3" )\n\/\/ If an undefined dataitem ID or Guide Panel ID is specified, "#N\/A" is output.\n\/\/ \u672a\u5b9a\u7fa9\u306e\u30c7\u30fc\u30bf\u9805\u76eeID\u3084\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u306eID\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001"#N\/A" \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n\/\/ If an unsupported type is specified, "#TYPE!" is output.\n\/\/ \u30b5\u30dd\u30fc\u30c8\u5916\u306e\u30c7\u30fc\u30bf\u578b\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001"#TYPE!" \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n\/\/ The file names are extracted for the File type. (Multiple: Space-separated)\n\/\/ \u30d5\u30a1\u30a4\u30eb\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09\n\/\/ The display strings of the selected options are extracted for the Select type. (Multiple: Space-separated)\n\/\/ \u9078\u629e\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09\n\/\/ It supports loop processing.\n\/\/ \u30eb\u30fc\u30d7\u51e6\u7406\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\uff08\u62bd\u51fa\u7d50\u679c\u306e\u8ffd\u8a18\uff09\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/ required\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst applicationRoot = configs.get( "conf_ApplicationRoot" ) + ""; \/\/ required\nconst processId = configs.get( "conf_ProcessId" ) + ""; \/\/ required\nconst dataitemIds = configs.get( "conf_DataitemIds" ) + ""; \/\/ required\nconst dataIdE = configs.get( "conf_DataIdE" ) + ""; \/\/ not required\nconst dataIdF = configs.get( "conf_DataIdF" ) + ""; \/\/ not required\n\/\/ 'java.lang.String' (String Obj) to javascript primitive 'string'\n\nengine.log( " AutomatedTask Config: Application Root: " + applicationRoot );\nengine.log( " AutomatedTask Config: Process ID: " + processId );\nengine.log( " AutomatedTask Config: Dataitem IDs: " + dataitemIds );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet strBeforeAppend = engine.findDataByNumber( dataIdF );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ get ProcessInstance via Questetra Workflow API\n\/\/ com.questetra.bpms.core.event.scripttask.HttpClientWrapper\nlet apiRequest = httpClient.begin(); \/\/ HttpRequestWrapper\n apiRequest = apiRequest.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n apiRequest = apiRequest.queryParam( "processInstanceId", processId );\nconst apiUri = applicationRoot + "API\/OR\/ProcessInstance\/view";\n\n\/\/ request to API\nengine.log( " AutomatedTask Trying: GET " + apiUri );\nconst response = apiRequest.get( apiUri );\nconst responseCode = response.getStatusCode() + "";\nengine.log( " AutomatedTask ApiResponse: Status " + responseCode );\nif( responseCode !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n responseCode + "\\n" + response.getResponseAsString() + "\\n" );\n}\nconst responseStr = response.getResponseAsString() + "";\nconst responseObj = JSON.parse( responseStr );\n\/\/engine.log( responseStr ); \/\/test\n\n\/\/ retrieve JSON\nlet strNewline = "";\nlet arrDataitemIds = dataitemIds.split(","); \/\/ e.g. "Title,Id,0,2,3"\nfor( let i = 0; i < arrDataitemIds.length; i++ ){\n if( arrDataitemIds[i] === "Id" ){\n strNewline += responseObj.processInstance.processInstanceId;\n }else if( arrDataitemIds[i] === "Title" ){\n if( responseObj.processInstance.processInstanceTitle !== null ){\n strNewline += responseObj.processInstance.processInstanceTitle;\n }\n }else{\n if( responseObj.processInstance.data[ arrDataitemIds[i] ] == undefined ){\n strNewline += "#N\/A";\n }else if( responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "STRING" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "DECIMAL" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "DATE" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "DATETIME" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "QUSER" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "QGROUP" ){\n if( responseObj.processInstance.data[ arrDataitemIds[i] ].value !== null ){\n strNewline += responseObj.processInstance.data[ arrDataitemIds[i] ].value\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n }\n }else if( responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "SELECT" ){\n if( responseObj.processInstance.data[ arrDataitemIds[i] ].value !== null ){\n for( let j = 0; j < responseObj.processInstance.data[ arrDataitemIds[i] ].value.length; j++ ){\n strNewline += responseObj.processInstance.data[ arrDataitemIds[i] ].value[j].display\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n if( j !== responseObj.processInstance.data[ arrDataitemIds[i] ].value.length - 1 ){\n strNewline += " "; \/\/ (Multiple: Space-separated)\n }\n }\n }\n }else if( responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "FILE2" ){\n if( responseObj.processInstance.data[ arrDataitemIds[i] ].value !== null ){\n for( let j = 0; j < responseObj.processInstance.data[ arrDataitemIds[i] ].value.length; j++ ){\n strNewline += responseObj.processInstance.data[ arrDataitemIds[i] ].value[j].name\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n if( j !== responseObj.processInstance.data[ arrDataitemIds[i] ].value.length - 1 ){\n strNewline += " "; \/\/ (Multiple: Space-separated)\n }\n }\n }\n }else{\n strNewline += "#TYPE!";\n }\n }\n if( i !== arrDataitemIds.length - 1 ){\n strNewline += "\\t";\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strNewline === "" ){\n engine.log( " AutomatedTask DataUpdating: Extracted Text empty" );\n}\nif( dataIdE !== "" ){ \n engine.setDataByNumber( dataIdE, strNewline );\n}\nif( dataIdF !== "" ){ \n if( strBeforeAppend !== null ){\n engine.setDataByNumber( dataIdF, strBeforeAppend + "\\n" + strNewline );\n }else{\n engine.setDataByNumber( dataIdF, strNewline );\n }\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Questetra-BPMS-Process-Extract-as-TSV.xml<\/a><\/li>\n\n\n\n
- Questetra-BPMS-Process-Extract-as-TSV-2023.xml<\/a>\n
- \n
- 2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-07-01 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-extract-as-tsv-2021\/<\/a>
<\/i> Addon\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306f Professional<\/strong><\/span> \u3067\u306e\u307f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Workflow\u30c7\u30fc\u30bf\u5185\u306e\u30bf\u30d6\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u62bd\u51fa\u6642\u306b\u524a\u9664\u3055\u308c\u307e\u3059<\/li>\n\n\n\n
- \u6848\u4ef6\u30bf\u30a4\u30c8\u30eb\u306e\u62bd\u51fa\u306b\u306f “Title” \u3092\u3001ID\u306e\u62bd\u51fa\u306b\u306f “Id” \u3092\u6307\u5b9a\u3057\u307e\u3059 ( \u4f8b “Title,Id,0,2,3” )<\/li>\n\n\n\n
- \u672a\u5b9a\u7fa9\u306e\u30c7\u30fc\u30bf\u9805\u76eeID\u3084\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u306eID\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001”#N\/A” \u304c\u51fa\u529b\u3055\u308c\u307e\u3059<\/li>\n\n\n\n
- \u30b5\u30dd\u30fc\u30c8\u5916\u306e\u30c7\u30fc\u30bf\u578b\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001”#TYPE!” \u304c\u51fa\u529b\u3055\u308c\u307e\u3059<\/li>\n\n\n\n
- \u30d5\u30a1\u30a4\u30eb\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09<\/li>\n\n\n\n
- \u9078\u629e\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09<\/li>\n\n\n\n
- \u30eb\u30fc\u30d7\u51e6\u7406\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\uff08\u62bd\u51fa\u7d50\u679c\u306e\u8ffd\u8a18\uff09<\/li>\n<\/ol>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/extract-as-tsv-ja-1.png?ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/09\/Questetra-BPMS-Process-Extract-as-TSV-capture-ja.png?resize=960%2C540&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- Questetra-BPMS-Process-Extract-as-TSV-2023.xml<\/a>\n
- <\/i><\/span> B: \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4URL\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044(${var[applicationRoot]} or https:\/\/<\/a>..\/) *<\/span>#{EL}<\/sup><\/span><\/li>\n