{"id":6146,"date":"2021-09-21T09:57:33","date_gmt":"2021-09-21T09:57:33","guid":{"rendered":"https:\/\/www.rvx.ro\/manual\/docs\/comune\/import-documente\/"},"modified":"2024-11-07T09:43:47","modified_gmt":"2024-11-07T09:43:47","slug":"import-documente","status":"publish","type":"docs","link":"https:\/\/www.rvx.ro\/manual\/docs\/comune\/import-documente\/","title":{"rendered":"Import documente"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Adaugare documente prin import Excel<\/h2>\n\n\n\n<p><strong>Import documente in format Excel<\/strong><\/p>\n\n\n\n<p>Fisierul va contine coloanele:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Number<\/strong>\u00a0\u2013 numar document;<\/li>\n\n\n\n<li><strong>Date<\/strong>\u00a0\u2013 data document;<\/li>\n\n\n\n<li><strong>PartnerCode<\/strong>\u00a0\u2013 cod partener;<\/li>\n\n\n\n<li><strong>DocType<\/strong>\u00a0\u2013 tip document:\u00a0<em>FVANZ, FCUMP, CVANZ, CCUMP, etc.<\/em>;<\/li>\n\n\n\n<li><strong>LocationId<\/strong>\u00a0\u2013 numele gestiunii in care se inregistreaza documentul;<\/li>\n\n\n\n<li><strong>AgentId<\/strong>\u00a0\u2013 numele agentului asignat documentului;<\/li>\n\n\n\n<li><strong>CenterId<\/strong>\u00a0\u2013 denumirea centrului de profit\/cost;<\/li>\n\n\n\n<li>In urma adaugarii inregistrarilor pentru import, salvati fisierul in format\u00a0<em>.xls<\/em>.<\/li>\n\n\n\n<li>In interfata lista, navigati\u00a0<strong>Actiuni \u2013 Import excel<\/strong>.<\/li>\n\n\n\n<li>In fereastra nou deschisa, utilizati butonul Browse si selectati fisierul pentru import.<\/li>\n\n\n\n<li>Pentru verificare inregistrari, selectati\u00a0<strong>Actiune\u00a0<\/strong>=\u00a0<em>VALIDATE<\/em>,\u00a0<strong>Key<\/strong>\u00a0=\u00a0<em>Number<\/em>.<\/li>\n\n\n\n<li>Pentru import inregistrari noi,\u00a0selectati\u00a0<strong>Actiune<\/strong><em>\u00a0= INSERT,\u00a0<\/em><strong>Key<\/strong><em>\u00a0= Number<\/em>.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Import<\/strong>\u00a0pentru importul datelor.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Inchide<\/strong>\u00a0in cazul in care nu se mai doreste importul datelor.<\/li>\n<\/ol>\n\n\n\n<p><strong>Import continut documente in format&nbsp;Excel<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>ParentId<\/strong>\u00a0\u2013 numar document parinte;<\/li>\n\n\n\n<li><strong>ItemCode<\/strong>\u00a0\u2013 cod articol;<\/li>\n\n\n\n<li><strong>Quantity<\/strong>\u00a0\u2013 cantitate produs;<\/li>\n\n\n\n<li><strong>PriceNetV<\/strong>\u00a0\u2013 pret unitar produs;<\/li>\n\n\n\n<li>Salvati fisierul in format\u00a0<em>.xls<\/em>.<\/li>\n\n\n\n<li>In interfata lista, navigati\u00a0<strong>Actiuni \u2013 Import excel<\/strong>.<\/li>\n\n\n\n<li>In fereastra nou deschisa, utilizati butonul Browse, si selectati fisierul pentru import.<\/li>\n\n\n\n<li>Pentru verificare inregistrari, selectati\u00a0<strong>Actiune\u00a0<\/strong>=\u00a0<em>VALIDATE<\/em>,\u00a0<strong>Key<\/strong>\u00a0=\u00a0<em>Number<\/em>.<\/li>\n\n\n\n<li>Pentru import inregistrari noi,\u00a0selectati\u00a0<strong>Actiune<\/strong><em>\u00a0= INSERT,\u00a0<\/em><strong>Key<\/strong><em>\u00a0= Number<\/em>.<\/li>\n\n\n\n<li>Bifati campul\u00a0<strong>Continut<\/strong>.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Import<\/strong>\u00a0pentru importul datelor.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Inchide<\/strong>\u00a0in cazul in care nu se mai doreste importul datelor.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Modificare documente prin import Excel<\/h2>\n\n\n\n<p>&nbsp;<strong>Modificare&nbsp;<\/strong><strong>documente<\/strong><\/p>\n\n\n\n<p>Fisierul va contine&nbsp;coloana&nbsp;<strong>Id<\/strong>&nbsp;si coloanele cu date actualizate.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In urma modificarii inregistrarilor, salvati fisierul in format\u00a0<em>.xls<\/em>.<\/li>\n\n\n\n<li>In interfata lista, navigati\u00a0<strong>Actiuni \u2013 Import excel<\/strong>.<\/li>\n\n\n\n<li>In fereastra nou deschisa, utilizati butonul\u00a0<strong>Browse<\/strong>\u00a0si selectati fisierul pentru import.<\/li>\n\n\n\n<li>Pentru modificare inregistrari existente,\u00a0selectati\u00a0<strong>Actiune<\/strong><em>\u00a0= UPDATE,\u00a0<\/em><strong>Key<\/strong><em>\u00a0= Id<\/em>.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Import<\/strong>\u00a0pentru actualizarea datelor.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Inchide<\/strong>\u00a0in cazul in care nu se mai doreste modificarea datelor.<\/li>\n<\/ol>\n\n\n\n<p><strong>Modificare continut documente<\/strong><\/p>\n\n\n\n<p>Fisierul va contine colonele&nbsp;<strong>Id,&nbsp;ParentId<\/strong>,&nbsp;<strong>ItemCode<\/strong>&nbsp;si coloanele cu date actualizate.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In urma modificarii inregistrarilor, salvati fisierul in format\u00a0<em>.xls<\/em>.<\/li>\n\n\n\n<li>In interfata lista, navigati\u00a0<strong>Actiuni \u2013 Import excel<\/strong>.<\/li>\n\n\n\n<li>In fereastra nou deschisa, utilizati butonul\u00a0<strong>Browse<\/strong>, si selectati fisierul pentru import.<\/li>\n\n\n\n<li>Pentru modificare inregistrari existente,\u00a0selectati\u00a0<strong>Actiune<\/strong><em>\u00a0= UPDATE,\u00a0<\/em><strong>Key<\/strong><em>\u00a0= Id<\/em>.<\/li>\n\n\n\n<li>Bifati campul\u00a0<strong>Continut<\/strong>.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Import<\/strong>\u00a0pentru actualizarea datelor.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Inchide<\/strong>\u00a0in cazul in care nu se mai doreste modificarea datelor.<\/li>\n<\/ol>\n\n\n\n<p><strong>ATENTIE!&nbsp;<\/strong><\/p>\n\n\n\n<p><em>Este absolut necesara pastrarea coloanei&nbsp;<strong>Id<\/strong>.<\/em><\/p>\n\n\n\n<p><em>Anterior importului, recomandam export lista inregistrari, pentru a avea o copie a acestora.<\/em><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Stergere documente prin import Excel<\/h2>\n\n\n\n<p><strong>Stergere&nbsp;<\/strong><strong>documente<\/strong><\/p>\n\n\n\n<p>Fisierul va contine&nbsp;coloana obligatoriu&nbsp;<strong>Id<\/strong>.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In interfata lista, navigati\u00a0<strong>Actiuni \u2013 Import excel<\/strong>.<\/li>\n\n\n\n<li>In fereastra nou deschisa, utilizati butonul\u00a0<strong>Browse<\/strong>\u00a0si selectati fisierul pentru import.<\/li>\n\n\n\n<li>Pentru stergere inregistrari existente,\u00a0selectati\u00a0<strong>Actiune<\/strong><em>\u00a0= DELETE,\u00a0<\/em><strong>Key<\/strong><em>\u00a0= Id<\/em>.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Import<\/strong>\u00a0pentru stergerea datelor.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Inchide<\/strong>\u00a0in cazul in care nu se mai doreste stergerea datelor.<\/li>\n<\/ol>\n\n\n\n<p><strong>Stergere continut documente<\/strong><\/p>\n\n\n\n<p>Fisierul va contine&nbsp;coloana obligatoriu&nbsp;<strong>Id<\/strong>.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In interfata lista, navigati\u00a0<strong>Actiuni \u2013 Import excel<\/strong>.<\/li>\n\n\n\n<li>In fereastra nou deschisa, utilizati butonul\u00a0<strong>Browse<\/strong>\u00a0si selectati fisierul pentru import.<\/li>\n\n\n\n<li>Pentru stergere inregistrari existente,\u00a0selectati\u00a0<strong>Actiune<\/strong><em>\u00a0= DELETE,\u00a0<\/em><strong>Key<\/strong><em>\u00a0= Id<\/em>.<\/li>\n\n\n\n<li>Bifati campul\u00a0<strong>Continut<\/strong>.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Import<\/strong>\u00a0pentru stergerea datelor.<\/li>\n\n\n\n<li>Apasati butonul\u00a0<strong>Inchide<\/strong>\u00a0in cazul in care nu se mai doreste stergerea datelor.<\/li>\n<\/ol>\n\n\n\n<p><strong>ATENTIE!&nbsp;<\/strong><\/p>\n\n\n\n<p><em>Anterior importului, recomandam export lista inregistrari, pentru a avea o copie a acestora.<\/em><\/p>\n","protected":false},"featured_media":0,"parent":3882,"menu_order":31,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-6146","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs\/6146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/comments?post=6146"}],"version-history":[{"count":16,"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs\/6146\/revisions"}],"predecessor-version":[{"id":8750,"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs\/6146\/revisions\/8750"}],"up":[{"embeddable":true,"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs\/3882"}],"next":[{"title":"Transfer articol nestocabil in stocabil","link":"https:\/\/www.rvx.ro\/manual\/docs\/comune\/transfer-articol-nestocabil-in-stocabil\/","href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs\/8315"}],"prev":[{"title":"Atasare fisiere la documente","link":"https:\/\/www.rvx.ro\/manual\/docs\/comune\/atasare-fisiere-la-documente\/","href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/docs\/5504"}],"wp:attachment":[{"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/media?parent=6146"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.rvx.ro\/manual\/wp-json\/wp\/v2\/doc_tag?post=6146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}