{"id":2300,"date":"2013-03-11T15:44:48","date_gmt":"2013-03-11T15:44:48","guid":{"rendered":"https:\/\/gofilemaker.de\/?p=2300"},"modified":"2022-03-29T06:27:52","modified_gmt":"2022-03-29T05:27:52","slug":"filemaker-short-tip-importing-entire-data-tables","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/en\/2013\/03\/filemaker-short-tip-importing-entire-data-tables\/","title":{"rendered":"FileMaker Quick Tip: Importing entire data tables"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft size-full wp-image-2301\" title=\"FileMaker Quick Tip: Importing tables into a FileMaker database\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/gofilemaker_kurztipp1.jpg\" alt=\"FileMaker Quick Tip: Importing tables into a FileMaker database\" width=\"150\" height=\"150\">Anyone who develops FileMaker databases will sooner or later want to import data tables from one solution to another, and not just once. It can also happen that data tables from other database systems such as mySQL or others are imported via <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/odbc\/\" target=\"_self\" title=\"What is ODBC in relation to FileMaker? ODBC (Open Database Connectivity)...\" class=\"encyclopedia\">ODBC<\/a> addressable databases are to be transferred. With the current FileMaker versions, a <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/table\/\" target=\"_self\" title=\"What is a table in FileMaker? A table is used in FileMaker...\" class=\"encyclopedia\">Table<\/a> of another system, including field definitions and all the information they contain, can be easily imported in one go using the import function.<\/p>\n<p>For this purpose, first open the FileMaker<a href=\"https:\/\/gofilemaker.de\/en\/glossary\/database\/\" target=\"_self\" title=\"What is a database? A database (database system, DBS) is understood to be...\" class=\"encyclopedia\">Database<\/a>into which a table from a third-party system is to be imported. Now select<\/p>\n<pre>File &gt; Import data records &gt; File.<\/pre>\n<p>Now select the table to be imported in the left-hand column under \"Source\" in the dialog for the field assignment. In the right-hand column, select the entry \"New table\" under \"Target\". After the import has been started, FileMaker automatically creates a new table in the target file with all the fields that are in the source table. This procedure also works smoothly with external tables. <a href=\"https:\/\/gofilemaker.de\/en\/glossary\/sql\/\" target=\"_self\" title=\"What is SQL and what is SQL used for? SQL (Structured...\" class=\"encyclopedia\">SQL<\/a>-databases via ODBC. You can then rename the newly imported table in the database definition and use the table immediately in your FileMaker database.<\/p>\n<figure id=\"attachment_8342\" aria-describedby=\"caption-attachment-8342\" style=\"width: 468px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/gofilemaker.de\/en\/filemaker\/training-coaching\/\"><img decoding=\"async\" class=\"wp-image-8342\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/468x60r_training_coaching.gif\" alt=\"FileMaker Training and Coaching\" width=\"468\" height=\"60\"><\/a><figcaption id=\"caption-attachment-8342\" class=\"wp-caption-text\">Display<\/figcaption><\/figure>","protected":false},"excerpt":{"rendered":"<p>Wer FileMaker-Datenbanken entwickelt, wird \u00fcber kurz oder lang und nicht nur einmal Datentabellen von einer L\u00f6sung in eine andere importieren wollen. Au\u00dferdem kann es vorkommen, dass Datentabellen aus anderen Datenbanksystemen wie z.B. mySQL oder anderen \u00fcber ODBC ansprechbare Datenbanken \u00fcbernommen werden sollen. Mit den aktuellen FileMaker-Versionen kann eine Tabelle eines anderen Systems inklusive Felddefinitionen und [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":32984,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":15,"footnotes":""},"categories":[1,5],"tags":[],"class_list":["post-2300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemakerpro","category-tipps-anleitungen"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts\/2300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/users\/187"}],"replies":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/comments?post=2300"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/posts\/2300\/revisions"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/media?parent=2300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/categories?post=2300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/en\/wp-json\/wp\/v2\/tags?post=2300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}