{"id":5732,"date":"2015-06-18T19:04:13","date_gmt":"2015-06-18T17:04:13","guid":{"rendered":"http:\/\/blog.wenzlaff.de\/?p=5732"},"modified":"2022-03-16T18:48:04","modified_gmt":"2022-03-16T17:48:04","slug":"csv-testdaten-generator-oder-wer-testet-ist-feige-nein-und-mehr-tools-fuer-csv-to","status":"publish","type":"post","link":"http:\/\/blog.wenzlaff.de\/?p=5732","title":{"rendered":"CSV Testdaten Generator (Oder wer testet ist feige? NEIN) und mehr Tools f\u00fcr CSV to &#8230;"},"content":{"rendered":"<p>Mit dem <a href=\"https:\/\/www.convertcsv.com\/generate-test-data.htm\" target=\"_blank\" rel=\"noopener\">CSV-Testdaten-Generator<\/a> kann schnell und einfach jegliche Art von Testdaten erzeugt werden. Die dann leicht in JUnit und sonstwie weiterverwendet werden k\u00f6nnen.<\/p>\n<p>Auch andere <a href=\"https:\/\/www.convertcsv.com\/\" target=\"_blank\" rel=\"noopener\">gute Tools<\/a> f\u00fcr die Bearbeitung von CSVs sind dort zu finden. z.B.<\/p>\n<ul>\n<li>Convert CSV To Delimited &#8211; reformat, filter, and sort delimited data<\/li>\n<li>Convert CSV To Fixed Width or ASCII Table<\/li>\n<li>Convert CSV To GeoJSON<\/li>\n<li>Convert CSV To HTML Table or MediaWiki Table New<\/li>\n<li>Convert CSV To JSON<\/li>\n<li>Convert CSV To KML<\/li>\n<li>Convert CSV To Multi-line Data<\/li>\n<li>Convert CSV To SQL<\/li>\n<li>Convert CSV To XML<\/li>\n<li>Convert CSV To YAML<\/li>\n<li>Pivot CSV Tool<\/li>\n<li>Convert Fixed Width To CSV<\/li>\n<li>Convert GeoJSON To CSV<\/li>\n<li>Convert HTML Table To CSV<\/li>\n<li>Convert JSON To CSV<\/li>\n<li>Convert SQL To CSV<\/li>\n<li>Convert XML To CSV<\/li>\n<li>Convert YAML To CSV<\/li>\n<\/ul>\n<p>Z.B. geben wir in der Eingabe Zeile folgende Schl\u00fcsselw\u00f6rter an:<\/p>\n<p><code>seq; first; last; name; email; latitude; longitude; domain; string<\/code><\/p>\n<p>W\u00e4hlen noch die Anzahl der zu erzeugenden Datens\u00e4tze, z.B. 10 und klicken auf &#8222;Generate Test Data&#8220;.<\/p>\n<p>Schon werden die Testdaten erzeugt, z.B.:<\/p>\n<pre class=\"lang:default decode:true \">[seq;first;last;name;email;latitude;longitude;domain;string\r\n1;Nevaeh;Flores;Layla Patton;funbecev@rud.gov;-37.83501;85.51261;es.com;X96yT8Ti*c10n2*Tq2$\r\n2;Raymond;Castillo;Madeline Austin;hewit@fedbi.net;-37.34585;81.91501;wiz.io;D%0B9\r\n3;Alex;Vega;Tucker Harris;fedwicro@jizpusi.io;50.22157;80.15615;pehuflir.edu;VUXsuoQ^\r\n4;Emery;Chapman;Ruby Blake;sehudguj@havbeawi.edu;63.62601;177.62135;iwnego.co.uk;bqa6xwK1jHm\r\n5;Ayla;Price;Alice Turner;are@ona.co.uk;71.88833;65.1077;usfevog.edu;UgHl&amp;lqo*WA16B\r\n6;Eden;Ortega;Presley Hunter;isozba@funoco.io;24.01598;15.27323;cuasve.gov;$R!hvnwUABHppwsN\r\n7;Eva;Higgins;Paige Guzman;se@dok.com;69.97058;168.30766;ton.net;imsoYdGG7\r\n8;Jaden;Maxwell;Amir Powell;keruduf@ig.co.uk;13.61097;109.48138;iwo.net;*LtbS&amp;2g]\r\n9;Bryson;Wood;Olivia Mathis;nofha@ufefic.edu;27.57553;144.73931;ozoum.co.uk;^L9gNMr\r\n10;Gabriel;West;Esther Bush;mefzule@et.org;-9.7853;130.91952;ipebuake.net;6BK[GKSfz(c!v^]\r\n<\/pre>\n<p>Mit klick auf &#8222;<code>Save to Disk<\/code>&#8220; k\u00f6nnen die Testdaten in eine Datei gespeichert werde. <\/p>\n<p>Die Testdaten werden auf dem Client erzeugt, und werden also <strong>nicht<\/strong> an den Hersteller der Seite gesendet.<\/p>\n<p>Nun k\u00f6nnen wir die CSV Testdaten auch in eine <a href=\"https:\/\/www.convertcsv.com\/csv-to-html.htm\" target=\"_blank\" rel=\"noopener\">HTML Tabelle<\/a> umwandeln, hier nur die Spalten 1,2,3 eingegeben:<\/p>\n<table border=\"1\">\n<thead>\n<tr>\n<th title=\"Field #1\">[seq<\/th>\n<th title=\"Field #2\">first<\/th>\n<th title=\"Field #3\">last<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td align=\"right\">1<\/td>\n<td>Nevaeh<\/td>\n<td>Flores<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">2<\/td>\n<td>Raymond<\/td>\n<td>Castillo<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">3<\/td>\n<td>Alex<\/td>\n<td>Vega<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">4<\/td>\n<td>Emery<\/td>\n<td>Chapman<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">5<\/td>\n<td>Ayla<\/td>\n<td>Price<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">6<\/td>\n<td>Eden<\/td>\n<td>Ortega<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">7<\/td>\n<td>Eva<\/td>\n<td>Higgins<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">8<\/td>\n<td>Jaden<\/td>\n<td>Maxwell<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">9<\/td>\n<td>Bryson<\/td>\n<td>Wood<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">10<\/td>\n<td>Gabriel<\/td>\n<td>West<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Wer die CSV dann in XML umwandel m\u00f6cht, kann dies auch leicht mit dem <a href=\"https:\/\/www.convertcsv.com\/csv-to-xml.htm\" target=\"_blank\" rel=\"noopener\">CSV to XML Converter<\/a> tun. Hier mal die CSV die oben generiert wurde:<\/p>\n<pre class=\"lang:xhtml decode:true \" >&lt;?xml version=\"1.0\"?&gt;\r\n&lt;ROWSET&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;1&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Nevaeh&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Flores&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Layla Patton&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;funbecev@rud.gov&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;-37.83501&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;85.51261&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;es.com&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;X96yT8Ti*c10n2*Tq2$&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;2&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Raymond&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Castillo&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Madeline Austin&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;hewit@fedbi.net&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;-37.34585&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;81.91501&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;wiz.io&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;D%0B9&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;3&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Alex&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Vega&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Tucker Harris&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;fedwicro@jizpusi.io&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;50.22157&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;80.15615&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;pehuflir.edu&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;VUXsuoQ^&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;4&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Emery&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Chapman&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Ruby Blake&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;sehudguj@havbeawi.edu&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;63.62601&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;177.62135&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;iwnego.co.uk&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;bqa6xwK1jHm&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;5&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Ayla&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Price&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Alice Turner&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;are@ona.co.uk&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;71.88833&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;65.1077&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;usfevog.edu&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;UgHl&amp;amp;amp&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;lqo*WA16B&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;6&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Eden&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Ortega&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Presley Hunter&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;isozba@funoco.io&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;24.01598&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;15.27323&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;cuasve.gov&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;$R!hvnwUABHppwsN&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;7&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Eva&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Higgins&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Paige Guzman&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;se@dok.com&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;69.97058&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;168.30766&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;ton.net&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;imsoYdGG7&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;8&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Jaden&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Maxwell&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Amir Powell&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;keruduf@ig.co.uk&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;13.61097&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;109.48138&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;iwo.net&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;*LtbS&amp;amp;amp&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;2g]&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;9&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Bryson&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;Wood&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Olivia Mathis&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;nofha@ufefic.edu&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;27.57553&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;144.73931&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;ozoum.co.uk&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;^L9gNMr&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;ROW&gt;\r\n&lt;FIELD1&gt;10&lt;\/FIELD1&gt;\r\n&lt;FIELD2&gt;Gabriel&lt;\/FIELD2&gt;\r\n&lt;FIELD3&gt;West&lt;\/FIELD3&gt;\r\n&lt;FIELD4&gt;Esther Bush&lt;\/FIELD4&gt;\r\n&lt;FIELD5&gt;mefzule@et.org&lt;\/FIELD5&gt;\r\n&lt;FIELD6&gt;-9.7853&lt;\/FIELD6&gt;\r\n&lt;FIELD7&gt;130.91952&lt;\/FIELD7&gt;\r\n&lt;FIELD8&gt;ipebuake.net&lt;\/FIELD8&gt;\r\n&lt;FIELD9&gt;6BK[GKSfz(c!v^x&lt;\/FIELD9&gt;\r\n&lt;FIELD10&gt;&lt;\/FIELD10&gt;\r\n&lt;\/ROW&gt;\r\n&lt;\/ROWSET&gt;<\/pre>\n<p>Oder mal eben 1000 Passw\u00f6rter die 20 Stellen haben generieren mit:<\/p>\n<p><code>seq,string(20)<\/code><\/p>\n<pre>\r\nseq,string\r\n1,6W50kn@61erS8r%5iPH5\r\n2,RsAUg%3fa0#dM)$si9f1\r\n3,[8aVDuuV#qo$U]If[vdx\r\n4,)vfY$S7MMJrJ8hGLsG40\r\n5,M92Ir1IZE#JxzIep)47T\r\n6,Jj9uqhd@D2Yt&iDNEdN)\r\n7,X0RU[l6sSnZq[zFnAavy\r\n8,1ZZgdvuNNLBi6HC28$)7\r\n9,p*dV^82rW&o0iK]ltA*[\r\n...\r\n1000,JT*0PBq&dzaCBrB#G2cQ\r\n<\/pre>\n<p>Weitere Ideen?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mit dem CSV-Testdaten-Generator kann schnell und einfach jegliche Art von Testdaten erzeugt werden. Die dann leicht in JUnit und sonstwie weiterverwendet werden k\u00f6nnen. Auch andere gute Tools f\u00fcr die Bearbeitung von CSVs sind dort zu finden. z.B. Convert CSV To Delimited &#8211; reformat, filter, and sort delimited data Convert CSV To Fixed Width or ASCII &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/blog.wenzlaff.de\/?p=5732\" class=\"more-link\"><span class=\"screen-reader-text\">\u201eCSV Testdaten Generator (Oder wer testet ist feige? NEIN) und mehr Tools f\u00fcr CSV to &#8230;\u201c <\/span>weiterlesen<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[79,6,7],"tags":[2113,1721,2108,2110,2111,1486,194,2107,2112],"class_list":["post-5732","post","type-post","status-publish","format-standard","hentry","category-programmierung","category-test","category-tools","tag-convertercsv-testgenerator","tag-csv","tag-csv-generator","tag-csvtohtml","tag-csvtoxml","tag-generator","tag-test-2","tag-testdaten-generator","tag-xmltocsv"],"_links":{"self":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/5732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5732"}],"version-history":[{"count":0,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/5732\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5732"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}