-
Notifications
You must be signed in to change notification settings - Fork 5
/
json2csv.js
79 lines (79 loc) · 1.87 KB
/
json2csv.js
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
var _ = require("underscore");
var getheaders = function (name,value,parent){
var ret = "";
if (typeof name == "number"){
name = "[" + name + "]";
}else{
if (name) name = "['" + name + "']";
}
var family = "";
if (parent){
family = parent + name;
}else{
family = name+"";
}
switch(Object.prototype.toString.call(value)){
case "[object Object]":
for (var k in value){
ret += getheaders(k,value[k],family);
}
break;
case "[object Array]":
for (var ix=0;ix < value.length; ix++){
ret += getheaders(ix,value[ix],family);
}
break;
default:
ret += family + ",";
}
return ret;
};
var tocsv = function (row,heads){
var ret = "", exec = "", val = "";
for (var x in heads){
exec = "row"+heads[x];
val = "";
try {
val = eval(exec);
if (typeof val == "string"){
val = '"' + val.replace('"','""') + '"';
}
}catch (err){
console.log("error : ",err);
}
ret += val+",";
}
if (ret.slice(-1)==",") ret = ret.substring(0, ret.length - 1);
return ret;
};
if (process.argv.length==4){
var json = "";
var fs = require("fs");
fs.readFile(process.argv[2],function(err,filedata){
if (err){
console.log("Error while opening file..",err);
process.exit(1);
}
var headers = [];
var json = JSON.parse(filedata);
//var headers = getheaders("",json,"");
for (var k in json.rows){
var header = getheaders("",json.rows[k],"");
if (header.slice(-1)==",") header = header.substring(0, header.length - 1);
headers = _.uniq(headers.concat(header.split(",")));
//headers = _.uniq(headers);
}
var data = headers.join(",")+"\n";;
for (var k in json.rows){
data += tocsv(json.rows[k],headers)+"\n";
}
fs.writeFile(process.argv[3],data,function(err){
if (err){
console.log("Error while writing file..",err);
process.exit(1);
}
});
});
}else{
console.log("Usage : node json2csv.js <<input file>> <<output file>>");
}