[OFBiz] Dev - Questions about generating Charts and data mining
Locked
[OFBiz] Dev - Questions about generating Charts and data mining
 
|
Has anybody implement graph analysis reports on OfBiz?
Any idea how can I integrate it? I came across with this Open-Source Chartreport tool BIRT, anybody use that before? or any recommendation how can I generate chart? Besides, anybody implemented Data Mining on Ofbiz as I have this customer questioning whether can have Business Intelligent feature on Ofbiz such as Sales Forecasting etc? Can anybody provide me guidance on implementing my own SQL query on my component as the tutorial given is just using the existing data model to retrieve the data without any sql query? I need it because I need to do calculation such as count, sum , etc on my Query. Thank you --- [hidden email] wrote: > Send Dev mailing list submissions to > [hidden email] > > To subscribe or unsubscribe via the World Wide Web, > visit > http://lists.ofbiz.org/mailman/listinfo/dev > or, via email, send a message with subject or body > 'help' to > [hidden email] > > You can reach the person managing the list at > [hidden email] > > When replying, please edit your Subject line so it > is more specific > than "Re: Contents of Dev digest..." > > > Today's Topics: > > 1. Re: orderstatus.bsh context creating too much > log (Chris Howe) > 2. About adding "createdByUserLogin" and > "lastModifiedByUserLogin" to every entity (Yan > Li) > 3. How about the <constraint-list> in > <view-entity>? (Yan Li) > 4. Re: How about the <constraint-list> in > <view-entity>? (Yan Li) > 5. Re: How to filter a field in a <view-entity> > (Yan Li) > 6. Re: How to filter a field in a <view-entity> > (Yan Li) > 7. Re: persisting dynamic entity created with > ModelEntity > (David E. Jones) > 8. Re: About adding "createdByUserLogin" and > "lastModifiedByUserLogin" to every entity > (David E. Jones) > 9. communication event form error (Si Chen) > > > > > Message: 1 > Date: Wed, 10 Aug 2005 19:55:57 -0700 (PDT) > From: Chris Howe <[hidden email]> > Subject: Re: [OFBiz] Dev - orderstatus.bsh context > creating too much > log > To: OFBiz Project Development Discussion > <[hidden email]> > Message-ID: > <[hidden email]> > Content-Type: text/plain; charset=iso-8859-1 > > can you update it to be active only for demo stores? > > It's pretty useful when customizing services and > such > that use ecommerce as a base. > > > --- Si Chen <[hidden email]> wrote: > > > Does anybody still need this? It generates TONS > of > > log messages: > > > > > > > > > info context: " + context, "orderstatus.bsh"); > > > > > > If it's no longer needed can we remove it? > > > > Thanks, > > > > Si > > > > _______________________________________________ > > Dev mailing list > > [hidden email] > > http://lists.ofbiz.org/mailman/listinfo/dev > > > > > > ------------------------------ > > Message: 2 > Date: Thu, 11 Aug 2005 15:48:53 +0800 > From: Yan Li <[hidden email]> > Subject: [OFBiz] Dev - About adding > "createdByUserLogin" and > "lastModifiedByUserLogin" to every entity > To: OFBiz Dev Mailing list <[hidden email]> > Message-ID: > <[hidden email]> > Content-Type: text/plain; charset=ISO-8859-1 > > Hello, > > Under many circumstances I found the need for fields > like > "createdByUserLogin" and "lastModifiedByUserLogin" > on every entity > just like the auto time stamp. I wonder your opinion > on this and why > these were not included in OFBiz Entity Engine yet? > > I've searched through the mailing list and found > just one post on this: > > > But no answer to it. > > Thanks in advance. > > -- > Best regards, > Yan > > > ------------------------------ > > Message: 3 > Date: Thu, 11 Aug 2005 16:33:34 +0800 > From: Yan Li <[hidden email]> > Subject: [OFBiz] Dev - How about the > <constraint-list> in > <view-entity>? > To: OFBiz Dev Mailing list <[hidden email]> > Message-ID: > <[hidden email]> > Content-Type: text/plain; charset=ISO-8859-1 > > Hello, > > Is there anyway currently exists to filter the > records in a > <view-entity> by setting constraint on some fields? > In previous > mailing lists, I found Adam had done a good job on > this: > > > Since it's old and long have passed since then, is > there a plan on > this feature now? > > Thanks. > > -- > Best regards, > Yan > > > ------------------------------ > > Message: 4 > Date: Thu, 11 Aug 2005 17:02:46 +0800 > From: Yan Li <[hidden email]> > Subject: Re: [OFBiz] Dev - How about the > <constraint-list> in > <view-entity>? > To: OFBiz Dev Mailing list <[hidden email]> > Message-ID: > <[hidden email]> > Content-Type: text/plain; charset=ISO-8859-1 > > Hello, > > Sorry, I haven't seen the former letters on this > problem I have posted > before( > > ), since a mailbox failure. > > > On 8/11/05, Yan Li <[hidden email]> wrote: > > Hello, > > > > Is there anyway currently exists to filter the > records in a > > <view-entity> by setting constraint on some > fields? In previous > > mailing lists, I found Adam had done a good job on > this: > > > > > > > Since it's old and long have passed since then, is > there a plan on > > this feature now? > > > > Thanks. > > > > -- > > Best regards, > ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Re: [OFBiz] Dev - Questions about generating Charts and data mining
|
|
Gan:
I was able to integrate (if you can call it that) the JFreeChart (http://www.jfree.org) charting tool with an OFBiz install. Don't know if those are the kinds of graphs you are interested in. If so, here's what I did. This was a "quick and dirty" install just to see if this would work. I wouldn't necessarily do it this way for the long run (BTW, this creates graph images in real time - that are delivered directly to an <img src= > tag within HTML/ Freemarker.) 1. Created a separate component for JFreeChart software (it comes with some servlet demonstration programs) 2. Used web.xml and no controller.xml file to configure the component (and servlet) 3. Followed the "servlet" install directions for JFreeChart to install the demo servlet and html files provided 4. Installed the JFreeChart .jar files in the ~build/lib directory in the new component (so I could create my own SQL and java programs) 5. Followed the jdbc examples for JFreeChart and pointed the queries to my OFBiz database. (I didn't have a chance to actually use the Engine Engine from within my new component - I just made straight SQL calls. ) 6. Tested first with just the demo stuff, including the sample JDBC program provided. I tested by just installing the demo html in another OFBiz component. Then I created some of my own calls. 7. After I got that to work, I changed the demo servlet so that it created the kinds of charts/graphs using my OFBiz data. So, that works although, like I said, at some point I will go back and at least use the Entity Engine to make the SQL calls. The other thing you have to do, and I don't know how to get around this, is to set the calling component(s) web.xml file(s) so that they will not filter anything from your JFreeChart URI. So for example, in my web.xml file for the component that hosts the Freemarker file with the <img = xxx> in it, I have something like: <init-param> <param-name>allowedPaths</param-name> <param-value>/images:/jfreechart</param-value> </init-param> Hope that makes sense. Regards, Ruth Gan Chun Yee wrote: >Has anybody implement graph analysis reports on OfBiz? >Any idea how can I integrate it? I came across with >this Open-Source Chartreport tool BIRT, anybody use >that before? or any recommendation how can I generate >chart? > >Besides, anybody implemented Data Mining on Ofbiz as I >have this customer questioning whether can have >Business Intelligent feature on Ofbiz such as Sales >Forecasting etc? > >Can anybody provide me guidance on implementing my own >SQL query on my component as the tutorial given is >just using the existing data model to retrieve the >data without any sql query? I need it because I need >to do calculation such as count, sum , etc on my >Query. > >Thank you > >--- [hidden email] wrote: > > > >>Send Dev mailing list submissions to >> [hidden email] >> >>To subscribe or unsubscribe via the World Wide Web, >>visit >> http://lists.ofbiz.org/mailman/listinfo/dev >>or, via email, send a message with subject or body >>'help' to >> [hidden email] >> >>You can reach the person managing the list at >> [hidden email] >> >>When replying, please edit your Subject line so it >>is more specific >>than "Re: Contents of Dev digest..." >> >> >>Today's Topics: >> >> 1. Re: orderstatus.bsh context creating too much >>log (Chris Howe) >> 2. About adding "createdByUserLogin" and >> "lastModifiedByUserLogin" to every entity (Yan >>Li) >> 3. How about the <constraint-list> in >><view-entity>? (Yan Li) >> 4. Re: How about the <constraint-list> in >><view-entity>? (Yan Li) >> 5. Re: How to filter a field in a <view-entity> >>(Yan Li) >> 6. Re: How to filter a field in a <view-entity> >>(Yan Li) >> 7. Re: persisting dynamic entity created with >>ModelEntity >> (David E. Jones) >> 8. Re: About adding "createdByUserLogin" and >> "lastModifiedByUserLogin" to every entity >>(David E. Jones) >> 9. communication event form error (Si Chen) >> >> >> >> >> >---------------------------------------------------------------------- > > >>Message: 1 >>Date: Wed, 10 Aug 2005 19:55:57 -0700 (PDT) >>From: Chris Howe <[hidden email]> >>Subject: Re: [OFBiz] Dev - orderstatus.bsh context >>creating too much >> log >>To: OFBiz Project Development Discussion >><[hidden email]> >>Message-ID: >><[hidden email]> >>Content-Type: text/plain; charset=iso-8859-1 >> >>can you update it to be active only for demo stores? >> >>It's pretty useful when customizing services and >>such >>that use ecommerce as a base. >> >> >>--- Si Chen <[hidden email]> wrote: >> >> >> >>>Does anybody still need this? It generates TONS >>> >>> >>of >> >> >>>log messages: >>> >>> >>> >>> >ecommerce/webapp/ecommerce/WEB-INF/actions/order/orderstatus.bsh:Debug.logInfo("orderstatus > > >>>info context: " + context, "orderstatus.bsh"); >>> >>> >>>If it's no longer needed can we remove it? >>> >>>Thanks, >>> >>>Si >>> >>>_______________________________________________ >>>Dev mailing list >>>[hidden email] >>>http://lists.ofbiz.org/mailman/listinfo/dev >>> >>> >>> >> >>------------------------------ >> >>Message: 2 >>Date: Thu, 11 Aug 2005 15:48:53 +0800 >>From: Yan Li <[hidden email]> >>Subject: [OFBiz] Dev - About adding >>"createdByUserLogin" and >> "lastModifiedByUserLogin" to every entity >>To: OFBiz Dev Mailing list <[hidden email]> >>Message-ID: >><[hidden email]> >>Content-Type: text/plain; charset=ISO-8859-1 >> >>Hello, >> >>Under many circumstances I found the need for fields >>like >>"createdByUserLogin" and "lastModifiedByUserLogin" >>on every entity >>just like the auto time stamp. I wonder your opinion >>on this and why >>these were not included in OFBiz Entity Engine yet? >> >>I've searched through the mailing list and found >>just one post on this: >> >> >> >http://lists.ofbiz.org/pipermail/dev/2004-November/007083.html > > >>But no answer to it. >> >>Thanks in advance. >> >>-- >>Best regards, >>Yan >> >> >>------------------------------ >> >>Message: 3 >>Date: Thu, 11 Aug 2005 16:33:34 +0800 >>From: Yan Li <[hidden email]> >>Subject: [OFBiz] Dev - How about the >><constraint-list> in >> <view-entity>? >>To: OFBiz Dev Mailing list <[hidden email]> >>Message-ID: >><[hidden email]> >>Content-Type: text/plain; charset=ISO-8859-1 >> >>Hello, >> >>Is there anyway currently exists to filter the >>records in a >><view-entity> by setting constraint on some fields? >>In previous >>mailing lists, I found Adam had done a good job on >>this: >> >> >> >http://lists.ofbiz.org/pipermail/dev/2004-March/004380.html > > >>Since it's old and long have passed since then, is >>there a plan on >>this feature now? >> >>Thanks. >> >>-- >>Best regards, >>Yan >> >> >>------------------------------ >> >>Message: 4 >>Date: Thu, 11 Aug 2005 17:02:46 +0800 >>From: Yan Li <[hidden email]> >>Subject: Re: [OFBiz] Dev - How about the >><constraint-list> in >> <view-entity>? >>To: OFBiz Dev Mailing list <[hidden email]> >>Message-ID: >><[hidden email]> >>Content-Type: text/plain; charset=ISO-8859-1 >> >>Hello, >> >>Sorry, I haven't seen the former letters on this >>problem I have posted >>before( >> >> >> >http://lists.ofbiz.org/pipermail/dev/2005-August/008985.html > > >>), since a mailbox failure. >> >> >>On 8/11/05, Yan Li <[hidden email]> wrote: >> >> >>>Hello, >>> >>>Is there anyway currently exists to filter the >>> >>> >>records in a >> >> >>><view-entity> by setting constraint on some >>> >>> >>fields? In previous >> >> >>>mailing lists, I found Adam had done a good job on >>> >>> >>this: >> >> >http://lists.ofbiz.org/pipermail/dev/2004-March/004380.html > > >>>Since it's old and long have passed since then, is >>> >>> >>there a plan on >> >> >>>this feature now? >>> >>>Thanks. >>> >>>-- >>>Best regards, >>> >>> >=== message truncated === > > > > >____________________________________________________ >Start your day with Yahoo! - make it your home page >http://www.yahoo.com/r/hs > > >_______________________________________________ >Dev mailing list >[hidden email] >http://lists.ofbiz.org/mailman/listinfo/dev > > > _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |