{"id":141658,"date":"2023-01-26T17:33:59","date_gmt":"2023-01-26T08:33:59","guid":{"rendered":"https:\/\/support.questetra.com\/?p=141658"},"modified":"2023-02-01T11:54:06","modified_gmt":"2023-02-01T02:54:06","slug":"climber-indexfile-create","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/climber-indexfile-create\/","title":{"rendered":"ClimberCloud Index File: Create"},"content":{"rendered":"\n

ClimberCloud Index File: Create<\/strong><\/h4>\n\n\n\n

ClimberCloud: Create Index File<\/a><\/p>\n\n\n\n

Generates an index file for a ClimberCloud’s ‘list with file’.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_FieldNames<\/dt>
C1: Data item field names for add index file (comma separated) *<\/span><\/dd>\n
conf_IndexFile<\/dt>
C2: Data item that stores the create index file (update) *<\/span><\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\n\nmain();\nfunction main(){\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst fieldNames         = configs.get( "conf_FieldNames" ) + "";\n\nconst dataId_indexFile   = configs.get( "conf_IndexFile" );\n\n\n\/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\nif ( fieldNames == "" ) {\n  throw `Field Names none.`;\n}\n\nlet text = "";\nlet arrayFieldNames = fieldNames.split(",");\nfor ( let i = 0; i < arrayFieldNames.length; i++) {\n  const fieldName = arrayFieldNames[i];\n\/\/engine.log("fieldName:" + fieldName);\n  const dataItem = engine.findDataDefinitionByVarName( fieldName );\n\n  \/\/\u6587\u5b57\u578b\u5358\u4e00\u884c\u30fb\u6570\u5024\u578b\u30fb\u65e5\u4ed8\u578b\u5e74\u6708\u65e5\u306e\u307f\u5bfe\u8c61\n  if ( dataItem.matchDataType("STRING_TEXTFIELD") ) {\n    const qstring = engine.findDataByVarName( fieldName ) + "";\n    text += qstring +",";\n  } else if ( dataItem.matchDataType("DECIMAL") ) {\n    const qnum = engine.findDataByVarName( fieldName );\n    text += qnum.longValue()+",";\n  } else if ( dataItem.matchDataType("DATE_YMD") ) {\n    const qdate = engine.findDataByVarName( fieldName );\n    text += qdate.toString()+",";\n  } else  {\n    text += ",";\n  }\n}\n\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\nlet files = new java.util.ArrayList();\n\/\/\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30d5\u30a1\u30a4\u30eb\u540d\u306f\u56fa\u5b9a\nfiles.add(new com.questetra.bpms.core.event.scripttask.NewQfile("index.csv","text\/csv; charset=Shift_JIS", text));\nengine.setDataByNumber( dataId_indexFile, files);\n\n}\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n