javascript - date type not matches google chart requirements -


it really hard me run project state right now. @ beginning, had no clue how can read file csv , push array. works right now, mismatching date value adding rows.

i think code simple , shows problem. im stuck.

<html>    <head>      <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>  <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>  <script src="jquery.csv.js"></script>    <script type="text/javascript">        google.charts.load('current', {'packages':['timeline']});      google.charts.setonloadcallback(drawchart);        function csvarray(filename, separator, callback) {           $.get(filename, function(filecontent){                   var result = [];                  var textarray = filecontent.split(/(\r\n|\n|\r)/gm);                  (var = 0; < textarray.length; i++) {                          if (textarray[i].length > 1) {                                  var elementarray = textarray[i].split(separator);                  				elementarray.splice(elementarray.length ,1 );                   result.push(elementarray);          }  		}          callback(result);      });  }     csvarray("data.csv", ";", function(result) {  		arrayresult = result;  });          function drawchart() {          var container = document.getelementbyid('timeline');          var chart = new google.visualization.timeline(container);          var datatable = new google.visualization.datatable();            datatable.addcolumn({ type: 'string', id: 'job'})          datatable.addcolumn({ type: 'string', id: 'status' });          datatable.addcolumn({ type: 'date', id: 'start' });          datatable.addcolumn({ type: 'date', id: 'end' });  		          datatable.addrows(arrayresult);  	          chart.draw(datatable);  }       </script>    </head>    <body>      <div id="timeline" style="height: 180px;"></div>    </body>  </html>

data.csv

'zs142770-win dateien dd---btd woche';'passed';new date(2014, 10, 15);new date(2014, 10, 15)

i guess problem is, array contain data string , not object - right?

errorcode:

error: type mismatch. value new date(2014, 10, 15) not match type date in column index 2

best regards paul

you correct problem,
need convert string real date

first, recommend changing date values in csv format
see more on here --> converting string date in js

then create date string, like... 

elementarray[2] = new date(elementarray[2]);

but if can't change values in csv,
can try using eval, pretty never recommended
(but should work) 

elementarray[2] = eval(elementarray[2]);

next, have timing issues layout of code,
recommend waiting google load, before loading csv
draw chart...

recommend setup similar following... 

google.charts.load('current', {   callback: getdata,   packages: ['timeline'] });  function getdata() {   $.get("data.csv", function (filecontent) {     var result = [];     var textarray = filecontent.split(/(\r\n|\n|\r)/gm);     (var = 0; < textarray.length; i++) {       if (textarray[i].length > 1) {         var elementarray = textarray[i].split(";");         // convert date         elementarray[2] = eval(elementarray[2]);         elementarray[3] = eval(elementarray[3]);          // or different format         elementarray[2] = new date(elementarray[2]);         elementarray[3] = new date(elementarray[3]);          result.push(elementarray);       }     }     drawchart(result);   }); }  function drawchart(arrayresult) {   var container = document.getelementbyid('timeline');   var chart = new google.visualization.timeline(container);   var datatable = new google.visualization.datatable();    datatable.addcolumn({ type: 'string', id: 'job'})   datatable.addcolumn({ type: 'string', id: 'status' });   datatable.addcolumn({ type: 'date', id: 'start' });   datatable.addcolumn({ type: 'date', id: 'end' });   datatable.addrows(arrayresult);    chart.draw(datatable); }

Comments

Post a Comment

Popular posts from this blog

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m
Read more

javascript - Z-index in d3.js -

i have map , when hover effect on region of map below yellow line , circle, last ones disappear. how can solve problem? http://jsfiddle.net/ot21n9qx/ var arc = g.append("path") .style("fill", "none") .style("stroke", "yellow") .style("stroke-width", 2) .attr("d", "m" + pathorigin[0] + "," + pathorigin[1] + " q" + svgpoint[0] + "," + pathorigin[1] + " " + svgpoint[0] + "," + svgpoint[1]); var circlesize = d3.scale.linear() .domain([0, 0.5, 1]) .range([4, 10, 4]); svg not have z order draws objects in order created. need create path , circle after create highlight regions. here forked fiddle: http://jsfiddle.net/o00fzgaf/1/
Read more