{"id":74689,"date":"2019-01-30T16:18:06","date_gmt":"2019-01-30T07:18:06","guid":{"rendered":"https:\/\/support.questetra.com\/?p=74689"},"modified":"2022-06-01T15:26:24","modified_gmt":"2022-06-01T06:26:24","slug":"converter-japanzipcsv-to-japanzipxml","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml\/","title":{"rendered":"Converter (JapanZipCsv to JapanZipXml)"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml-2021\/_\">https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml-2021\/<\/a><\/div>\n<\/div><\/div>\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-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" 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\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\">Converter (JapanZipCsv to JapanZipXml)<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">Generates a postal code master. The zip data &#8220;KEN_ALL.CSV&#8221; (120k lines) of Japan Post is converted to &#8220;Japan-Zip.xml&#8221;. You can refer to postal code master in input form settings such as &#8220;Select (Search Select box)&#8221;.<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml\/\" target=\"_Blank\" rel=\"noopener noreferrer\">https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml\/<\/a><br><span style=\"float: right;\">2019-01-28 (C) Questetra, Inc. (MIT License)<\/span><\/div><\/div>\n\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\"><ul class=\"fa-ul\">\n<li> A: Select FILES DATA for KEN_ALL.CSV (Multiple not supported)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Select FILES DATA for Japan-Zip.xml (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> Bx: Set the file name if you want to save as a different name<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<\/ul><\/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<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/\/\/\/\/\/\/ 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 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 = \"Japan-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 ==\nvar myFiles = engine.findDataByNumber( dataIdA ); \nvar 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   = &#091;];\nfileRepository.readFile(myFiles.get(0), \"Shift_JIS\", function(line) {\n  const lineVals = line.split(\",\");\n  const zipCode  = lineVals&#091;2].replace(\/\"\/g, '');\n  const zipAddr  = (lineVals&#091;6] + lineVals&#091;7]).replace(\/\"\/g, '');\n  let   zipAddr2 = lineVals&#091;8].replace(\/\"\/g, '');\n  if( lineVals&#091;12] == \"1\" ){ zipAddr2 += \"\u3001\"; } \/\/ \u4e8c\u4ee5\u4e0a\u306e\u753a\u57df\n  const codeAddr = &#091;zipCode, zipAddr, zipAddr2];\n  arrCodeAddr.push( codeAddr );\n  myLineCounter++;\n});\nengine.log( \"#Line of Text-File: \" + myLineCounter );\n\n\/\/\/ Sort by ZipCode\n\/\/ \"\u4e8c\u4ee5\u4e0a\u306e\u753a\u57df\" \u3092\u7d50\u5408\u3057\u3084\u3059\u304f\u3059\u308b\u305f\u3081\n\/\/ \"0680546\",\"\u5317\u6d77\u9053\",\"\u5915\u5f35\u5e02\",\"\u5357\u90e8\u9752\u8449\u753a\",0,0,0,1,0,0\n\/\/ \"0680545\",\"\u5317\u6d77\u9053\",\"\u5915\u5f35\u5e02\",\"\u5357\u90e8\u6771\u753a\",0,0,0,0,0,0\n\/\/ \"0680541\",\"\u5317\u6d77\u9053\",\"\u5915\u5f35\u5e02\",\"\u5357\u90e8\u9060\u5e4c\u753a\",0,0,0,0,0,0\n\/\/ \"0680544\",\"\u5317\u6d77\u9053\",\"\u5915\u5f35\u5e02\",\"\u5357\u90e8\u5927\u5bae\u753a\",0,0,0,0,0,0\n\/\/ \"0680546\",\"\u5317\u6d77\u9053\",\"\u5915\u5f35\u5e02\",\"\u5357\u90e8\u83ca\u6c34\u753a\",0,0,0,1,0,0\n\/\/ ...\narrCodeAddr.sort(function(a, b){\n\tif (a&#091;0] &gt; b&#091;0]) return 1;\n\tif (a&#091;0] &lt; b&#091;0]) return -1;\n\treturn 0;\n});\n\n\/\/\/ Generate XML\n\/\/ '&lt;item value=\"1500041\" display=\"150-0041 \u6771\u4eac\u90fd\u6e0b\u8c37\u533a\u795e\u5357\" \/&gt;'\n\/\/ https:\/\/www.post.japanpost.jp\/zipcode\/dl\/readme.html\nlet xmlFileText = '';\nlet stackedAddr = '';\nfor( var i = 0; i &lt; myLineCounter - 1; i++ ){\n  if( arrCodeAddr&#091;i]&#091;0] !== arrCodeAddr&#091;i+1]&#091;0] ){\n    xmlFileText += '&lt;item value=\"';\n    xmlFileText += arrCodeAddr&#091;i]&#091;0];\n    xmlFileText += '\" display=\"';\n    xmlFileText += arrCodeAddr&#091;i]&#091;0].substring(0,3) + '-' + arrCodeAddr&#091;i]&#091;0].substring(3,7);\n    xmlFileText += ' ';\n    if( stackedAddr !== '' ){\n      var joinedAddr = stackedAddr + arrCodeAddr&#091;i]&#091;2];\n      joinedAddr = joinedAddr.replace(\/\u3001$\/, '');\n      xmlFileText += joinedAddr;\n    }else{\n      xmlFileText += arrCodeAddr&#091;i]&#091;1] + arrCodeAddr&#091;i]&#091;2];\n    }\n    xmlFileText += '\" \/&gt;\\n';\n    stackedAddr = '';\n  }else{\n    if( stackedAddr !== '' ){\n      stackedAddr += arrCodeAddr&#091;i]&#091;2];\n    }else{\n      stackedAddr += arrCodeAddr&#091;i]&#091;1] + arrCodeAddr&#091;i]&#091;2];\n    }\n  }\n}\n\/\/\/ Generate XML (last line)\nxmlFileText += '&lt;item value=\"';\nxmlFileText += arrCodeAddr&#091;myLineCounter - 1]&#091;0];\nxmlFileText += '\" display=\"';\nxmlFileText += arrCodeAddr&#091;myLineCounter - 1]&#091;0].substring(0,3) + '-' + arrCodeAddr&#091;myLineCounter - 1]&#091;0].substring(3,7);\nxmlFileText += ' ';\nif( stackedAddr !== '' ){\n  let joinedAddr = stackedAddr + arrCodeAddr&#091;myLineCounter - 1]&#091;2];\n  joinedAddr = joinedAddr.replace(\/\u3001$\/, '');\n  xmlFileText += joinedAddr;\n}else{\n  xmlFileText += arrCodeAddr&#091;myLineCounter - 1]&#091;1] + arrCodeAddr&#091;myLineCounter - 1]&#091;2];\n}\nxmlFileText += '\" \/&gt;\\n';\n\n\/\/\/ Replace Noise Words\nxmlFileText = xmlFileText.replace(\/\uff08\u305d\u306e\u4ed6\uff09\/g,'')\n  .replace(\/\u4ee5\u4e0b\u306b\u63b2\u8f09\u304c\u306a\u3044\u5834\u5408\/g,'')\n  .replace(\/\u306e\u6b21\u306b\u756a\u5730\u304c\u304f\u308b\u5834\u5408\/g,'');\n\n\/\/\/ Add XML Declaration etc\nxmlFileText = '&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;&lt;items&gt;\\n'\n  + xmlFileText + '&lt;\/items&gt;';\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()\" \/\/\/\/\/\/\/\/<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACx0lEQVRYR8WXz0sUYRjHP5O0CLX+\nuHTIQ7sHIby0BdIh0EU6hwmd20Vx9mb9AUvlQQSRVhBq0WW3gxcFKzx4000kBKO2QNgSssgS6uDu\noQQJJt4ZZ3ecH+s4O+kLyy7s+z7fz\/PM87zPMxKnvKRj6afpBbpRiCDRAkQOzhdQKCEhvvMkeOnW\n7tEAWVrYZwi4B6qom1UCUgSYII747bhqAzwhxhkeH0PYLCTE48i8cCJwBnhKCkn13I+VQua+nSF7\ngDQ54K4fyhUbCjkSxM02rQD+en5YT2GChJpLlXUYQHvmWV89txq7bcyJKoCW7Vt1JJxb7hIBwnp1\nVAHSPAQeuLVSa99U1xTzW\/Msflt02vYIWdXDCCBKptkPgI07GzQFmhhcGXSCKCHTWgXQbrjnRvGe\niz20nWvzxJO8lqS9uZ3t39u1INRc0CJgk\/nCi47WDk8AxkOOEAcVoQGkyat3vGH5BbD3d4\/RwijD\nb4fNzrxCJqoDfAEuGXdMd03TeaHTUwRC50NqDgjx8Q\/jJN8k7ewUkLmqAyielBwOieiFg+Fa4tpJ\nGelIgODZIJnuDDt\/dhh67a41rN5aZfnHspPnVWwDgOURiF1CPBvN0hvqJfcxx8DKgH+BUnhPgohj\nEhrFG6QG1n6usVne9ASw9H2J3CfR3w4tQxLalOHszVn6wn0I8XpXppixRs9UhpaLaPLGJP2X+2ls\naKxXH1sAMFxE2l1guYqNEHOf51j4uuAJplgqsv5r3Xi2jKyNd0c2Ix1iZnPGzyS0aUZaOxbVYGlI\nY9fH2N3fZeTdiKcImA6VCRCytmOx61QHEh3zf45kUAm9LndyQyk8QyZmfoYnNZZbPK8dAf1fbVAR\nV5jXSakMxLy9mOgQWnWIUVp83IIIYfFqlqrv1cz8wEREFKJIRFBoQeKKukU0FokSCgUk8rU8dp8D\nflS8Cxv\/AFp57iGwqv7bAAAAAElFTkSuQmCC\" alt=\"\"\/><\/figure><\/div>\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\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/1DCPyzGqQNLzcX4koXlIru43DiXwsr4Wd\/view?usp=sharing\">Converter-JapanZipCsv-to-JapanZipXml.xml<\/a><\/li><\/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\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"540\" data-attachment-id=\"90846\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml\/attachment\/converter-japan-zip-flow\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?fit=960%2C540&amp;ssl=1\" data-orig-size=\"960,540\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"converter-japan-zip-flow\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?fit=960%2C540&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?resize=960%2C540&#038;ssl=1\" alt=\"\" class=\"wp-image-90846\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?w=960&amp;ssl=1 960w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-japan-zip-flow.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure><\/div>\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-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ywD6Is3HEc\"><a href=\"https:\/\/support.questetra.com\/en\/options\/japan-zip\/\">Zip Code Japan<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cZip Code Japan\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/options\/japan-zip\/embed\/#?secret=qKhZHUQvYS#?secret=ywD6Is3HEc\" data-secret=\"ywD6Is3HEc\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Generates a postal code master. The zip data &#8220;KEN_ALL.CSV&#8221; (120k lines) of Japan Post is converted to &#8220;Japan-Zip.xml&#8221;. You can refer to postal code master in input form settings such as &#8220;Select (Search Select box)&#8221;.<\/p>\n","protected":false},"author":2,"featured_media":90844,"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":"","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_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":[],"faq_section":[],"class_list":["post-74689","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.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":0,"uagb_excerpt":"Generates a postal code master. The zip data \"KEN_ALL.CSV\" (120k lines) of Japan Post is converted to \"Japan-Zip.xml\". You can refer to postal code master in input form settings such as \"Select (Search Select box)\".","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-jqF","jetpack-related-posts":[{"id":74671,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-jigyosyozipcsv-to-jigyosyozipxml\/","url_meta":{"origin":74689,"position":0},"title":"Converter (JigyosyoZipCsv to JigyosyoZipXml)","author":"IMAMURA, Genichi","date":"2019-01-30","format":false,"excerpt":"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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.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\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109449,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-japanzipcsv-to-japanzipxml-2021\/","url_meta":{"origin":74689,"position":1},"title":"Converter (JapanZipCsv to JapanZipXml)","author":"Hirotaka NISHI","date":"2021-07-14","format":false,"excerpt":"Generates a postal code master. The zip data \"KEN_ALL.CSV\" (120k lines) of Japan Post is converted to \"Japan-Zip.xml\". You can refer to postal code master in input form settings such as \"Select (Search Select box)\"","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.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\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109446,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-jigyosyozipcsv-to-jigyosyozipxml-2021\/","url_meta":{"origin":74689,"position":2},"title":"Converter (JigyosyoZipCsv to JigyosyoZipXml)","author":"Hirotaka NISHI","date":"2021-07-13","format":false,"excerpt":"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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.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\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/converter-jigyosyo-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76721,"url":"https:\/\/support.questetra.com\/en\/templates\/postal-matter-sending-process-20141215\/","url_meta":{"origin":74689,"position":3},"title":"Postal Mailing Process","author":"Hirotaka NISHI","date":"2022-07-20","format":false,"excerpt":"Accepts internal postal matter requests and assists for sending. Generates \"Cover sheet PDF\" automatically based on the information entered in the Step of [1. Addressee Info + Sending Materials]. General Affair staff prints out the cover sheet and encloses it and sends. After completing sending, a notification email will be\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\/05\/eye-catch-postal-matter-sending-process-20141215-220-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\/05\/eye-catch-postal-matter-sending-process-20141215-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-postal-matter-sending-process-20141215-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-postal-matter-sending-process-20141215-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/eye-catch-postal-matter-sending-process-20141215-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69778,"url":"https:\/\/support.questetra.com\/en\/pdf\/pdf-coversheet\/","url_meta":{"origin":74689,"position":4},"title":"Base PDF: Letter of transmittal","author":"Hirotaka NISHI","date":"2022-07-21","format":false,"excerpt":"A base PDF file for automatically generating a Letter of transmittal based on the entered business data. Values such as recipient and issuer information entered in the workflow are inserted into each field.","rel":"","context":"In &quot;Base PDF&quot;","block_context":{"text":"Base PDF","link":"https:\/\/support.questetra.com\/en\/category\/pdf\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/12\/pdf-coversheet-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/12\/pdf-coversheet-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/12\/pdf-coversheet-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/12\/pdf-coversheet-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2014\/12\/pdf-coversheet-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":71382,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-table-options\/","url_meta":{"origin":74689,"position":5},"title":"Converter (Table to Options)","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Convert IDs-Labels defined in Table data to two String type data items. (In order to base registration as Options XML, refer to two String type data from Select type data. Then, refer to the Select type data from [Service Task (Choices Update)].) *Note Columns in the table information A' must\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-table-options-header.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\/2019\/01\/japan-zipcsv-to-xml-header.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/74689","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=74689"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/74689\/revisions"}],"predecessor-version":[{"id":109600,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/74689\/revisions\/109600"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/90844"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=74689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=74689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=74689"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=74689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}