{"id":1655,"date":"2009-12-09T23:45:27","date_gmt":"2009-12-09T22:45:27","guid":{"rendered":"http:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/"},"modified":"2009-12-09T23:45:27","modified_gmt":"2009-12-09T22:45:27","slug":"wil_importcsv-datenimport-fr-typo3","status":"publish","type":"post","link":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/","title":{"rendered":"wil_importcsv: Datenimport f&uuml;r TYPO3"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:642,&quot;href&quot;:&quot;http:\\\/\\\/typo3.org\\\/extensions\\\/repository\\\/view\\\/wil_importcsv\\\/current&quot;,&quot;archived_href&quot;:&quot;&quot;,&quot;redirect_href&quot;:&quot;https:\\\/\\\/typo3.org\\\/extensions\\\/repository\\\/view\\\/wil_importcsv\\\/current&quot;,&quot;checks&quot;:[],&quot;broken&quot;:false,&quot;last_checked&quot;:null,&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Screenshot: wil_importcsv\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" height=\"212\" alt=\"Screenshot: wil_importcsv\" src=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png\" width=\"420\" border=\"0\" \/><\/p>\n<p>Wie importiert man Daten, die in Form einer CSV-Datei vorliegen, in eine beliebige TYPO3-Datenbanktabelle? Beispielsweise mit der Extension <a href=\"http:\/\/typo3.org\/extensions\/repository\/view\/wil_importcsv\/current\/\" target=\"_blank\">wil_importcsv<\/a>. Das Vorgehen k\u00f6nnte nicht einfacher sein:<\/p>\n<ul>\n<li>Zun\u00e4chst wird im Seitenbaum diejenige Seite (kann auch ein SysFolder sein) ausgew\u00e4hlt, in die man die Daten importieren m\u00f6chte.<\/li>\n<li>Danach w\u00e4hlt man die zu importierende CSV-Datei, das darin verwendete Trennzeichen zwischen den Feldern (normalerweise ein Strichpunkt) sowie die Zieltabelle aus (vgl. Screenshot).<\/li>\n<li>Anschliessend erfolgt das Mapping, bei dem man die Felder der CSV-Datei (wird automatisch aus der ersten Zeile der CSV-Datei extrahiert) den Spalten der Datenbanktabelle zuordnet.<\/li>\n<li>Schliesslich erh\u00e4lt man eine tabellarische Vorschau des zu erwartenden Resultats und kann den Import per Knopfdruck ausl\u00f6sen.<\/li>\n<\/ul>\n<p>Die Extension installiert ein Modul im TYPO3-Backend, das auch f\u00fcr Nicht-Administratoren zug\u00e4nglich ist. In der Konfiguration kann man gewisse Einschr\u00e4nkungen vornehmen, beispielsweise dass normale Backend User nur in ausgew\u00e4hlte Datenbanktabellen importieren d\u00fcrfen.<\/p>\n<p>Die Extension hat insofern noch eine besondere Rafinesse, als die importierten Daten je nach dem nicht einfach der Datenbank hinzugef\u00fcgt werden, sondern dass bestehende Datens\u00e4tze mit der gleichen UID aktualisiert werden.<\/p>\n<p>Auf der anderen Seite habe ich aber auch einen Bug gefunden: Wenn die CSV-Datei nicht nur UIDs, sondern auch PID (Page IDs) enth\u00e4lt, werden die Daten nicht in die entsprechende Seite (und auch nicht in die ausgew\u00e4hlte Seite) importiert, sondern immer in die Seite mit der ID 1. Das Problem kann man nur umgehen, indem man die PID aus der CSV-Datei l\u00f6scht.<\/p>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Wie importiert man Daten, die in Form einer CSV-Datei vorliegen, in eine beliebige TYPO3-Datenbanktabelle? Beispielsweise mit der Extension wil_importcsv. Das Vorgehen k\u00f6nnte nicht einfacher sein: Zun\u00e4chst wird im Seitenbaum diejenige Seite (kann auch ein SysFolder sein) ausgew\u00e4hlt, in die man die Daten importieren m\u00f6chte. Danach w\u00e4hlt man die zu importierende CSV-Datei, das darin verwendete Trennzeichen &#8230; <a title=\"wil_importcsv: Datenimport f&uuml;r TYPO3\" class=\"read-more\" href=\"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/\" aria-label=\"Read more about wil_importcsv: Datenimport f&uuml;r TYPO3\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[5],"tags":[1483,1577,1576,1876,1575],"class_list":["post-1655","post","type-post","status-publish","format-standard","hentry","category-typo3","tag-csv","tag-datenaustausch","tag-import","tag-typo3","tag-wil_importcsv"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>wil_importcsv: Datenimport f&uuml;r TYPO3 - Open Mind<\/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:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"wil_importcsv: Datenimport f&uuml;r TYPO3 - Open Mind\" \/>\n<meta property=\"og:description\" content=\"Wie importiert man Daten, die in Form einer CSV-Datei vorliegen, in eine beliebige TYPO3-Datenbanktabelle? Beispielsweise mit der Extension wil_importcsv. Das Vorgehen k\u00f6nnte nicht einfacher sein: Zun\u00e4chst wird im Seitenbaum diejenige Seite (kann auch ein SysFolder sein) ausgew\u00e4hlt, in die man die Daten importieren m\u00f6chte. Danach w\u00e4hlt man die zu importierende CSV-Datei, das darin verwendete Trennzeichen ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/\" \/>\n<meta property=\"og:site_name\" content=\"Open Mind\" \/>\n<meta property=\"article:published_time\" content=\"2009-12-09T22:45:27+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png\" \/>\n<meta name=\"author\" content=\"The Open Source Guy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschrieben von\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Open Source Guy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/\"},\"author\":{\"name\":\"The Open Source Guy\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\"},\"headline\":\"wil_importcsv: Datenimport f&uuml;r TYPO3\",\"datePublished\":\"2009-12-09T22:45:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/\"},\"wordCount\":260,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/image4.png\",\"keywords\":[\"CSV\",\"Datenaustausch\",\"Import\",\"TYPO3\",\"wil_importcsv\"],\"articleSection\":[\"TYPO3\"],\"inLanguage\":\"de-CH\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/\",\"name\":\"wil_importcsv: Datenimport f&uuml;r TYPO3 - Open Mind\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/image4.png\",\"datePublished\":\"2009-12-09T22:45:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#breadcrumb\"},\"inLanguage\":\"de-CH\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-CH\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/image4.png\",\"contentUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/image4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2009\\\/12\\\/09\\\/wil_importcsv-datenimport-fr-typo3\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"wil_importcsv: Datenimport f&uuml;r TYPO3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#website\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/\",\"name\":\"Open Mind\",\"description\":\"Open Source &amp; Open Content\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de-CH\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\",\"name\":\"The Open Source Guy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-CH\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"contentUrl\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"caption\":\"The Open Source Guy\"},\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"wil_importcsv: Datenimport f&uuml;r TYPO3 - Open Mind","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:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/","og_locale":"de_DE","og_type":"article","og_title":"wil_importcsv: Datenimport f&uuml;r TYPO3 - Open Mind","og_description":"Wie importiert man Daten, die in Form einer CSV-Datei vorliegen, in eine beliebige TYPO3-Datenbanktabelle? Beispielsweise mit der Extension wil_importcsv. Das Vorgehen k\u00f6nnte nicht einfacher sein: Zun\u00e4chst wird im Seitenbaum diejenige Seite (kann auch ein SysFolder sein) ausgew\u00e4hlt, in die man die Daten importieren m\u00f6chte. Danach w\u00e4hlt man die zu importierende CSV-Datei, das darin verwendete Trennzeichen ... Read more","og_url":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/","og_site_name":"Open Mind","article_published_time":"2009-12-09T22:45:27+00:00","og_image":[{"url":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png","type":"","width":"","height":""}],"author":"The Open Source Guy","twitter_card":"summary_large_image","twitter_misc":{"Geschrieben von":"The Open Source Guy","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#article","isPartOf":{"@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/"},"author":{"name":"The Open Source Guy","@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793"},"headline":"wil_importcsv: Datenimport f&uuml;r TYPO3","datePublished":"2009-12-09T22:45:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/"},"wordCount":260,"commentCount":0,"image":{"@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#primaryimage"},"thumbnailUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png","keywords":["CSV","Datenaustausch","Import","TYPO3","wil_importcsv"],"articleSection":["TYPO3"],"inLanguage":"de-CH","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/","url":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/","name":"wil_importcsv: Datenimport f&uuml;r TYPO3 - Open Mind","isPartOf":{"@id":"https:\/\/www.workshop.ch\/openmind\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#primaryimage"},"image":{"@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#primaryimage"},"thumbnailUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png","datePublished":"2009-12-09T22:45:27+00:00","author":{"@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793"},"breadcrumb":{"@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#breadcrumb"},"inLanguage":"de-CH","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/"]}]},{"@type":"ImageObject","inLanguage":"de-CH","@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#primaryimage","url":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png","contentUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2009\/12\/image4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.workshop.ch\/openmind\/2009\/12\/09\/wil_importcsv-datenimport-fr-typo3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.workshop.ch\/openmind\/"},{"@type":"ListItem","position":2,"name":"wil_importcsv: Datenimport f&uuml;r TYPO3"}]},{"@type":"WebSite","@id":"https:\/\/www.workshop.ch\/openmind\/#website","url":"https:\/\/www.workshop.ch\/openmind\/","name":"Open Mind","description":"Open Source &amp; Open Content","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.workshop.ch\/openmind\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de-CH"},{"@type":"Person","@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793","name":"The Open Source Guy","image":{"@type":"ImageObject","inLanguage":"de-CH","@id":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","url":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","contentUrl":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","caption":"The Open Source Guy"},"url":"https:\/\/www.workshop.ch\/openmind"}]}},"_links":{"self":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/1655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/comments?post=1655"}],"version-history":[{"count":0,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/1655\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/media?parent=1655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/categories?post=1655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/tags?post=1655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}