current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 3 down vote favorite

I am trying to convert a JSON string in a Javascript object literal. I think it is possible with some loops, but i couldn't get it done. The target structure is shown below, "chartData".

Fiddle can be found here: http://jsbin.com/ajemih/13/edit

Here's the JSON data:

{
   "1b":{
      "allLoad":"130",
      "loadMovement":"111",
      "allMovement":"111"
   },
   "1a":{
      "allLoad":"910",
      "loadMovement":"671",
      "allMovement":"280"
   },
   "systemLoad":"963"
}

This should it look like after the conversion:

chartData = [[['loadMovement', 111], 
              ['allMovement', 120], 
              ['allLoad', 130]], 
             [['Load+Move', 671], 
              ['allMovement', 280], 
              ['allLoad', 910]]];
share|improve this question
2  
The text of your question makes no sense. There's no JSON string in either of your blocks of code. Are you just asking how to convert the first javascript data structure to the second data structure? –  jfriend00 Mar 19 '13 at 20:16
    
Yes. I want to convert the first data structure in the second one. –  mcknight Mar 19 '13 at 20:18
1  
@jfriend00 his first segment is technically valid JSON. He's not using it that way in his fiddle though. –  Ben McCormick Mar 19 '13 at 20:19
3  
@mcknight you're going to have to be more specific about what rules you want to follow here. Do you want to ignore values with primitive string keys? just ignore systemLoad? Just traverse properties in the form 1<char> ? –  Ben McCormick Mar 19 '13 at 20:21
2  
So what have you tried so far? I couldn't find any actual attempted code in the jsbin. –  Vega Mar 19 '13 at 20:22

3 Answers 3

up vote 4 down vote accepted

I think this would work:

Working demo: http://jsfiddle.net/jfriend00/YmjDR/

var data = {
   "1b":{
      "allLoad":"130",
      "loadMovement":"111",
      "allMovement":"111"
   },
   "1a":{
      "allLoad":"910",
      "loadMovement":"671",
      "allMovement":"280"
   },
   "systemLoad":"963"
};

var chartData = [];

for (var i in data) {
    var item = data[i];
    var outer = [];
    // skip over items in the outer object that aren't nested objects themselves
    if (typeof item === "object") {
        for (var j in item) {
            var temp = [];
            temp.push(j);
            temp.push(item[j]);
            outer.push(temp);
        }
    }
    if (outer.length) {
        chartData.push(outer);
    }
}
share|improve this answer
up vote 3 down vote

You could do something like this:

var chartData = []

for(var key in data) {        
    var properties = data[key];

    if(typeof properties === "object") {
       var array = [];

       for(var propKey in properties) {
           array.push([propKey, properties[propKey]])
       }

       chartData.push(array);
    }             
}

Check out the fiddle.

share|improve this answer
up vote 3 down vote

You need to map the data manually. Thats actually more a diligent but routine piece of work.

var jsonData = 'your json string';

Object.keys( jsonData ).map(function( key ) {
    if( typeof jsonData[ key ] === 'object' ) {
        return Object.keys( jsonData[ key ] ).sort(function( a, b ) {
            return +jsonData[ key ][ a ] - +jsonData[ key ][ b ];
        }).map(function( name ) {
            return [ name, jsonData[ key ][ name ] ];
        });
    }
}).filter( Boolean );

The above code will sort each group by its numeric value and then map a new array in the required style. Since .map() possibly returns undefined values on non-object elements, we need to filter those out before or afterwards.

See http://jsfiddle.net/WjZB2/2/

share|improve this answer
    
Just for the reference, the code can be way prettier: jsfiddle.net/Ralt/WjZB2/5 –  Florian Margaine Mar 19 '13 at 20:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.