{"id":155171,"date":"2026-11-01T15:05:09","date_gmt":"2026-11-01T15:05:09","guid":{"rendered":"https:\/\/docs.daftra.com\/?post_type=faq&p=155171"},"modified":"2026-11-01T15:12:26","modified_gmt":"2026-11-01T15:12:26","slug":"why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason","status":"publish","type":"faq","link":"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/","title":{"rendered":"Why did a row in the import file fail, and how do I find out the reason?"},"content":{"rendered":"
\n

After you click Import<\/strong>, the Result<\/strong> page appears. It shows the number of rows in each state, and a message for each row that failed to import, explaining the error reason and the line number:<\/p>\n\n\n\n\n\n\n
Counter<\/th>\nMeaning<\/th>\n<\/tr>\n
Imported successfully<\/strong><\/td>\nNew employees created from the file.<\/td>\n<\/tr>\n
Updated successfully<\/strong><\/td>\nExisting employees whose details were updated.<\/td>\n<\/tr>\n
Failed<\/strong><\/td>\nRows that were not imported because of an error in their data.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Error messages appear above the counters, and each message states the error reason and the line number in the file, for example: an invalid value for the Type<\/strong> field in line #2<\/strong>. The header row in the file counts as line 1, so line #2<\/strong> is the first employee row in the file.<\/p>\n

Common reasons a row fails:<\/strong><\/p>\n

    \n
  • A required field is left empty. Required fields are marked with *<\/strong> in the Fields Mapping<\/strong> step.<\/li>\n
  • A value isn’t accepted, such as a value in the Type<\/strong> column other than user<\/strong> or employee<\/strong>, or an invalid email address.<\/li>\n
  • A branch, direct manager, or role that doesn’t exist in the system.<\/li>\n
  • A date in a format different from the system’s date format.<\/li>\n
  • A code, Official ID, or email address repeated in the file, or an Official ID or email address that belongs to another employee.<\/li>\n<\/ul>\n
    \n

    \ud83d\udec8<\/span><\/p>\n

    \n

    Notes:<\/strong><\/p>\n

      \n
    • If you turn on Ignore errors while importing<\/strong> in the Fields Mapping<\/strong> step, the system imports the valid rows and skips the rows with errors, and a message appears for each skipped row.<\/li>\n
    • If you don’t turn on this option, the import stops at the first row with an error, and only that row’s message appears.<\/li>\n
    • The message shows only the first error in the row. If the row has more than one error, a new message may appear for the same row after you fix the first error and import again.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
      \n

      \u26a0<\/span><\/p>\n

      Warning:<\/strong> After you fix the failed rows, import only these rows again. If you import the whole file again, the rows that succeeded before with an empty code column will create new employees again.<\/p>\n<\/div>\n<\/div>\n","protected":false},"author":39,"template":"","categories":[2201,2197],"tags":[26680,26843,4970,14028,23128,27203,27202,27204,27205],"class_list":["post-155171","faq","type-faq","status-publish","hentry","category-employees","category-hr","tag-employee-import-errors","tag-employee-import-file","tag-human-resources","tag-ignore-errors-while-importing","tag-import-employees","tag-import-result-page","tag-line-number-in-the-error-message","tag-row-failed-to-import","tag-why-did-the-employee-import-fail"],"yoast_head":"\nWhy did a row in the import file fail, and how do I find out the reason? - Daftra Knowledge Base<\/title>\n<meta name=\"description\" content=\"Learn why a row in the employee import file fails, how to find the error reason and line number on the Result page, and what the Ignore errors while importing option does.\" \/>\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\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why did a row in the import file fail, and how do I find out the reason? - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Learn why a row in the employee import file fails, how to find the error reason and line number on the Result page, and what the Ignore errors while importing option does.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-01T15:12:26+00:00\" \/>\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\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/en\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/en\/#website\",\"url\":\"https:\/\/docs.daftra.com\/en\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/\",\"name\":\"Why did a row in the import file fail, and how do I find out the reason? - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/#website\"},\"datePublished\":\"2026-11-01T15:05:09+00:00\",\"dateModified\":\"2026-11-01T15:12:26+00:00\",\"description\":\"Learn why a row in the employee import file fails, how to find the error reason and line number on the Result page, and what the Ignore errors while importing option does.\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why did a row in the import file fail, and how do I find out the reason?\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why did a row in the import file fail, and how do I find out the reason? - Daftra Knowledge Base","description":"Learn why a row in the employee import file fails, how to find the error reason and line number on the Result page, and what the Ignore errors while importing option does.","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\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/","og_locale":"en_US","og_type":"article","og_title":"Why did a row in the import file fail, and how do I find out the reason? - Daftra Knowledge Base","og_description":"Learn why a row in the employee import file fails, how to find the error reason and line number on the Result page, and what the Ignore errors while importing option does.","og_url":"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-01T15:12:26+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/en\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/en\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/en\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/en\/#website","url":"https:\/\/docs.daftra.com\/en\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/#webpage","url":"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/","name":"Why did a row in the import file fail, and how do I find out the reason? - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/en\/#website"},"datePublished":"2026-11-01T15:05:09+00:00","dateModified":"2026-11-01T15:12:26+00:00","description":"Learn why a row in the employee import file fails, how to find the error reason and line number on the Result page, and what the Ignore errors while importing option does.","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/faq\/why-did-a-row-in-the-import-file-fail-and-how-do-i-find-out-the-reason\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Why did a row in the import file fail, and how do I find out the reason?"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/faq\/155171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/39"}],"version-history":[{"count":2,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/faq\/155171\/revisions"}],"predecessor-version":[{"id":155173,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/faq\/155171\/revisions\/155173"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=155171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=155171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=155171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}