Forums (Obsolete)

Member

Rodrigo Perez - 6/23/2011 5:17:16 AM

Charting

Hi there!
Im trying to render charts within a Kentico site.
I found the 3rd party web part for google charts, but seems that It cannot be connected to a data source.
I research about available tools such as fusion charts, js charts and so on... I want to avoid the usage of flash, since Im aiming to re-use code for iPhone and iPad apps.

So I have few questions:
- What is the recommended best practise to integrate live charting in kentico?
- Some of the JS solutions I found set the data in the JS code. Can I embeb macros or parameters in JS using Kentico?
- What technology for charting would you recommend?

Im pretty sure that I am not the first one trying to get this, but couldnt find any threats for this.

Your help and advise will be highly appreciated!


Member	Rodrigo Perez - 6/23/2011 5:20:32 AM RE:Charting Oh I forgot to mention that the data used to feed the charts come from a Web Service, not a sql database. The webservice is 100% compatible with Kentico. So I can use a webservice data source also to feed any kind of charting tool. (Option not available in Google Charts web Part.) :)

Kentico Consulting

kentico_borisp - 6/27/2011 9:23:39 AM

RE:Charting

Hello,

As far as i know there wasn't any similar request in the past and i wasn't also able to find any entry in our database about this. Anyway, you will have to create a custom web part which would generate the chart on the fly. As it turns out we currently don't have any web part or module suitable for this.
You can create either a custom javascript for creating charts or use some .net components.

So the short answers are:

1) There isn't any. Choose the one which better suits your needs. If you want to re-use the code I would recommend you to use JS.
2) No, regrettably this isn't possible. We don't parse the JS code for our macros or any other code of ours.
3) This depends on your preferences. Kentico will use the library provided by .net in the next 6.0 version to create charts from reports.

Best regards,
Boris Pocatko


Member	matan - 6/29/2011 4:11:35 AM RE:Charting Hi, I'm currently using FusionCharts (http://www.fusioncharts.com/) in Kentico. The only thing you've to do is to transform data coming from your webservice into an XML file or XML formatted long string. There's an appropriate XML structure for any kind of chart you need. If you need extra help, feel free to contact me!

Member

Rodrigo Perez - 6/29/2011 4:23:35 AM

RE:Charting

Thank you very much for the offer.
Fusion charts was actually my first choice.

Can you send me a link to your web to see the charts working?
Also, I would really appreciate if you can share with me the XML definition that fits. I guess I can easily modify the output of the web services, since their only purpose is to feed my charts.

Thanks again.
Rodrigo
rodrigo.perez@acumenholding.com

Member

matan - 6/29/2011 4:40:13 AM

RE:Charting

Hi Rodrigo,
unfortunately I can't show the web site where I've used Fusioncharts because it's an internal one of my company. So the external access is denied.
Anyway I can't send you anything because the XML depends on the kind of chart you need: pie, column, bar and so on. So, first of all, I suggest you to download the free or evaluate version. Take care that the free version processes the charts in flash while the evaluate version processes charts in javascript/Html5 and flash if you need compatibility with devices which don't support flash, such as apple products.
The evaluate version put a label "EVALUATE VERSION" over your chart, so you need to buy the license when you'll finish your development :)
The example section in both version is really nice and for sure you'll find the example which fits best your requirements.

After you'll download the appropriate package and you'll start to develop something then I could help you only regarding Kentico+Fusioncharts issues.
If you have any trouble with Fusioncharts, please take a look at their forum.
Regards.