Charting in OFBiz

[Erwan de FERRIERES]

Hi all,

Following the discussion about charting and which library to use, I've
added at rev. 945044 a full set of charting capabilities to OFBiz.
Those is based on flotr, a library using prototype. It"s under a MIT
license, so there is no problem.

The example on how to use it is in the example component. 2 new screens
have been added, one for a bar chart, the other for a pie chart.

In order to have data to display, you need to create new examples, and
use different types, so it would be nicer.

The charts are based on a view, which counts the types and totals
related to them. From the screens in example, you will see it has a
great extending capacity.

New chart types can be included, they just have to be developped.
Examples on what can be displayed are just a click away :
http://phenxdesign.net/projects/flotr/examples/prototype/

Regards,

--
Erwan de FERRIERES
www.nereide.biz

[Bruno Busco]

Hi Erwan,
thank you for your work on this subject. I think it will be very usefull.
BTW I have tested it on the demo server right now but this link:
https://demo-trunk.ofbiz.apache.org/example/control/BarChart

gives an error:
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://example/widget/example/ExampleScreens.xml#BarChart]:
java.lang.IllegalArgumentException: In find entity by condition could not
find definition for entity with name [ExampleCountByType]. (In find entity
by condition could not find definition for entity with name
[ExampleCountByType].)

Could you please check if something is missing? (I did not tested it yet
locally)

I think it would be the best to have a single entry in the example
application menu named "Chart examples" and then several different screens
(they can become many) at a lower level.
I used this arrangement in the geo-localizzation example.

Thank you,
Bruno

2010/5/17 Erwan de FERRIERES <[hidden email]>

> Hi all,
>
> Following the discussion about charting and which library to use, I've
> added at rev. 945044 a full set of charting capabilities to OFBiz.
> Those is based on flotr, a library using prototype. It"s under a MIT
> license, so there is no problem.
>
> The example on how to use it is in the example component. 2 new screens
> have been added, one for a bar chart, the other for a pie chart.
>
> In order to have data to display, you need to create new examples, and use
> different types, so it would be nicer.
>
> The charts are based on a view, which counts the types and totals related
> to them. From the screens in example, you will see it has a great extending
> capacity.
>
> New chart types can be included, they just have to be developped. Examples
> on what can be displayed are just a click away :
> http://phenxdesign.net/projects/flotr/examples/prototype/
>
> Regards,
>
> --
> Erwan de FERRIERES
> www.nereide.biz
>

[Jacques Le Roux]

Bruno,

It's because I updated manually for a bug I fixed in layered lookup but I did not take the time to make the whole update process (I
only svn updated and ant svninfo). The bot will do it soon (every 24h)
So you have to try it locally for now...

Jacques

From: "Bruno Busco" <[hidden email]>

> Hi Erwan,
> thank you for your work on this subject. I think it will be very usefull.
> BTW I have tested it on the demo server right now but this link:
> https://demo-trunk.ofbiz.apache.org/example/control/BarChart
>
> gives an error:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://example/widget/example/ExampleScreens.xml#BarChart]:
> java.lang.IllegalArgumentException: In find entity by condition could not
> find definition for entity with name [ExampleCountByType]. (In find entity
> by condition could not find definition for entity with name
> [ExampleCountByType].)
>
> Could you please check if something is missing? (I did not tested it yet
> locally)
>
> I think it would be the best to have a single entry in the example
> application menu named "Chart examples" and then several different screens
> (they can become many) at a lower level.
> I used this arrangement in the geo-localizzation example.
>
> Thank you,
> Bruno
>
> 2010/5/17 Erwan de FERRIERES <[hidden email]>
>
>> Hi all,
>>
>> Following the discussion about charting and which library to use, I've
>> added at rev. 945044 a full set of charting capabilities to OFBiz.
>> Those is based on flotr, a library using prototype. It"s under a MIT
>> license, so there is no problem.
>>
>> The example on how to use it is in the example component. 2 new screens
>> have been added, one for a bar chart, the other for a pie chart.
>>
>> In order to have data to display, you need to create new examples, and use
>> different types, so it would be nicer.
>>
>> The charts are based on a view, which counts the types and totals related
>> to them. From the screens in example, you will see it has a great extending
>> capacity.
>>
>> New chart types can be included, they just have to be developped. Examples
>> on what can be displayed are just a click away :
>> http://phenxdesign.net/projects/flotr/examples/prototype/
>>
>> Regards,
>>
>> --
>> Erwan de FERRIERES
>> www.nereide.biz
>>
>

[Erwan de FERRIERES]

Le 17/05/2010 18:52, Bruno Busco a écrit :

> Hi Erwan,
> thank you for your work on this subject. I think it will be very usefull.
> BTW I have tested it on the demo server right now but this link:
> https://demo-trunk.ofbiz.apache.org/example/control/BarChart
>
> gives an error:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://example/widget/example/ExampleScreens.xml#BarChart]:
> java.lang.IllegalArgumentException: In find entity by condition could not
> find definition for entity with name [ExampleCountByType]. (In find entity
> by condition could not find definition for entity with name
> [ExampleCountByType].)
>
> Could you please check if something is missing? (I did not tested it yet
> locally)
>

Hi Bruno,

Thanks for your inputs. I will then go this way.

For the missing view, the view (ExampleCountByType) is missing. Just
restarting the server should do the trick !

Cheers,

>> The example on how to use it is in the example component. 2 new screens
>> have been added, one for a bar chart, the other for a pie chart.
>>
>> In order to have data to display, you need to create new examples, and use
>> different types, so it would be nicer.
>>
>> The charts are based on a view, which counts the types and totals related
>> to them. From the screens in example, you will see it has a great extending
>> capacity.
>>
>> New chart types can be included, they just have to be developped. Examples
>> on what can be displayed are just a click away :
>> http://phenxdesign.net/projects/flotr/examples/prototype/
>>
>> Regards,
>>
>> --
>> Erwan de FERRIERES
>> www.nereide.biz
>>
>

--
Erwan de FERRIERES
www.nereide.biz

[Harmeet Bedi]

I realize this may be a bit late to talk about libs.
but one library that we have used is Google visualization
(http://code.google.com/apis/visualization/documentation/gallery.html)

The good(and bad) thing is that the library is external. Ofbiz through
custom rendering only generates data specification.

Harmeet

On 17/05/10 3:43 PM, Erwan de FERRIERES wrote:

> Hi all,
>
> Following the discussion about charting and which library to use, I've
> added at rev. 945044 a full set of charting capabilities to OFBiz.
> Those is based on flotr, a library using prototype. It"s under a MIT
> license, so there is no problem.
>
> The example on how to use it is in the example component. 2 new screens
> have been added, one for a bar chart, the other for a pie chart.
>
> In order to have data to display, you need to create new examples, and
> use different types, so it would be nicer.
>
> The charts are based on a view, which counts the types and totals
> related to them. From the screens in example, you will see it has a
> great extending capacity.
>
> New chart types can be included, they just have to be developped.
> Examples on what can be displayed are just a click away :
> http://phenxdesign.net/projects/flotr/examples/prototype/
>
> Regards,
>

[Scott Gray-2]

I think the google api could be a good example of how we might build our own.  Hell something like that could be its own project, a drop-in servlet that provides the same chart rendering functionality as google's servers.

But ultimately google provides these services in order to gain access to your data and to your users, and that isn't really something you want to provide from an ERP application.  In addition most of the google APIs are only available free of charge when used in a publicly accessible website which is why I'm not entirely comfortable having the google maps API used on the backend.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 29/05/2010, at 6:19 AM, Harmeet Bedi wrote:

> I realize this may be a bit late to talk about libs.
> but one library that we have used is Google visualization (http://code.google.com/apis/visualization/documentation/gallery.html)
>
> The good(and bad) thing is that the library is external. Ofbiz through custom rendering only generates data specification.
>
> Harmeet
>
> On 17/05/10 3:43 PM, Erwan de FERRIERES wrote:
>> Hi all,
>>
>> Following the discussion about charting and which library to use, I've
>> added at rev. 945044 a full set of charting capabilities to OFBiz.
>> Those is based on flotr, a library using prototype. It"s under a MIT
>> license, so there is no problem.
>>
>> The example on how to use it is in the example component. 2 new screens
>> have been added, one for a bar chart, the other for a pie chart.
>>
>> In order to have data to display, you need to create new examples, and
>> use different types, so it would be nicer.
>>
>> The charts are based on a view, which counts the types and totals
>> related to them. From the screens in example, you will see it has a
>> great extending capacity.
>>
>> New chart types can be included, they just have to be developped.
>> Examples on what can be displayed are just a click away :
>> http://phenxdesign.net/projects/flotr/examples/prototype/
>>
>> Regards,
>>
>