{"id":1452,"date":"2012-11-06T20:23:09","date_gmt":"2012-11-06T20:23:09","guid":{"rendered":"https:\/\/markus-schall.de\/?p=1452"},"modified":"2025-10-09T08:32:38","modified_gmt":"2025-10-09T08:32:38","slug":"sql-rozhrani-z-filemakeru-do-shop-cms-nebo-jinych-databazi","status":"publish","type":"post","link":"https:\/\/www.markus-schall.de\/cs\/2012\/11\/sql-rozhrani-z-filemakeru-do-shop-cms-nebo-jinych-databazi\/","title":{"rendered":"SQL rozhran\u00ed z FileMaker do obchodu, CMS nebo jin\u00fdch datab\u00e1z\u00ed"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1455\" title=\"Konference FileMaker: Prezentace o rozhran\u00edch pro FileMaker\" src=\"https:\/\/markus-schall.de\/wp-content\/uploads\/fmk-2012_filemaker-schnittstellen.jpg\" alt=\"Konference FileMaker: Prezentace o rozhran\u00edch pro FileMaker\" width=\"201\" height=\"150\" srcset=\"https:\/\/www.markus-schall.de\/wp-content\/uploads\/fmk-2012_filemaker-schnittstellen.jpg 201w, https:\/\/www.markus-schall.de\/wp-content\/uploads\/fmk-2012_filemaker-schnittstellen-16x12.jpg 16w\" sizes=\"auto, (max-width: 201px) 100vw, 201px\" \/>Na leto\u0161n\u00ed konferenci FileMaker v Salcburku jsem p\u0159ednesl prezentaci o tom, jak propojit datab\u00e1zi FileMaker s jin\u00fdmi syst\u00e9my, jako jsou internetov\u00e9 obchody, syst\u00e9my pro spr\u00e1vu obsahu jako WordPress nebo Typo3 nebo jin\u00e9 datab\u00e1ze SQL. Ve sv\u00e9 prezentaci jsem jako p\u0159\u00edklad pou\u017eil p\u0159ipojen\u00ed z FileMaker k internetov\u00e9mu obchodu xt:Commerce nebo Gambio. Uk\u00e1\u017eu v\u00e1m metodu, jak snadno integrovat jakoukoli extern\u00ed datab\u00e1zi, ke kter\u00e9 lze p\u0159istupovat prost\u0159ednictv\u00edm ODBC, do datab\u00e1ze FileMaker. T\u00edmto zp\u016fsobem lze do \u0159e\u0161en\u00ed FileMaker integrovat data z nejr\u016fzn\u011bj\u0161\u00edch syst\u00e9m\u016f t\u0159et\u00edch stran a p\u0159en\u00e9st je na stoln\u00ed po\u010d\u00edta\u010d PC nebo Mac a pomoc\u00ed FileMaker Go i na iPad, iPhone nebo iPod touch.<!--more--><\/p>\n<p>Ve sv\u00e9m workshopu vysv\u011btl\u00edm, jak lze internetov\u00fd obchod (nap\u0159. xt:Commerce nebo Gambio) p\u0159ipojit k datab\u00e1zi FileMaker. Nejprve uk\u00e1\u017eu, jak lze datab\u00e1zov\u00e9 tabulky z internetov\u00fdch obchod\u016f zalo\u017een\u00fdch na datab\u00e1zi MySQL v\u010detn\u011b jejich obsahu p\u0159en\u00e9st do libovoln\u00e9 datab\u00e1ze FileMaker pomoc\u00ed n\u011bkolika kliknut\u00ed my\u0161\u00ed. Na z\u00e1klad\u011b datov\u00fdch tabulek p\u0159enesen\u00fdch do FileMaker lze pak realizovat skriptem \u0159\u00edzen\u00e9 p\u0159ipojen\u00ed k libovoln\u00e9 existuj\u00edc\u00ed datab\u00e1zi FileMaker. Workshop ukazuje, jak lze \u010dl\u00e1nky z FileMaker exportovat do internetov\u00e9ho obchodu pouh\u00fdm stisknut\u00edm tla\u010d\u00edtka a jak lze z internetov\u00e9ho obchodu importovat objedn\u00e1vky a \u00fadaje o z\u00e1kazn\u00edc\u00edch do datab\u00e1ze FileMaker.<\/p>\n<p>S takov\u00fdm \u0159e\u0161en\u00edm lze v\u00fdrazn\u011b zjednodu\u0161it spr\u00e1vu internetov\u00e9ho obchodu a automatizovat opakuj\u00edc\u00ed se provozn\u00ed procesy, jako je evidence \u00fadaj\u016f o z\u00e1kazn\u00edc\u00edch a objedn\u00e1vk\u00e1ch v FileMaker.<\/p>\n<p><strong>P\u0159ehled t\u00e9mat:<\/strong><\/p>\n<ul>\n<li>P\u0159\u00edstup k datab\u00e1z\u00edm MySQL pomoc\u00ed ODBC<\/li>\n<li>Nastaven\u00ed datov\u00e9ho zdroje ODBC v syst\u00e9mech Mac OS X a Windows<\/li>\n<li>P\u0159enos datov\u00fdch tabulek z internetov\u00e9ho obchodu do FileMaker<\/li>\n<li>Skriptem \u0159\u00edzen\u00e9 p\u0159ipojen\u00ed dat obchodu k libovoln\u00e9 datab\u00e1zi FileMaker<\/li>\n<li>Vytv\u00e1\u0159en\u00ed a zm\u011bna datov\u00fdch z\u00e1znam\u016f v datab\u00e1zi MySQL z FileMaker<\/li>\n<\/ul>\n<div style=\"margin-bottom: 5px;\"><strong> <a title=\"FMK2012: Rozhran\u00ed z FileMaker na syst\u00e9my internetov\u00fdch obchod\u016f z Markus Schall\" href=\"http:\/\/de.slideshare.net\/fmkonferenz\/fmk2012-xtcommerce\" target=\"_blank\" rel=\"noopener\">FMK2012: Rozhran\u00ed z FileMaker na syst\u00e9my internetov\u00fdch obchod\u016f z Markus Schall<\/a><\/strong><\/div>\n<div style=\"margin-bottom: 5px;\">z\u00a0<strong><a href=\"http:\/\/de.slideshare.net\/fmkonferenz\" target=\"_blank\" rel=\"noopener\">Asociace pro konference FM<\/a><\/strong><\/div>\n<div style=\"margin-bottom: 5px;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Na leto\u0161n\u00ed konferenci FileMaker v Salcburku jsem p\u0159ednesl prezentaci o tom, jak propojit datab\u00e1zi FileMaker s jin\u00fdmi syst\u00e9my, jako jsou internetov\u00e9 obchody, syst\u00e9my pro spr\u00e1vu obsahu jako WordPress nebo Typo3 nebo jin\u00e9 datab\u00e1ze SQL. Ve sv\u00e9 prezentaci jsem jako p\u0159\u00edklad pou\u017eil p\u0159ipojen\u00ed z FileMaker k internetov\u00e9mu obchodu xt:Commerce nebo Gambio. Uk\u00e1zal jsem, jak\u00fdm zp\u016fsobem lze v r\u00e1mci tohoto syst\u00e9mu vytvo\u0159it ... <a title=\"SQL rozhran\u00ed z FileMaker do obchodu, CMS nebo jin\u00fdch datab\u00e1z\u00ed\" class=\"read-more\" href=\"https:\/\/www.markus-schall.de\/cs\/2012\/11\/sql-rozhrani-z-filemakeru-do-shop-cms-nebo-jinych-databazi\/\" aria-label=\"\u010c\u00edst v\u00edce o SQL rozhran\u00ed z FileMaker do obchodu, CMS nebo jin\u00fdch datab\u00e1z\u00ed\">\u010c\u00edst d\u00e1l<\/a><\/p>","protected":false},"author":1,"featured_media":1428,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":6,"footnotes":""},"categories":[3],"tags":[410],"class_list":["post-1452","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemaker","tag-filemaker"],"_links":{"self":[{"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/posts\/1452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/comments?post=1452"}],"version-history":[{"count":2,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/posts\/1452\/revisions"}],"predecessor-version":[{"id":2714,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/posts\/1452\/revisions\/2714"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/media\/1428"}],"wp:attachment":[{"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/media?parent=1452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/categories?post=1452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markus-schall.de\/cs\/wp-json\/wp\/v2\/tags?post=1452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}