{"id":457,"date":"2026-06-23T15:40:28","date_gmt":"2026-06-23T08:40:28","guid":{"rendered":"http:\/\/helpemis.misa.vn\/thu-vien\/?post_type=ht_kb&p=457"},"modified":"2026-06-24T12:09:02","modified_gmt":"2026-06-24T05:09:02","slug":"emis-thu-vien-lam-the-nao-khi-nhap-sach-bao-loi-trung-sach","status":"publish","type":"ht_kb","link":"\/thu-vien\/knowledge-base\/emis-thu-vien-lam-the-nao-khi-nhap-sach-bao-loi-trung-sach\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o khi nh\u1eadp s\u00e1ch b\u00e1o l\u1ed7i tr\u00f9ng s\u00e1ch"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

1. T\u1ed5ng quan<\/span><\/h3>\n

Khi nh\u1eadp kh\u1ea9u s\u00e1ch v\u00e0o Phi\u1ebfu nh\u1eadp s\u00e1ch<\/strong>, anh\/ch\u1ecb c\u00f3 th\u1ec3 g\u1eb7p th\u00f4ng b\u00e1o l\u1ed7i tr\u00f9ng s\u00e1ch, tr\u00f9ng nhan \u0111\u1ec1: “Nhan \u0111\u1ec1 … \u0111\u00e3 b\u1ecb nh\u1eadp tr\u00f9ng. Vui l\u00f2ng ki\u1ec3m tra l\u1ea1i.”<\/strong> khi th\u1ef1c hi\u1ec7n C\u1ea5t phi\u1ebfu<\/strong> d\u00f9 qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u tr\u01b0\u1edbc \u0111\u00f3 th\u00e0nh c\u00f4ng.<\/span><\/p>\n

\"\"<\/span><\/p>\n

L\u1ed7i n\u00e0y khi\u1ebfn anh\/ch\u1ecb kh\u00f4ng th\u1ec3 l\u01b0u phi\u1ebfu nh\u1eadp s\u00e1ch v\u00e0 m\u1ea5t th\u1eddi gian ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u tr\u00ean file Excel ho\u1eb7c danh s\u00e1ch s\u00e1ch \u0111\u00e3 nh\u1eadp tr\u00ean phi\u1ebfu.<\/span><\/p>\n

B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb:<\/span><\/p>\n

    \n
  • X\u00e1c \u0111\u1ecbnh nguy\u00ean nh\u00e2n ph\u1ea7n m\u1ec1m b\u00e1o tr\u00f9ng s\u00e1ch, tr\u00f9ng nhan \u0111\u1ec1 khi nh\u1eadp kh\u1ea9u.<\/span><\/li>\n
  • C\u00e1ch x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00f9ng tr\u1ef1c ti\u1ebfp tr\u00ean Phi\u1ebfu nh\u1eadp s\u00e1ch.<\/span><\/li>\n
  • C\u00e1ch ch\u1ec9nh s\u1eeda file Excel \u0111\u1ec3 nh\u1eadp kh\u1ea9u l\u1ea1i khi c\u00f3 nhi\u1ec1u d\u1eef li\u1ec7u tr\u00f9ng.<\/span><\/li>\n<\/ul>\n

    2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/span><\/h3>\n

    2.1. Nguy\u00ean nh\u00e2n<\/span><\/h4>\n

    Do file Excel nh\u1eadp kh\u1ea9u c\u00f3 nhan \u0111\u1ec1 s\u00e1ch b\u1ecb tr\u00f9ng:\u00a0Khi nh\u1eadp s\u00e1ch b\u1eb1ng file Excel, n\u1ebfu trong file c\u00f3 nhi\u1ec1u d\u00f2ng ch\u1ee9a c\u00f9ng m\u1ed9t nhan \u0111\u1ec1 s\u00e1ch<\/strong>, ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3u l\u00e0 d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng v\u00e0 b\u00e1o l\u1ed7i khi anh\/ch\u1ecb th\u1ef1c hi\u1ec7n C\u1ea5t phi\u1ebfu nh\u1eadp s\u00e1ch<\/strong>.<\/span><\/p>\n

    L\u01b0u \u00fd:<\/strong> V\u1edbi c\u00e1c s\u00e1ch c\u00f3 c\u00f9ng nhan \u0111\u1ec1, anh\/ch\u1ecb ch\u1ec9 khai b\u00e1o 01 d\u00f2ng duy nh\u1ea5t<\/strong> v\u00e0 t\u0103ng s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n

    V\u00ed d\u1ee5: <\/strong>Tr\u00ean file Excel c\u00f3 2 d\u00f2ng c\u00f9ng nhan \u0111\u1ec1: Ti\u1ebfng Vi\u1ec7t t\u1eadp 1.<\/strong><\/span><\/p>\n

      \n
    • D\u00f2ng 1: S\u1ed1 l\u01b0\u1ee3ng = 1.<\/span><\/li>\n
    • D\u00f2ng 2: S\u1ed1 l\u01b0\u1ee3ng = 1.<\/span><\/li>\n<\/ul>\n

      Khi nh\u1eadp kh\u1ea9u, ph\u1ea7n m\u1ec1m s\u1ebd b\u00e1o l\u1ed7i tr\u00f9ng nhan \u0111\u1ec1 Ti\u1ebfng Vi\u1ec7t t\u1eadp 1<\/strong>.<\/span><\/p>\n

      => C\u00e1ch khai b\u00e1o \u0111\u00fang:<\/span><\/p>\n

        \n
      • Ch\u1ec9 \u0111\u1ec3 1 d\u00f2ng: Ti\u1ebfng Vi\u1ec7t t\u1eadp 1.<\/strong><\/span><\/li>\n
      • S\u1ed1 l\u01b0\u1ee3ng = 2.<\/span><\/li>\n<\/ul>\n

        2.2. Gi\u1ea3i ph\u00e1p<\/span><\/h4>\n

        N\u1ebfu ch\u1ec9 c\u00f3 \u00edt d\u00f2ng b\u1ecb tr\u00f9ng, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n tr\u1ef1c ti\u1ebfp tr\u00ean Phi\u1ebfu nh\u1eadp s\u00e1ch<\/strong> nh\u01b0 sau:<\/span><\/p>\n

        B\u01b0\u1edbc 1:<\/strong> X\u00f3a d\u00f2ng s\u00e1ch b\u1ecb tr\u00f9ng.<\/span><\/p>\n

          \n
        • \n
            \n
          • \n
              \n
            • T\u1ea1i phi\u1ebfu nh\u1eadp s\u00e1ch v\u1eeba nh\u1eadp kh\u1ea9u tr\u00ean ph\u1ea7n m\u1ec1m<\/span><\/li>\n
            • X\u00f3a b\u1edbt c\u00e1c d\u00f2ng c\u00f3 c\u00f9ng nhan \u0111\u1ec1 b\u1ecb tr\u00f9ng.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

              B\u01b0\u1edbc 2:<\/strong> \u0110i\u1ec1u ch\u1ec9nh l\u1ea1i s\u1ed1 l\u01b0\u1ee3ng.<\/span><\/p>\n

                \n
              • \n
                  \n
                • \n
                    \n
                  • T\u1ea1i d\u00f2ng c\u00f2n l\u1ea1i, s\u1eeda S\u1ed1 l\u01b0\u1ee3ng<\/strong> th\u00e0nh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng th\u1ef1c t\u1ebf c\u1ee7a nhan \u0111\u1ec1 \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                    N\u1ebfu file c\u00f3 nhi\u1ec1u nhan \u0111\u1ec1 b\u1ecb tr\u00f9ng, anh\/ch\u1ecb n\u00ean ch\u1ec9nh s\u1eeda l\u1ea1i file Excel tr\u01b0\u1edbc khi nh\u1eadp kh\u1ea9u l\u1ea1i.<\/span><\/p>\n

                    B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel nh\u1eadp kh\u1ea9u.<\/span><\/p>\n

                      \n
                    • \n
                        \n
                      • \n
                          \n
                        • Ki\u1ec3m tra c\u00e1c d\u00f2ng c\u00f3 c\u00f9ng nhan \u0111\u1ec1 s\u00e1ch.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                          B\u01b0\u1edbc 2:<\/strong> G\u1ed9p d\u1eef li\u1ec7u tr\u00f9ng.<\/span><\/p>\n

                            \n
                          • \n
                              \n
                            • \n
                                \n
                              • X\u00f3a c\u00e1c d\u00f2ng tr\u00f9ng nhan \u0111\u1ec1.<\/span><\/li>\n
                              • Gi\u1eef l\u1ea1i 1 d\u00f2ng duy nh\u1ea5t cho m\u1ed7i nhan \u0111\u1ec1.<\/span><\/li>\n
                              • C\u1eadp nh\u1eadt S\u1ed1 l\u01b0\u1ee3ng<\/strong> b\u1eb1ng t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c d\u00f2ng \u0111\u00e3 g\u1ed9p.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                B\u01b0\u1edbc 3:<\/strong> Nh\u1eadp kh\u1ea9u l\u1ea1i file.<\/span><\/p>\n

                                  \n
                                • \n
                                    \n
                                  • \n
                                      \n
                                    • L\u01b0u file Excel sau khi ch\u1ec9nh s\u1eeda.<\/span><\/li>\n
                                    • Th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u l\u1ea1i v\u00e0o Phi\u1ebfu nh\u1eadp s\u00e1ch v\u00e0 c\u1ea5t phi\u1ebfu.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                      L\u01b0u \u00fd:<\/strong> Khi nh\u1eadp kh\u1ea9u s\u00e1ch, m\u1ed7i nhan \u0111\u1ec1 ch\u1ec9 n\u00ean xu\u1ea5t hi\u1ec7n 1 l\u1ea7n duy nh\u1ea5t<\/strong> tr\u00ean file Excel \u0111\u1ec3 tr\u00e1nh l\u1ed7i tr\u00f9ng d\u1eef li\u1ec7u khi l\u01b0u phi\u1ebfu nh\u1eadp.<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div>\n<\/div>\n<\/div>\n

                                      <\/div>\n","protected":false},"excerpt":{"rendered":"

                                      1. T\u1ed5ng quan Khi nh\u1eadp kh\u1ea9u s\u00e1ch v\u00e0o Phi\u1ebfu nh\u1eadp s\u00e1ch, anh\/ch\u1ecb c\u00f3 th\u1ec3 g\u1eb7p th\u00f4ng b\u00e1o l\u1ed7i tr\u00f9ng s\u00e1ch, tr\u00f9ng nhan \u0111\u1ec1: “Nhan \u0111\u1ec1 … \u0111\u00e3 b\u1ecb nh\u1eadp tr\u00f9ng. Vui l\u00f2ng ki\u1ec3m tra l\u1ea1i.” khi th\u1ef1c hi\u1ec7n C\u1ea5t phi\u1ebfu d\u00f9 qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u tr\u01b0\u1edbc \u0111\u00f3 th\u00e0nh c\u00f4ng. L\u1ed7i…<\/p>\n","protected":false},"author":29,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-457","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb\/457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/comments?post=457"}],"version-history":[{"count":2,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb\/457\/revisions"}],"predecessor-version":[{"id":759,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb\/457\/revisions\/759"}],"wp:attachment":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/media?parent=457"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb-category?post=457"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb-tag?post=457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}