OFBiz › OFBiz - User

Query regarding ofbiz-BIRT integration

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

6 messages Options

Swapnil Sawant

Query regarding ofbiz-BIRT integration

Hi,

I am new to report generation in ofbiz using BIRT GUI. For achieving report generation in ofbiz, I follow below steps :

1. Prepare the report using BIRT GUI (designing format of report, assigning entity data to the fields in it)

2. Generate the code out of it .

3. Once code is generated, I need to change that auto-generated code from BIRT GUI for some of the following things :

a. Writing ofbiz logic (e.g. fetching data from ofbiz entity using delegator.findBy.. )in open and fetch methods

b. Change the entity field names from BIRT GUI format to ofbiz entity fields (e.g. emplId field in ofbiz entity becomes EMPL_ID in BIRT auto-generated code)

4. Once above filtration is done then only I can use "rptdesign" file in my ofbiz code.

Hence, I wanted to know is there any way by which we can eliminate step - 3 and start using BIRT auto-generated code directly in ofbiz in order to achieve following benefits :

- Making maintenance of reports very easy

- Reduce the development hours

- Smooth integration of BIRT and ofbiz

Thanks & Regards,
Swapnil Sawant

________________________________
This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

______________________________________________________________________

Santosh Malviya-3

Re: Query regarding ofbiz-BIRT integration

Hello Swapnil,

Instead of writing code in open and fetch method of rptdesign, you can use
groovy to fetch data and then just get your data in open from groovy and set
into fetch method, and groovy is easy to maintain than rptdesign.

--
Thanks and Regards
Santosh Malviya

On Thu, Aug 12, 2010 at 11:03 AM, Swapnil Sawant <
[hidden email]> wrote:

> Hi,
>
>
> I am new to report generation in ofbiz using BIRT GUI. For achieving report
> generation in ofbiz, I follow below steps :
>
>
> 1. Prepare the report using BIRT GUI (designing format of report,
> assigning entity data to the fields in it)
>
> 2. Generate the code out of it .
>
> 3. Once code is generated, I need to change that auto-generated code
> from BIRT GUI for some of the following things :
>
> a. Writing ofbiz logic (e.g. fetching data from ofbiz entity using
> delegator.findBy.. )in open and fetch methods
>
> b. Change the entity field names from BIRT GUI format to ofbiz entity
> fields (e.g. emplId field in ofbiz entity becomes EMPL_ID in BIRT
> auto-generated code)
>
>
> 4. Once above filtration is done then only I can use "rptdesign"
> file in my ofbiz code.
>
> Hence, I wanted to know is there any way by which we can eliminate step - 3
> and start using BIRT auto-generated code directly in ofbiz in order to
> achieve following benefits :
>
>
> - Making maintenance of reports very easy
>
> - Reduce the development hours
>
> - Smooth integration of BIRT and ofbiz
>
>
>
>
> Thanks & Regards,
> Swapnil Sawant
>
> ________________________________
> This Email may contain confidential or privileged information for the
> intended recipient (s) If you are not the intended recipient, please do not
> use or disseminate the information, notify the sender and delete it from
> your system.
>
> ______________________________________________________________________

Swapnil Sawant

RE: Query regarding ofbiz-BIRT integration

Hi Santosh,

Thanks for your reply.

Even if I migrate my logic of 'fetching data and then setting it to report fields' to groovy layer, I would still need to clear 'open' and 'fetch' method part from auto-generated code (as during report generation using BIRT GUI, I must have formed the queries to fetch data in report. Hence, code for this too would be present in 'open' and 'fetch' method of auto-generated code)

How can I avoid above situation ? i.e I just want that without making even a single change in 'auto-generated' code I should be able to run that report from ofbiz code. What settings / tasks I would have to do on BIRT GUI side to achieve this?

Thanks & Regards,

Swapnil Sawant

-----Original Message-----
From: Santosh Malviya [mailto:[hidden email]]
Sent: Thursday, August 12, 2010 12:21 PM
To: [hidden email]
Subject: Re: Query regarding ofbiz-BIRT integration

Hello Swapnil,

Instead of writing code in open and fetch method of rptdesign, you can use
groovy to fetch data and then just get your data in open from groovy and set
into fetch method, and groovy is easy to maintain than rptdesign.

--
Thanks and Regards
Santosh Malviya

On Thu, Aug 12, 2010 at 11:03 AM, Swapnil Sawant <
[hidden email]> wrote:

______________________________________________________________________

This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

______________________________________________________________________

Santosh Malviya-3

Re: Query regarding ofbiz-BIRT integration

Hello Swapnil,

If you have formed query in groovy then why are you again doing query in
rptdesign file, can you put your open and fetch code here to better
understand.

--
Thanks and Regards
Santosh Malviya

On Thu, Aug 12, 2010 at 1:00 PM, Swapnil Sawant <
[hidden email]> wrote:

> Hi Santosh,
>
> Thanks for your reply.
>
> Even if I migrate my logic of 'fetching data and then setting it to report
> fields' to groovy layer, I would still need to clear 'open' and 'fetch'
> method part from auto-generated code (as during report generation using BIRT
> GUI, I must have formed the queries to fetch data in report. Hence, code for
> this too would be present in 'open' and 'fetch' method of auto-generated
> code)
>
>
> How can I avoid above situation ? i.e I just want that without making even
> a single change in 'auto-generated' code I should be able to run that report
> from ofbiz code. What settings / tasks I would have to do on BIRT GUI side
> to achieve this?
>
>
>
>
>
>
> Thanks & Regards,
>
> Swapnil Sawant
>
>
> -----Original Message-----
> From: Santosh Malviya [mailto:[hidden email]]
> Sent: Thursday, August 12, 2010 12:21 PM
> To: [hidden email]
> Subject: Re: Query regarding ofbiz-BIRT integration
>
> Hello Swapnil,
>
> Instead of writing code in open and fetch method of rptdesign, you can use
> groovy to fetch data and then just get your data in open from groovy and
> set
> into fetch method, and groovy is easy to maintain than rptdesign.
>
> --
> Thanks and Regards
> Santosh Malviya
>
> On Thu, Aug 12, 2010 at 11:03 AM, Swapnil Sawant <
> [hidden email]> wrote:
>
> > Hi,
> >
> >
> > I am new to report generation in ofbiz using BIRT GUI. For achieving
> report
> > generation in ofbiz, I follow below steps :
> >
> >
> > 1. Prepare the report using BIRT GUI (designing format of report,
> > assigning entity data to the fields in it)
> >
> > 2. Generate the code out of it .
> >
> > 3. Once code is generated, I need to change that auto-generated
> code
> > from BIRT GUI for some of the following things :
> >
> > a. Writing ofbiz logic (e.g. fetching data from ofbiz entity using
> > delegator.findBy.. )in open and fetch methods
> >
> > b. Change the entity field names from BIRT GUI format to ofbiz
> entity
> > fields (e.g. emplId field in ofbiz entity becomes EMPL_ID in BIRT
> > auto-generated code)
> >
> >
> > 4. Once above filtration is done then only I can use "rptdesign"
> > file in my ofbiz code.
> >
> > Hence, I wanted to know is there any way by which we can eliminate step -
> 3
> > and start using BIRT auto-generated code directly in ofbiz in order to
> > achieve following benefits :
> >
> >
> > - Making maintenance of reports very easy
> >
> > - Reduce the development hours
> >
> > - Smooth integration of BIRT and ofbiz
> >
> >
> >
> >
> > Thanks & Regards,
> > Swapnil Sawant
> >
> > ________________________________
> > This Email may contain confidential or privileged information for the
> > intended recipient (s) If you are not the intended recipient, please do
> not
> > use or disseminate the information, notify the sender and delete it from
> > your system.
> >
> > ______________________________________________________________________
>
>
> ______________________________________________________________________
>
> This Email may contain confidential or privileged information for the
> intended recipient (s) If you are not the intended recipient, please do not
> use or disseminate the information, notify the sender and delete it from
> your system.
>
> ______________________________________________________________________
>

Swapnil Sawant

RE: Query regarding ofbiz-BIRT integration

Hi Santosh,

The 'rptdesign' file is 'auto-generated code using BIRT GUI' .

We are using this 'auto-generated' code in our ofbiz code after doing step 3 as mentioned in 1st mail of mine.

So when we prepare a report using BIRT GUI tool,in order to test the report, we assign values to the columns in the report . for example,

In a salary report I would not only design/create a field called Employee name but I would also specify as to from which table I wld need to feed the data to this field.

Again to summarize the whole thing, preparing report using BIRT GUI tool involves following two things :

- designing format of report
- mapping fields from report to fields of entities in database

Hence, after successful testing when we 'auto-generate' the code, inside open and fetch method of this code we get the code corresponding to "above assignment of ofbiz entity fields to report fields' . This code we have to modify. Apart from this modification we have to do modifications as specified in my first mail's step - 3 .

We are requiring that , we should be able to design and test report on BIRT GUI,generate the code and directly start using it without any modifications.

Thanks & Regards,
Swapnil Sawant | iLabs | L & T Infotech

Plot no. EL - 200,TTC Electronic Zone,Shil-Mahape road,Navi Mumbai - 400 701
Extn: +91 22 6795 4325
Mail: [hidden email]

www.lntinfotech.com

-----Original Message-----
From: Santosh Malviya [mailto:[hidden email]]
Sent: Thursday, August 12, 2010 2:04 PM
To: [hidden email]
Subject: Re: Query regarding ofbiz-BIRT integration

Hello Swapnil,

If you have formed query in groovy then why are you again doing query in
rptdesign file, can you put your open and fetch code here to better
understand.

--
Thanks and Regards
Santosh Malviya

On Thu, Aug 12, 2010 at 1:00 PM, Swapnil Sawant <
[hidden email]> wrote:

BJ Freeman

Re: Query regarding ofbiz-BIRT integration

In reply to this post by Swapnil Sawant

If you have reviewed the Birt example in ofbiz that is probably the best
there is.
https://demo-trunk.ofbiz.apache.org/example/control/Report
in the last week there was some discussion about this you might check
the mailing list.

Swapnil Sawant sent the following on 8/11/2010 10:33 PM:

> Hi,
>
>
> I am new to report generation in ofbiz using BIRT GUI. For achieving report generation in ofbiz, I follow below steps :
>
>
> 1. Prepare the report using BIRT GUI (designing format of report, assigning entity data to the fields in it)
>
> 2. Generate the code out of it .
>
> 3. Once code is generated, I need to change that auto-generated code from BIRT GUI for some of the following things :
>
> a. Writing ofbiz logic (e.g. fetching data from ofbiz entity using delegator.findBy.. )in open and fetch methods
>
> b. Change the entity field names from BIRT GUI format to ofbiz entity fields (e.g. emplId field in ofbiz entity becomes EMPL_ID in BIRT auto-generated code)
>
>
> 4. Once above filtration is done then only I can use "rptdesign" file in my ofbiz code.
>
> Hence, I wanted to know is there any way by which we can eliminate step - 3 and start using BIRT auto-generated code directly in ofbiz in order to achieve following benefits :
>
>
> - Making maintenance of reports very easy
>
> - Reduce the development hours
>
> - Smooth integration of BIRT and ofbiz
>
>
>
>
> Thanks& Regards,
> Swapnil Sawant
>
> ________________________________
> This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.
>
> ______________________________________________________________________