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 Escalation to run periodic data export?

From: Jason Verly (2012-10-17 14:37)

I can manually run an data export using DATA in External Systems to export a specific set of information into XML, but I want to look at doing the steps automatically on a recurring basis.
Has anyone ever been able to use an Escalation to periodically run a data export (flat file or XML) via the MIF?


From: Mohamed Skandaji (2012-10-17 15:44)

You can do that with a custom cron task
On Wed, Oct 17, 2012 at 3:37 PM, Jason Verly <jason.verly@yahoo.com> wrote:
> **
>
>
> I can manually run an data export using DATA in External Systems to export
> a specific set of information into XML, but I want to look at doing the
> steps automatically on a recurring basis.
>
> Has anyone ever been able to use an Escalation to periodically run a data
> export (flat file or XML) via the MIF?
>
>
>
--
Mohamed Skandaji, MBA, PMP


From: Chris Lawless (2012-10-17 08:21)

The easiest way is to have an escalation set a flag on the records you want to export then have a publish channel with an event listener publish them. Add a skip rule to the channel to exclude all other updates. No custom code, all straightforward config via the UI.
Chris.
On Oct 17, 2012, at 7:37 AM, "Jason Verly" <jason.verly@yahoo.com> wrote:
> I can manually run an data export using DATA in External Systems to export a specific set of information into XML, but I want to look at doing the steps automatically on a recurring basis.
>
> Has anyone ever been able to use an Escalation to periodically run a data export (flat file or XML) via the MIF?
>
>


From: Ian Wright (2012-10-17 15:27)

This will create one object per output file is that what you want ?

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: 17 October 2012 16:21
To: MAXIMO@yahoogroups.com
Cc: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Using Escalation to run periodic data export?



The easiest way is to have an escalation set a flag on the records you want to export then have a publish channel with an event listener publish them. Add a skip rule to the channel to exclude all other updates. No custom code, all straightforward config via the UI.

Chris.

On Oct 17, 2012, at 7:37 AM, "Jason Verly" <jason.verly@yahoo.com<mailto:jason.verly%40yahoo.com>> wrote:

> I can manually run an data export using DATA in External Systems to export a specific set of information into XML, but I want to look at doing the steps automatically on a recurring basis.
>
> Has anyone ever been able to use an Escalation to periodically run a data export (flat file or XML) via the MIF?
>
>




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: Hanna, Christopher CTR (2012-10-18 07:34)

The other potential drawback to this method is that you are actually affecting a change on every record that you wish to export, so if it is an object that tracks changeby/date, this will reflect the escalation user, rather than the user that actually made the last real change. This may or may not be important to you, but it is worth consideration. If you're comfortable/skilled with custom code, it provides a little more control and flexibility and the code to fire off an export is fairly simple. You'll have to weigh the pros and cons of each approach in your own setup.

One other thing to be aware of, as noted, a listener will fire off one message per record. This is actually desirable if the end consumer is a system rather than a human. Many smaller messages will process more efficiently than one large message. My experience, with a dedicated MIF instance and 4+ gb allocated to its JVM, you can only export about 8 to 10k records (locations) at once before the JVM runs out of memory. I've been able to do nearly 40k records as multiple individual messages and it is barely noticeable in the memory monitor.

-Chris H



-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: Wednesday, October 17, 2012 11:28 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Using Escalation to run periodic data export?



This will create one object per output file is that what you want ?

From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Chris Lawless
Sent: 17 October 2012 16:21
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Cc: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Using Escalation to run periodic data export?



The easiest way is to have an escalation set a flag on the records you want to export then have a publish channel with an event listener publish them. Add a skip rule to the channel to exclude all other updates. No custom code, all straightforward config via the UI.

Chris.

On Oct 17, 2012, at 7:37 AM, "Jason Verly" <jason.verly@yahoo.com <mailto:jason.verly%40yahoo.com> <mailto:jason.verly%40yahoo.com>> wrote:

> I can manually run an data export using DATA in External Systems to export a specific set of information into XML, but I want to look at doing the steps automatically on a recurring basis.
>
> Has anyone ever been able to use an Escalation to periodically run a data export (flat file or XML) via the MIF?
>
>




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: Ian Wright (2012-10-18 12:19)

You could always use rest

http://maxdemo/maximo/rest/mbo/asset?assetnum=~eq~SV0001&_lid=username&_lpwd=password

or finds all assets with SV in assetnum field

http://maxdemo.gdfbrit.local/maximo/rest/mbo/asset?assetnum=SV&_lid=maxadmin&_lpwd=maxadmin


or set up a query web service bypassing the queues really fast

Rgds Ian

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Hanna, Christopher CTR
Sent: 18 October 2012 12:34
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Using Escalation to run periodic data export?



The other potential drawback to this method is that you are actually affecting a change on every record that you wish to export, so if it is an object that tracks changeby/date, this will reflect the escalation user, rather than the user that actually made the last real change. This may or may not be important to you, but it is worth consideration. If you're comfortable/skilled with custom code, it provides a little more control and flexibility and the code to fire off an export is fairly simple. You'll have to weigh the pros and cons of each approach in your own setup.

One other thing to be aware of, as noted, a listener will fire off one message per record. This is actually desirable if the end consumer is a system rather than a human. Many smaller messages will process more efficiently than one large message. My experience, with a dedicated MIF instance and 4+ gb allocated to its JVM, you can only export about 8 to 10k records (locations) at once before the JVM runs out of memory. I've been able to do nearly 40k records as multiple individual messages and it is barely noticeable in the memory monitor.

-Chris H



-----Original Message-----
From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Ian Wright
Sent: Wednesday, October 17, 2012 11:28 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Using Escalation to run periodic data export?



This will create one object per output file is that what you want ?

From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of Chris Lawless
Sent: 17 October 2012 16:21
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Cc: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Using Escalation to run periodic data export?



The easiest way is to have an escalation set a flag on the records you want to export then have a publish channel with an event listener publish them. Add a skip rule to the channel to exclude all other updates. No custom code, all straightforward config via the UI.

Chris.

On Oct 17, 2012, at 7:37 AM, "Jason Verly" <jason.verly@yahoo.com<mailto:jason.verly%40yahoo.com> <mailto:jason.verly%40yahoo.com> <mailto:jason.verly%40yahoo.com>> wrote:

> I can manually run an data export using DATA in External Systems to export a specific set of information into XML, but I want to look at doing the steps automatically on a recurring basis.
>
> Has anyone ever been able to use an Escalation to periodically run a data export (flat file or XML) via the MIF?
>
>




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: Basant M Kumar (2012-10-18 10:50)

Why not use CRON to schedule the export with MIF? escalation will use the cron any way.
Thanks,
 
Basant M Kumar
________________________________
From: Chris Lawless <lawlessc@gmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Cc: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Wednesday, October 17, 2012 10:21 AM
Subject: Re: [MAXIMO List] Using Escalation to run periodic data export?

 
The easiest way is to have an escalation set a flag on the records you want to export then have a publish channel with an event listener publish them. Add a skip rule to the channel to exclude all other updates. No custom code, all straightforward config via the UI.
Chris.
On Oct 17, 2012, at 7:37 AM, "Jason Verly" <jason.verly@yahoo.com> wrote:
> I can manually run an data export using DATA in External Systems to export a specific set of information into XML, but I want to look at doing the steps automatically on a recurring basis.
>
> Has anyone ever been able to use an Escalation to periodically run a data export (flat file or XML) via the MIF?
>
>