Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Exporting flat files from BIRT

From: e11271b (2012-06-27 14:30)

Ok.. This may not be best practice, but I have a scenario where I need to create an export file containing data produced in a report. This export file (fixed width or comma separate or possibly xml not sure) will be sent to an external system for processing. Is this possible in BIRT.
Any help would be appreciated, as I am very new to BIRT and need all the help I can get:)
Thanks.


From: Mohamed Skandaji (2012-06-27 09:36)

we are doing the same for the same need....
You need to know how to design a birt report.... and then any birt report
can be exported to xls
On Wed, Jun 27, 2012 at 9:30 AM, e11271b <ebennett@gfs.com> wrote:
> **
>
>
> Ok.. This may not be best practice, but I have a scenario where I need to
> create an export file containing data produced in a report. This export
> file (fixed width or comma separate or possibly xml not sure) will be sent
> to an external system for processing. Is this possible in BIRT.
>
> Any help would be appreciated, as I am very new to BIRT and need all the
> help I can get:)
>
> Thanks.
>
>
>
--
Mohamed Skandaji, MBA, PMP


From: e11271b (2012-06-27 15:26)

Thank You for your reply Mohamed. Sorry if this get posted twice. I tried replying before, but I don't think it was sent..
Anyway, The report has been created, and I don't need to export to excel via user input. I need the report to create a datafile(possibly a fixed width file) using data generated by the report, that can be ftp'd to an external compensation system for processing.
Since the report is creating the required data that I need, I was hoping to be able to have the report create the datafile rather than creating another process that would basically recreate the data that the report is already generating.
The report itself if fairly complex, and I really don't want to try and recreate all the business logic in two places.
Thanks for your help.
--- In MAXIMO@yahoogroups.com, Mohamed Skandaji <mohska@...> wrote:
>
> we are doing the same for the same need....
>
> You need to know how to design a birt report.... and then any birt report
> can be exported to xls
>
>
> On Wed, Jun 27, 2012 at 9:30 AM, e11271b <ebennett@...> wrote:
>
> > **
> >
> >
> > Ok.. This may not be best practice, but I have a scenario where I need to
> > create an export file containing data produced in a report. This export
> > file (fixed width or comma separate or possibly xml not sure) will be sent
> > to an external system for processing. Is this possible in BIRT.
> >
> > Any help would be appreciated, as I am very new to BIRT and need all the
> > help I can get:)
> >
> > Thanks.
> >
> >
> >
>
>
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
>


From: wwilliams (2012-06-27 10:02)

I am currently working on exactly the same thing. The data needs to be in a fixed file format as we are feeding labor and material transactions to a legacy system.
I am converting from and Actuate report. Using a little JAVA for the file=writing and javascript for formatting.
search for FileWriter
http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
Good Luck!
 
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, June 27, 2012 9:30 AM
Subject: [MAXIMO List] Exporting flat files from BIRT

 
Ok.. This may not be best practice, but I have a scenario where I need to create an export file containing data produced in a report. This export file (fixed width or comma separate or possibly xml not sure) will be sent to an external system for processing. Is this possible in BIRT.
Any help would be appreciated, as I am very new to BIRT and need all the help I can get:)
Thanks.


From: e11271b (2012-06-27 15:01)

The report has been created.
I'm not looking to create an excel spreadsheet via user input. When the report runs I need to create a file (possibly a fixed width file) using specific data that the report generates so that it can be ftp'd to an external system.
Not even sure this can be done. Since the report generates the data I need, I was hoping to just let the report create the datafile.
--- In MAXIMO@yahoogroups.com, Mohamed Skandaji <mohska@...> wrote:
>
> we are doing the same for the same need....
>
> You need to know how to design a birt report.... and then any birt report
> can be exported to xls
>
>
> On Wed, Jun 27, 2012 at 9:30 AM, e11271b <ebennett@...> wrote:
>
> > **
> >
> >
> > Ok.. This may not be best practice, but I have a scenario where I need to
> > create an export file containing data produced in a report. This export
> > file (fixed width or comma separate or possibly xml not sure) will be sent
> > to an external system for processing. Is this possible in BIRT.
> >
> > Any help would be appreciated, as I am very new to BIRT and need all the
> > help I can get:)
> >
> > Thanks.
> >
> >
> >
>
>
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
>


From: andrew.tess (2012-06-27 15:05)

I will point you to Pam Denny's great wiki about everything maximo reporting:
http://www.ibm.com/developerworks/wikis/display/maximo/Reports
You would probably want to look at the section Reports: Developing.
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> Ok.. This may not be best practice, but I have a scenario where I need to create an export file containing data produced in a report. This export file (fixed width or comma separate or possibly xml not sure) will be sent to an external system for processing. Is this possible in BIRT.
>
> Any help would be appreciated, as I am very new to BIRT and need all the help I can get:)
>
>
> Thanks.
>


From: Mohamed Skandaji (2012-06-27 13:32)

Wes
Are you running BIRT report in Maximo and getting the output file directly
in a fixed file format ?
On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@rocketmail.com> wrote:
> **
>
>
> I am currently working on exactly the same thing. The data needs to be in
> a fixed file format as we are feeding labor and material transactions to a
> legacy system.
> I am converting from and Actuate report. Using a little JAVA for the
> file=writing and javascript for formatting.
>
> search for FileWriter
> http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
>
> Good Luck!
>
>
> Wes Williams
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
> ________________________________
> From: e11271b <ebennett@gfs.com>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, June 27, 2012 9:30 AM
> Subject: [MAXIMO List] Exporting flat files from BIRT
>
>
>
>
> Ok.. This may not be best practice, but I have a scenario where I need to
> create an export file containing data produced in a report. This export
> file (fixed width or comma separate or possibly xml not sure) will be sent
> to an external system for processing. Is this possible in BIRT.
>
> Any help would be appreciated, as I am very new to BIRT and need all the
> help I can get:)
>
> Thanks.
>
>
>
>
>
--
Mohamed Skandaji, MBA, PMP


From: wwilliams (2012-06-27 11:36)

Well hope to try that tonight, I write the file independently, executed from Maximo and written directly to a directory.
 
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: Mohamed Skandaji <mohska@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, June 27, 2012 1:32 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

Wes
Are you running BIRT report in Maximo and getting the output file directly
in a fixed file format ?
On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@rocketmail.com> wrote:
> **
>
>
> I am currently working on exactly the same thing. The data needs to be in
> a fixed file format as we are feeding labor and material transactions to a
> legacy system.
> I am converting from and Actuate report. Using a little JAVA for the
> file=writing and javascript for formatting.
>
> search for FileWriter
> http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
>
> Good Luck!
>
>
> Wes Williams
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
> ________________________________
> From: e11271b <ebennett@gfs.com>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, June 27, 2012 9:30 AM
> Subject: [MAXIMO List] Exporting flat files from BIRT
>
>
>
>
> Ok.. This may not be best practice, but I have a scenario where I need to
> create an export file containing data produced in a report. This export
> file (fixed width or comma separate or possibly xml not sure) will be sent
> to an external system for processing. Is this possible in BIRT.
>
> Any help would be appreciated, as I am very new to BIRT and need all the
> help I can get:)
>
> Thanks.
>
>
>

>
--
Mohamed Skandaji, MBA, PMP
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join  : MAXIMO-subscribe@yahoogroups.com
Leave  : MAXIMO-unsubscribe@yahoogroups.com
Cry    : MAXIMO-owner@yahoogroups.com
Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links


From: Mohamed Skandaji (2012-06-27 13:54)

Please let me know the result (positive or negative). I feel that this is a
good feature that can be used as an alternative to interface
cheers.
On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@rocketmail.com> wrote:
> **
>
>
> Well hope to try that tonight, I write the file independently, executed
> from Maximo and written directly to a directory.
>
>
>
> Wes Williams
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
> ________________________________
> From: Mohamed Skandaji <mohska@gmail.com>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, June 27, 2012 1:32 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>
> Wes
> Are you running BIRT report in Maximo and getting the output file directly
> in a fixed file format ?
>
> On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@rocketmail.com> wrote:
>
> > **
>
> >
> >
> > I am currently working on exactly the same thing. The data needs to be in
> > a fixed file format as we are feeding labor and material transactions to
> a
> > legacy system.
> > I am converting from and Actuate report. Using a little JAVA for the
> > file=writing and javascript for formatting.
> >
> > search for FileWriter
> > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> >
> > Good Luck!
> >
> >
> > Wes Williams
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> > ________________________________
> > From: e11271b <ebennett@gfs.com>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 9:30 AM
> > Subject: [MAXIMO List] Exporting flat files from BIRT
> >
> >
> >
> >
> > Ok.. This may not be best practice, but I have a scenario where I need to
> > create an export file containing data produced in a report. This export
> > file (fixed width or comma separate or possibly xml not sure) will be
> sent
> > to an external system for processing. Is this possible in BIRT.
> >
> > Any help would be appreciated, as I am very new to BIRT and need all the
> > help I can get:)
> >
> > Thanks.
> >
> >
> >
> >
> >
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
> ------------------------------------
>
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join : MAXIMO-subscribe@yahoogroups.com
> Leave : MAXIMO-unsubscribe@yahoogroups.com
> Cry : MAXIMO-owner@yahoogroups.com
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>
>
--
Mohamed Skandaji, MBA, PMP


From: wwilliams (2012-06-27 16:20)

Works fine runs from my work station and writes the file on the server.
 
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: Mohamed Skandaji <mohska@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, June 27, 2012 1:54 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

Please let me know the result (positive or negative). I feel that this is a
good feature that can be used as an alternative to interface
cheers.
On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@rocketmail.com> wrote:
> **
>
>
> Well hope to try that tonight, I write the file independently, executed
> from Maximo and written directly to a directory.
>
>
>
> Wes Williams
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
> ________________________________
> From: Mohamed Skandaji <mohska@gmail.com>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, June 27, 2012 1:32 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>
> Wes
> Are you running BIRT report in Maximo and getting the output file directly
> in a fixed file format ?
>
> On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@rocketmail.com> wrote:
>
> > **
>
> >
> >
> > I am currently working on exactly the same thing. The data needs to be in
> > a fixed file format as we are feeding labor and material transactions to
> a
> > legacy system.
> > I am converting from and Actuate report. Using a little JAVA for the
> > file=writing and javascript for formatting.
> >
> > search for FileWriter
> > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> >
> > Good Luck!
> >
> >
> > Wes Williams
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> > ________________________________
> > From: e11271b <ebennett@gfs.com>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 9:30 AM
> > Subject: [MAXIMO List] Exporting flat files from BIRT
> >
> >
> >
> >
> > Ok.. This may not be best practice, but I have a scenario where I need to
> > create an export file containing data produced in a report. This export
> > file (fixed width or comma separate or possibly xml not sure) will be
> sent
> > to an external system for processing. Is this possible in BIRT.
> >
> > Any help would be appreciated, as I am very new to BIRT and need all the
> > help I can get:)
> >
> > Thanks.
> >
> >
> >
> >
> >
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
> ------------------------------------
>
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join  : MAXIMO-subscribe@yahoogroups.com
> Leave  : MAXIMO-unsubscribe@yahoogroups.com
> Cry    : MAXIMO-owner@yahoogroups.com
> Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>

>
--
Mohamed Skandaji, MBA, PMP
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join  : MAXIMO-subscribe@yahoogroups.com
Leave  : MAXIMO-unsubscribe@yahoogroups.com
Cry    : MAXIMO-owner@yahoogroups.com
Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links


From: e11271b (2012-06-28 14:26)

This sounds very interesting!
Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
Thanks!
--- In MAXIMO@yahoogroups.com, wwilliams@... wrote:
>
> Works fine runs from my work station and writes the file on the server.
>  
> Wes Williams
>
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
>
> ________________________________
> From: Mohamed Skandaji <mohska@...>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, June 27, 2012 1:54 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
> Please let me know the result (positive or negative). I feel that this is a
> good feature that can be used as an alternative to interface
>
> cheers.
>
>
> On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@...> wrote:
>
> > **
> >
> >
> > Well hope to try that tonight, I write the file independently, executed
> > from Maximo and written directly to a directory.
> >
> >
> >
> > Wes Williams
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@...>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:32 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> >
> > Wes
> > Are you running BIRT report in Maximo and getting the output file directly
> > in a fixed file format ?
> >
> > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@...> wrote:
> >
> > > **
> >
> > >
> > >
> > > I am currently working on exactly the same thing. The data needs to be in
> > > a fixed file format as we are feeding labor and material transactions to
> > a
> > > legacy system.
> > > I am converting from and Actuate report. Using a little JAVA for the
> > > file=writing and javascript for formatting.
> > >
> > > search for FileWriter
> > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > >
> > > Good Luck!
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: e11271b <ebennett@...>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > >
> > >
> > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > create an export file containing data produced in a report. This export
> > > file (fixed width or comma separate or possibly xml not sure) will be
> > sent
> > > to an external system for processing. Is this possible in BIRT.
> > >
> > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > help I can get:)
> > >
> > > Thanks.
> > >
> > >
> > >
> > >
> > >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> > ------------------------------------
> >
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> > 
> >
>
>
>
> --
> Mohamed Skandaji, MBA, PMP
>
>
>
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join  : MAXIMO-subscribe@yahoogroups.com
> Leave  : MAXIMO-unsubscribe@yahoogroups.com
> Cry    : MAXIMO-owner@yahoogroups.com
> Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>
>
>
>
>


From: e11271b (2012-06-28 16:15)

Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>


From: wwilliams (2012-06-28 14:31)

I would think so, I have one data set, but I am guessing it shouldn't be a problem.
I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
I write the header in the beforeFactory , detail in the fetch.
Lots of examples on the WEB.
 
Wes Williams
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, June 28, 2012 11:15 AM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

 
Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>


From: siva ravuri (2012-06-28 17:31)

I could not find a single example to export to excel using Birt(using code) on the Web. Can you please kindly post a link to such an example.
Thanks...Siva
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 4:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

 
I would think so, I have one data set, but I am guessing it shouldn't be a problem.
I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
I write the header in the beforeFactory , detail in the fetch.
Lots of examples on the WEB.
 
Wes Williams
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, June 28, 2012 11:15 AM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>


From: wwilliams (2012-06-28 19:50)

we were talking about fixed-file format, csv, xml.
Maybe these will help?
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/ 
http://www.eclipse.org/forums/index.php/t/278937/ 
 
Wes Williams
________________________________
From: siva ravuri <srpravuri@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 7:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

 
I could not find a single example to export to excel using Birt(using code) on the Web. Can you please kindly post a link to such an example.
Thanks...Siva
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 4:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I would think so, I have one data set, but I am guessing it shouldn't be a problem.
I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
I write the header in the beforeFactory , detail in the fetch.
Lots of examples on the WEB.
 
Wes Williams
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, June 28, 2012 11:15 AM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>


From: siva ravuri (2012-06-28 20:38)

I am sorry. I mean .csv file format only. I need to export data to a file. Please send me the link or any sample example which you created.
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 9:50 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

 
we were talking about fixed-file format, csv, xml.
Maybe these will help?
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/ 
http://www.eclipse.org/forums/index.php/t/278937/ 
 
Wes Williams
________________________________
From: siva ravuri <srpravuri@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 7:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I could not find a single example to export to excel using Birt(using code) on the Web. Can you please kindly post a link to such an example.
Thanks...Siva
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 4:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I would think so, I have one data set, but I am guessing it shouldn't be a problem.
I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
I write the header in the beforeFactory , detail in the fetch.
Lots of examples on the WEB.
 
Wes Williams
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, June 28, 2012 11:15 AM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>



From: wwilliams (2012-06-29 06:39)

http://www.java-samples.com/showtutorial.php?tutorialid=392 
 
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: siva ravuri <srpravuri@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 10:38 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

 
I am sorry. I mean .csv file format only. I need to export data to a file. Please send me the link or any sample example which you created.
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 9:50 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
we were talking about fixed-file format, csv, xml.
Maybe these will help?
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/ 
http://www.eclipse.org/forums/index.php/t/278937/ 
 
Wes Williams
________________________________
From: siva ravuri <srpravuri@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 7:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I could not find a single example to export to excel using Birt(using code) on the Web. Can you please kindly post a link to such an example.
Thanks...Siva
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 4:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I would think so, I have one data set, but I am guessing it shouldn't be a problem.
I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
I write the header in the beforeFactory , detail in the fetch.
Lots of examples on the WEB.
 
Wes Williams
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, June 28, 2012 11:15 AM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>



From: wwilliams (2012-07-01 09:22)

http://www.weswilliams.net/html/stuff.html
Just an overview
 
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: siva ravuri <srpravuri@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 10:38 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT

 
I am sorry. I mean .csv file format only. I need to export data to a file. Please send me the link or any sample example which you created.
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 9:50 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
we were talking about fixed-file format, csv, xml.
Maybe these will help?
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/ 
http://www.eclipse.org/forums/index.php/t/278937/ 
 
Wes Williams
________________________________
From: siva ravuri <srpravuri@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 7:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I could not find a single example to export to excel using Birt(using code) on the Web. Can you please kindly post a link to such an example.
Thanks...Siva
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Thursday, June 28, 2012 4:31 PM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
I would think so, I have one data set, but I am guessing it shouldn't be a problem.
I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
I write the header in the beforeFactory , detail in the fetch.
Lots of examples on the WEB.
 
Wes Williams
________________________________
From: e11271b <ebennett@gfs.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, June 28, 2012 11:15 AM
Subject: Re: [MAXIMO List] Exporting flat files from BIRT
 
Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
Is it possible to capture the reports displayed values, and export that data using the FileWriter?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This sounds very interesting!
>
> Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
>
> Thanks!
>
>
> --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> >
> > Works fine runs from my work station and writes the file on the server.
> >  
> > Wes Williams
> >
> >
> > http://www.weswilliams.net
> > http://www.williamsconnell.com
> >
> >
> > ________________________________
> > From: Mohamed Skandaji <mohska@>
> > To: MAXIMO@yahoogroups.com
> > Sent: Wednesday, June 27, 2012 1:54 PM
> > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> >
> > Please let me know the result (positive or negative). I feel that this is a
> > good feature that can be used as an alternative to interface
> >
> > cheers.
> >
> >
> > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> >
> > > **
> > >
> > >
> > > Well hope to try that tonight, I write the file independently, executed
> > > from Maximo and written directly to a directory.
> > >
> > >
> > >
> > > Wes Williams
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > >
> > > Wes
> > > Are you running BIRT report in Maximo and getting the output file directly
> > > in a fixed file format ?
> > >
> > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am currently working on exactly the same thing. The data needs to be in
> > > > a fixed file format as we are feeding labor and material transactions to
> > > a
> > > > legacy system.
> > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > file=writing and javascript for formatting.
> > > >
> > > > search for FileWriter
> > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > >
> > > > Good Luck!
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: e11271b <ebennett@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > >
> > > >
> > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > create an export file containing data produced in a report. This export
> > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > sent
> > > > to an external system for processing. Is this possible in BIRT.
> > > >
> > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > help I can get:)
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > > 
> > >
> >
> >
> >
> > --
> > Mohamed Skandaji, MBA, PMP
> >
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Email addresses you might need:
> > Posting: MAXIMO@yahoogroups.com
> > Join  : MAXIMO-subscribe@yahoogroups.com
> > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > Cry    : MAXIMO-owner@yahoogroups.com
> > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> >
> >
> >
> >
> >
>



From: e11271b (2012-07-02 22:35)

I'm trying to get the CVSEmitter option to work, but I get the following error when running the export.
SEVERE: Error.OutputFormatNotSupported
org.eclipse.birt.report.engine.api.UnsupportedFormatException: The output format csv is not supported.
I may have misunderstood the instructions. Has anyone gotten around this issue?
--- In MAXIMO@yahoogroups.com, wwilliams@... wrote:
>
> http://www.weswilliams.net/html/stuff.html
>
> Just an overview
>  
> Wes Williams
>
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
>
> ________________________________
> From: siva ravuri <srpravuri@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Thursday, June 28, 2012 10:38 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>
>  
> I am sorry. I mean .csv file format only. I need to export data to a file. Please send me the link or any sample example which you created.
>
> ________________________________
> From: "wwilliams@..." <wwilliams@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Thursday, June 28, 2012 9:50 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>
>  
> we were talking about fixed-file format, csv, xml.
>
> Maybe these will help?
>
> http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/ 
>
> http://www.eclipse.org/forums/index.php/t/278937/ 
>
>  
> Wes Williams
>
> ________________________________
> From: siva ravuri <srpravuri@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Thursday, June 28, 2012 7:31 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>  
> I could not find a single example to export to excel using Birt(using code) on the Web. Can you please kindly post a link to such an example.
> Thanks...Siva
>
> ________________________________
> From: "wwilliams@..." <wwilliams@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Thursday, June 28, 2012 4:31 PM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>  
> I would think so, I have one data set, but I am guessing it shouldn't be a problem.
> I am writing the detail in the fetch using for example row["wonum"] which I pad with spaces and it becomes wonum + another padded column etc. I have  javascript function I call to pad correct number spaces.
>
> I write the header in the beforeFactory , detail in the fetch.
>
> Lots of examples on the WEB.
>
>  
> Wes Williams
>
> ________________________________
> From: e11271b <ebennett@...>
> To: MAXIMO@yahoogroups.com
> Sent: Thursday, June 28, 2012 11:15 AM
> Subject: Re: [MAXIMO List] Exporting flat files from BIRT
>
>  
> Side note.. The report that I am trying to extract data from has one main table, but many groups and datasets.
>
> Is it possible to capture the reports displayed values, and export that data using the FileWriter?
>
> --- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@> wrote:
> >
> > This sounds very interesting!
> >
> > Wes, can you share your implementation. I would like to see how you incorporated the FileWriter in your report.
> >
> > Thanks!
> >
> >
> > --- In MAXIMO@yahoogroups.com, wwilliams@ wrote:
> > >
> > > Works fine runs from my work station and writes the file on the server.
> > >  
> > > Wes Williams
> > >
> > >
> > > http://www.weswilliams.net
> > > http://www.williamsconnell.com
> > >
> > >
> > > ________________________________
> > > From: Mohamed Skandaji <mohska@>
> > > To: MAXIMO@yahoogroups.com
> > > Sent: Wednesday, June 27, 2012 1:54 PM
> > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > >
> > > Please let me know the result (positive or negative). I feel that this is a
> > > good feature that can be used as an alternative to interface
> > >
> > > cheers.
> > >
> > >
> > > On Wed, Jun 27, 2012 at 1:36 PM, <wwilliams@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Well hope to try that tonight, I write the file independently, executed
> > > > from Maximo and written directly to a directory.
> > > >
> > > >
> > > >
> > > > Wes Williams
> > > >
> > > > http://www.weswilliams.net
> > > > http://www.williamsconnell.com
> > > >
> > > > ________________________________
> > > > From: Mohamed Skandaji <mohska@>
> > > > To: MAXIMO@yahoogroups.com
> > > > Sent: Wednesday, June 27, 2012 1:32 PM
> > > > Subject: Re: [MAXIMO List] Exporting flat files from BIRT
> > > >
> > > >
> > > > Wes
> > > > Are you running BIRT report in Maximo and getting the output file directly
> > > > in a fixed file format ?
> > > >
> > > > On Wed, Jun 27, 2012 at 12:02 PM, <wwilliams@> wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I am currently working on exactly the same thing. The data needs to be in
> > > > > a fixed file format as we are feeding labor and material transactions to
> > > > a
> > > > > legacy system.
> > > > > I am converting from and Actuate report. Using a little JAVA for the
> > > > > file=writing and javascript for formatting.
> > > > >
> > > > > search for FileWriter
> > > > > http://docs.oracle.com/javase/1.4.2/docs/api/java/io/FileWriter.html
> > > > >
> > > > > Good Luck!
> > > > >
> > > > >
> > > > > Wes Williams
> > > > >
> > > > > http://www.weswilliams.net
> > > > > http://www.williamsconnell.com
> > > > >
> > > > > ________________________________
> > > > > From: e11271b <ebennett@>
> > > > > To: MAXIMO@yahoogroups.com
> > > > > Sent: Wednesday, June 27, 2012 9:30 AM
> > > > > Subject: [MAXIMO List] Exporting flat files from BIRT
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Ok.. This may not be best practice, but I have a scenario where I need to
> > > > > create an export file containing data produced in a report. This export
> > > > > file (fixed width or comma separate or possibly xml not sure) will be
> > > > sent
> > > > > to an external system for processing. Is this possible in BIRT.
> > > > >
> > > > > Any help would be appreciated, as I am very new to BIRT and need all the
> > > > > help I can get:)
> > > > >
> > > > > Thanks.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > > --
> > > > Mohamed Skandaji, MBA, PMP
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > >
> > > > Email addresses you might need:
> > > > Posting: MAXIMO@yahoogroups.com
> > > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > > Cry    : MAXIMO-owner@yahoogroups.com
> > > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > > 
> > > >
> > >
> > >
> > >
> > > --
> > > Mohamed Skandaji, MBA, PMP
> > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Email addresses you might need:
> > > Posting: MAXIMO@yahoogroups.com
> > > Join  : MAXIMO-subscribe@yahoogroups.com
> > > Leave  : MAXIMO-unsubscribe@yahoogroups.com
> > > Cry    : MAXIMO-owner@yahoogroups.com
> > > Group  : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>