{"id":5915,"date":"2026-10-27T13:30:31","date_gmt":"2026-10-27T12:30:31","guid":{"rendered":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/rstickets-kategorija-2\/rstickets-75\/"},"modified":"2026-10-27T14:09:25","modified_gmt":"2026-10-27T13:09:25","slug":"izvoz-podataka-iz-gk-na-web-mysql","status":"publish","type":"docs","link":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/","title":{"rendered":"Izvoz podataka iz GK na web &#8211; MySQL"},"content":{"rendered":"<p><strong><span style=\"text-decoration: underline;\">Za odraditi u DIL-u:<\/span><\/strong><\/p>\n<p>1. Otvoriti novog korisnika na web-u<\/p>\n<p>GK &#8211; Specifi\u010dnosti &#8211; mySQL korisni\u010dki ra\u010duni<\/p>\n<p>\u0160ifre ne smiju biti prejednostavne, da bi firme ne bi jedna drugoj gledale podatke, nikako ne i\u0107i logikom naziv firme\/ime djelatnika)<\/p>\n<p><strong><span style=\"text-decoration: underline;\">Za odraditi kod korisnika:<\/span><\/strong><\/p>\n<p>1. Instalirati MySQL ODBC 5.1.6. win32 sa <a href=\"https:\/\/dil-93.hr\/old\/index.php\/preuzimanje-download\">http:\/\/www.dil-93.hr\/old\/index.php\/preuzimanje-download<\/a>&nbsp;proc broj 19. ili direktno pokrenite tj. instalirajte <a href=\"https:\/\/dil-93.hr\/old\/..\/d\/instalacije\/mysql_odbc_516.msi\">http:\/\/www.dil-93.hr\/d\/instalacije\/mysql_odbc_516.msi<\/a><\/p>\n<p>2. Kod korisnika GK &#8211; specifi\u010dnosti staviti proceduru za izvoz GK na web (pogledati u podacima od DIL-a, specifi\u010dnost br. 1228 izvoz na mySQL, <a href=\"https:\/\/dil-93.hr\/old\/..\/rip\">www.dil-93.hr\/rip<\/a>, 01.05. otkazali smo dil93.com<\/p>\n<p>3. GK&nbsp; &#8211; dodavanje tabela u bazu<\/p>\n<p>4.&nbsp;GK&nbsp;&nbsp;&#8211; provjeriti &#8216;Skra\u0107eni izvje\u0161taj konta&#8217;<\/p>\n<p><span><span>Neto <\/span><\/span>dobit i bruto dobiti treba minus koeficijent, da bi se dobit prikazala kao pozitivna na grafi\u010dkom prikazu, a gubitak kao negativan.<\/p>\n<p>5. GK &#8211; pokrenuti izradu &#8216;Skra\u0107enog izvje\u0161taja&#8217;<\/p>\n<p>6. GK &#8211; pokrenuti specifi\u010dnost &#8211; Izvoz GK na web<\/p>\n<p>7. Provjera podataka na <a href=\"https:\/\/dil-93.hr\/old\/..\/rip\">www.dil-93.hr\/rip<\/a><\/p>\n","protected":false},"featured_media":0,"parent":5831,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_is_vendor_doc":"0","footnotes":""},"doc_tag":[],"class_list":["post-5915","docs","type-docs","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.5 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Izvoz podataka iz GK na web - MySQL - Dil-93<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"hr_HR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Izvoz podataka iz GK na web - MySQL\" \/>\n<meta property=\"og:description\" content=\"Za odraditi u DIL-u: 1. Otvoriti novog korisnika na web-u GK &#8211; Specifi\u010dnosti &#8211; mySQL korisni\u010dki ra\u010duni \u0160ifre ne smiju biti prejednostavne, da bi firme ne bi jedna drugoj gledale podatke, nikako ne i\u0107i logikom naziv firme\/ime djelatnika) Za odraditi kod korisnika: 1. Instalirati MySQL ODBC 5.1.6. win32 sa http:\/\/www.dil-93.hr\/old\/index.php\/preuzimanje-download&nbsp;proc broj 19. ili direktno pokrenite...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Dil-93\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-27T13:09:25+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Procijenjeno vrijeme \u010ditanja\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/glavna-knjiga\\\/izvoz-podataka-iz-gk-na-web-mysql\\\/\",\"url\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/glavna-knjiga\\\/izvoz-podataka-iz-gk-na-web-mysql\\\/\",\"name\":\"Izvoz podataka iz GK na web - MySQL - Dil-93\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/#website\"},\"datePublished\":\"2026-10-27T12:30:31+00:00\",\"dateModified\":\"2026-10-27T13:09:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/glavna-knjiga\\\/izvoz-podataka-iz-gk-na-web-mysql\\\/#breadcrumb\"},\"inLanguage\":\"hr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/glavna-knjiga\\\/izvoz-podataka-iz-gk-na-web-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/glavna-knjiga\\\/izvoz-podataka-iz-gk-na-web-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Baza znanja\",\"item\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Glavna knjiga\",\"item\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/docs\\\/rip-interna-baza-znanja\\\/glavna-knjiga\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Izvoz podataka iz GK na web &#8211; MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/#website\",\"url\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/\",\"name\":\"Dil-93\",\"description\":\"Informati\u010dki in\u017einjering i usluge\",\"publisher\":{\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/#organization\",\"name\":\"Dil-93 d.o.o.\",\"url\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hr\",\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/dil_logo_stari_cisti_favicon.png\",\"contentUrl\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/dil_logo_stari_cisti_favicon.png\",\"width\":512,\"height\":512,\"caption\":\"Dil-93 d.o.o.\"},\"image\":{\"@id\":\"https:\\\/\\\/dil-93.hr\\\/cro\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Izvoz podataka iz GK na web - MySQL - Dil-93","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/","og_locale":"hr_HR","og_type":"article","og_title":"Izvoz podataka iz GK na web - MySQL","og_description":"Za odraditi u DIL-u: 1. Otvoriti novog korisnika na web-u GK &#8211; Specifi\u010dnosti &#8211; mySQL korisni\u010dki ra\u010duni \u0160ifre ne smiju biti prejednostavne, da bi firme ne bi jedna drugoj gledale podatke, nikako ne i\u0107i logikom naziv firme\/ime djelatnika) Za odraditi kod korisnika: 1. Instalirati MySQL ODBC 5.1.6. win32 sa http:\/\/www.dil-93.hr\/old\/index.php\/preuzimanje-download&nbsp;proc broj 19. ili direktno pokrenite...","og_url":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/","og_site_name":"Dil-93","article_modified_time":"2026-10-27T13:09:25+00:00","twitter_card":"summary_large_image","twitter_misc":{"Procijenjeno vrijeme \u010ditanja":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/","url":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/","name":"Izvoz podataka iz GK na web - MySQL - Dil-93","isPartOf":{"@id":"https:\/\/dil-93.hr\/cro\/#website"},"datePublished":"2026-10-27T12:30:31+00:00","dateModified":"2026-10-27T13:09:25+00:00","breadcrumb":{"@id":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/#breadcrumb"},"inLanguage":"hr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/izvoz-podataka-iz-gk-na-web-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dil-93.hr\/cro\/"},{"@type":"ListItem","position":2,"name":"Baza znanja","item":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/"},{"@type":"ListItem","position":3,"name":"Glavna knjiga","item":"https:\/\/dil-93.hr\/cro\/docs\/rip-interna-baza-znanja\/glavna-knjiga\/"},{"@type":"ListItem","position":4,"name":"Izvoz podataka iz GK na web &#8211; MySQL"}]},{"@type":"WebSite","@id":"https:\/\/dil-93.hr\/cro\/#website","url":"https:\/\/dil-93.hr\/cro\/","name":"Dil-93","description":"Informati\u010dki in\u017einjering i usluge","publisher":{"@id":"https:\/\/dil-93.hr\/cro\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dil-93.hr\/cro\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hr"},{"@type":"Organization","@id":"https:\/\/dil-93.hr\/cro\/#organization","name":"Dil-93 d.o.o.","url":"https:\/\/dil-93.hr\/cro\/","logo":{"@type":"ImageObject","inLanguage":"hr","@id":"https:\/\/dil-93.hr\/cro\/#\/schema\/logo\/image\/","url":"https:\/\/dil-93.hr\/cro\/wp-content\/uploads\/2022\/04\/dil_logo_stari_cisti_favicon.png","contentUrl":"https:\/\/dil-93.hr\/cro\/wp-content\/uploads\/2022\/04\/dil_logo_stari_cisti_favicon.png","width":512,"height":512,"caption":"Dil-93 d.o.o."},"image":{"@id":"https:\/\/dil-93.hr\/cro\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":[],"comment_info":0,"comment_count":0,"_links":{"self":[{"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/docs\/5915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/comments?post=5915"}],"version-history":[{"count":1,"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/docs\/5915\/revisions"}],"predecessor-version":[{"id":6048,"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/docs\/5915\/revisions\/6048"}],"up":[{"embeddable":true,"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/docs\/5831"}],"wp:attachment":[{"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/media?parent=5915"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/dil-93.hr\/cro\/wp-json\/wp\/v2\/doc_tag?post=5915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}