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.



Using BIRT Report to write directly to a Maximo Table

From: tpw5511 (2012-12-13 17:45)

I have been asked to modify a Brio report (from Maximo v4) to a BIRT report for use in Maximo v7. What the report does, is, basically upon receipt of a certain item, report creates a new bin location with a unique identifier for that item,along with concatonating a 001 (at the end) for the item whose quantity is 1 or if quantity is more than 1, adding a 002, 003, 004, etc for all remaining quantities.
Problem is, I am learning from other Maximo administrators, that using a BIRT report to write directly to a Maximo table in Maximo v7 is in violation of the our IBM maintenance support agreement.
Obviously we can manually create the new bin locations in Maximo v7, however, with that said, what have other Maximo'ers done to insert/update tables based on a certain event without the use of a BIRT report ??
Thanks,
TPW5511


From: Sean Clark-McCarthy (2012-12-13 18:08)

Can't say I've heard of that being a problem before. If that were the case, using a SQL tool would be a violation or even an Automation Script. The Asset Cost Rollup report does an update to the database directly. As long as you know what you're doing it shouldn't be a problem.
However, if you run into a problem with it IBM will not provide support for it (which they don't do for a customization anyway).
If you are on 7.5, you could always write an Automation Script to accomplish your goals.
Sean Clark-McCarthy
Sr. Solutions Architect
Cohesive Information Solutions
smccarthy@cohesivesolutions.com
________________________________
From: MAXIMO@yahoogroups.com [MAXIMO@yahoogroups.com] on behalf of tpw5511 [weatherfree@tampabay.rr.com]
Sent: Thursday, December 13, 2012 12:45 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Using BIRT Report to write directly to a Maximo Table
I have been asked to modify a Brio report (from Maximo v4) to a BIRT report for use in Maximo v7. What the report does, is, basically upon receipt of a certain item, report creates a new bin location with a unique identifier for that item,along with concatonating a 001 (at the end) for the item whose quantity is 1 or if quantity is more than 1, adding a 002, 003, 004, etc for all remaining quantities.
Problem is, I am learning from other Maximo administrators, that using a BIRT report to write directly to a Maximo table in Maximo v7 is in violation of the our IBM maintenance support agreement.
Obviously we can manually create the new bin locations in Maximo v7, however, with that said, what have other Maximo'ers done to insert/update tables based on a certain event without the use of a BIRT report ??
Thanks,
TPW5511


From: Ian Wright (2012-12-14 09:22)

7.X or 7.5 if its 7.5 then automation scripts at the object level will do it for you
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of tpw5511
Sent: 13 December 2012 17:46
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Using BIRT Report to write directly to a Maximo Table
I have been asked to modify a Brio report (from Maximo v4) to a BIRT report for use in Maximo v7. What the report does, is, basically upon receipt of a certain item, report creates a new bin location with a unique identifier for that item,along with concatonating a 001 (at the end) for the item whose quantity is 1 or if quantity is more than 1, adding a 002, 003, 004, etc for all remaining quantities.
Problem is, I am learning from other Maximo administrators, that using a BIRT report to write directly to a Maximo table in Maximo v7 is in violation of the our IBM maintenance support agreement.
Obviously we can manually create the new bin locations in Maximo v7, however, with that said, what have other Maximo'ers done to insert/update tables based on a certain event without the use of a BIRT report ??
Thanks,
TPW5511
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************


From: tpw5511 (2012-12-14 20:29)

Thank you Sean and Ian both four your suggestion.
I've been working with Maximo product for over 20 years and have never heard of a report updating a table violating an IBM Maintenance agreement.
--- In MAXIMO@yahoogroups.com, Sean Clark-McCarthy <smccarthy@...> wrote:
>
> Can't say I've heard of that being a problem before. If that were the case, using a SQL tool would be a violation or even an Automation Script. The Asset Cost Rollup report does an update to the database directly. As long as you know what you're doing it shouldn't be a problem.
>
> However, if you run into a problem with it IBM will not provide support for it (which they don't do for a customization anyway).
>
> If you are on 7.5, you could always write an Automation Script to accomplish your goals.
>
> Sean Clark-McCarthy
> Sr. Solutions Architect
> Cohesive Information Solutions
> smccarthy@...
> ________________________________
> From: MAXIMO@yahoogroups.com [MAXIMO@yahoogroups.com] on behalf of tpw5511 [weatherfree@...]
> Sent: Thursday, December 13, 2012 12:45 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Using BIRT Report to write directly to a Maximo Table
>
>
>
> I have been asked to modify a Brio report (from Maximo v4) to a BIRT report for use in Maximo v7. What the report does, is, basically upon receipt of a certain item, report creates a new bin location with a unique identifier for that item,along with concatonating a 001 (at the end) for the item whose quantity is 1 or if quantity is more than 1, adding a 002, 003, 004, etc for all remaining quantities.
>
> Problem is, I am learning from other Maximo administrators, that using a BIRT report to write directly to a Maximo table in Maximo v7 is in violation of the our IBM maintenance support agreement.
>
> Obviously we can manually create the new bin locations in Maximo v7, however, with that said, what have other Maximo'ers done to insert/update tables based on a certain event without the use of a BIRT report ??
>
> Thanks,
> TPW5511
>
>
>
>
>
>
>


From: John (2012-12-14 20:41)

I think the "rules" changed, as, a lot can happen in 20 years.
I got older for one.
Software vendor changed names.
The product went from whatever to now web-based.
The user-seat licensing rules changed.
Remember SQLTALK? well, it left a long time ago. If you had privileges you could Insert, Update, and Delete - anything.
SQR reporting allowed for direct updates too.
The odd part you are referring too is...the standard MAXIMO reports perform internal updating in some cases(but they wrote these).
Lastly,
the reporting tool changed more than the design of the Ford mustang.
.... "i'm just sayin"....
--- In MAXIMO@yahoogroups.com, "tpw5511" <weatherfree@...> wrote:
>
> Thank you Sean and Ian both four your suggestion.
>
> I've been working with Maximo product for over 20 years and have never heard of a report updating a table violating an IBM Maintenance agreement.
>
> --- In MAXIMO@yahoogroups.com, Sean Clark-McCarthy <smccarthy@> wrote:
> >
> > Can't say I've heard of that being a problem before. If that were the case, using a SQL tool would be a violation or even an Automation Script. The Asset Cost Rollup report does an update to the database directly. As long as you know what you're doing it shouldn't be a problem.
> >
> > However, if you run into a problem with it IBM will not provide support for it (which they don't do for a customization anyway).
> >
> > If you are on 7.5, you could always write an Automation Script to accomplish your goals.
> >
> > Sean Clark-McCarthy
> > Sr. Solutions Architect
> > Cohesive Information Solutions
> > smccarthy@
> > ________________________________
> > From: MAXIMO@yahoogroups.com [MAXIMO@yahoogroups.com] on behalf of tpw5511 [weatherfree@]
> > Sent: Thursday, December 13, 2012 12:45 PM
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] Using BIRT Report to write directly to a Maximo Table
> >
> >
> >
> > I have been asked to modify a Brio report (from Maximo v4) to a BIRT report for use in Maximo v7. What the report does, is, basically upon receipt of a certain item, report creates a new bin location with a unique identifier for that item,along with concatonating a 001 (at the end) for the item whose quantity is 1 or if quantity is more than 1, adding a 002, 003, 004, etc for all remaining quantities.
> >
> > Problem is, I am learning from other Maximo administrators, that using a BIRT report to write directly to a Maximo table in Maximo v7 is in violation of the our IBM maintenance support agreement.
> >
> > Obviously we can manually create the new bin locations in Maximo v7, however, with that said, what have other Maximo'ers done to insert/update tables based on a certain event without the use of a BIRT report ??
> >
> > Thanks,
> > TPW5511
> >
> >
> >
> >
> >
> >
> >
>