Articles
Da Honey Pot
About meThis entry was posted on Monday, November 5th, 2007 at 2:19 pm and is filed under Cool Tools, IBM Lotus Notes, Interface, Webdesign. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
BizzyBee’s BizzyThoughts
Think Outside The Hive – About Notes and Web
Even better looking charts from your data with Fusioncharts
My very first article here was about how to create good looking charts from your data.
I found a tool that produces even better looking results in the browser. Take a look at this:
The tool I found was FusionCharts. It’s not freeware or open source, but you can download an evaluation version on their site and if you like it, you can buy a user license for 69$ (this means you cannot edit the flash source code, and you are allowed to use it on one website and an unlimited number of developer and test servers).
Using their evaluation version, I created a charts demo database with some examples on how to use Fusioncharts in a Lotus Notes web application.
Just download and unzip the database and do a web preview of the page Charts.
Below you find a clarifying image of the different parts that are needed in html.
- Include the FusionCharts.js javascript library. I inserted it in the file resources of the database.
- You need a reference to the type of chart to use. All charts are included in the file resources as swf (Flash) movies. If you ever buy a license, just replace the files in the file resources with the files in the charts directory of the package.
- Add a div where you want to display the chart and refer to it by its id in your javascript.
- The data must be present in an xml file. This is where you have to decide on how to deliver the xml.
- Give the chart object a name for js access, f.e. to do a refresh of the chart.
- Experiment with the dimensions of the chart.
I included 3 examples in the demo database:
- Pie3D (top image) uses form piedata to create documents, view piedataxml to embed in page pie3d.xml. The page also contains the markup xml.
- Column2D (image below) uses form columndata to create documents, view columndataxml is used to access its values via @DbColumn in page column2d.xml.
- MsColumn3D (image below): I just put the data in a simple page mscolumn3D.xml (I didn’t have any spare energy to create a structure around it
)
For an explanation of all different parameters, settings and chart types, I refer to their website. There are tons of different possibilities, gradients, shadows, neat color schemes,… to satisfy even the most graphic hungry among you.
(4 votes, average: 5.00 out of 5)
Loading ...
December 20th, 2007 at 4:40 pm
I have setup some databases with FusionChart myself, based on Ferdy Christant’s blog article.
The charts look very nice indeed and easy to implement!
December 21st, 2007 at 10:24 am
Apparently somebody out there already created a demo. It’s hard to come up with something original with all those good bloggers out there
. But then again, 2 ways of explaining the same thing=more information, somewhat different approach,…
December 27th, 2007 at 4:32 pm
[...] real purpose then. Until I saw IntelliPRINT’s Dashboard Reporting: they use FusionCharts, the tool I spoke about earlier, to display its amazing charts in the [...]
November 18th, 2008 at 10:14 pm
Any easy way to have this pull in categorized data from a notes view….to get the record count by category and then chart that?
Thanks
(By easy I am hoping to avoid looping through each document to determine the number in each category)
November 23rd, 2008 at 2:48 pm
Dan – You should try IntelliPRINT Dashboard Reporting
March 10th, 2009 at 10:04 pm
Do you know how to make this work by passing values in a url and generating xml via an agent? I would like to pass an account number to an agent, and generate the xml on the fly. But the chart.setDataURL parameter isn’t reading anything after the question mark.
chart.setDataURL(“https://cbsdev.cbservices.org/testPieAgent2.xml?openagent&France=100″);
If you open the URL itself, you’ll see that it set’s France to 100 in the XML. But it’s not working when in the setDataURL parameter – so I think it’s ignoring everything after the question mark.
Do you know of any other way to accomplish this?
March 10th, 2009 at 10:09 pm
Sorry wrong URL:
http://www.cbservices.org/charts_demo.nsf/testPieAgent2.xml?openagent&France=100
Generates the XML, but this page doesn’t show France:
http://www.cbservices.org/charts_demo.nsf/testPieAgent2?OpenPage
March 11th, 2009 at 4:03 pm
I figured it out – the setDataURL doesn’t like the ‘&’ after the open agent. Use the character code ‘%26′ instead.
March 11th, 2009 at 10:33 pm
Great, Jason, I didn’t have to do anything, you figured it out by yourself!
.
Thanks for the tip!
April 14th, 2009 at 9:10 pm
Hi, i need to do some charts in a application, but i need it works like a server, i put your chart demo in the server where it will work but when the example CHARTS runs get the “Error in loading data”, what can i do?
July 6th, 2009 at 6:21 pm
x0DwMe Hi! The post is really interesting! I’ve read your blog and can say it’s a good job.thanks,
July 6th, 2009 at 6:21 pm
Thank you for this site, such as multi information.I! Thank you!,
July 6th, 2009 at 6:21 pm
Bravo! Nice Article.,
July 6th, 2009 at 6:21 pm
Thanks for your insights – I couldn’t agree more.,
July 6th, 2009 at 6:21 pm
beautiful site..)),
July 6th, 2009 at 6:22 pm
Hi can someone please translate for me thanx,
July 6th, 2009 at 6:22 pm
Nice man!,
July 6th, 2009 at 6:22 pm
beautiful site..)),
July 6th, 2009 at 6:22 pm
Great post, well written!,
July 6th, 2009 at 6:23 pm
beautiful site..)),
July 6th, 2009 at 6:23 pm
Thanks I’ll give that a go!,
July 6th, 2009 at 6:24 pm
Cool Info, practical.. lol,
July 6th, 2009 at 6:24 pm
Don’t you think he is a little late for the game?,
July 6th, 2009 at 6:24 pm
Thanks I’ll give that a go!,
July 6th, 2009 at 6:25 pm
Cool Info, practical.. lol,
November 23rd, 2009 at 6:37 am
8RmHxc http://j8Jw83mNs0doPpsqvjrcns5.info
March 3rd, 2011 at 5:51 pm
I’ve to say that I concur with all the sentiments about getting AOL as quantity one particular. The comments posted along side it sum it up nicely, that it does almost nothing to strengthen the brand, but only adds confusion.From the perfect rebrands while in the l ist, I would place SyFy at the prime. In the beginning I hated the name, due to the fact I thought they did it ??just because,??? when actually that they had to change their name due to getting unable to legally use Sci-fi.??? Now relatively than coming up which has a full new name that no one would know- and maybe lose a great deal with the previously inbuilt SciFi??? brand- they caught using the outdated name which has a little bit of phrase play. I can even now call SyFy Sci-fi when it comes up, and that makes me satisfied.
May 22nd, 2011 at 8:19 pm
Howdy! I know this is kinda off topic however , I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog article or vice-versa? My site covers a lot of the same topics as yours and I think we could greatly benefit from each other. If you happen to be interested feel free to send me an e-mail. I look forward to hearing from you! Fantastic blog by the way!
May 22nd, 2011 at 9:32 pm
Your blog is just about the most informative information sites within this industry. Practically every blog post that you make is golden. Your way of writing is eloquent, exciting,and very interesting.
June 14th, 2011 at 1:55 am
Thanks for every other informative website. The place else may I am getting that type of information written in such an ideal manner? I’ve a undertaking that I’m simply now operating on, and I have been at the glance out for such info.
July 12th, 2011 at 7:49 am
Thanks for another magnificent article. Where else could anybody get that type of info in such an ideal way of writing? I’ve a presentation next week, and I’m on the look for such info.
July 31st, 2011 at 2:24 am
Thank you a whole lot with regard to offering people who have this type of marvellous possiblity to verify suggestions from this website. It’s typically extremely ideal and stuffed with an enjoyable experience personally as well as my personal workplace partners to talk to your web site specifically three times every week to study the fresh stuff you have. And finally, we’re certainly contented concerning the terrific info you give. Picked a couple of tips about this site are really the finest I have ever experienced.
August 6th, 2011 at 12:56 pm
Wow, fantastic weblog format! How long have you ever been blogging for? you made running a blog glance easy. The whole glance of your web site is magnificent, let alone the content material!
August 23rd, 2011 at 3:13 pm
Good post. I be taught something more difficult on completely different blogs everyday. It’s going to all the time be stimulating to learn content from other writers and apply a little something from their store. I’d favor to make use of some with the content on my weblog whether you don’t mind. Natually I’ll provide you with a link on your internet blog. Thanks for sharing.
September 15th, 2011 at 12:40 am
I went over this web site and I think you have a lot of great info, bookmarked (:.
September 22nd, 2011 at 2:49 am
Rattling informative and good bodily structure of subject matter, now that’s user friendly (:.
December 22nd, 2011 at 1:46 pm
I just ran across the OpenNTF chart app (*) that uses the free version of FusionCharts and was having trouble understanding how to use the DataURL method instead of the agent driven method so your sample db is great. I’m not sure that the Data method turns out to be any better than the Data XML method. When you build the XML string in an agent, the data is sting length limited. If you use views and create the dataULR method, you’re doing a dbColumn to set the ‘XML’data and that is also limited. I don’t know if the DbColumn is bigger than smaller than the xml string limit. In any case, thanks for the example.
(*) http://www.openntf.org/internal/home.nsf/release.xsp?action=openDocument&documentId=CF77960FE7FF01FF86257584001ABB59