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.
Hi all, I need to be able to send the SR attachments with an email generated by the work order created by the SR. Work order communication templates don't have the ability to send the SR attachments so I created an action group to move the SR attachments (updating the ownertable and ownerID in doclinks), and put this action in the workflow assigned to the button that sends the email out.
The problem is, the attachments don't appear on the email the first time I run the workflow. Only the second time. I figure this is because there is not a db commit until the end of the workflow.
Is there any way I can force a db commit in the middle of the workflow, or does anyone know of any trick I can use to do what I'm trying to do?
I tried putting the action group in a subprocess but that didn't seem to work either.
Kevin Wertz
Grifols, Inc.
Clayton NC
Kevin,
If you are on 7.5 , you can try sending email through action launch point automation script in your workflow.
Refer below URL:
http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/ http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
Thanks,
Arpit
---In MAXIMO@yahoogroups.com, <wertzee@...> wrote :
Hi all, I need to be able to send the SR attachments with an email generated by the work order created by the SR. Work order communication templates don't have the ability to send the SR attachments so I created an action group to move the SR attachments (updating the ownertable and ownerID in doclinks), and put this action in the workflow assigned to the button that sends the email out.
The problem is, the attachments don't appear on the email the first time I run the workflow. Only the second time. I figure this is because there is not a db commit until the end of the workflow.
Is there any way I can force a db commit in the middle of the workflow, or does anyone know of any trick I can use to do what I'm trying to do?
I tried putting the action group in a subprocess but that didn't seem to work either.
Kevin Wertz
Grifols, Inc.
Clayton NC
Thanks Arpit. We are on 7.1 but thanks for the info. That looks like
something we will be able to use after we upgrade.
We actually submitted to IBM the inability to attach related SR attachments
and it seems to be stuck in discussions. At least they haven't said yet
that it is that way by design.
What I ended up doing was just using the action group to move the SR
attachments to work order attachments, then we present a dialog to the user
to press the route workflow again to complete sending the email. Not the
most elegant solution, but since only a small percentage of the SRs from
this business unit have attachments, they weren't too uptight about it.
KW
On Sat, Jun 28, 2014 at 6:34 AM, narainarpit@gmail.com [MAXIMO] <
MAXIMO@yahoogroups.com> wrote:
>
>
> Kevin,
>
> If you are on 7.5 , you can try sending email through action launch point
> automation script in your workflow.
>
> Refer below URL:
>
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> Thanks,
> Arpit
>
>
> ---In MAXIMO@yahoogroups.com, <wertzee@...> wrote :
>
> Hi all, I need to be able to send the SR attachments with an email
> generated by the work order created by the SR. Work order communication
> templates don't have the ability to send the SR attachments so I created an
> action group to move the SR attachments (updating the ownertable and
> ownerID in doclinks), and put this action in the workflow assigned to the
> button that sends the email out.
>
>
> The problem is, the attachments don't appear on the email the first time I
> run the workflow. Only the second time. I figure this is because there is
> not a db commit until the end of the workflow.
>
>
> Is there any way I can force a db commit in the middle of the workflow, or
> does anyone know of any trick I can use to do what I'm trying to do?
>
>
> I tried putting the action group in a subprocess but that didn't seem to
> work either.
>
>
> Kevin Wertz
> Grifols, Inc.
> Clayton NC
>
>
>
>
>
>
>
>
>
Workflow performs a commit each time an assignment is made; so all you have to do is assign to “autoaccept” when you need the commit before taking further actions. The Auto Accept cron task will move the record at the next execution. ☺
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Monday, August 25, 2014 1:32 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Re: Commit in the middle of a workflow?
Thanks Arpit. We are on 7.1 but thanks for the info. That looks like
something we will be able to use after we upgrade.
We actually submitted to IBM the inability to attach related SR attachments
and it seems to be stuck in discussions. At least they haven't said yet
that it is that way by design.
What I ended up doing was just using the action group to move the SR
attachments to work order attachments, then we present a dialog to the user
to press the route workflow again to complete sending the email. Not the
most elegant solution, but since only a small percentage of the SRs from
this business unit have attachments, they weren't too uptight about it.
KW
On Sat, Jun 28, 2014 at 6:34 AM, narainarpit@gmail.com<mailto:narainarpit@gmail.com> [MAXIMO] <
MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>> wrote:
>
>
> Kevin,
>
> If you are on 7.5 , you can try sending email through action launch point
> automation script in your workflow.
>
> Refer below URL:
>
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> Thanks,
> Arpit
>
>
> ---In MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>, <wertzee@...<mailto:wertzee@...>> wrote :
>
> Hi all, I need to be able to send the SR attachments with an email
> generated by the work order created by the SR. Work order communication
> templates don't have the ability to send the SR attachments so I created an
> action group to move the SR attachments (updating the ownertable and
> ownerID in doclinks), and put this action in the workflow assigned to the
> button that sends the email out.
>
>
> The problem is, the attachments don't appear on the email the first time I
> run the workflow. Only the second time. I figure this is because there is
> not a db commit until the end of the workflow.
>
>
> Is there any way I can force a db commit in the middle of the workflow, or
> does anyone know of any trick I can use to do what I'm trying to do?
>
>
> I tried putting the action group in a subprocess but that didn't seem to
> work either.
>
>
> Kevin Wertz
> Grifols, Inc.
> Clayton NC
>
>
>
>
>
>
>
>
>
Thanks Will! I will try this. We did finally just hear from IBM that it is
by design that SR attachments do not get pulled over the work order. But we
were told we can put in an RFE, of course. Which of course will be rejected
6 months later :)
KW
On Mon, Aug 25, 2014 at 10:56 PM, Will Hampton
will.hampton@exxtremeconsulting.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> Workflow performs a commit each time an assignment is made; so all you
> have to do is assign to “autoaccept” when you need the commit before taking
> further actions. The Auto Accept cron task will move the record at the next
> execution. ☺
>
> R/
> Will
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Monday, August 25, 2014 1:32 PM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Re: Commit in the middle of a workflow?
>
>
>
> Thanks Arpit. We are on 7.1 but thanks for the info. That looks like
> something we will be able to use after we upgrade.
>
> We actually submitted to IBM the inability to attach related SR
> attachments
> and it seems to be stuck in discussions. At least they haven't said yet
> that it is that way by design.
>
> What I ended up doing was just using the action group to move the SR
> attachments to work order attachments, then we present a dialog to the
> user
> to press the route workflow again to complete sending the email. Not the
> most elegant solution, but since only a small percentage of the SRs from
> this business unit have attachments, they weren't too uptight about it.
>
> KW
>
> On Sat, Jun 28, 2014 at 6:34 AM, narainarpit@gmail.com<mailto:
> narainarpit@gmail.com> [MAXIMO] <
> MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>> wrote:
>
> >
> >
> > Kevin,
> >
> > If you are on 7.5 , you can try sending email through action launch
> point
> > automation script in your workflow.
> >
> > Refer below URL:
> >
> >
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> >
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> > Thanks,
> > Arpit
> >
> >
> > ---In MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>, <wertzee@
> ...<mailto:wertzee@...>> wrote :
> >
> > Hi all, I need to be able to send the SR attachments with an email
> > generated by the work order created by the SR. Work order communication
> > templates don't have the ability to send the SR attachments so I created
> an
> > action group to move the SR attachments (updating the ownertable and
> > ownerID in doclinks), and put this action in the workflow assigned to
> the
> > button that sends the email out.
> >
> >
> > The problem is, the attachments don't appear on the email the first time
> I
> > run the workflow. Only the second time. I figure this is because there
> is
> > not a db commit until the end of the workflow.
> >
> >
> > Is there any way I can force a db commit in the middle of the workflow,
> or
> > does anyone know of any trick I can use to do what I'm trying to do?
> >
> >
> > I tried putting the action group in a subprocess but that didn't seem to
> > work either.
> >
> >
> > Kevin Wertz
> > Grifols, Inc.
> > Clayton NC
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>
>
>
As docklinks are controlled by a relationship on the work order and you have the related record number of your SR then you should be able to amend the relationship to look at the SR’s attachments in fact the
Following is actually in the doclinks relationship on version 7.5 so its out of the box that SR’s attached docs are available on the work order !!!
(ownertable in ('SR','INCIDENT','PROBLEM') and ownerid in (select ticketuid from ticket,relatedrecord where
ticketid=recordkey and ticket.class = relatedrecord.class and relatedrecclass=:woclass and relatedreckey=:wonum
and relatedrecsiteid=:siteid))
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: 29 September 2014 20:13
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Re: Commit in the middle of a workflow?
Thanks Will! I will try this. We did finally just hear from IBM that it is
by design that SR attachments do not get pulled over the work order. But we
were told we can put in an RFE, of course. Which of course will be rejected
6 months later :)
KW
On Mon, Aug 25, 2014 at 10:56 PM, Will Hampton
will.hampton@exxtremeconsulting.com<mailto:will.hampton@exxtremeconsulting.com> [MAXIMO] <MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>> wrote:
>
>
> Workflow performs a commit each time an assignment is made; so all you
> have to do is assign to “autoaccept” when you need the commit before taking
> further actions. The Auto Accept cron task will move the record at the next
> execution. ☺
>
> R/
> Will
>
>
>
> From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com]
> Sent: Monday, August 25, 2014 1:32 PM
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
> Subject: Re: [MAXIMO List] Re: Commit in the middle of a workflow?
>
>
>
> Thanks Arpit. We are on 7.1 but thanks for the info. That looks like
> something we will be able to use after we upgrade.
>
> We actually submitted to IBM the inability to attach related SR
> attachments
> and it seems to be stuck in discussions. At least they haven't said yet
> that it is that way by design.
>
> What I ended up doing was just using the action group to move the SR
> attachments to work order attachments, then we present a dialog to the
> user
> to press the route workflow again to complete sending the email. Not the
> most elegant solution, but since only a small percentage of the SRs from
> this business unit have attachments, they weren't too uptight about it.
>
> KW
>
> On Sat, Jun 28, 2014 at 6:34 AM, narainarpit@gmail.com<mailto<mailto:narainarpit@gmail.com%3cmailto>:
> narainarpit@gmail.com<mailto:narainarpit@gmail.com>> [MAXIMO] <
> MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com%3cmailto:MAXIMO@yahoogroups.com>>> wrote:
>
> >
> >
> > Kevin,
> >
> > If you are on 7.5 , you can try sending email through action launch
> point
> > automation script in your workflow.
> >
> > Refer below URL:
> >
> >
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> >
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> > Thanks,
> > Arpit
> >
> >
> > ---In MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com%3cmailto:MAXIMO@yahoogroups.com>>, <wertzee@
> ...<mailto:wertzee@...>> wrote :
> >
> > Hi all, I need to be able to send the SR attachments with an email
> > generated by the work order created by the SR. Work order communication
> > templates don't have the ability to send the SR attachments so I created
> an
> > action group to move the SR attachments (updating the ownertable and
> > ownerID in doclinks), and put this action in the workflow assigned to
> the
> > button that sends the email out.
> >
> >
> > The problem is, the attachments don't appear on the email the first time
> I
> > run the workflow. Only the second time. I figure this is because there
> is
> > not a db commit until the end of the workflow.
> >
> >
> > Is there any way I can force a db commit in the middle of the workflow,
> or
> > does anyone know of any trick I can use to do what I'm trying to do?
> >
> >
> > I tried putting the action group in a subprocess but that didn't seem to
> > work either.
> >
> >
> > Kevin Wertz
> > Grifols, Inc.
> > Clayton NC
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>
>
>
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.
**************************************************************************************************************
Yes but you can't send them on communication templates. There is no option
there to select to send SR attachments with the communication.
KW
On Tue, Sep 30, 2014 at 6:42 AM, Ian Wright ian.wright@gdfsuezep.co.uk
[MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> As docklinks are controlled by a relationship on the work order and you
> have the related record number of your SR then you should be able to amend
> the relationship to look at the SR’s attachments in fact the
> Following is actually in the doclinks relationship on version 7.5 so its
> out of the box that SR’s attached docs are available on the work order !!!
>
> (ownertable in ('SR','INCIDENT','PROBLEM') and ownerid in (select
> ticketuid from ticket,relatedrecord where
> ticketid=recordkey and ticket.class = relatedrecord.class and
> relatedrecclass=:woclass and relatedreckey=:wonum
> and relatedrecsiteid=:siteid))
>
> Rgds Ian
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: 29 September 2014 20:13
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Re: Commit in the middle of a workflow?
>
>
>
> Thanks Will! I will try this. We did finally just hear from IBM that it is
> by design that SR attachments do not get pulled over the work order. But
> we
> were told we can put in an RFE, of course. Which of course will be
> rejected
> 6 months later :)
>
> KW
>
> On Mon, Aug 25, 2014 at 10:56 PM, Will Hampton
> will.hampton@exxtremeconsulting.com<mailto:
> will.hampton@exxtremeconsulting.com> [MAXIMO] <MAXIMO@yahoogroups.com
> <mailto:MAXIMO@yahoogroups.com>> wrote:
>
> >
> >
> > Workflow performs a commit each time an assignment is made; so all you
> > have to do is assign to “autoaccept” when you need the commit before
> taking
> > further actions. The Auto Accept cron task will move the record at the
> next
> > execution. ☺
> >
> > R/
> > Will
> >
> >
> >
> > From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:
> MAXIMO@yahoogroups.com]
> > Sent: Monday, August 25, 2014 1:32 PM
> > To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
> > Subject: Re: [MAXIMO List] Re: Commit in the middle of a workflow?
> >
> >
> >
> > Thanks Arpit. We are on 7.1 but thanks for the info. That looks like
> > something we will be able to use after we upgrade.
> >
> > We actually submitted to IBM the inability to attach related SR
> > attachments
> > and it seems to be stuck in discussions. At least they haven't said yet
> > that it is that way by design.
> >
> > What I ended up doing was just using the action group to move the SR
> > attachments to work order attachments, then we present a dialog to the
> > user
> > to press the route workflow again to complete sending the email. Not the
> > most elegant solution, but since only a small percentage of the SRs from
> > this business unit have attachments, they weren't too uptight about it.
> >
> > KW
> >
> > On Sat, Jun 28, 2014 at 6:34 AM, narainarpit@gmail.com<mailto<mailto:
> narainarpit@gmail.com%3cmailto>:
> > narainarpit@gmail.com<mailto:narainarpit@gmail.com>> [MAXIMO] <
> > MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com<mailto:
> MAXIMO@yahoogroups.com%3cmailto:MAXIMO@yahoogroups.com>>> wrote:
> >
> > >
> > >
> > > Kevin,
> > >
> > > If you are on 7.5 , you can try sending email through action launch
> > point
> > > automation script in your workflow.
> > >
> > > Refer below URL:
> > >
> > >
> >
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> > >
> >
> http://maximoworks.wordpress.com/2013/07/22/sending-email-from-maximo-using-automationrhino-script/
> > > Thanks,
> > > Arpit
> > >
> > >
> > > ---In MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com<mailto:
> MAXIMO@yahoogroups.com%3cmailto:MAXIMO@yahoogroups.com>>, <wertzee@
> > ...<mailto:wertzee@...>> wrote :
> > >
> > > Hi all, I need to be able to send the SR attachments with an email
> > > generated by the work order created by the SR. Work order
> communication
> > > templates don't have the ability to send the SR attachments so I
> created
> > an
> > > action group to move the SR attachments (updating the ownertable and
> > > ownerID in doclinks), and put this action in the workflow assigned to
> > the
> > > button that sends the email out.
> > >
> > >
> > > The problem is, the attachments don't appear on the email the first
> time
> > I
> > > run the workflow. Only the second time. I figure this is because there
> > is
> > > not a db commit until the end of the workflow.
> > >
> > >
> > > Is there any way I can force a db commit in the middle of the
> workflow,
> > or
> > > does anyone know of any trick I can use to do what I'm trying to do?
> > >
> > >
> > > I tried putting the action group in a subprocess but that didn't seem
> to
> > > work either.
> > >
> > >
> > > Kevin Wertz
> > > Grifols, Inc.
> > > Clayton NC
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
> 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.
> **************************************************************************************************************
>
>
>
>
>
>
>
---In MAXIMO@yahoogroups.com, <wertzee@gmail.com> wrote :
Yes but you can't send them on communication templates. There is no option
there to select to send SR attachments with the communication.
Sorry I'm late to this, but you amend your workflow to use an AUTOACCEPT action to force a save to the database. This technique is used to get the memo of an action visible for email, so it should work for your situation as well.
-C