-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathconvertAll.js
More file actions
47 lines (39 loc) · 1.48 KB
/
convertAll.js
File metadata and controls
47 lines (39 loc) · 1.48 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
var fs = require('fs');
var parse = require('csv-parse');
const convert = (input,output) => {
var parser = parse({delimiter: ','}, function(err, data){
var rows = data.length;
var columns = data[0].length;
var headers = data[0];
console.log('rows,columns,headers: ',rows,columns,headers);
// create array of listing objects
var items = [];
var item;
for(var i=1; i<rows; i++){
item = {};
for(var j=0; j<columns; j++){
item[headers[j]] = data[i][j];
}
items.push(item);
}
// write listings to file
fs.writeFile(output, JSON.stringify(items), function(err) {
if(err) {
return console.log(err);
}
console.log("The file was saved!");
});
});
fs.createReadStream(input).pipe(parser);
}
convert('data/categories.csv', 'data/categories.js');
convert('data/customers.csv', 'data/customers.js');
convert('data/employee_territories.csv', 'data/employee_territories.js');
convert('data/employees.csv', 'data/employees.js');
convert('data/order_details.csv', 'data/order_details.js');
convert('data/orders.csv', 'data/orders.js');
convert('data/products.csv', 'data/products.js');
convert('data/regions.csv', 'data/regions.js');
convert('data/shippers.csv', 'data/shippers.js');
convert('data/suppliers.csv', 'data/suppliers.js');
convert('data/territories.csv', 'data/territories.js');