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.
Dear All,
I tried to 'EXPORT BIRT REPORT DATA' via BIRT report viewer. logged as maxadmin, run a report such as SR List, click the 'export button'
on the toolbar, select the field to be exported, select CSV as output format. when click ok xls file shows database field name instead of the label
which we define it for example shows ticketid instead of SR.no#
Hope for the early reply below is our sysinfo.
System Info
App Server IBM WebSphere Application Server 6.1
Version
Common PMP 7.1.1.7 Build 201006041645 DB Build V7117-02
Base Services 7.1.1.7-LA20101014-0712 Build 20100522-0325 DB Build V7117-47 HFDB Build HF7117-11
IBM Maximo Project Adaptor 7.1.1.02 Build 14 DB Build V7110-02
Server OS Windows Server 2003 5.2 build 3790 Service Pack 2
Was the report build with field alias names? If not then you will need to
rebuild with the field Alias names..
Shannon Sutton
CMMS Specialist
EMCOR Government Services
Office: 571-403-8940
Cell: 571-970-7965
From: Irfan Ahmed <irfanahmed45@yahoo.com>
To: "maximo@yahoogroups.com" <maximo@yahoogroups.com>
Date: 04/26/2012 07:52 AM
Subject: [MAXIMO List] CSV as output format
Sent by: MAXIMO@yahoogroups.com
Dear All,
I tried to 'EXPORT BIRT REPORT DATA' via BIRT report viewer. logged as
maxadmin, run a report such as SR List, click the 'export button'
on the toolbar, select the field to be exported, select CSV as output
format. when click ok xls file shows database field name instead of the
label
which we define it for example shows ticketid instead of SR.no#
Hope for the early reply below is our sysinfo.
System Info
App Server IBM WebSphere Application Server 6.1
Version
Common PMP 7.1.1.7 Build 201006041645 DB Build V7117-02
Base Services 7.1.1.7-LA20101014-0712 Build 20100522-0325 DB Build V7117-47
HFDB Build HF7117-11
IBM Maximo Project Adaptor 7.1.1.02 Build 14 DB Build V7110-02
Server OS Windows Server 2003 5.2 build 3790 Service Pack 2
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient.
Dear Shannon,
I tried with the field aliases name but still I got the same result
example my report shows ticketid instead of sr.no
----- Forwarded Message -----
From: Irfan Ahmed <irfanahmed45@yahoo.com>
To: "maximo@yahoogroups.com" <maximo@yahoogroups.com>
Sent: Thursday, April 26, 2012 4:52 PM
Subject: CSV as output format
Dear All,
I tried to 'EXPORT BIRT REPORT DATA' via BIRT report viewer. logged as maxadmin, run a report such as SR List, click the 'export button'
on the toolbar, select the field to be exported, select CSV as output format. when click ok xls file shows database field name instead of the label
which we define it for example shows ticketid instead of SR.no#
Hope for the early reply below is our sysinfo.
System Info
App Server IBM WebSphere Application Server 6.1
Version
Common PMP 7.1.1.7 Build 201006041645 DB Build V7117-02
Base Services 7.1.1.7-LA20101014-0712 Build 20100522-0325 DB Build V7117-47 HFDB Build HF7117-11
IBM Maximo Project Adaptor 7.1.1.02 Build 14 DB Build V7110-02
Server OS Windows Server 2003 5.2 build 3790 Service Pack 2