{"id":33127,"date":"2025-04-07T12:45:27","date_gmt":"2025-04-07T12:45:27","guid":{"rendered":"https:\/\/docs.daftra.com\/?post_type=user_manual&#038;p=33127"},"modified":"2025-04-15T11:52:41","modified_gmt":"2025-04-15T11:52:41","slug":"importing-an-attendance-days-file","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/","title":{"rendered":"Importing an Attendance Days File"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text]You can now import employee attendance days by uploading the file to the system. This feature allows you to efficiently update attendance records in bulk, saving time and reducing manual entry errors. Follow the steps below to ensure a smooth import process.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]From the main menu, click on &#8220;<strong>Attendance Days<\/strong>&#8221; in the dropdown of &#8220;<strong>Attendance<\/strong>&#8220;. Then click the button &#8220;<strong>Import<\/strong>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33130\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png\" alt=\"\" width=\"1366\" height=\"599\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png 1366w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers-300x132.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers-1024x449.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers-768x337.png 768w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span data-sider-select-id=\"55efa1cb-cbc5-4c16-ae24-780b7245e56c\">Ensure that the Excel file is prepared, including all the attendance days data to be uploaded to the system, such as the Employee&#8217;s Name, Date, Status, Leave Type, Leave Count, Sign-In, Sign-Out.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33134\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/hfujoiws.png\" alt=\"\" width=\"1366\" height=\"720\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/hfujoiws.png 1366w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/hfujoiws-300x158.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/hfujoiws-1024x540.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/hfujoiws-768x405.png 768w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/p>\n<p>Choose the\u00a0<b>\u201cComma Separated ( , )\u201d<\/b>\u00a0option and click on\u00a0<b>\u201cChoose File\u201d<\/b>\u00a0to upload the desired Excel file from your device.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33132\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/ybij.png\" alt=\"\" width=\"1198\" height=\"599\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/ybij.png 1198w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/ybij-300x150.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/ybij-1024x512.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/ybij-768x384.png 768w\" sizes=\"auto, (max-width: 1198px) 100vw, 1198px\" \/>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_message message_box_style=&#8221;3d&#8221; message_box_color=&#8221;alert-warning&#8221;]If each column has a title like \u201cLeave Type\u201d, \u201cLeave Count\u201d, do not activate \u201cImport First Row\u201d, but if there is no title for each column, activate this feature to avoid losing any items during the upload[\/vc_message][\/vc_column][\/vc_row][vc_row][vc_column][vc_message message_box_style=&#8221;3d&#8221; message_box_color=&#8221;vista_blue&#8221; icon_fontawesome=&#8221;fas fa-bell&#8221;]You can get an example for the proper structure of the excel sheet required by the system to complete the importing process successfully by clicking the button &#8220;<strong>Download Sample<\/strong>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33136 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/predf-1024x510.png\" alt=\"\" width=\"640\" height=\"319\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/predf-1024x510.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/predf-300x149.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/predf-768x382.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/predf.png 1366w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>[\/vc_message][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]You will receive a message indicating the number of days successfully imported and those that failed to import so you can correct any errors that led to their loss.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33139\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/lughkjl.png\" alt=\"\" width=\"1198\" height=\"599\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/lughkjl.png 1198w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/lughkjl-300x150.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/lughkjl-1024x512.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/lughkjl-768x384.png 768w\" sizes=\"auto, (max-width: 1198px) 100vw, 1198px\" \/>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":23,"template":"","categories":[8009],"tags":[],"class_list":["post-33127","user_manual","type-user_manual","status-publish","hentry","category-attendance-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importing an Attendance Days File - Daftra Knowledge Base<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing an Attendance Days File - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text]You can now import employee attendance days by uploading the file to the system. This feature allows you to efficiently update attendance records in bulk, saving time and reducing manual entry errors. Follow the steps below to ensure a smooth import process.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]From the main menu, click on &#8220;Attendance Days&#8221; in the dropdown of &#8220;Attendance&#8220;. Then [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T11:52:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png\",\"width\":1366,\"height\":599},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/\",\"name\":\"Importing an Attendance Days File - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#primaryimage\"},\"datePublished\":\"2025-04-07T12:45:27+00:00\",\"dateModified\":\"2025-04-15T11:52:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing an Attendance Days File\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing an Attendance Days File - Daftra Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/","og_locale":"en_US","og_type":"article","og_title":"Importing an Attendance Days File - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text]You can now import employee attendance days by uploading the file to the system. This feature allows you to efficiently update attendance records in bulk, saving time and reducing manual entry errors. Follow the steps below to ensure a smooth import process.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]From the main menu, click on &#8220;Attendance Days&#8221; in the dropdown of &#8220;Attendance&#8220;. Then [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2025-04-15T11:52:41+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2025\/04\/vwers.png","width":1366,"height":599},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/","name":"Importing an Attendance Days File - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#primaryimage"},"datePublished":"2025-04-07T12:45:27+00:00","dateModified":"2025-04-15T11:52:41+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-an-attendance-days-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Importing an Attendance Days File"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/33127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/user_manual"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/23"}],"version-history":[{"count":7,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/33127\/revisions"}],"predecessor-version":[{"id":33144,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/33127\/revisions\/33144"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=33127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=33127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=33127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}