How to create new charts using DashletGenericChart() - 5.5.x

[Jeremy Hutchings]

I'm trying to make a range of custom charts (as dashlets) so users can add them to their dashboard as they like.

All I've been able to find so far is :

http://developers.sugarcrm.com/docs/...r.html#9000997

And there appears to be nothing in the wiki. I've gone though class SugarChart() and am currently reverse engineering an API doc so I can get a clue of what is going on.

I've copied an exsisting Chart Dashlet from ........

{$home}/modules/Charts/Dashlets

......and am trying to work though how it creates the query, XML, then eventaully displays it.

Though with no documentation it's very slow going.

Does anyone know off or have the API documentation (if it exsists) a tutorial or even what format the query result needs to be parsed into for the XML ?

Thanks.

[Jeremy Hutchings]

I found this :

http://media.sugarcrm.com/50tutorial...ing/index.html

And various threads like :

http://www.sugarcrm.com/forums/showt...ighlight=chart

http://www.sugarcrm.com/forums/showt...d=1#post108452

etc.

Though all seem to point to the fact that either get Pro, or you're wading though undocumented code to figure it out, is that the case ?

Going to have a look at this now : http://www.sugarcrm.com/forums/showp...5&postcount=23

[Jeremy Hutchings]

Does anyone know what format or structure

$sugarChart->data_set

Should be in ?

[andopes]

data_set is an array of fetched rows from database, as can be seen at SugarChar::getData()

Cheers

[Jeremy Hutchings]

data_set is an array of fetched rows from database, as can be seen at SugarChar::getData()

Cheers

Indeed I found that - though I need to find the structure of that array and what fields are expected for each graph type to be able to ensure it's created correctly.

It's not key value or straight array as there would be with jpgraph, there are other things going on.

A link to the documentation of what is expected in the XML would be ideal if it exists ?

Has http://www.sugardev.net/ been taken down ? as it's the only place I can find any class reference at all :

http://webcache.googleusercontent.co...www.google.com

[Jeremy Hutchings]

In the Pro version is there actually Pro developer documentation or existing development that allows the creation of custom charts ?


Off to decompile the Flash now to see if there are any clues in there.

[Jeremy Hutchings]

It would appear to get the XML format expected by the SWF you have to decompile it with something like flare and then reverse engineer the code.

Which is what I've done.

It seems a little extreme ........ maybe having some even half decent developer documentation would be an idea to support the growth of this project. Any ideas what happened to the sugardev site ?

[Jeremy Hutchings]

If in doubt (or with no documentation and near code obfuscation) write your own !

http://www.jeremyhutchings.com/2011/...rm-graphs.html

[agcopley]

Nice work Mr Hutchins and thanks for the contribution!