{"id":52887,"date":"2021-05-24T09:46:21","date_gmt":"2021-05-24T00:46:21","guid":{"rendered":"https:\/\/learningbox.online\/?p=52887"},"modified":"2021-05-24T10:01:22","modified_gmt":"2021-05-24T01:01:22","slug":"blog_csv-learningbox","status":"publish","type":"post","link":"https:\/\/learningbox.online\/en\/column\/blog_csv-learningbox\/","title":{"rendered":"Important\u3011Information about the change of CSV format"},"content":{"rendered":"<p>The version of learningBOX was upgraded from Ver 2.13 to 2.14 on May 12, 2021.<br \/>\nA major update has changed some of the formatting of the member management CSV.<br \/>\nDue to the format change, if you upload using the format you used in 2.13, an error message will be displayed and you will not be able to register.<br \/>\nIn this article, we will introduce the CSV format that was changed from 2.13 series to 2.14 series and the improvement measures.<\/p>\n<p class=\"mokujimidasi\">Content<\/p>\n<ul class=\"mokuji\">\n<li>1. CSV format (2.13 series)<\/li>\n<li>2. CSV format (2.14 series)<\/li>\n<li>3. Points to note when uploading members in bulk<\/li>\n<li>4. apology for the change in format<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>Format of CSV for Series 2.13<\/h2>\n<p>The format before 2.13 series had 10 items in total, from left to right: Login ID, Name, Display Name, Department, Position, E-mail Address, Password, Status, Effective Date, Group Affiliation.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv.png\" alt=\"2.13-csv\" width=\"1392\" height=\"433\" class=\"aligncenter size-full wp-image-53033\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv.png 1392w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-300x93.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-1024x319.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-768x239.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-16x5.png 16w\" sizes=\"auto, (max-width: 1392px) 100vw, 1392px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<h2>Format of CSV for 2.14 series<\/h2>\n<p>In 2.14 and later, there are 11 format items from left to right: Login ID, Name, E-mail address, Password, Country, Language, Time zone, Status, Due date type, Effective date\/time, Group affiliation.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv.png\" alt=\"\" width=\"1203\" height=\"433\" class=\"aligncenter size-full wp-image-53038\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv.png 1203w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-300x108.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-1024x369.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-768x276.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-16x6.png 16w\" sizes=\"auto, (max-width: 1203px) 100vw, 1203px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<h2>Points to note when uploading members in bulk<\/h2>\n<p>If you try to register a member using the format of 2.13 or earlier, the following error message will be displayed and you will not be able to register.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/learningBOX-csc-error.png\" alt=\"learningBOX-csc-error\" width=\"1366\" height=\"625\" class=\"aligncenter size-full wp-image-53041\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/learningBOX-csc-error.png 1366w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/learningBOX-csc-error-300x137.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/learningBOX-csc-error-1024x469.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/learningBOX-csc-error-768x351.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/learningBOX-csc-error-16x7.png 16w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>When you perform the upload and click Proceed to Confirmation Screen, an error message is displayed.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-43-07.png\" alt=\"learningBOX-csv\" width=\"1366\" height=\"625\" class=\"aligncenter size-full wp-image-53043\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-43-07.png 1366w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-43-07-300x137.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-43-07-1024x469.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-43-07-768x351.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-43-07-16x7.png 16w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>We apologize for any inconvenience this may cause you, but please click the plus button on the member management screen, go to [Bulk operation (CSV)] &gt; [Member registration\/update], download the [CSV format sample], enter the member information again, and upload the file. After downloading the CSV format sample, please enter the member information again and upload the file.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-53-48.png\" alt=\"\" width=\"1366\" height=\"625\" class=\"aligncenter size-full wp-image-53045\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-53-48.png 1366w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-53-48-300x137.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-53-48-1024x469.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-53-48-768x351.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_15-53-48-16x7.png 16w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Open the downloaded file and enter the member information.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv.png\" alt=\"\" width=\"1203\" height=\"433\" class=\"aligncenter size-full wp-image-53038\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv.png 1203w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-300x108.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-1024x369.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-768x276.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.14csv-16x6.png 16w\" sizes=\"auto, (max-width: 1203px) 100vw, 1203px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Finally, upload your files and you're done.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_16-08-02.png\" alt=\"\" width=\"1366\" height=\"625\" class=\"aligncenter size-full wp-image-53047\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_16-08-02.png 1366w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_16-08-02-300x137.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_16-08-02-1024x469.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_16-08-02-768x351.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-19_16-08-02-16x7.png 16w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<h3>How to upload using an existing CSV file<\/h3>\n<p>Open the CSV file you are using.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv.png\" alt=\"2.13-csv\" width=\"1392\" height=\"433\" class=\"aligncenter size-full wp-image-53033\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv.png 1392w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-300x93.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-1024x319.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-768x239.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2.13-csv-16x5.png 16w\" sizes=\"auto, (max-width: 1392px) 100vw, 1392px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Edit the CSV file, edit the order according to the format of 2.14 series, and add items.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/fb12e184416175a782b89e0f1a88fcb1.png\" alt=\"Series 2.14-learningBOX-csv\" width=\"1182\" height=\"433\" class=\"aligncenter size-full wp-image-53063\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/fb12e184416175a782b89e0f1a88fcb1.png 1182w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/fb12e184416175a782b89e0f1a88fcb1-300x110.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/fb12e184416175a782b89e0f1a88fcb1-1024x375.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/fb12e184416175a782b89e0f1a88fcb1-768x281.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/fb12e184416175a782b89e0f1a88fcb1-16x6.png 16w\" sizes=\"auto, (max-width: 1182px) 100vw, 1182px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Enter the member information that was used in the existing CSV.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_9-58-32.png\" alt=\"learningBOX-csv-batch registration\" width=\"1182\" height=\"433\" class=\"aligncenter size-full wp-image-53067\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_9-58-32.png 1182w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_9-58-32-300x110.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_9-58-32-1024x375.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_9-58-32-768x281.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_9-58-32-16x6.png 16w\" sizes=\"auto, (max-width: 1182px) 100vw, 1182px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<p>Overwrite the edited CSV file and save it, then upload the file.<\/p>\n<p class=\"well\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_10-02-51.png\" alt=\"\" width=\"1366\" height=\"625\" class=\"aligncenter size-full wp-image-53069\" srcset=\"https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_10-02-51.png 1366w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_10-02-51-300x137.png 300w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_10-02-51-1024x469.png 1024w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_10-02-51-768x351.png 768w, https:\/\/learningbox.online\/wp-content\/uploads\/2021\/05\/2021-05-20_10-02-51-16x7.png 16w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/>\n<\/p>\n<p>&nbsp;<\/p>\n<h2>Apology for the change in format<\/h2>\n<p>The version of learningBOX was upgraded from Ver 2.13 to 2.14 on May 12, 2021.<br \/>\nWith this major update, the format of CSV in Member Management has been partially changed.<\/p>\n<p>We sincerely apologize for the fact that we did not share information thoroughly within our company due to the change in functionality, and that we released the product without notifying our customers.<br \/>\nFrom now on, we will keep close communication and coordination within our team so that we do not repeat the same mistake.<\/p>\n<p>We would like to express our sincere apologies to our customers, business partners, and all related parties for any inconvenience or trouble caused.<br \/>\nWe look forward to working with you in the future.<\/p>","protected":false},"excerpt":{"rendered":"LearningBOX was upgraded from version 2.13 to 2.14 on May 12, 2021. The major update allows member management CS...","protected":false},"author":16,"featured_media":31603,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_lmt_disableupdate":"yes","_lmt_disable":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_vk_print_noindex":"","_veu_custom_css":"","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[41,4],"tags":[261,111,133,50],"class_list":["post-52887","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learningbox","category-4","tag-csv","tag-e","tag-learningbox"],"acf":[],"modified_by":"i.hirota","jetpack_featured_media_url":"https:\/\/learningbox.online\/wp-content\/uploads\/2020\/02\/thumail.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pgWaOl-dL1","publishpress_future_action":{"enabled":false,"date":"2026-06-17 08:27:44","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/posts\/52887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/comments?post=52887"}],"version-history":[{"count":32,"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/posts\/52887\/revisions"}],"predecessor-version":[{"id":53174,"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/posts\/52887\/revisions\/53174"}],"wp:attachment":[{"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/media?parent=52887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/categories?post=52887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learningbox.online\/en\/wp-json\/wp\/v2\/tags?post=52887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}