Event Handler to send email after attachments uploaded

I am wanting to create an event handler that will send an email when a new Customer Order has been added, but I want to wait 5 minutes for it to send so that documents can be uploaded to the order and included as attachments. I have created 2 event actions:

1. Sleep - waits 300 seconds after new CO is added

2. Send Email - sends the email. Attachments set to ALL.

This all works, but the attachments are not there. Has anyone done something similar that you can share?

Find more posts tagged with

General Discussions

Accepted answers

All comments

Are you using the GenericSendEmail event for the email part? If so, as far as I know, you have to populate the attachments collection variable specifically. It won't automatically pick up the attachments on the Customer Order record.

Tim,

I have other Send Email event actions that send attachments. The only option I have set on these is the attachments field set to ALL in the Send Email parameters. What specific variable do you think I need to specify and where would I specify this at?

0712131256598360.doc

?

Sounds like you are using a different mechanism to send the email than GenericSendEmail, so my comment probably doesn't apply in your case. If you do switch to using GenericSendEmail, there are a bunch of variables you set - From, Reply-To, To, Cc, etc... - and an Attachments variable. Add your attachments to the collection that is behind that variable and it will send them. See https://docs.infor.com/csi/10.x/en-us/csbiolh/default.html

These are my event actions. The email sends but still not attachments:

Event Name

Handler Description

Sequence

Action Sequence

Action Type

Action Description

Parameters

IdoPostItemInsert

Send Email for New EG Customer Order

13

5

Sleep

INTERVAL(300)

IdoPostItemInsert

Send Email for New EG Customer Order

13

10

Set Values

SETVARVALUES( AttachmentNum=1, NumAttachments=DBFUNCTION("dbo.NumEntries", E(AttachmentFileList), ",") )

IdoPostItemInsert

Send Email for New EG Customer Order

13

15

Branch

CONDITION(V(NumAttachments) = 0) DEST(100)

IdoPostItemInsert

Send Email for New EG Customer Order

13

20

Set Values

SETVARVALUES( AttachmentFileVar=DBFUNCTION("dbo.Entry", V(AttachmentNum), E(AttachmentFileList), ","), AttachmentNameVar=DBFUNCTION("dbo.Entry", V(AttachmentNum), E(AttachmentNameList), ","), AttachmentDocTypeVar=DBFUNCTION("dbo.Entry", V(AttachmentNum), E(AttachmentDocTypeList), ","), AttachmentNum=1+V(AttachmentNum) )

IdoPostItemInsert

Send Email for New EG Customer Order

13

30

Attach

DOCACTION(ATTACH) DOCTYPE(V(AttachmentDocTypeVar)) FILENAME(V(AttachmentFileVar)) ATTACHMENTNAME(V(AttachmentNameVar))

IdoPostItemInsert

Send Email for New EG Customer Order

13

40

Branch

CONDITION(V(AttachmentNum)<=V(NumAttachments)) DEST(20)

IdoPostItemInsert

Send Email for New EG Customer Order

13

100

Send Email

Send e-mail message

CONDITION(P("CoNum") LIKE "EG*" OR P("CoNum") LIKE "eg*")TO("EngineeringGroup@jcmind.com")SUBJECT(SUBSTITUTE("New Engineered Order {0} has been created for Customer {1}.", FP("CoNum"), FP("CustNum")))HTMLFORMAT(FALSE)BODY(SUBSTITUTE("New Engineered Order {0} has been created for Customer {1}.", FP("CoNum"), FP("CustNum")))ATTACH(ALL)

Event Name	Handler Description	Sequence	Action Sequence	Action Type	Action Description	Parameters
IdoPostItemInsert	Send Email for New EG Customer Order	13	5	Sleep		INTERVAL(300)
IdoPostItemInsert	Send Email for New EG Customer Order	13	10	Set Values		SETVARVALUES( AttachmentNum=1, NumAttachments=DBFUNCTION("dbo.NumEntries", E(AttachmentFileList), ",") )
IdoPostItemInsert	Send Email for New EG Customer Order	13	15	Branch		CONDITION(V(NumAttachments) = 0) DEST(100)
IdoPostItemInsert	Send Email for New EG Customer Order	13	20	Set Values		SETVARVALUES( AttachmentFileVar=DBFUNCTION("dbo.Entry", V(AttachmentNum), E(AttachmentFileList), ","), AttachmentNameVar=DBFUNCTION("dbo.Entry", V(AttachmentNum), E(AttachmentNameList), ","), AttachmentDocTypeVar=DBFUNCTION("dbo.Entry", V(AttachmentNum), E(AttachmentDocTypeList), ","), AttachmentNum=1+V(AttachmentNum) )
IdoPostItemInsert	Send Email for New EG Customer Order	13	30	Attach		DOCACTION(ATTACH) DOCTYPE(V(AttachmentDocTypeVar)) FILENAME(V(AttachmentFileVar)) ATTACHMENTNAME(V(AttachmentNameVar))
IdoPostItemInsert	Send Email for New EG Customer Order	13	40	Branch		CONDITION(V(AttachmentNum)<=V(NumAttachments)) DEST(20)
IdoPostItemInsert	Send Email for New EG Customer Order	13	100	Send Email	Send e-mail message	CONDITION(P("CoNum") LIKE "EG" OR P("CoNum") LIKE "eg")TO("EngineeringGroup@jcmind.com")SUBJECT(SUBSTITUTE("New Engineered Order {0} has been created for Customer {1}.", FP("CoNum"), FP("CustNum")))HTMLFORMAT(FALSE)BODY(SUBSTITUTE("New Engineered Order {0} has been created for Customer {1}.", FP("CoNum"), FP("CustNum")))ATTACH(ALL)

0712131256598360.doc

Did you ever get this to work? Looking to do something similar

Hi, I would be interested to know as well. I have been asked to send an email to the user if their background task fails. I do not for which std event I need to code the event handler.

We handled the email on bg task failure by making a Publication and firing it off by adding a trigger to BGTaskHistory_mst. (We are on prem)

https://pastebin.com/NmeLjUBa

Becareful, any errors in that trigger and your bg tasks will no longer work.

You can use the TaskPostPerform event in the application event system. You can make it run on a condition that the task status is failed and then you can email the initialing user.

Quick Links