Skip to content

Instantly share code, notes, and snippets.

@sks147

sks147/a.js

Created September 11, 2019 08:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sks147/4bae4f07d77c2afd6e80e0f060d8e622 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sks147/4bae4f07d77c2afd6e80e0f060d8e622 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. sks147 created this gist Sep 11, 2019.
    17 changes: 17 additions & 0 deletions a.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    const fs = require('fs').promises;
    const jsonData = require('./generated.json');
    const JSONToCSV = require('json2csv').parse;

    const fields = ['balance', 'age', 'name', 'gender', 'company', 'email', 'phone'];
    const opts = { fields: fields };

    async function convert() {
    const csv = JSONToCSV(jsonData, opts);
    try {
    await fs.writeFile('./destination.csv', csv);
    } catch (e) {
    console.error(`ERROR in conversion: ${e.stack}`);
    }
    };

    convert();
    8 changes: 8 additions & 0 deletions destination.csv
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    "balance","age","name","gender","company","email","phone"
    "$3,316.42",35,"Katrina Hudson","female","EVEREST","[email protected]","+1 (971) 519-2982"
    "$2,686.06",20,"Pruitt Mercado","male","DIGIGENE","[email protected]","+1 (828) 421-2203"
    "$3,742.94",33,"Silva Herring","male","AUTOMON","[email protected]","+1 (932) 408-2429"
    "$1,737.57",37,"Ford Castillo","male","IRACK","[email protected]","+1 (988) 515-3601"
    "$1,628.88",30,"Eleanor David","female","ZILLAR","[email protected]","+1 (868) 571-3271"
    "$2,293.21",29,"Wooten Ingram","male","SUPPORTAL","[email protected]","+1 (947) 533-3606"
    "$2,767.67",38,"Melissa Mcdaniel","female","BIFLEX","[email protected]","+1 (887) 538-3385"
    317 changes: 317 additions & 0 deletions generated.json
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,317 @@
    [
    {
    "_id": "5d78a2e96188fbf3c901b708",
    "index": 0,
    "guid": "856a9a02-634d-4fec-b9c1-af1e8b2791b1",
    "isActive": false,
    "balance": "$3,316.42",
    "picture": "http://placehold.it/32x32",
    "age": 35,
    "eyeColor": "brown",
    "name": "Katrina Hudson",
    "gender": "female",
    "company": "EVEREST",
    "email": "[email protected]",
    "phone": "+1 (971) 519-2982",
    "address": "672 Vandam Street, Nelson, South Carolina, 3235",
    "about": "Nostrud amet adipisicing labore laboris sunt. Exercitation duis consequat non nisi. Commodo est consequat voluptate eiusmod et Lorem anim ex velit. Anim ea nostrud laboris duis nostrud officia nisi incididunt aliquip magna aliquip reprehenderit dolore. Elit est officia aute duis. Occaecat sit sunt aliquip officia et et magna esse.\r\n",
    "registered": "2014-08-31T12:08:05 -06:-30",
    "latitude": -60.745451,
    "longitude": -10.087167,
    "tags": [
    "eu",
    "velit",
    "et",
    "consequat",
    "nulla",
    "excepteur",
    "ut"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Hale Jarvis"
    },
    {
    "id": 1,
    "name": "Goodman Stone"
    },
    {
    "id": 2,
    "name": "Garrett Roth"
    }
    ],
    "greeting": "Hello, Katrina Hudson! You have 2 unread messages.",
    "favoriteFruit": "apple"
    },
    {
    "_id": "5d78a2e97f60c8e5bb8c71c5",
    "index": 1,
    "guid": "154e9dd1-e53c-4f3e-8d58-98b3a461486a",
    "isActive": true,
    "balance": "$2,686.06",
    "picture": "http://placehold.it/32x32",
    "age": 20,
    "eyeColor": "green",
    "name": "Pruitt Mercado",
    "gender": "male",
    "company": "DIGIGENE",
    "email": "[email protected]",
    "phone": "+1 (828) 421-2203",
    "address": "911 Elliott Place, Bladensburg, Nebraska, 179",
    "about": "Cillum veniam culpa commodo elit minim. Adipisicing minim amet cillum dolor commodo quis minim ipsum irure consequat minim aute nisi. Id laboris pariatur minim veniam nisi dolor quis qui. Magna magna enim Lorem commodo aliquip anim amet culpa aliqua occaecat. Nisi ea est ex veniam ullamco esse voluptate eu incididunt sint laborum ut amet in.\r\n",
    "registered": "2016-03-27T11:21:23 -06:-30",
    "latitude": -66.890913,
    "longitude": 56.281445,
    "tags": [
    "dolor",
    "qui",
    "proident",
    "officia",
    "culpa",
    "eu",
    "consequat"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Perkins Herrera"
    },
    {
    "id": 1,
    "name": "Ellison Livingston"
    },
    {
    "id": 2,
    "name": "Ayers Decker"
    }
    ],
    "greeting": "Hello, Pruitt Mercado! You have 2 unread messages.",
    "favoriteFruit": "apple"
    },
    {
    "_id": "5d78a2e963fcbef2f2887fa4",
    "index": 2,
    "guid": "5d205224-f529-490d-bfed-94f8d35aec90",
    "isActive": false,
    "balance": "$3,742.94",
    "picture": "http://placehold.it/32x32",
    "age": 33,
    "eyeColor": "blue",
    "name": "Silva Herring",
    "gender": "male",
    "company": "AUTOMON",
    "email": "[email protected]",
    "phone": "+1 (932) 408-2429",
    "address": "276 Madoc Avenue, Taft, Illinois, 6237",
    "about": "Mollit excepteur consequat nostrud consectetur. Veniam cillum quis commodo sint pariatur minim. Enim occaecat cupidatat do occaecat velit. Qui duis tempor esse officia irure ea est labore incididunt cupidatat voluptate exercitation laborum. Enim aliqua laboris eu consequat ut. Deserunt anim id aute ea ullamco laboris laborum aute sit consectetur.\r\n",
    "registered": "2018-04-15T06:57:25 -06:-30",
    "latitude": -59.289598,
    "longitude": 93.213482,
    "tags": [
    "anim",
    "mollit",
    "proident",
    "eu",
    "aute",
    "reprehenderit",
    "eiusmod"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Eileen Patterson"
    },
    {
    "id": 1,
    "name": "Valeria Knapp"
    },
    {
    "id": 2,
    "name": "Boone Chandler"
    }
    ],
    "greeting": "Hello, Silva Herring! You have 7 unread messages.",
    "favoriteFruit": "strawberry"
    },
    {
    "_id": "5d78a2e98608df15c6f9f8e3",
    "index": 3,
    "guid": "240aebf3-6b41-43a1-8d96-4a12ba071bb3",
    "isActive": false,
    "balance": "$1,737.57",
    "picture": "http://placehold.it/32x32",
    "age": 37,
    "eyeColor": "blue",
    "name": "Ford Castillo",
    "gender": "male",
    "company": "IRACK",
    "email": "[email protected]",
    "phone": "+1 (988) 515-3601",
    "address": "799 Oriental Boulevard, Belfair, Delaware, 2078",
    "about": "Magna reprehenderit est est sunt dolore aliquip et excepteur in. Id ullamco minim eu non nulla amet incididunt ex deserunt. Mollit mollit qui aute ea ex anim sunt. Tempor elit duis culpa minim et sit consequat quis dolore dolor voluptate. Enim id laboris laboris reprehenderit do veniam esse eu aliqua laboris dolor laboris sunt qui.\r\n",
    "registered": "2015-04-28T12:17:48 -06:-30",
    "latitude": 8.41473,
    "longitude": 101.613334,
    "tags": [
    "sint",
    "aliquip",
    "fugiat",
    "commodo",
    "occaecat",
    "velit",
    "sint"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Essie Greer"
    },
    {
    "id": 1,
    "name": "Rutledge Cotton"
    },
    {
    "id": 2,
    "name": "Lorene Guerra"
    }
    ],
    "greeting": "Hello, Ford Castillo! You have 2 unread messages.",
    "favoriteFruit": "banana"
    },
    {
    "_id": "5d78a2e9bfe70682d7955ef5",
    "index": 4,
    "guid": "e67e3759-a459-421c-86a2-7d2cd00468fa",
    "isActive": true,
    "balance": "$1,628.88",
    "picture": "http://placehold.it/32x32",
    "age": 30,
    "eyeColor": "brown",
    "name": "Eleanor David",
    "gender": "female",
    "company": "ZILLAR",
    "email": "[email protected]",
    "phone": "+1 (868) 571-3271",
    "address": "690 Sands Street, Carlton, Arkansas, 3984",
    "about": "Laborum excepteur do amet enim labore et adipisicing aute. Consectetur do occaecat excepteur deserunt eiusmod nulla cupidatat cillum culpa quis cupidatat ullamco sunt. Adipisicing id est Lorem ex aliquip do ut dolore culpa enim. Laboris adipisicing ullamco sunt veniam aute do ullamco duis qui consequat ullamco. Non non pariatur enim cillum duis. Consequat mollit ad in anim nisi tempor. Eu officia elit tempor ut cupidatat ullamco ea excepteur laboris do quis magna sunt nulla.\r\n",
    "registered": "2016-11-23T01:54:11 -06:-30",
    "latitude": 84.058098,
    "longitude": 159.080222,
    "tags": [
    "nostrud",
    "exercitation",
    "culpa",
    "eu",
    "laboris",
    "in",
    "aliquip"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Winnie Patel"
    },
    {
    "id": 1,
    "name": "Moody Fowler"
    },
    {
    "id": 2,
    "name": "Brandie Garcia"
    }
    ],
    "greeting": "Hello, Eleanor David! You have 10 unread messages.",
    "favoriteFruit": "strawberry"
    },
    {
    "_id": "5d78a2e947f86390c9d69926",
    "index": 5,
    "guid": "d8623b4a-33cc-454f-8179-47a04f55e713",
    "isActive": true,
    "balance": "$2,293.21",
    "picture": "http://placehold.it/32x32",
    "age": 29,
    "eyeColor": "green",
    "name": "Wooten Ingram",
    "gender": "male",
    "company": "SUPPORTAL",
    "email": "[email protected]",
    "phone": "+1 (947) 533-3606",
    "address": "371 Irving Avenue, Blanco, New Mexico, 7515",
    "about": "Culpa incididunt ea quis do consequat reprehenderit. Non enim voluptate adipisicing laborum laborum veniam esse. Adipisicing mollit proident proident culpa cillum tempor officia.\r\n",
    "registered": "2014-01-20T01:23:41 -06:-30",
    "latitude": 73.660281,
    "longitude": 172.143966,
    "tags": [
    "veniam",
    "Lorem",
    "irure",
    "dolore",
    "ut",
    "eu",
    "sunt"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Gillespie Campos"
    },
    {
    "id": 1,
    "name": "Lucy Mack"
    },
    {
    "id": 2,
    "name": "Bean Branch"
    }
    ],
    "greeting": "Hello, Wooten Ingram! You have 7 unread messages.",
    "favoriteFruit": "apple"
    },
    {
    "_id": "5d78a2e9d161988969798281",
    "index": 6,
    "guid": "ac9b61fd-54ef-4051-9b04-e87863798a8a",
    "isActive": true,
    "balance": "$2,767.67",
    "picture": "http://placehold.it/32x32",
    "age": 38,
    "eyeColor": "green",
    "name": "Melissa Mcdaniel",
    "gender": "female",
    "company": "BIFLEX",
    "email": "[email protected]",
    "phone": "+1 (887) 538-3385",
    "address": "174 Eagle Street, Veyo, Utah, 5395",
    "about": "Culpa laborum cillum amet commodo veniam. Et sint labore laborum tempor voluptate ex laborum incididunt adipisicing. Culpa ut proident cupidatat sit irure consectetur anim occaecat eiusmod do commodo duis qui ex. Mollit elit qui laboris pariatur aliquip occaecat et officia sunt non id id. Veniam commodo labore dolor et enim ea incididunt. Dolor quis adipisicing deserunt ipsum ad. Incididunt est magna deserunt et exercitation culpa elit incididunt do.\r\n",
    "registered": "2016-02-13T02:48:38 -06:-30",
    "latitude": -72.979497,
    "longitude": -50.042608,
    "tags": [
    "dolore",
    "magna",
    "do",
    "amet",
    "commodo",
    "ex",
    "laborum"
    ],
    "friends": [
    {
    "id": 0,
    "name": "Lourdes Howell"
    },
    {
    "id": 1,
    "name": "Scott Vincent"
    },
    {
    "id": 2,
    "name": "Maura Kline"
    }
    ],
    "greeting": "Hello, Melissa Mcdaniel! You have 9 unread messages.",
    "favoriteFruit": "banana"
    }
    ]
    10 changes: 10 additions & 0 deletions package.json
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    {
    "name": "extras",
    "version": "1.0.0",
    "main": "a.js",
    "license": "MIT",
    "private": true,
    "dependencies": {
    "json2csv": "^4.5.3"
    }
    }