{"id":36427,"date":"2026-01-26T08:22:48","date_gmt":"2026-01-26T08:22:48","guid":{"rendered":"https:\/\/www.erplybooks.com\/?page_id=36427"},"modified":"2026-04-28T10:33:14","modified_gmt":"2026-04-28T10:33:14","slug":"andmete-importimine-ja-muutmine-aruandegeneraatoris","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/juhendid\/andmete-importimine-ja-muutmine-aruandegeneraatoris\/","title":{"rendered":"Andmete importimine ja muutmine aruandegeneraatoris"},"content":{"rendered":"

Andmete importimine ja muutmine aruandegeneraatoris<\/b><\/h1>\n

Aruandegeneraator <\/b>v\u00f5imaldab lisaks ERPLY Books\u2019i andmete redigeerimisele teha muudatusi ka ERPLY lao backoffice\u2019is, sealhulgas andmeid importida, uuendada ja eemaldada . K\u00e4esolev juhend selgitab, kuidas t\u00f6\u00f6tada ERPLY backoffice andmetega <\/span>Aruandegeneraatori <\/b>kaudu<\/span><\/p>\n

Kaks meetodit andmete hankimiseks<\/b><\/h2>\n

 <\/p>\n

Meetod 1: Andmete importimine<\/b><\/h3>\n
    \n
  1. Avage <\/span>Aruandegeneraator <\/b>(Aruanded \u2192 Aruandegeneraator)<\/span><\/li>\n
  2. Vajutage: <\/span>Impordi Eelvaade<\/b><\/li>\n
  3. Kl\u00f5psake: <\/span>Vali fail<\/b><\/li>\n
  4. Laadige fail \u00fcles (nt Excel, CSV)<\/span><\/li>\n
  5. Tehke vajadusel muudatused jaotises: <\/span>Muud v\u00f5imalused<\/b><\/li>\n
  6. Kl\u00f5psake: <\/span>Tehtud<\/b><\/li>\n<\/ol>\n

    \"\"<\/p>\n

    Meetod 2: Otsene API p\u00e4ring<\/b><\/h3>\n
      \n
    1. Avage <\/span>Aruandegeneraator <\/b>(Aruanded \u2192 Aruandegeneraator)<\/span><\/li>\n
    2. Vajutage: <\/span>Impordi Eelvaade<\/b><\/li>\n
    3. Sisestage API p\u00e4ring otse (ERPLY API) (nt “getBillingStatements”)<\/span><\/li>\n
    4. Kl\u00f5psake: <\/span>Tehtud<\/b><\/li>\n
    5. S\u00fcsteem hangib andmed otse ERPLY API-st<\/span><\/li>\n<\/ol>\n

      \"\"<\/p>\n

      Redigeerimise juhend<\/b><\/h2>\n

      NB!<\/b> See juhend kasutab andmete hankimiseks meetodit 2 (Otsene API p\u00e4ring).<\/span><\/p>\n

      Muudatuste tegemine<\/b><\/h3>\n

      Kui andmed on laaditud, saate:<\/span><\/p>\n

        \n
      • Muuta v\u00e4\u00e4rtusi<\/b> – Kl\u00f5psake otse lahtrites andmete muutmiseks<\/span><\/li>\n
      • Lisada uusi ridu<\/b> – Kl\u00f5psake allanoolt, et lisada uus kirje<\/span><\/li>\n
      • Kopeerida <\/b>– Kleepige andmeid otse tabelitest (nt. Excelist)<\/span><\/li>\n
      • Kustutada ridu<\/b> – Kasutage kustutamise v\u00f5imalust veergude l\u00f5pus<\/span><\/li>\n<\/ul>\n

        Muudatuste salvestamine<\/b><\/h3>\n

        Kui kl\u00f5psate <\/span>Salvesta<\/b>, peate seadistama kolm toimingut:<\/span><\/p>\n

          \n
        • POST<\/b> (API p\u00e4ring uute kirjete loomiseks)<\/span><\/li>\n
        • PUT<\/b> (API p\u00e4ring kirjete muutmiseks)<\/span><\/li>\n
        • DELETE<\/b> (API p\u00e4ring kirjete eemaldamiseks)<\/span><\/li>\n<\/ul>\n

          NB:<\/b> ERPLY backoffice\u2019i puhul kasutatakse <\/span>uute <\/b>kirjete lisamisel\u00a0 ja olemasolevate kirjete <\/span>uuendamisel <\/b>samat API p\u00e4ringut.<\/span><\/p>\n

          N\u00f5utav seadistus<\/b><\/h3>\n

          Peate <\/span>kindlasti lisama<\/b> ID field <\/b>\u2013 m\u00e4\u00e4rake alati oma andmet\u00fc\u00fcbi ID v\u00e4li:<\/span><\/p>\n

            \n
          • N\u00e4iteks: <\/span>billingStatementID<\/span><\/li>\n<\/ul>\n

            S\u00fcsteem kasutab seda, et tuvastada milliseid kirjeid uuendada v\u00f5i kustutada.<\/span><\/p>\n

            Mapper (Vajadusel)<\/b><\/h3>\n

            M\u00f5ned v\u00e4ljad vajavad seostamist (mapper), et m\u00e4\u00e4rata API v\u00e4li:<\/span><\/p>\n

              \n
            • N\u00e4iteks: <\/span>“productCategoryName”:”nameENG”<\/span> (inglise keel)<\/span><\/li>\n
            • N\u00e4iteks: <\/span>“productCategoryName”:”nameLAT”<\/span> (l\u00e4ti keel)<\/span><\/li>\n<\/ul>\n

              \"\"<\/p>\n

              Kohandatud aruannete salvestamine<\/b><\/h2>\n

              ERPLY v\u00f5imaldab salvestada oma aruandegeneraatori seadistusi ka hilisemaks kasutamiseks.<\/span><\/p>\n

              Aruannete salvestamine<\/b><\/h3>\n
                \n
              1. T\u00e4itke k\u00f5ik vajalikud seaded (API p\u00e4ringud, ID v\u00e4li, Mapper jne)<\/span><\/li>\n
              2. Kl\u00f5psake <\/span>Salvesta aruanne<\/b><\/li>\n
              3. Andke oma aruandele <\/span>nimi <\/b>(nt “Billing Statement”) ja <\/span>t\u00fc\u00fcp<\/b><\/li>\n
              4. Vajutage <\/span>Salvesta<\/b><\/li>\n<\/ol>\n

                Salvestatud aruannete kasutamine<\/b><\/h3>\n
                  \n
                1. Avage <\/span>Salvestatud aruanded<\/b> (Aruanded \u2192 Salvestatud aruanded)<\/span><\/li>\n
                2. Valige oma salvestatud aruanne (nt “Billing Statement”)<\/span><\/li>\n
                3. Kl\u00f5psake aruande laadimiseks koos k\u00f5igi eelseadistatud s\u00e4tetega<\/span><\/li>\n
                4. Tehke oma muudatused<\/span><\/li>\n
                5. Kl\u00f5psake Save muudatuste t\u00f6\u00f6tlemiseks<\/span><\/li>\n<\/ol>\n

                  Lisafunktsioonid<\/b><\/h2>\n

                  ID Mapping<\/b><\/h3>\n

                  S\u00fcsteemi ID-d (nt klientide ID-d)\u00a0 on teile sageli t\u00e4henduseta numbrid, kuna need kasutavad teistsugust formaati. ID Mapping v\u00f5imaldab teil lisada redaktori (editori) s\u00fcsteemi ID-le,nii et s\u00fcsteem saab tehnilisi ID-sid taustal automaatselt hallata.<\/span><\/p>\n

                  N\u00e4ide: Kliendi ID ( customerID editor)<\/b><\/h4>\n

                  Probleem:<\/b> customerIDd on (teise) s\u00fcsteemi genereeritud numbrid, mis ei t\u00e4henda praegu teie jaoks midagi. Lahenduseks tuleb teha ID Mapping, mis seob kliendi registrikoodi customerIDga, et otsing p\u00f5hineks kliendi registrikoodil, kuid s\u00fcsteem kasutaks taustal endiselt \u00f5iget ID-d.<\/span><\/p>\n

                  \"\"<\/p>\n

                  Sammud:<\/b><\/p>\n

                    \n
                  • Kl\u00f5psake <\/span>Veel\u2192 Muud v\u00f5imalused<\/b><\/li>\n<\/ul>\n
                      \n
                    1. Valige “<\/span>M\u00e4\u00e4ra, kuidas andmed \u00fchendada<\/b>“<\/span><\/li>\n
                    2. Lisage v\u00e4\u00e4rtused: (nt <\/span>customerID:ENTITY.REGISTRATION_CODE:ENTITY.PARTNER_CUSTOMER_ID<\/span>)<\/span><\/li>\n
                    3. Samuti, kui soovite lisada editori mitte ainult \u00fchele ID-le, vaid kahele v\u00f5i enamale korraga (n\u00e4iteks customerID ja productID), siis saate seda seadistada j\u00e4rgmiselt: <\/span>customerID:ENTITY.REGISTRATION_CODE:ENTITY.PARTNER_CUSTOMER_ID|productID:ARTICLE.CODE:ARTICLE.PARTNER_ARTICLE_ID|<\/span><\/li>\n<\/ol>\n
                        \n
                      1. Kl\u00f5psake <\/span>Otsi<\/b><\/li>\n<\/ol>\n

                        \u00a0N\u00fc\u00fcd saate kliente otsida ja valida nende registrikoodi j\u00e4rgi, kuid s\u00fcsteem salvestab \u00f5ige kliendi ID ERPLY back office\u2019is.<\/span><\/p>\n

                        \"\"<\/p>\n

                        Valikukastid loetelu (Enum) v\u00e4\u00e4rtuste jaoks<\/b><\/h3>\n

                        M\u00f5nedel v\u00e4ljadel on konkreetsed lubatud v\u00e4\u00e4rtused (loetelu\/s\u00f5nastiku v\u00e4\u00e4rtused). Neid saate seadistada rippmen\u00fc\u00fc valikukastidena vabateksti asemel, mis v\u00e4hendab vigu ning tagab, et sisestatakse ainult kehtivad v\u00e4\u00e4rtused. Selle teostamiseks saab samamoodi kasutada ID Mappingut.<\/span><\/p>\n

                        N\u00e4ide: Billing statement time<\/b><\/h4>\n

                        Antud n\u00e4itel on olemas ainult 3 v\u00f5imalikku v\u00e4\u00e4rtust:<\/b><\/p>\n

                          \n
                        • Kui periood algab<\/span><\/li>\n
                        • Kui periood l\u00f5peb<\/span><\/li>\n
                        • M\u00f5\u00f5detud n\u00e4itude p\u00f5hjal<\/span><\/li>\n<\/ul>\n

                          Saate lisada v\u00e4\u00e4rtused j\u00e4rgmiselt: nt billingStatementTime:CUSTOM,1=WHEN_PERIOD_STARTS,2=WHEN_PERIOD_ENDS,3=BASED_ON_METERED_READINGS<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

                          Andmete importimine ja muutmine aruandegeneraatoris Aruandegeneraator v\u00f5imaldab lisaks ERPLY Books\u2019i andmete redigeerimisele teha muudatusi ka ERPLY lao backoffice\u2019is, sealhulgas andmeid importida, uuendada ja eemaldada . K\u00e4esolev juhend selgitab, kuidas t\u00f6\u00f6tada ERPLY backoffice andmetega Aruandegeneraatori kaudu Kaks meetodit andmete hankimiseks   Meetod 1: Andmete importimine Avage Aruandegeneraator (Aruanded \u2192 Aruandegeneraator) Vajutage: Impordi Eelvaade Kl\u00f5psake: Vali fail […]<\/p>\n","protected":false},"author":28,"featured_media":0,"parent":3312,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[],"tags":[],"class_list":["post-36427","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/36427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=36427"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/36427\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/3312"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=36427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=36427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=36427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}