JSON object from csv

Question

my csv file is as follows:

NAME,AGE
"John","23"
"BOB","24"

When executing below code, I am getting {} as alert instead of JSON object. My intended output should be JSON file in below format:

{
    "items": [
        {
            "NAME": "John",
            "AGE": " 23"
        },
        {
            "NAME": "BOB",
            "AGE": "24"
        },
    ]
}

CODE:

<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
        <script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
        <script type="text/javascript" src="json.js"></script>
<script type="text/javascript" src="json2.js"></script>
<script type="text/javascript">
  var lines = {};
$(document).ready(function() {
    $.ajax({
        type: "GET",
        url: "data.csv",
        dataType: "csv",
        success: function(data) {processData(data);}
     });
});

function processData(allText) {
    var allTextLines = allText.split(/\r\n|\n/);
    var headers = allTextLines[0].split(',');


    for (var i=1; i<allTextLines.length; i++) {
        var data = allTextLines[i].split(',');
        if (data.length == headers.length) {

            var tarr = [];
            for (var j=0; j<headers.length; j++) {
                tarr.push(headers[j]+":"+data[j]);
            }
            lines.push(tarr);
        }
    }
    alert(lines);
}


var val = JSON.stringify(lines);

alert(val);
</script>
</head>
<body>

</body>
</html>

MaxK · Accepted Answer · 2013-08-22 04:48:36Z

You are trying to push a single string value to an array, rather than key value pairs to an object. so rather than tarr being an array, make it an object. as such, you need to use assign by index rather than using push. The other issue is that lines is never made to contain items, which should be your array.

$(document).ready(function() {
    $.ajax({
        type: "GET",
        url: "data.csv",
        dataType: "csv",
        success: function(data) {processData(data);}
    });
});

function processData(allText) {
    var lines = {};
    var items = [];
    var allTextLines = allText.split(/\r\n|\n/);
    var headers = allTextLines[0].split(',');


    for (var i=1; i<allTextLines.length; i++) {
        var data = allTextLines[i].split(',');
        if (data.length == headers.length) {

            var tarr = {};
            for (var j=0; j<headers.length; j++) {
                tarr[headers[j]] = data[j];
            }
            items.push(tarr);
        }
    }
    lines.items = items;
    alert(lines);
}

edit: Rereading it, if you want actual javascript object, use what i put above. if you want an array of lines of text, do what you were doing, but replace the objects with arrays

Milan V. · Accepted Answer · 2013-08-26 04:50:17Z

0

/*NAME,AGE"John","23""BOB","24"*/
var mvJSON = {};
var myCSV;
var myJSON_str = '{"items":[]}';
var resJSON_str = "";

//*** Edit
$.get("yourcsvfilepath.csv",function(data){
    // coopy file content of csv to variable
    myCSV = data;
    console.clear();processData(myCSV); 
});
//*** Done Edit





function processData(allText) {

    var items = allText.split(',');
    var keys = [items[0],items[1]];
    var items_str = "";

        for(var i = 2; i< items.length;i = i+2){
            items_str += (i==2) ? '{"'+keys[0]+'":'+items[i]+',"'+keys[1]+'":'+items[i+1]+'}' : ',{"'+keys[0]+'":'+items[i]+',"'+keys[1]+'":'+items[i+1]+'}';     
        }

        items_str = items_str.replace("\n","");
        items_str = items_str.replace("\r","");    
        resJSON_str = myJSON_str.substring(0,myJSON_str.length-2)+items_str+myJSON_str.substring(myJSON_str.length-2,myJSON_str.length);
        alert(resJSON_str);

}

edited Aug 26, 2013 at 4:50

answered Aug 22, 2013 at 7:03

Milan V.

6971 gold badge6 silver badges23 bronze badges

1 Comment

Aquarius24 Over a year ago

my csv file is in .csv format and not a string like in this code. how can i give path of csv here rather than giving string

agershun · Accepted Answer · 2014-12-17 08:42:11Z

0

You can do all these operations in one line with Alasql library. The following script can load the data file from server, parse it and put the result to array of JSON objects:

<script src="alasql.min.js"></script>
<script>
    alasql('SELECT NAME, AGE FROM CSV("items.csv",{headers:true})',[],function(res){
        var data = {items:res};
    });
</script>

answered Dec 17, 2014 at 8:42

agershun

4,10742 silver badges42 bronze badges

Collectives™ on Stack Overflow

JSON object from csv

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related