Hi Martin, Sure, just give me another day or two, I'll make a simple SQLite example of the d3one you mentioned. It isn't too complex to hook d3 up to a web2py json (or csv) output. I'm still experimenting in getting the graphs to dynamically update, and to also allow database updates from user actions (such as dragging and dropping to establish relationships). d3 has a learning curve, so my attempts so far a proofs of concepts without a lot of flashy layouts.
Hi Derek, I't can be done without too much hassle from the browser, but I need to cater for IE users, and also to do some batch processing and report output. On Tuesday, July 3, 2012 10:13:12 AM UTC+12, Derek wrote: > > OP said he was interested in doing it on the server, but doing it on the > client can reduce server load and perhaps that will work for you. You could > take the SVG and render it to a canvas and then export the canvas to PNG. > Here is a javascript library which does such a thing. > > http://www.nihilogic.dk/labs/canvas2image/ > > > Thanks, > Derek > > On Monday, July 2, 2012 3:48:04 AM UTC-7, Martin Felder wrote: >> >> Hi Andrew, >> >> I'm currently looking for a good data vis toolkit for web2py. Currently >> we are plotting things with matplotlib in the background and display the >> generated PNGs, but that feels rather awkward and is not interactive (ok, I >> could generate SVGs and fiddle with them using StringIO and XML parsing, >> but that seems to convoluted to me). >> >> Since my MS Office using clientele can't deal with SVGs, I'm very >> interested in how the PNG conversion issue turns out. >> >> Coming back to your offer, could you perhaps post a simple example on how >> to integrate web2py and d3.js? For now I'm particularly interested in the >> ingenious barcharts example on >> http://mbostock.github.com/d3/ex/stack.html - how do I replace the faux >> data generation functions with a web2py controller passing a data array? >> >> Thanks, >> Martin >> >>