FilesExpand file tree

 master

/

csv2json.js

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

41 lines (37 loc) · 1.17 KB

 master

/

csv2json.js

Top

File metadata and controls

• Code
• Blame

41 lines (37 loc) · 1.17 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

/*

CSV 2 JSON utility:

It reads in all the content from the csv line by line (may be read out of order)

It then use underscorejs to convert into key + value pairs and finally dump into

a json file

Developer: Antony Wu (antony@meshway.com)

*/

var csv = require('csv'),

fs = require('fs'),

_ = require('underscore'),

masterOptions = {

inputFile: '../fee-schedule-master-file-fy13_displayFields.csv',

outputFile: 'fee-schedule-master-file-fy13.json'

},

alcoholOptions = {

inputFile: '../alcohol-fee-schedule.csv',

outputFile: 'alcohol-fee-schedule.json'

};

(function(options) {

var header = null;

var output = [];

csv()

.from(options.inputFile)

.on('record', function(row,index){

if (index === 0)

header = row;

else

output.push(_.object(header, row));

})

.on('end', function(count){

console.log('Number of lines: '+count);

fs.writeFile(options.outputFile, JSON.stringify(output), function (err) {

if (err) throw err;

console.log('It\'s saved!');

});

});

})(masterOptions);