{"id":274,"date":"2011-01-09T17:14:56","date_gmt":"2011-01-09T17:14:56","guid":{"rendered":"https:\/\/gofilemaker.de\/?p=274"},"modified":"2022-03-29T07:51:15","modified_gmt":"2022-03-29T06:51:15","slug":"automaticky-z-microsoft-access-do-filemaker-pro","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/cs\/2011\/01\/automaticky-z-microsoft-access-do-filemaker-pro\/","title":{"rendered":"Automaticky z Microsoft Access do FileMaker Pro."},"content":{"rendered":"<p>V posledn\u00edch letech mnoho spole\u010dnost\u00ed pracovalo v\u00fdhradn\u011b se syst\u00e9mem Windows a \u010dasto s datab\u00e1zemi pod. <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/microsoft-access\/\" target=\"_self\" title=\"Microsoft Access je rela\u010dn\u00ed syst\u00e9m pro spr\u00e1vu datab\u00e1z\u00ed (DBMS) od spole\u010dnosti Microsoft, s jeho\u017e pomoc\u00ed lze...\" class=\"encyclopedia\">Microsoft Access<\/a>Visual FoxPro nebo na <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/sql\/\" target=\"_self\" title=\"Co je SQL a k \u010demu se pou\u017e\u00edv\u00e1? SQL (Structured...\" class=\"encyclopedia\">SQL<\/a>-z\u00e1klad. Nejen v\u00fdrazn\u011b vy\u0161\u0161\u00ed flexibilita FileMakeru, ale tak\u00e9 neust\u00e1le rostouc\u00ed z\u00e1jem o platformu Apple zaji\u0161\u0165uj\u00ed, \u017ee se FileMaker dost\u00e1v\u00e1 st\u00e1le v\u00edce do pop\u0159ed\u00ed z\u00e1jmu firem v N\u011bmecku. Jak v\u0161ak lze \u0159e\u0161en\u00ed, kter\u00e9 bylo d\u0159\u00edve vyvinuto pod Microsoft Access, Visual FoxPro nebo na b\u00e1zi SQL, p\u0159ev\u00e9st na FileMaker? \u010cist\u011b manu\u00e1ln\u00ed migrace - tedy nov\u00fd v\u00fdvoj - je samoz\u0159ejm\u011b v\u017edy mo\u017en\u00e1, ale je tak\u00e9 mimo\u0159\u00e1dn\u011b \u010dasov\u011b n\u00e1ro\u010dn\u00e1. K tomuto \u00fa\u010delu je k dispozici n\u00e1stroj FmPro Migrator, s jeho\u017e pomoc\u00ed lze migraci z Microsoft Access, Visual FoxPro, Firebird a SQL-.<a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/server\/\" target=\"_self\" title=\"Co je to server? V prost\u0159ed\u00ed FileMakeru je server...\" class=\"encyclopedia\">Server<\/a> (a naopak) je zna\u010dn\u011b usnadn\u011bna. <!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<h3>Migra\u010dn\u00ed n\u00e1stroj FileMaker pro v\u0161echny p\u0159\u00edpady<\/h3>\n<p>FmPro Migrator od spole\u010dnosti .com Solutions Inc. umo\u017e\u0148uje \u0161irokou \u0161k\u00e1lu mo\u017enost\u00ed p\u0159evodu datab\u00e1z\u00ed - podrobn\u011bji jsou to n\u00e1sleduj\u00edc\u00ed mo\u017enosti:<\/p>\n<ul>\n<li>P\u0159evod datab\u00e1z\u00ed Microsoft Access na FileMaker Pro (v\u010detn\u011b formul\u00e1\u0159\u016f a sestav)<\/li>\n<li>Datab\u00e1ze Microsoft Visual FoxPro do FileMaker Pro<\/li>\n<li>Firebird a SQL Server do FileMaker Pro (datov\u00e9 tabulky)<\/li>\n<li>FileMaker Pro 2-11 do SQL-<a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/databaze\/\" target=\"_self\" title=\"Co je to datab\u00e1ze? Datab\u00e1z\u00ed (datab\u00e1zov\u00fdm syst\u00e9mem, DBS) se rozum\u00ed...\" class=\"encyclopedia\">Datab\u00e1ze<\/a> (nap\u0159. MySQL, Oracle, Access, MS SQL Server atd.)<\/li>\n<li>Opakov\u00e1n\u00ed pol\u00ed z datab\u00e1ze FileMaker do datab\u00e1ze SQL<\/li>\n<li>Export obr\u00e1zk\u016f z pol\u00ed kontejneru FileMaker<\/li>\n<li>Export rozvr\u017een\u00ed FileMaker Pro do HTML, XML, formul\u00e1\u0159\u016f\/report\u016f Access, projekt\u016f Visual Studio 2010, .Net 4 a Servoy<\/li>\n<li>P\u0159ev\u00e1d\u00ed projekty FileMaker Pro, Microsoft Access a Visual FoxPro na plnohodnotn\u00e9 aplikace LiveCode.<\/li>\n<li>Automatizuje FileMaker p\u0159i vytv\u00e1\u0159en\u00ed vztah\u016f, TO a rozvr\u017een\u00ed.<\/li>\n<\/ul>\n<p>FmPro Migrator je samostatn\u00e1 aplikace pro Mac OS X nebo Windows, kter\u00e1 rychle a spolehliv\u011b p\u0159ev\u00e1d\u00ed datab\u00e1ze FileMaker Pro do MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite a Valentina. Cel\u00e1 struktura datab\u00e1ze z FileMakeru je automaticky p\u0159evedena do odpov\u00eddaj\u00edc\u00edch datov\u00fdch tabulek c\u00edlov\u00e9 datab\u00e1ze. Zohledn\u011bna jsou velk\u00e1 textov\u00e1 pole i opakuj\u00edc\u00ed se nebo kontejnerov\u00e1 pole.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-284\" title=\"fmpromigrator_1\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/fmpromigrator_1.jpg\" alt=\"Sn\u00edmek obrazovky FMPro Migrator\" width=\"620\" height=\"597\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/fmpromigrator_1.jpg 620w, https:\/\/gofilemaker.de\/wp-content\/uploads\/fmpromigrator_1-300x288.jpg 300w\" sizes=\"(max-width: 620px) 100vw, 620px\"><\/p>\n<h3>Migrace aplikace FileMaker do aplikace FileMaker<\/h3>\n<p>Pomoc\u00ed funkce \"Konsolidace tabulek\" lze kop\u00edrovat tabulky, TO, vztahy, data, skripty a rozvr\u017een\u00ed mezi libovoln\u00fdmi datab\u00e1zemi FileMaker (verze 8-11). Tato funkce je obzvl\u00e1\u0161t\u011b u\u017eite\u010dn\u00e1, pokud se nap\u0159\u00edklad \u0159e\u0161en\u00ed s n\u011bkolika soubory m\u00e1 p\u0159ev\u00e9st na \u0159e\u0161en\u00ed s jedn\u00edm souborem. D\u00edky t\u00e9to funkci mohou v\u00fdvoj\u00e1\u0159i t\u011b\u017eit z vy\u0161\u0161\u00edho v\u00fdkonu a nov\u00e9ho modelu zabezpe\u010den\u00ed implementovan\u00e9ho ve FileMakeru od verze 7. Z tohoto d\u016fvodu je tato funkce vhodn\u00e1 zejm\u00e9na pro p\u0159evod \u0159e\u0161en\u00ed ze star\u0161\u00edch verz\u00ed aplikace FileMaker (do verze 6.0) na nov\u011bj\u0161\u00ed verzi. <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/format-fp7\/\" target=\"_self\" title=\"Co je to form\u00e1t .fp7 od spole\u010dnosti FileMaker? Form\u00e1t souboru s...\" class=\"encyclopedia\">Form\u00e1t 7. RP<\/a> p\u0159ev\u00e9st. FmPro Migrator Developer Edition pou\u017e\u00edv\u00e1 pro p\u0159evod d\u00e1vkov\u00e9 n\u00e1stroje, QuickKeys pod Mac OS X a WinAutomation pod Windows. T\u00edmto zp\u016fsobem lze do p\u0159ev\u00e1d\u011bn\u00e9ho \u0159e\u0161en\u00ed automaticky p\u0159ev\u00e9st tabulky a pole, TO, vztahy, seznamy hodnot, vlastn\u00ed funkce, rozvr\u017een\u00ed a skripty. B\u011bhem procesu migrace se TO a odkazy na soubory automaticky p\u0159enesou do nov\u00e9 struktury datab\u00e1ze a p\u0159i\u0159ad\u00ed se jednotliv\u00fdm rozvr\u017een\u00edm.<\/p>\n<h3>P\u0159evod z Microsoft Access do FileMakeru<\/h3>\n<p>FmPro Migrator lze zakoupit ve dvou r\u016fzn\u00fdch edic\u00edch. Edice Platinum zahrnuje v\u0161echny funkce edice Developer, ale tak\u00e9 p\u0159evod \u0159e\u0161en\u00ed pod Microsoft Access do FileMakeru a naopak, p\u0159evod \u0159e\u0161en\u00ed MS Access a FileMaker na pln\u011b funk\u010dn\u00ed a s\u00ed\u0165ov\u011b kompatibiln\u00ed aplikace LiveCode. Tyto funkce lze tak\u00e9 licencovat samostatn\u011b s edic\u00ed Developer Edition programu FmPro Migrator.<\/p>\n<h4>Funkce p\u0159evodu z Accessu do FileMakeru<\/h4>\n<ul>\n<li>Automatick\u00fd p\u0159evod formul\u00e1\u0159\u016f, sestav a podformul\u00e1\u0159\u016f do rozvr\u017een\u00ed a port\u00e1l\u016f FileMakeru. Formul\u00e1\u0159e a sestavy jsou p\u0159evedeny na rozvr\u017een\u00ed FileMaker b\u011bhem n\u011bkolika sekund.<\/li>\n<li>P\u0159evod funkc\u00ed Visual Basicu do komentovan\u00fdch skript\u016f FileMakeru<\/li>\n<li>P\u0159evod seskupen\u00fdch r\u00e1diov\u00fdch tla\u010d\u00edtek a za\u0161krt\u00e1vac\u00edch pol\u00ed\u010dek na pole na rozvr\u017een\u00edch se seznamy ulo\u017een\u00fdch hodnot<\/li>\n<li>P\u0159evod grafu vztah\u016f Access na graf vztah\u016f FileMaker<\/li>\n<li>P\u0159evod seznam\u016f hodnot Access na seznamy hodnot FileMaker<\/li>\n<li>Migrace vlo\u017een\u00fdch obr\u00e1zk\u016f a grafick\u00fdch prvk\u016f ve formul\u00e1\u0159\u00edch Access do objekt\u016f rozvr\u017een\u00ed FileMaker<\/li>\n<li>P\u0159evod dotaz\u016f SQL aplikace Access do TO a skript\u016f FileMakeru<\/li>\n<li>Nahrazen\u00ed p\u00edsem pouze pro syst\u00e9m Windows v p\u00edsmech nez\u00e1visl\u00fdch na platform\u011b pomoc\u00ed editoru Hled\u00e1n\u00ed a nahrazov\u00e1n\u00ed<\/li>\n<\/ul>\n<h4>Nepodporovan\u00e9 objekty Access p\u0159i p\u0159evodu<\/h4>\n<ul>\n<li>Vlo\u017een\u00e9 objekty Page#, Date, Record (zde se do rozvr\u017een\u00ed vlo\u017e\u00ed pouze text objektu)<\/li>\n<li>Graf (nen\u00ed mo\u017en\u00e9, proto\u017ee FileMaker podporuje plnou podporu graf\u016f pouze prost\u0159ednictv\u00edm z\u00e1suvn\u00fdch modul\u016f t\u0159et\u00edch stran)<\/li>\n<li>acCustomControl (ovl\u00e1dac\u00ed prvky ActiveX nejsou kompatibiln\u00ed)<\/li>\n<li>Po\u0159ad\u00ed TAB u objekt\u016f rozvr\u017een\u00ed<\/li>\n<li>stohov\u00e1n\u00ed objekt\u016f rozvr\u017een\u00ed v po\u0159ad\u00ed z<\/li>\n<li>Objekty rozvr\u017een\u00ed d\u00edlu<\/li>\n<\/ul>\n<p>Platinov\u00e1 edice programu FmPro Migrator tak nab\u00edz\u00ed rozs\u00e1hlou a automatickou konverzi datab\u00e1z\u00ed Access (.mdb\/.accdb) do datab\u00e1z\u00ed FileMaker za pevnou cenu. Na rozd\u00edl od aplikace Microsoft Access, kter\u00e1 umo\u017e\u0148uje maxim\u00e1ln\u011b 2 GB na soubor a 255 pol\u00ed, nab\u00edz\u00ed FileMaker zcela nov\u00e9 mo\u017enosti pro v\u00fdvoj\u00e1\u0159e s maximem 8 TB a libovoln\u00fdm po\u010dtem pol\u00ed a tak\u00e9 nez\u00e1vislost na platform\u011b. Podrobn\u00e9 informace o p\u0159evodu datab\u00e1z\u00ed Access na datab\u00e1ze FileMaker naleznete na str\u00e1nce <strong><a title=\"Informace o p\u0159evodu z Accessu do FileMakeru\" href=\"http:\/\/www.fmpromigrator.com\/services\/access_to_fmpro_service.html\" target=\"_blank\" rel=\"nofollow noopener\">Webov\u00e9 str\u00e1nky<\/a><\/strong> v\u00fdrobce.<\/p>\n<h3>Licencov\u00e1n\u00ed a ceny<\/h3>\n<p>FmPro Migrator Developer Edition lze zakoupit od v\u00fdrobce za cenu 200 americk\u00fdch dolar\u016f pro Mac OS X a Windows jako licenci pro jednoho u\u017eivatele. Verze Platinum Edition, kter\u00e1 podporuje tak\u00e9 p\u0159evod z aplikace Access do aplikace FileMaker Pro, z aplikace FileMaker Pro do aplikace Access (neomezen\u011b) a z datab\u00e1ze do aplikace LiveCode, stoj\u00ed 600 americk\u00fdch dolar\u016f jako licence pro jednoho u\u017eivatele. Aplikaci FmPro Migrator lze st\u00e1hnout z t\u00e9to str\u00e1nky <strong><a title=\"Objednat FmPro Migrator od spole\u010dnosti .com Solutions Inc.\" href=\"http:\/\/www.fmpromigrator.com\/order\/index.html#fmpro_migrator\" target=\"_blank\" rel=\"nofollow noopener\">Webov\u00e9 str\u00e1nky<\/a><\/strong> lze objednat p\u0159\u00edmo u spole\u010dnosti .com Solutions Inc. a zaplatit kreditn\u00ed kartou.<\/p>","protected":false},"excerpt":{"rendered":"<p>Viele Unternehmen haben in den letzten Jahren ausschlie\u00dflich mit Windows und oftmals mit Datenbanken unter Microsoft Access, Visual FoxPro oder auf SQL-Basis gearbeitet. Nicht nur die deutlich erh\u00f6hte Flexibilit\u00e4t von FileMaker, auch das stetig steigende Interesse an der Apple-Plattform sorgen daf\u00fcr, da\u00df FileMaker immer mehr in den Fokus von Unternehmen in Deutschland r\u00fcckt. Doch wie [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":291,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":20,"footnotes":""},"categories":[1,47],"tags":[],"class_list":["post-274","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemakerpro","category-tools-utilities"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts\/274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/users\/187"}],"replies":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/comments?post=274"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts\/274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media\/291"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media?parent=274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/categories?post=274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/tags?post=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}