{"id":476,"date":"2020-09-01T20:44:00","date_gmt":"2020-09-01T18:44:00","guid":{"rendered":"http:\/\/dufajn.pl\/?p=476"},"modified":"2020-09-17T17:43:31","modified_gmt":"2020-09-17T15:43:31","slug":"how-to-create-a-lot-of-test-data-fast-in-json-or-csv-format","status":"publish","type":"post","link":"https:\/\/dufajn.pl\/?p=476","title":{"rendered":"How to create a lot of test data fast in JSON or CSV format?"},"content":{"rendered":"\n

During testing, you need test data, a lot of data. There is one tool that can be very helpful for you. You can use dynamic variables to fill the value for each field. When you save the template you can also use this schema to mock your API. If you have any questions on how to use this tool, post a comment I’ll provide the link with the working solution. https:\/\/www.mockaroo.com\/<\/a><\/p>\n\n\n\n

Below are some examples of files that can be created using this application. <\/p>\n\n\n\n

JSON format:<\/p>\n\n\n\n

[\n   {\n     \"DUFAJN_PL\": 1,\n     \"first_name\": \"Stanley\",\n     \"last_name\": \"Yakushkin\",\n     \"email\": \"syakushkin0@hp.com\",\n     \"gender\": \"Male\",\n     \"avatar\": \"http:\/\/dummyimage.com\/121x105.bmp\/cc0000\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 2,\n     \"first_name\": \"Retha\",\n     \"last_name\": \"Redfearn\",\n     \"email\": \"rredfearn1@prnewswire.com\",\n     \"gender\": \"Female\",\n     \"avatar\": \"http:\/\/dummyimage.com\/108x210.jpg\/ff4444\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 3,\n     \"first_name\": \"Quintus\",\n     \"last_name\": \"Burgher\",\n     \"email\": \"qburgher2@jiathis.com\",\n     \"gender\": \"Male\",\n     \"avatar\": \"http:\/\/dummyimage.com\/105x215.png\/cc0000\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 4,\n     \"first_name\": \"Anthony\",\n     \"last_name\": \"de Banke\",\n     \"email\": \"adebanke3@upenn.edu\",\n     \"gender\": \"Male\",\n     \"avatar\": \"http:\/\/dummyimage.com\/221x145.bmp\/ff4444\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 5,\n     \"first_name\": \"Darn\",\n     \"last_name\": \"Sutton\",\n     \"email\": \"dsutton4@sfgate.com\",\n     \"gender\": \"Male\",\n     \"avatar\": \"http:\/\/dummyimage.com\/143x231.jpg\/cc0000\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 6,\n     \"first_name\": \"Leann\",\n     \"last_name\": \"Shurey\",\n     \"email\": \"lshurey5@sogou.com\",\n     \"gender\": \"Female\",\n     \"avatar\": \"http:\/\/dummyimage.com\/249x105.png\/ff4444\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 7,\n     \"first_name\": \"Carlota\",\n     \"last_name\": \"Croan\",\n     \"email\": \"ccroan6@si.edu\",\n     \"gender\": \"Female\",\n     \"avatar\": \"http:\/\/dummyimage.com\/113x239.jpg\/5fa2dd\/ffffff\"\n   },\n   {\n     \"DUFAJN_PL\": 8,\n     \"first_name\": \"Tuck\",\n     \"last_name\": \"Rosekilly\",\n     \"email\": \"trosekilly7@deliciousdays.com\",\n     \"gender\": \"Male\",\n     \"avatar\": \"http:\/\/dummyimage.com\/125x236.png\/cc0000\/ffffff\"\n   }\n ]<\/code><\/pre>\n\n\n\n
CSV format:<\/p>\n\n\n\n
DUFAJN_PL,first_name,last_name,email,gender,avatar 1,Patrick,Grason,pgrason0@ucoz.ru,Male,http:\/\/dummyimage.com\/160x169.png\/dddddd\/000000 2,Heath,Connikie,hconnikie1@myspace.com,Female,http:\/\/dummyimage.com\/189x143.png\/5fa2dd\/ffffff 3,Obadiah,Horsburgh,ohorsburgh2@merriam-webster.com,Male,http:\/\/dummyimage.com\/154x177.jpg\/cc0000\/ffffff 4,Mill,Goldspink,mgoldspink3@vk.com,Male,http:\/\/dummyimage.com\/223x194.bmp\/5fa2dd\/ffffff 5,Ursola,Kiossel,ukiossel4@cbslocal.com,Female,http:\/\/dummyimage.com\/176x169.png\/cc0000\/ffffff 6,Edsel,Remnant,eremnant5@cnbc.com,Male,http:\/\/dummyimage.com\/151x149.png\/ff4444\/ffffff 7,Lew,Kilbane,lkilbane6@flavors.me,Male,http:\/\/dummyimage.com\/110x240.png\/cc0000\/ffffff 8,Sol,Yurenev,syurenev7@issuu.com,Male,http:\/\/dummyimage.com\/169x235.bmp\/5fa2dd\/ffffff <\/code><\/pre>\n\n\n\n
XML format:<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<dataset>\n  <record>\n    <DUFAJN_PL>1<\/DUFAJN_PL>\n    <first_name>Zachariah<\/first_name>\n    <last_name>Penhaleurack<\/last_name>\n    <email>zpenhaleurack0@tinyurl.com<\/email>\n    <gender>Male<\/gender>\n    <avatar>http:\/\/dummyimage.com\/155x249.bmp\/ff4444\/ffffff<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>2<\/DUFAJN_PL>\n    <first_name>Genia<\/first_name>\n    <last_name>Howood<\/last_name>\n    <email>ghowood1@ftc.gov<\/email>\n    <gender>Female<\/gender>\n    <avatar>http:\/\/dummyimage.com\/138x130.png\/cc0000\/ffffff<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>3<\/DUFAJN_PL>\n    <first_name>Torry<\/first_name>\n    <last_name>Jowsey<\/last_name>\n    <email>tjowsey2@usatoday.com<\/email>\n    <gender>Male<\/gender>\n    <avatar>http:\/\/dummyimage.com\/101x214.jpg\/5fa2dd\/ffffff<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>4<\/DUFAJN_PL>\n    <first_name>Annadiane<\/first_name>\n    <last_name>Proffer<\/last_name>\n    <email>aproffer3@stanford.edu<\/email>\n    <gender>Female<\/gender>\n    <avatar>http:\/\/dummyimage.com\/134x133.bmp\/ff4444\/ffffff<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>5<\/DUFAJN_PL>\n    <first_name>Carlie<\/first_name>\n    <last_name>Firle<\/last_name>\n    <email>cfirle4@cargocollective.com<\/email>\n    <gender>Male<\/gender>\n    <avatar>http:\/\/dummyimage.com\/102x240.jpg\/dddddd\/000000<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>6<\/DUFAJN_PL>\n    <first_name>Luelle<\/first_name>\n    <last_name>Rogers<\/last_name>\n    <email>lrogers5@edublogs.org<\/email>\n    <gender>Female<\/gender>\n    <avatar>http:\/\/dummyimage.com\/229x125.png\/ff4444\/ffffff<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>7<\/DUFAJN_PL>\n    <first_name>Lanni<\/first_name>\n    <last_name>Kewley<\/last_name>\n    <email>lkewley6@engadget.com<\/email>\n    <gender>Female<\/gender>\n    <avatar>http:\/\/dummyimage.com\/104x248.bmp\/ff4444\/ffffff<\/avatar>\n  <\/record>\n  <record>\n    <DUFAJN_PL>8<\/DUFAJN_PL>\n    <first_name>Holmes<\/first_name>\n    <last_name>Springham<\/last_name>\n    <email>hspringham7@wordpress.com<\/email>\n    <gender>Male<\/gender>\n    <avatar>http:\/\/dummyimage.com\/160x243.jpg\/5fa2dd\/ffffff<\/avatar>\n  <\/record>\n<\/dataset><\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
Other supported formats are tab-delimited, SQL, Cassandra CQL, Firebase, Excel, XML, DBUnit XML.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
During testing, you need test data, a lot of data. There is one tool that can be very helpful for<\/p>\n","protected":false},"author":3,"featured_media":493,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[],"class_list":["post-476","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-testing"],"_links":{"self":[{"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/posts\/476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dufajn.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=476"}],"version-history":[{"count":11,"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/posts\/476\/revisions"}],"predecessor-version":[{"id":491,"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/posts\/476\/revisions\/491"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dufajn.pl\/index.php?rest_route=\/wp\/v2\/media\/493"}],"wp:attachment":[{"href":"https:\/\/dufajn.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dufajn.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dufajn.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}