{"id":810,"date":"2020-08-31T10:33:55","date_gmt":"2020-08-31T03:33:55","guid":{"rendered":"http:\/\/helpbhxh.misa.vn\/?post_type=ht_kb&#038;p=810"},"modified":"2026-06-15T10:05:24","modified_gmt":"2026-06-15T03:05:24","slug":"them-moi-lao-dong-vao-don-vi-bang-cach-nhap-khau-tu-excel","status":"publish","type":"ht_kb","link":"\/amis-bhxh\/kb\/them-moi-lao-dong-vao-don-vi-bang-cach-nhap-khau-tu-excel\/","title":{"rendered":"Th\u00eam ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o \u0111\u01a1n v\u1ecb b\u1eb1ng c\u00e1ch nh\u1eadp kh\u1ea9u t\u1eeb file Excel"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong> H\u01b0\u1edbng d\u1eabn ng\u01b0\u1eddi d\u00f9ng nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u lao \u0111\u1ed9ng t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m AMIS BHXH.<br \/>\n<strong>N\u1ed9i dung:<\/strong><br \/>\n&#8211; Ch\u1ecdn v\u00e0 c\u1eadp nh\u1eadt file m\u1eabu<br \/>\n&#8211; Ki\u1ec3m tra d\u1eef li\u1ec7u sau khi t\u1ea3i l\u00ean<br \/>\n&#8211; X\u1eed l\u00fd l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u<br \/>\n<strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> Nh\u00e2n s\u1ef1, k\u1ebf to\u00e1n, qu\u1ea3n tr\u1ecb ph\u1ea7n m\u1ec1m<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>T\u1ea1i ph\u00e2n h\u1ec7 <strong>Qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/strong>, nh\u1ea5n v\u00e0o d\u1ea5u m\u0169i t\u00ean b\u00ean c\u1ea1nh m\u1ee5c <strong>Th\u00eam m\u1edbi lao \u0111\u1ed9ng, <\/strong>nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong>\u2227<\/strong> ch\u1ecdn<strong> Nh\u1eadp kh\u1ea9u t\u1eeb Excel<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/15.png\" alt=\"\" width=\"1352\" height=\"545\" \/><\/p>\n<h4><b>2.1 Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/b><\/h4>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea3i file m\u1eabu sau \u0111\u00f3 c\u1eadp nh\u1eadt th\u00f4ng tin ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o file m\u1eabu.<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>C\u1ea7n nh\u1eadp ch\u00ednh x\u00e1c th\u00f4ng tin theo c\u00e1c tr\u01b0\u1eddng trong m\u1eabu th\u00ec m\u1edbi c\u00f3 th\u1ec3 nh\u1eadp kh\u1ea9u l\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u trong file Excel t\u1ea3i l\u00ean c\u00f3 CMTND\/CCCD\/H\u1ed9 chi\u1ebfu tr\u00f9ng v\u1edbi danh s\u00e1ch lao \u0111\u1ed9ng ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e3 c\u00f3 tr\u01b0\u1edbc \u0111\u00f3:<\/li>\n<\/ul>\n<p>&#8211; Nh\u1ea5n <strong>C\u1eadp nh\u1eadt m\u1edbi<\/strong> n\u1ebfu mu\u1ed1n c\u1eadp nh\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/p>\n<p>&#8211; Nh\u1ea5n <strong>B\u1ecf qua<\/strong> n\u1ebfu kh\u00f4ng mu\u1ed1n c\u1eadp nh\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/p>\n<p><a href=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12.png\" alt=\"\" width=\"1200\" height=\"687\" \/><\/a><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp kh\u1ea9u l\u00ean ph\u1ea7n m\u1ec1m b\u1eb1ng c\u00e1ch k\u00e9o file d\u1eef li\u1ec7u v\u00e0o kho\u1ea3ng tr\u1ed1ng \u0111\u01b0\u1ee3c khoanh \u0111\u1ecf.<\/p>\n<p><a href=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12-1.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/2022-02-17_10-17-12-1.png\" alt=\"\" width=\"1200\" height=\"687\" \/><\/a><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n b\u01b0\u1edbc th\u1ef1c hi\u1ec7n.<\/p>\n<h4><b>2.2 Ki\u1ec3m tra d\u1eef li\u1ec7u<\/b><\/h4>\n<p>H\u1ec7 th\u1ed1ng c\u1eadp nh\u1eadt danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u1eeba \u0111\u01b0\u1ee3c t\u1ea3i l\u00ean th\u00e0nh c\u00f4ng.<\/p>\n<figure class=\"size-large\"><img decoding=\"async\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-7.png\" alt=\"\" \/><\/figure>\n<p>Danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng \u0111\u01b0\u1ee3c chia theo nh\u00f3m d\u1eef li\u1ec7u. Nh\u1ea5n v\u00e0o t\u1eebng nh\u00f3m \u0111\u1ec3 xem chi ti\u1ebft.<\/p>\n<figure class=\"size-large\"><img decoding=\"async\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/6-4-1024x100.png\" alt=\"\" \/><\/figure>\n<ul>\n<li><strong>T\u1ed5ng d\u00f2ng d\u1eef li\u1ec7u<\/strong>: T\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng d\u1eef li\u1ec7u bao g\u1ed3m: d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p t\u1ea1i excel, d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3, d\u1eef li\u1ec7u sai.<\/li>\n<li><strong>D\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p t\u1ea1i excel<\/strong>: Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p s\u1ed1 CMTND\/CCCD\/H\u1ed9 chi\u1ebfu trong file b\u1ea3n excel \u0111ang \u0111\u01b0\u1ee3c t\u1ea3i l\u00ean v\u00e0 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh. Khi c\u00f3 tr\u01b0\u1eddng h\u1ee3p tr\u00f9ng n\u00e0y, ch\u1ec9 c\u00f3 d\u00f2ng d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng trong b\u1ea3n excel c\u1ee7a anh\/ch\u1ecb \u0111\u01b0\u1ee3c nh\u1eadp kh\u1ea9u v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<li><strong>D\u1eef li\u1ec7u \u0111\u00e3 c\u00f3<\/strong>: Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u t\u1ea1i b\u1ea3n excel c\u00f3 CMTND\/CCCD\/H\u1ed9 chi\u1ebfu tr\u00f9ng v\u1edbi danh s\u00e1ch lao \u0111\u1ed9ng ch\u01b0\u01a1ng tr\u00ecnh \u0111ang c\u00f3. Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n &#8220;B\u1ecf qua&#8221; ho\u1eb7c &#8220;C\u1eadp nh\u1eadt m\u1edbi&#8221; d\u00f2ng d\u1eef li\u1ec7u theo l\u1ef1a ch\u1ecdn c\u1ee7a anh\/ch\u1ecb tr\u01b0\u1edbc \u0111\u00f3.<\/li>\n<li><strong>D\u1eef li\u1ec7u sai<\/strong>: Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u c\u00f3 th\u00f4ng tin sai \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c th\u00f4ng tin kh\u00f4ng n\u1eb1m trong danh s\u00e1ch \u0111\u00e3 c\u00f3 c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh. C\u00e1c d\u00f2ng d\u1eef li\u1ec7u n\u00e0y s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<li><strong>T\u1ea3i v\u1ec1 file b\u00e1o l\u1ed7i<\/strong>: Khi file t\u1ea3i l\u00ean ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u sai, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n t\u1ea3i file b\u00e1o l\u1ed7i v\u1ec1 \u0111\u1ec3 ki\u1ec3m tra v\u00e0 ch\u1ec9nh s\u1eeda l\u1ea1i.<\/li>\n<\/ul>\n<p>=&gt; Sau khi \u0111\u00e3 ki\u1ec3m tra c\u00e1c nh\u00f3m d\u1eef li\u1ec7u, nh\u1ea5n <strong>Nh\u1eadp kh\u1ea9u<\/strong> \u0111\u1ec3 th\u00eam c\u00e1c lao \u0111\u1ed9ng v\u00e0o danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng c\u1ee7a \u0111\u01a1n v\u1ecb.<\/p>\n<figure class=\"size-large\"><img decoding=\"async\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8.png\" alt=\"\" \/><\/figure>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>3. X\u1eed l\u00fd l\u1ed7i<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>L\u1ed7i:<\/strong> Tr\u00ean file nh\u1eadp kh\u1ea9u, ph\u1ea7n m\u1ec1m tr\u1ea3 k\u1ebft qu\u1ea3 <strong>Kh\u00f4ng h\u1ee3p l\u1ec7<\/strong> v\u1edbi l\u00fd do &#8220;<strong>B\u1ed9 ph\u1eadn ph\u00f2ng ban kh\u00f4ng c\u00f3 trong danh m\u1ee5c<\/strong>&#8220;.<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong> Gi\u00e1 tr\u1ecb b\u1ed9 ph\u1eadn\/ph\u00f2ng ban trong file Excel kh\u00f4ng t\u1ed3n t\u1ea1i trong danh m\u1ee5c C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c c\u1ee7a ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong><\/p>\n<ul>\n<li>Ki\u1ec3m tra v\u00e0 s\u1eeda l\u1ea1i file Excel, \u0111\u1ea3m b\u1ea3o c\u00e1c gi\u00e1 tr\u1ecb b\u1ed9 ph\u1eadn \u0111\u01b0\u1ee3c l\u1ea5y \u0111\u00fang t\u1eeb danh m\u1ee5c <strong>Thi\u1ebft l\u1eadp\\C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c<\/strong>.<\/li>\n<li>N\u1ebfu ch\u01b0a c\u00f3 trong danh m\u1ee5c, c\u1ea7n th\u00eam m\u1edbi tr\u01b0\u1edbc khi nh\u1eadp kh\u1ea9u. Xem h\u01b0\u1edbng d\u1eabn t\u1ea1i: <a href=\"\/amis-bhxh\/kb\/thiet-lap-co-cau-to-chuc\/\" target=\"_blank\" rel=\"noopener\">Thi\u1ebft l\u1eadp c\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c<\/a>.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-810","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/comments?post=810"}],"version-history":[{"count":6,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810\/revisions"}],"predecessor-version":[{"id":25271,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810\/revisions\/25271"}],"wp:attachment":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/media?parent=810"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb-category?post=810"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb-tag?post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}