{"id":58,"date":"2023-08-30T08:53:47","date_gmt":"2023-08-30T01:53:47","guid":{"rendered":"https:\/\/hrdpintar.com\/blog\/?p=58"},"modified":"2023-08-30T08:53:49","modified_gmt":"2023-08-30T01:53:49","slug":"tips-export-csv-untuk-upload-data-hrdpintar","status":"publish","type":"post","link":"https:\/\/hrdpintar.com\/blog\/tips-export-csv-untuk-upload-data-hrdpintar\/","title":{"rendered":"Tips Export CSV untuk Upload Data Hrdpintar"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hrdpintar memiliki fitur untuk upload data dari file CSV, template sudah disediakan sehingga hanya perlu isi data dan lakukan &#8220;Save As&#8221; dengan format CSV, namun terkadang file CSV gagal terupload sempurna, contohnya seperti ini :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/lh3.googleusercontent.com\/-DOO3JR3CFok\/X_VlTXvIv0I\/AAAAAAAAAJ4\/zb9ON1QPhCA6T1MY-TDbmP0zQSdx9ueaQCLcBGAsYHQ\/image.png\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/-DOO3JR3CFok\/X_VlTXvIv0I\/AAAAAAAAAJ4\/zb9ON1QPhCA6T1MY-TDbmP0zQSdx9ueaQCLcBGAsYHQ\/w590-h212\/image.png\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Berikut adalah cara untuk memperbaikinya :<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Pastikan data valid, Hrdpintar melakukan pengecekan data valid atau tidak, jika data tidak valid maka tidak dimunculkan \/ blank, jadi pastikan data valid seperti ID karyawan sudah terdaftar, tanggal masih dalam periode berjalan dan seterusnya.<\/li><li>Pastikan data sesuai format yang telah ditentukan, misalnya data tanggal menggunakan format YYYY-MM-DD jika tidak sesuai format maka data tidak muncul.<\/li><li>Pastikan data telah di &#8220;Save As&#8221; sebagai &#8220;CSV (Comma Delimited)&#8221;, tidak jarang pengguna masih melakukan &#8220;Save As&#8221; sebagai XLS atau XLSX atau format lainnya.<\/li><li>Hrdpintar menggunakan pemisah (separator) pada file CSV menggunakan koma (,) dan terkadang aplikasi Excel menggunakan titik-koma (;) seperti ini :<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/lh3.googleusercontent.com\/-uP2QIl2yV0Q\/X_VrRzFjNNI\/AAAAAAAAAKE\/BU0YNFkyI9gfCZsJb6DuDaxeD_Tp1D-KACLcBGAsYHQ\/image.png\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/-uP2QIl2yV0Q\/X_VrRzFjNNI\/AAAAAAAAAKE\/BU0YNFkyI9gfCZsJb6DuDaxeD_Tp1D-KACLcBGAsYHQ\/w543-h186\/image.png\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Rubah titik-koma (;) menjadi (,) dengan melakukan find &amp; replace pada Excel atau Notepad<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">atau<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Rubah pengaturan di Control Panel agar tidak menggunakan titik-koma (;) dengan cara :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Buka Control Panel -&gt; Region &amp; Language (atau bisa diketik melalui pencarian di Control Panel)<\/li><li>Klik &#8220;Additional Setting&#8221; seperti ini :<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/lh3.googleusercontent.com\/-XA02DFuL2XM\/X_VvbmkDc3I\/AAAAAAAAAKQ\/ULJ_T7JuWXMUGTQ_rn8cpxWJ3AjfDqHWgCLcBGAsYHQ\/image.png\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/-XA02DFuL2XM\/X_VvbmkDc3I\/AAAAAAAAAKQ\/ULJ_T7JuWXMUGTQ_rn8cpxWJ3AjfDqHWgCLcBGAsYHQ\/w348-h390\/image.png\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Kemudian rubah &#8220;List Separator&#8221; menjadi koma (,) sepeti ini :<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/lh3.googleusercontent.com\/-VaqsO6x0c34\/X_Vv9NN81aI\/AAAAAAAAAKY\/EOOKW28vFzs96OM9bkgfWgzyUmAPbwMWgCLcBGAsYHQ\/image.png\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/-VaqsO6x0c34\/X_Vv9NN81aI\/AAAAAAAAAKY\/EOOKW28vFzs96OM9bkgfWgzyUmAPbwMWgCLcBGAsYHQ\/w347-h425\/image.png\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Kemudian restart komputer dan lakukan &#8220;Save As&#8221; sebagai &#8220;CSV (Comma Delimited)&#8221; kembali.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hrdpintar memiliki fitur untuk upload data dari file CSV, template sudah disediakan sehingga hanya perlu isi data dan lakukan &#8220;Save As&#8221; dengan format CSV, namun terkadang file CSV gagal terupload sempurna, contohnya seperti ini : &nbsp; Berikut adalah cara untuk memperbaikinya : Pastikan data valid, Hrdpintar melakukan pengecekan data valid atau tidak, jika data tidak [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-58","post","type-post","status-publish","format-standard","hentry","category-faq"],"_links":{"self":[{"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":1,"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":59,"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions\/59"}],"wp:attachment":[{"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hrdpintar.com\/blog\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}