{"id":6296,"date":"2024-11-26T18:21:08","date_gmt":"2024-11-26T16:21:08","guid":{"rendered":"http:\/\/www.ramses.de\/?p=6296"},"modified":"2024-12-13T08:10:01","modified_gmt":"2024-12-13T06:10:01","slug":"faq-access-konventionen-fuer-feldnamen-3","status":"publish","type":"post","link":"https:\/\/www.ramses.de\/?p=6296","title":{"rendered":"FAQ Access &#8211; Anpassung der Importspezifikationen"},"content":{"rendered":"<div>\n<h1>Access Grundlagen &#8211; Import von Daten<\/h1>\n<\/div>\n<div>\n<h2><strong>Problem <\/strong><\/h2>\n<p>Nach dem Import von Daten kann die entsprechene Art und Weise in einer Importspezifikation gespeichert werden.<\/p>\n<\/div>\n<p>Was aber, wenn diese Spezifikation im Nachgang angepasst werden muss<\/p>\n<div>\n<h2><strong>L\u00f6sung <\/strong><\/h2>\n<\/div>\n<p>Die Spezifikation sind in einer versteckten Tabelle gespeichert. Im ersten Schritt machen wir die ausgeblendeten Objekte sichtbar.<\/p>\n<p><a href=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6297\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import01.jpg\" alt=\"\" width=\"386\" height=\"230\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import01.jpg 386w, https:\/\/www.ramses.de\/wp-content\/uploads\/Import01-300x179.jpg 300w\" sizes=\"auto, (max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import02-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6299\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import02-1.jpg\" alt=\"\" width=\"651\" height=\"452\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import02-1.jpg 651w, https:\/\/www.ramses.de\/wp-content\/uploads\/Import02-1-300x208.jpg 300w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p>Nun haben wir zwei Tabellen, die uns interessieren<\/p>\n<ul>\n<li>MSysIMEXSpecs<br \/>\nDie Importspezifikation an sich<\/li>\n<li>MSysIMEXColumns<br \/>\nDie Spalten der Importspezifikation<\/li>\n<\/ul>\n<p>Gerade die Felddatentypen und die Gr\u00f6\u00dfen der Felder lassen sich hier leicht anpassen.<\/p>\n<p><a href=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import03.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-6300\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import03-1024x463.jpg\" alt=\"\" width=\"900\" height=\"407\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/Import03-1024x463.jpg 1024w, https:\/\/www.ramses.de\/wp-content\/uploads\/Import03-300x136.jpg 300w, https:\/\/www.ramses.de\/wp-content\/uploads\/Import03-768x347.jpg 768w, https:\/\/www.ramses.de\/wp-content\/uploads\/Import03.jpg 1376w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/a><\/p>\n<p>Nat\u00fcrlich ist es denkbar, hierf\u00fcr ein ein Formular zu erstellen.<\/p>\n<p>Die angezeigten Felddatentypen bedeuten folgendes:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>DataType<\/strong><\/th>\n<th><strong>Datentyp<\/strong><\/th>\n<\/tr>\n<\/thead>\n<\/table>\n<div>\n<table>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Text<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>2<\/td>\n<td>Memo (Langtext in neueren Versionen)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>3<\/td>\n<td>Long Integer (Ganzzahl, 4 Byte)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>4<\/td>\n<td>Single (Gleitkommazahl, 4 Byte)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>5<\/td>\n<td>Double (Gleitkommazahl, 8 Byte)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>6<\/td>\n<td>Currency (W\u00e4hrung)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>7<\/td>\n<td>Date\/Time (Datum\/Uhrzeit)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>8<\/td>\n<td>Binary (Bin\u00e4rdaten)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>9<\/td>\n<td>Yes\/No (Ja\/Nein, Boolean)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>10<\/td>\n<td>GUID<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>11<\/td>\n<td>Decimal (Dezimalzahl)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>12<\/td>\n<td>Byte<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>13<\/td>\n<td>Integer (Ganzzahl, 2 Byte)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>\n<table>\n<tbody>\n<tr>\n<td>14<\/td>\n<td>VarBinary (Variable Bin\u00e4rdaten)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Access Grundlagen &#8211; Import von Daten Problem Nach dem Import von Daten kann die entsprechene Art und Weise in einer Importspezifikation gespeichert werden. Was aber, &#8230; <a title=\"FAQ Access &#8211; Anpassung der Importspezifikationen\" class=\"read-more\" href=\"https:\/\/www.ramses.de\/?p=6296\" aria-label=\"Mehr Informationen \u00fcber FAQ Access &#8211; Anpassung der Importspezifikationen\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":6300,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47,43],"tags":[58],"class_list":["post-6296","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-access","category-faq","tag-access-2010","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/6296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6296"}],"version-history":[{"count":2,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/6296\/revisions"}],"predecessor-version":[{"id":6304,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/6296\/revisions\/6304"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/media\/6300"}],"wp:attachment":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}