Converter (JigyosyoZipCsv to JigyosyoZipXml)<\/div>
Generates a postal code master. The business zip “JIGYOSYO.CSV” (20k lines) by Japan Post Co., Ltd. is converted to “Jigyosyo-Zip.xml”. If “Japan-Zip.xml” (120k lines) is specified, “Jigyosyo-Zip.xml” (140k lines) will be created.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- A: Select FILES DATA for JIGYOSYO.CSV (Multiple not supported) *<\/span><\/li>\n
- Ax: Select FILES DATA for Japan-Zip.xml (Multiple not supported)<\/li>\n
- B: Select FILES DATA for Jigyosyo-Zip.xml (update) *<\/span><\/li>\n
- <\/i><\/span> Bx: Set the file name if you want to save as a different name#{EL}<\/sup><\/span><\/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\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA = configs.get( "conf_DataIdA" ) + "";\nconst dataIdAx = configs.get( "conf_DataIdAx" ) + "";\nconst dataIdB = configs.get( "conf_DataIdB" ) + "";\nconst saveAs = configs.get( "conf_SaveAs" ) + "";\n\/\/ 'java.lang.String' (String Obj) to javascript primitive 'string'\n\nlet fileName = "";\nif( saveAs === "" ){\n fileName = "Jigyosyo-Zip.xml";\n}else{\n fileName = saveAs;\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst myFiles = engine.findDataByNumber( dataIdA ); \nlet upFiles = engine.findDataByNumber( dataIdB ); \n\/\/ java.util.ArrayList\nif (myFiles === null || myFiles.size() != 1) {\n throw new Error( '\\n One-file attachment is only valid. \\n' );\n}\nif (upFiles === null ) {\n upFiles = new java.util.ArrayList();\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Read Lines\nlet myLineCounter = 0;\nlet arrCodeAddr = [];\nfileRepository.readFile(myFiles.get(0), "Shift_JIS", function(line) {\n const lineVals = line.split(",");\n const zipCode = lineVals[7].replace(\/"\/g, '');\n const zipAddr = (lineVals[3] + lineVals[4] + lineVals[5] + lineVals[6]).replace(\/"\/g, '');\n const zipCorp = lineVals[2].replace(\/"\/g, '');\n const codeAddr = [zipCode, zipAddr, zipCorp];\n arrCodeAddr.push( codeAddr );\n myLineCounter++;\n});\nengine.log( "#Line of Text-File: " + myLineCounter );\n\n\/\/\/ Generate XML\n\/\/ '<item value="6068501" display="606-8501 \u4eac\u90fd\u5e9c\u4eac\u90fd\u5e02\u5de6\u4eac\u533a\u5409\u7530\u672c\u753a \u4eac\u90fd\u5927\u5b66" \/>'\n\/\/ https:\/\/www.post.japanpost.jp\/zipcode\/dl\/jigyosyo\/readme.html\n\nlet xmlFileText = '';\nfor( var i = 0; i < myLineCounter; i++ ){\n xmlFileText += '<item value="';\n xmlFileText += arrCodeAddr[i][0];\n xmlFileText += '" display="';\n xmlFileText += arrCodeAddr[i][0].substring(0,3) + '-' + arrCodeAddr[i][0].substring(3,7);\n xmlFileText += ' ';\n xmlFileText += arrCodeAddr[i][1];\n xmlFileText += ' ';\n xmlFileText += arrCodeAddr[i][2];\n xmlFileText += '" \/>\\n';\n}\n\n\/\/\/ Append Japan-Zip.xml\n\/\/\/ Read Lines\nif( dataIdAx !== "" ){\n const cfFiles = engine.findDataByNumber( dataIdAx ); \n if( cfFiles !== null && cfFiles.size() == 1 ){\n let cfLineCounter = 0;\n fileRepository.readFile(cfFiles.get(0), "UTF-8", function(line) {\n if( line.startsWith('<item') ){\n xmlFileText += line + '\\n';\n }\n cfLineCounter++;\n });\n engine.log( "#Line of Text-File: " + cfLineCounter );\n }\n}\n\n\/\/\/ Add XML Declaration etc\nxmlFileText = '<?xml version="1.0" encoding="UTF-8"?><items>\\n' + xmlFileText + '<\/items>';\n\n\/\/\/ Add to Files Array\nupFiles.add( new com.questetra.bpms.core.event.scripttask.NewQfile(\n fileName, "application\/xml", xmlFileText ));\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setDataByNumber( dataIdB, upFiles );\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
- Converter-JigyosyoZipCsv-to-JigyosyoZipXml-2021.xml<\/a><\/li><\/ul>\n\n\n\n
2021-07-08 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/converter-jigyosyozipcsv-to-jigyosyozipxml-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> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/converter-jigyosyo-2021-en.png?ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/Converter-JigyosyoZipCsv-to-JigyosyoZipXml-en.png.png?ssl=1\")
<\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n