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 ,
If I had a communication template based on PO table -for example - and want to send email contain for some one containing all items in that PO , is there a way to do that using communication template and relationship.
P.S: the number of items is dynamic.
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
Officially no, but it can be done with a little trickery or other tools. Dbnews works very well for this as a packaged base solution, if not you need to cheat a little. I did this once using a view, essentially in the view I used a function to dynamically build the email body including formatted lines then ran the escalation against the view.
Creating such a view isn't trivial via database configuration but you can build it in the database then import it in or create a matching table in database configuration then in the database drop it and replace it with a view - Maximo will not care as long as you don't try to modify it within database configuration.
Sent from my iPad
On Oct 5, 2013, at 10:58 AM, amir samir <amir_s_anwar@yahoo.com> wrote:
> Hi ,
> If I had a communication template based on PO table -for example - and want to send email contain for some one containing all items in that PO , is there a way to do that using communication template and relationship.
> P.S: the number of items is dynamic.
>
> Best regards,
> Amir Anwar
> Senior Software Engineer
> Beshay Steel Egypt
>
Chris ,
Since I had to do a work around and no easy way to do it , I made a custom action class the send the mail using MXServer.SendEmail method and associate it with the escalation.
Thanks for the fast replay , I had to make sure there is no easy way to have this.
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
________________________________
From: Chris Lawless <lawlessc@gmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Saturday, October 5, 2013 5:05 PM
Subject: Re: [MAXIMO List] communication Template and Relationship
Officially no, but it can be done with a little trickery or other tools. Dbnews works very well for this as a packaged base solution, if not you need to cheat a little. I did this once using a view, essentially in the view I used a function to dynamically build the email body including formatted lines then ran the escalation against the view.
Creating such a view isn't trivial via database configuration but you can build it in the database then import it in or create a matching table in database configuration then in the database drop it and replace it with a view - Maximo will not care as long as you don't try to modify it within database configuration.
Sent from my iPad
On Oct 5, 2013, at 10:58 AM, amir samir <amir_s_anwar@yahoo.com> wrote:
>Hi ,
>If I had a communication template based on PO table -for example - and want to send email contain for some one containing all items in that PO , is there a way to do that using communication template and relationship.
>P.S: the number of items is dynamic.
>
>Best regards,
>Amir Anwar
>Senior Software Engineer
>Beshay Steel Egypt
No problem, I'm not really a java guy so I tend to look elsewhere, I have
written an automation script action to send emails though, reads in an HTML
template and builds an email from it - fairly similar to what you have done
I suspect!
On Sat, Oct 5, 2013 at 11:35 AM, amir samir <amir_s_anwar@yahoo.com> wrote:
> **
>
>
> Chris ,
> Since I had to do a work around and no easy way to do it , I made a custom
> action class the send the mail using MXServer.SendEmail method and
> associate it with the escalation.
> Thanks for the fast replay , I had to make sure there is no easy way to
> have this.
>
>
> Best regards,
> Amir Anwar
> Senior Software Engineer
> Beshay Steel Egypt
>
> ------------------------------
> *From:* Chris Lawless <lawlessc@gmail.com>
> *To:* "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> *Sent:* Saturday, October 5, 2013 5:05 PM
> *Subject:* Re: [MAXIMO List] communication Template and Relationship
>
>
> Officially no, but it can be done with a little trickery or other tools.
> Dbnews works very well for this as a packaged base solution, if not you
> need to cheat a little. I did this once using a view, essentially in the
> view I used a function to dynamically build the email body including
> formatted lines then ran the escalation against the view.
>
> Creating such a view isn't trivial via database configuration but you can
> build it in the database then import it in or create a matching table in
> database configuration then in the database drop it and replace it with a
> view - Maximo will not care as long as you don't try to modify it within
> database configuration.
>
> Sent from my iPad
>
> On Oct 5, 2013, at 10:58 AM, amir samir <amir_s_anwar@yahoo.com> wrote:
>
>
> Hi ,
> If I had a communication template based on PO table -for example - and
> want to send email contain for some one containing all items in that PO ,
> is there a way to do that using communication template and relationship.
> P.S: the number of items is dynamic.
>
> Best regards,
> Amir Anwar
> Senior Software Engineer
> Beshay Steel Egypt
>
>
>
>
>
I'll try to dig out the automation script action although I would say that
it is easier to do a view if you're comfortable with basic PL/SQL, mainly
because the escalation/communication template takes care of all the mailing
details for you rather than having to manipulate MXMailer. I would start of
with a basic layout for your email with a header then table lines and build
a function to generate it, all you then need to do is include it as
&&BODY&& or whatever. I should stress it's been a while and I haven't used
this approach in Maximo 7.x as yet.
Chris.
On Mon, Oct 7, 2013 at 11:17 AM, <swkim@getty.edu> wrote:
> **
>
>
> Hi Chris -- is this something you could share with us? We prefer
> automation scripts as that will likely be better supported on future maximo
> revisions than custom java classes that would need to be migrated.
>
>
> We have a po receipts escalation that only looks at the receipts status in
> the po table, but would be nice to include po line details. Or perhaps even
> group po lines so that one person gets all their relevant po lines in one
> email.
>
>
> I've been thinking about us inane oracle database function called listagg
> that I could possibly all the po line data as one row.
>
>
> ---In maximo@yahoogroups.com, <lawlessc@...> wrote:
>
> No problem, I'm not really a java guy so I tend to look elsewhere, I have
> written an automation script action to send emails though, reads in an HTML
> template and builds an email from it - fairly similar to what you have done
> I suspect!
>
>
>
>
This Jython automation script contains the basics of building and sending
an email from an action on an escalation as well as a rudimentary HTML
table.
from psdi.mbo import MboConstants;
from psdi.mbo import Mbo;
from psdi.mbo import MboSetRemote;
from java.lang import String;
actions = mbo.getMboSet("ACTIONS");
subject = ""
msgbody = ""
wfdesc = mbo.getString("DESCRIPTION")
subject = "WorkFlow Assignment : " + wfdesc
numoff = actions.count();
msgbody = msgbody = "You have a WorkFlow assignment pending as
follows:<br><br>"
msgbody = msgbody + "The assignment description is : " + wfdesc + "<br><br>"
msgbody = msgbody + "The action options are: " + "<br><br>"
msgbody = msgbody + "WFASSIGNMENTID: " + mbo.getString("WFASSIGNMENTID") +
"<br><br>"
for i in range(numoff):
action = actions.getMbo(i)
msgbody = msgbody + action.getString("INSTRUCTION") + "<br>"
msgbody = msgbody + "<br><hr><br>"
msgbody = msgbody + "<table
border=1><tr><td>One</td><td>Two</td></tr><tr><td>One</td><td>Two</td></tr></table>"
from psdi.mbo import MboServerInterface;
mboServer = scriptHome.getMboServer();
mailer = mboServer.getMXServer();
mailer.sendEMail('liberi@eaglena.com','admin@eaglena.com',subject,msgbody)
On Mon, Oct 7, 2013 at 11:21 AM, Chris Lawless <lawlessc@gmail.com> wrote:
> I'll try to dig out the automation script action although I would say that
> it is easier to do a view if you're comfortable with basic PL/SQL, mainly
> because the escalation/communication template takes care of all the mailing
> details for you rather than having to manipulate MXMailer. I would start of
> with a basic layout for your email with a header then table lines and build
> a function to generate it, all you then need to do is include it as
> &&BODY&& or whatever. I should stress it's been a while and I haven't used
> this approach in Maximo 7.x as yet.
>
> Chris.
>
>
> On Mon, Oct 7, 2013 at 11:17 AM, <swkim@getty.edu> wrote:
>
>> **
>>
>>
>> Hi Chris -- is this something you could share with us? We prefer
>> automation scripts as that will likely be better supported on future maximo
>> revisions than custom java classes that would need to be migrated.
>>
>>
>> We have a po receipts escalation that only looks at the receipts status
>> in the po table, but would be nice to include po line details. Or perhaps
>> even group po lines so that one person gets all their relevant po lines in
>> one email.
>>
>>
>> I've been thinking about us inane oracle database function called listagg
>> that I could possibly all the po line data as one row.
>>
>>
>> ---In maximo@yahoogroups.com, <lawlessc@...> wrote:
>>
>> No problem, I'm not really a java guy so I tend to look elsewhere, I have
>> written an automation script action to send emails though, reads in an HTML
>> template and builds an email from it - fairly similar to what you have done
>> I suspect!
>>
>>
>>
>>
>
>
To run an automation script from an escalation you create it with an ACTION
launch point, you can then specify it as the action on your escalation.
On Mon, Oct 7, 2013 at 4:47 PM, <swkim@getty.edu> wrote:
> **
>
>
> Chris - thanks for the script. I guess I need a little more in terms of
> how to incorporate an automation script into an ESCALATION, or someway to
> send out the PO lines in an e-mail that shows of the status of each PO and
> the status of their respective lines.
>
>
> ---In MAXIMO@yahoogroups.com, <maximo@yahoogroups.com> wrote:
>
> This Jython automation script contains the basics of building and sending
> an email from an action on an escalation as well as a rudimentary HTML
> table.
>
> from psdi.mbo import MboConstants;
> from psdi.mbo import Mbo;
> from psdi.mbo import MboSetRemote;
> from java.lang import String;
>
> actions = mbo.getMboSet("ACTIONS");
>
> subject = ""
> msgbody = ""
>
> wfdesc = mbo.getString("DESCRIPTION")
> subject = "WorkFlow Assignment : " + wfdesc
>
> numoff = actions.count();
>
> msgbody = msgbody = "You have a WorkFlow assignment pending as
> follows:<br><br>"
> msgbody = msgbody + "The assignment description is : " + wfdesc +
> "<br><br>"
> msgbody = msgbody + "The action options are: " + "<br><br>"
> msgbody = msgbody + "WFASSIGNMENTID: " + mbo.getString("WFASSIGNMENTID") +
> "<br><br>"
>
> for i in range(numoff):
> action = actions.getMbo(i)
> msgbody = msgbody + action.getString("INSTRUCTION") + "<br>"
>
> msgbody = msgbody + "<br><hr><br>"
> msgbody = msgbody + "<table
> border=1><tr><td>One</td><td>Two</td></tr><tr><td>One</td><td>Two</td></tr></table>"
>
> from psdi.mbo import MboServerInterface;
> mboServer = scriptHome.getMboServer();
> mailer = mboServer.getMXServer();
>
> mailer.sendEMail('liberi@...','admin@...',subject,msgbody)
>
>
> On Mon, Oct 7, 2013 at 11:21 AM, Chris Lawless <lawlessc@...> wrote:
>
> I'll try to dig out the automation script action although I would say that
> it is easier to do a view if you're comfortable with basic PL/SQL, mainly
> because the escalation/communication template takes care of all the mailing
> details for you rather than having to manipulate MXMailer. I would start of
> with a basic layout for your email with a header then table lines and build
> a function to generate it, all you then need to do is include it as
> &&BODY&& or whatever. I should stress it's been a while and I haven't used
> this approach in Maximo 7.x as yet.
>
> Chris.
>
>
> On Mon, Oct 7, 2013 at 11:17 AM, <swkim@...> wrote:
>
> **
>
>
> Hi Chris -- is this something you could share with us? We prefer
> automation scripts as that will likely be better supported on future maximo
> revisions than custom java classes that would need to be migrated.
>
>
> We have a po receipts escalation that only looks at the receipts status in
> the po table, but would be nice to include po line details. Or perhaps even
> group po lines so that one person gets all their relevant po lines in one
> email.
>
>
> I've been thinking about us inane oracle database function called listagg
> that I could possibly all the po line data as one row.
>
>
> ---In maximo@yahoogroups.com, <lawlessc@...> wrote:
>
> No problem, I'm not really a java guy so I tend to look elsewhere, I have
> written an automation script action to send emails though, reads in an HTML
> template and builds an email from it - fairly similar to what you have done
> I suspect!
>
>
>
>
>
>
I will say Rules Manager makes this easy if you can make the investment.
Good discussions, our users are the best!
Thanks to all of you.
Wes (the moderator)
________________________________
From: Chris Lawless <lawlessc@gmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Monday, October 7, 2013 4:14 PM
Subject: Re: Re: [MAXIMO List] RE: communication Template and Relationship
To run an automation script from an escalation you create it with an ACTION launch point, you can then specify it as the action on your escalation.
On Mon, Oct 7, 2013 at 4:47 PM, <swkim@getty.edu> wrote:
>
>Chris - thanks for the script. I guess I need a little more in terms of how to incorporate an automation script into an ESCALATION, or someway to send out the PO lines in an e-mail that shows of the status of each PO and the status of their respective lines.
>
>
>---In MAXIMO@yahoogroups.com, <maximo@yahoogroups.com> wrote:
>
>
>This Jython automation script contains the basics of building and sending an email from an action on an escalation as well as a rudimentary HTML table.
>
>
>from psdi.mbo import MboConstants;
>from psdi.mbo import Mbo;
>from psdi.mbo import MboSetRemote;
>from java.lang import String;
>
>
>actions = mbo.getMboSet("ACTIONS");
>
>
>subject = ""
>msgbody = ""
>
>
>wfdesc = mbo.getString("DESCRIPTION")
>subject = "WorkFlow Assignment : " + wfdesc
>
>
>
>numoff = actions.count();
>
>
>msgbody = msgbody = "You have a WorkFlow assignment pending as follows:<br><br>"
>msgbody = msgbody + "The assignment description is : " + wfdesc + "<br><br>"
>msgbody = msgbody + "The action options are: " + "<br><br>"
>msgbody = msgbody + "WFASSIGNMENTID: " + mbo.getString("WFASSIGNMENTID") + "<br><br>"
>
>
>for i in range(numoff):
> action = actions.getMbo(i)
> msgbody = msgbody + action.getString("INSTRUCTION") + "<br>"
>
>
>msgbody = msgbody + "<br><hr><br>"
>msgbody = msgbody + "<table border=1><tr><td>One</td><td>Two</td></tr><tr><td>One</td><td>Two</td></tr></table>"
>
>from psdi.mbo import MboServerInterface;
>mboServer = scriptHome.getMboServer();
>mailer = mboServer.getMXServer();
>
>
>mailer.sendEMail('liberi@...','admin@...',subject,msgbody)
>
>
>
>On Mon, Oct 7, 2013 at 11:21 AM, Chris Lawless <lawlessc@...> wrote:
>>
>>I'll try to dig out the automation script action although I would say that it is easier to do a view if you're comfortable with basic PL/SQL, mainly because the escalation/communication template takes care of all the mailing details for you rather than having to manipulate MXMailer. I would start of with a basic layout for your email with a header then table lines and build a function to generate it, all you then need to do is include it as &&BODY&& or whatever. I should stress it's been a while and I haven't used this approach in Maximo 7.x as yet.
>>>
>>>
>>>Chris.
>>>
>>>
>>>
>>>On Mon, Oct 7, 2013 at 11:17 AM, <swkim@...> wrote:
>>>
>>>
>>>>
>>>> Hi Chris -- is this something you could share with us? We prefer automation scripts as that will likely be better supported on future maximo revisions than custom java classes that would need to be migrated.
>>>>
>>>>
>>>>We have a po receipts escalation that only looks at the receipts status in the po table, but would be nice to include po line details. Or perhaps even group po lines so that one person gets all their relevant po lines in one email.
>>>>
>>>>
>>>>I've been thinking about us inane oracle database function called listagg that I could possibly all the po line data as one row.
>>>>
>>>>
>>>>---In maximo@yahoogroups.com, <lawlessc@...> wrote:
>>>>
>>>>
>>>>No problem, I'm not really a java guy so I tend to look elsewhere, I have written an automation script action to send emails though, reads in an HTML template and builds an email from it - fairly similar to what you have done I suspect!
>>>>
>>>>
>>>>
>>>
>>
That’s true – our users are generally the best. But this group is not as busy as it used to be … a pity.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of wwilliams@rocketmail.com
Sent: October-07-13 3:44 PM
To: MAXIMO@yahoogroups.com
Subject: Re: Re: [MAXIMO List] RE: communication Template and Relationship
I will say Rules Manager makes this easy if you can make the investment.
Good discussions, our users are the best!
Thanks to all of you.
Wes (the moderator)
_____
From: Chris Lawless <lawlessc@gmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Monday, October 7, 2013 4:14 PM
Subject: Re: Re: [MAXIMO List] RE: communication Template and Relationship
To run an automation script from an escalation you create it with an ACTION launch point, you can then specify it as the action on your escalation.
On Mon, Oct 7, 2013 at 4:47 PM, <swkim@getty.edu> wrote:
Chris - thanks for the script. I guess I need a little more in terms of how to incorporate an automation script into an ESCALATION, or someway to send out the PO lines in an e-mail that shows of the status of each PO and the status of their respective lines.
---In MAXIMO@yahoogroups.com, <maximo@yahoogroups.com> wrote:
This Jython automation script contains the basics of building and sending an email from an action on an escalation as well as a rudimentary HTML table.
from psdi.mbo import MboConstants;
from psdi.mbo import Mbo;
from psdi.mbo import MboSetRemote;
from java.lang import String;
actions = mbo.getMboSet("ACTIONS");
subject = ""
msgbody = ""
wfdesc = mbo.getString("DESCRIPTION")
subject = "WorkFlow Assignment : " + wfdesc
numoff = actions.count();
msgbody = msgbody = "You have a WorkFlow assignment pending as follows:<br><br>"
msgbody = msgbody + "The assignment description is : " + wfdesc + "<br><br>"
msgbody = msgbody + "The action options are: " + "<br><br>"
msgbody = msgbody + "WFASSIGNMENTID: " + mbo.getString("WFASSIGNMENTID") + "<br><br>"
for i in range(numoff):
action = actions.getMbo(i)
msgbody = msgbody + action.getString("INSTRUCTION") + "<br>"
msgbody = msgbody + "<br><hr><br>"
msgbody = msgbody + "<table border=1><tr><td>One</td><td>Two</td></tr><tr><td>One</td><td>Two</td></tr></table>"
from psdi.mbo import MboServerInterface;
mboServer = scriptHome.getMboServer();
mailer = mboServer.getMXServer();
mailer.sendEMail('liberi@...','admin@...',subject,msgbody)
On Mon, Oct 7, 2013 at 11:21 AM, Chris Lawless <lawlessc@...> wrote:
I'll try to dig out the automation script action although I would say that it is easier to do a view if you're comfortable with basic PL/SQL, mainly because the escalation/communication template takes care of all the mailing details for you rather than having to manipulate MXMailer. I would start of with a basic layout for your email with a header then table lines and build a function to generate it, all you then need to do is include it as &&BODY&& or whatever. I should stress it's been a while and I haven't used this approach in Maximo 7.x as yet.
Chris.
On Mon, Oct 7, 2013 at 11:17 AM, <swkim@...> wrote:
Hi Chris -- is this something you could share with us? We prefer automation scripts as that will likely be better supported on future maximo revisions than custom java classes that would need to be migrated.
We have a po receipts escalation that only looks at the receipts status in the po table, but would be nice to include po line details. Or perhaps even group po lines so that one person gets all their relevant po lines in one email.
I've been thinking about us inane oracle database function called listagg that I could possibly all the po line data as one row.
---In maximo@yahoogroups.com, <lawlessc@...> wrote:
No problem, I'm not really a java guy so I tend to look elsewhere, I have written an automation script action to send emails though, reads in an HTML template and builds an email from it - fairly similar to what you have done I suspect!
Go add to that: the most often-used document on autoscripting is
https://www.ibm.com/developerworks/community/groups/service/html/communityvi
ew?communityUuid=a9ba1efe-b731-4317-9724-a181d6155e3a#fullpageWidgetId=W5f28
1fe58c09_49c7_9fa4_e094f86b7e98
<https://www.ibm.com/developerworks/community/groups/service/html/communityv
iew?communityUuid=a9ba1efe-b731-4317-9724-a181d6155e3a#fullpageWidgetId=W5f2
81fe58c09_49c7_9fa4_e094f86b7e98&file=83c7752c-a621-4af9-bb32-d6ba7d612ab2>
&file=83c7752c-a621-4af9-bb32-d6ba7d612ab2
That would be the place to start.
Shannon Rotz
P.S. Chris: thanks for probably saving me a bunch of time - I was about to
try to re-invent your wheel in the next month or so, in the same context,
i.e. receipt notifications :)
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Chris Lawless
Sent: October-07-13 2:15 PM
To: MAXIMO@yahoogroups.com
Subject: Re: Re: [MAXIMO List] RE: communication Template and Relationship
To run an automation script from an escalation you create it with an ACTION
launch point, you can then specify it as the action on your escalation.
On Mon, Oct 7, 2013 at 4:47 PM, <swkim@getty.edu> wrote:
Chris - thanks for the script. I guess I need a little more in terms of how
to incorporate an automation script into an ESCALATION, or someway to send
out the PO lines in an e-mail that shows of the status of each PO and the
status of their respective lines.
---In MAXIMO@yahoogroups.com, <maximo@yahoogroups.com> wrote:
This Jython automation script contains the basics of building and sending an
email from an action on an escalation as well as a rudimentary HTML table.
from psdi.mbo import MboConstants;
from psdi.mbo import Mbo;
from psdi.mbo import MboSetRemote;
from java.lang import String;
actions = mbo.getMboSet("ACTIONS");
subject = ""
msgbody = ""
wfdesc = mbo.getString("DESCRIPTION")
subject = "WorkFlow Assignment : " + wfdesc
numoff = actions.count();
msgbody = msgbody = "You have a WorkFlow assignment pending as
follows:<br><br>"
msgbody = msgbody + "The assignment description is : " + wfdesc + "<br><br>"
msgbody = msgbody + "The action options are: " + "<br><br>"
msgbody = msgbody + "WFASSIGNMENTID: " + mbo.getString("WFASSIGNMENTID") +
"<br><br>"
for i in range(numoff):
action = actions.getMbo(i)
msgbody = msgbody + action.getString("INSTRUCTION") + "<br>"
msgbody = msgbody + "<br><hr><br>"
msgbody = msgbody + "<table
border=1><tr><td>One</td><td>Two</td></tr><tr><td>One</td><td>Two</td></tr><
/table>"
from psdi.mbo import MboServerInterface;
mboServer = scriptHome.getMboServer();
mailer = mboServer.getMXServer();
mailer.sendEMail('liberi@...','admin@...',subject,msgbody)
On Mon, Oct 7, 2013 at 11:21 AM, Chris Lawless <lawlessc@...> wrote:
I'll try to dig out the automation script action although I would say that
it is easier to do a view if you're comfortable with basic PL/SQL, mainly
because the escalation/communication template takes care of all the mailing
details for you rather than having to manipulate MXMailer. I would start of
with a basic layout for your email with a header then table lines and build
a function to generate it, all you then need to do is include it as &&BODY&&
or whatever. I should stress it's been a while and I haven't used this
approach in Maximo 7.x as yet.
Chris.
On Mon, Oct 7, 2013 at 11:17 AM, <swkim@...> wrote:
Hi Chris -- is this something you could share with us? We prefer automation
scripts as that will likely be better supported on future maximo revisions
than custom java classes that would need to be migrated.
We have a po receipts escalation that only looks at the receipts status in
the po table, but would be nice to include po line details. Or perhaps even
group po lines so that one person gets all their relevant po lines in one
email.
I've been thinking about us inane oracle database function called listagg
that I could possibly all the po line data as one row.
---In maximo@yahoogroups.com, <lawlessc@...> wrote:
No problem, I'm not really a java guy so I tend to look elsewhere, I have
written an automation script action to send emails though, reads in an HTML
template and builds an email from it - fairly similar to what you have done
I suspect!