{"id":879,"date":"2017-05-29T16:43:01","date_gmt":"2017-05-29T07:43:01","guid":{"rendered":"http:\/\/help.glu.jp\/en\/?p=879"},"modified":"2017-11-06T17:31:58","modified_gmt":"2017-11-06T08:31:58","slug":"manually-compiling-reports","status":"publish","type":"post","link":"https:\/\/help.glu.jp\/en\/faq\/make_report\/manually-compiling-reports\/","title":{"rendered":"Manually Compiling Reports"},"content":{"rendered":"<h2 id=\"content_1_1\">Q<\/h2>\n<p>How do I manually compile reports with my Excel template?<\/p>\n<h2 id=\"content_1_2\">A<\/h2>\n<p>Please refer to the following when downloading report templates and compiling reports.<\/p>\n<p><strong>Downloading Report Templates<\/strong><\/p>\n<ol class=\"list1\">\n<li style=\"list-style-type: none\">\n<ol class=\"list1\">\n<li>Login to glu.<\/li>\n<li>Select the corresponding dice.\u3002<\/li>\n<li>From the \u201cReport\u201d tab, select \u201cPeriod\u201d and then start date box.<br \/>\n(The start date your choose here will be set as the reference date for manual compilation).<a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/download_temp-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-861\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/download_temp-1.png\" alt=\"Reference Date\" width=\"626\" height=\"281\" \/><\/a><\/li>\n<li>Click \u201cRefresh\u201d.<\/li>\n<li>Click \u201cDownload\u201d and select template to be used.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><strong>Compiling Reports<\/strong><\/p>\n<ol class=\"list1\">\n<li>Verify that the downloaded file name includes symbols and numbers, such as below.<br \/>\n${0~000.000.00.000~00~0_0000000000~00~yyyymmdd}<\/li>\n<li>The field with \u201c0\u201ds represents the dice key, while \u201cyyyy\u201d represents the current year, \u201cmm\u201d current month, and \u201cdd\u201d current day.<br \/>\n(The report will not compile properly if the file name lacks these symbols and numbers)<br \/>\n(You can verify the dice key under the \u201cProperty\u201d tab of that dice on glu)<\/li>\n<li>Open the file.<\/li>\n<li>From the excel Add-Ins tab, select \u201cReport\u201d and then \u201cCompile\u201d<br \/>\n(If you do not see an Add-Ins tab, please install the compiler).<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/compile_button-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-166\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/compile_button-1.png\" alt=\"Compile Add-In\" width=\"601\" height=\"116\" \/><\/a><\/div>\n<\/li>\n<li>The report will begin compiling.<br \/>\n(If you see the following message, the file name did not contain the correct symbols and numbers. In this case, close the message or click \u201cStart Compile\u201d and double check the above steps after it finishes processing.<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2015\/03\/FAQ_4-6_reportcompile10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-167 size-full\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2015\/03\/FAQ_4-6_reportcompile10.jpg\" alt=\"Profile Key Prompt\" width=\"438\" height=\"108\" srcset=\"https:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2015\/03\/FAQ_4-6_reportcompile10.jpg 438w, https:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2015\/03\/FAQ_4-6_reportcompile10-300x74.jpg 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/a><\/div>\n<\/li>\n<li>The compile progress will appear on the screen.\u3002\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/compile_progress.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-168\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/compile_progress.png\" alt=\"Compile Progress\" width=\"452\" height=\"145\" \/><\/a><\/div>\n<\/li>\n<li>In the case of an error, the following message will appear.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/error_msg.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-169\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/error_msg.png\" alt=\"Report Done\" width=\"300\" height=\"165\" \/><\/a><\/div>\n<\/li>\n<li>If the report compiles successfully, the following message will appear.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/reports_done.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-170\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/reports_done.png\" alt=\"Report Done\" width=\"252\" height=\"166\" \/><\/a><\/div>\n<\/li>\n<li>Confirm that the report content is correct.<\/li>\n<\/ol>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Q How do I manually compile reports with my Excel template? A Please refer to the following when downloading report templates and compiling reports. Downloading Report Templates Login to glu. Select the corresponding dice.\u3002 From the \u201cReport\u201d tab, select \u201cPeriod\u201d and then start date box. (The start date your choose here will be set as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-879","post","type-post","status-publish","format-standard","hentry","category-make_report"],"_links":{"self":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts\/879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/comments?post=879"}],"version-history":[{"count":11,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts\/879\/revisions"}],"predecessor-version":[{"id":1123,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts\/879\/revisions\/1123"}],"wp:attachment":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/media?parent=879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/categories?post=879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/tags?post=879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}