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

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

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

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more