Welcome Guest, Not a member yet? Register   Sign In
going from json to datatable format
#1

I am sending a buffer of json data from my codeigniter based app to the client PC's browser. Here is the AJAX that catches it. I am having trouble getting the data out of the json array  and into the datatable format. I have attached a copy of the json that arrives in jsonData and also the AJAX that gets the buffer.  
function drawChart() {
   var jsonData = $.ajax({
   type : "GET",
       url: "<?php echo base_url(); ?>" + "index.php/Configure/snd_json",
      dataType: "json",
    //  jsonp: false,
       cache: false,
       dataSrc: '',
       success: function(jsonData)
           {
       //   var jD = JSON.parse(jsonData);
       // ien=jsonData.length;
           var data = new google.visualization.DataTable(jsonData);
           data.addColumn('string', 'Name');
           data.addColumn('string', 'Manager');
           data.addColumn('string', 'ToolTip');
           for ( var i=0, ien=jsonData.length ; i<ien ; i++ ) {
                data.addRow(jsonData[i]['employee_email'],jsonData[i]['manager_email'],jsonData[i]['employee_title']);
                //   data[i][0] = '<a href="/message/'+json.data[i][0]+'>View message</a>';
                 }

          // var jsonObject=$.parseJSON(jsonData);
           var chart = new google.visualization.OrgChart(document.getElementById('chart_div'));
           // Draw the chart, setting the allowHtml option to true for the tooltips.
           chart.draw(data, {});
           },
       error:
          function (jqXHR, textStatus, errorThrown) {
           alert('error');
              // Request failed. Show error message to user.
              // errorThrown has error message, or "timeout" in case of timeout.


          },

       async: false,
       timeout: 10000,

   }).responseText;


The trouble I have is on the line in RED. I don't know how to grab the data in the json buffers so I can copy them to the datatable. I have tried jsonData[i].employee_email too but with no luck. Any help is appreciated.

Thanks, Rich

Attached Files
.txt   sample_json.txt (Size: 891 bytes / Downloads: 92)
proof that an old dog can learn new tricks
Reply
#2

Well, I figured it out on my own. Unfortunately I am kind of burned out on the effort it took to do it. Here is how I got it working for others with this same issue.
First I built a array for each line by using var arrJd=(jsonData[i].employee_email, jsonData[i].manager_email,jsonData[i].employee_title);
And then I add the row to the datatable with addRow(arrJd);
proof that an old dog can learn new tricks
Reply




Theme © iAndrew 2016 - Forum software by © MyBB