Bursting of Notifications

Ruma,

I haven't tried to burst off from two columns in the same notification to two different groups. However, my question is have you looked at using the employee.login in the info set to handle as well?

I will dig into my notes and try to find something for you.

Thank you for the webex on bursting. It explains a lot.

However I am unable to find anything on this issue. I am actually not bursting on the employee but the administrator and the director email.

what is the data element you are bursting on?

Hi Matt,

I want to burst on 2 data elements - the director's email and the operator's email who key's in the service agreement in one notification.

You should be able to construct your SQL so that it combines both the Operator and Director email address into one column. Additionally, if you need to customize the content based on the roll you could put in a static column in your SQL identifying such then use that column in the template to give the appropriate content.

So if I add jsmith@jh.comrst@gh.com in one field how will the notification figure out that there are 2 emails in this field and burst it twice.

Ruma,
Were you ever successful in bursting to multiple emails contained in one column? I'm attempting to do the same thing and have tried separating the email addresses with a semi-colon and a comma, but neither have worked. I know I could change the query to return multiple rows with single email addresses but I was hoping to avoid that. Just wondered what your solution was.

Thanks.

Have you guys considered using distributions groups? Not sure it meets the criteria but its a good way to handle multiple email addresses.

Kevin,

I was not able to burst notifications to multiple levels of management using a single notification. I do not want to include multiple rows of the same data in my query because then I cannot validate whether the query is right or wrong.

Just last week I was presented with such a scenario: Management has performance evaluations for their employees. Once they rate the employees' performance and send this information to HR, HR puts this information into lawson which drives compensation for salary increases, bonuses etc HR would like the immediate supervisor(team lead), manager, director etc to get notification that their rating as been put into Lawson.

They wanted a single notification to be burst to all 3 levels of management in one notification and not 3 separate emails. I did not find any way of doing this since each indiviual manager needs to be notified the rating of their employee and this information cannot be shared with other managers.

I investigated thoroughly and have not found a way of doing this, since on the bursting tab of the notification it clearly asks which field you want the smart notification to be bursted by.

Someone on this chain recomended bursting groups but I cannot see that defined anywhere in the system. If Matt is talking about distribution groups I do not know where these are defined in the system and how to use this.

I'm not familiar with distribution groups either, but I suspect those would be for a fixed list of recipients.  Since I need to send the email to an employee and their current manager (ideally in a single email so that each knows the other also received the notice), the dist group won't work because that emp-mgr relationship could change at any time.

When I did try to burst to two addresses combined in one column separated by a semicolon or comma, I am seeing java errors in the ENPDELIVERY log that point to:
Caused by:  javax.mail.internet.AddressException: Illegal semicolon, not in group in string

or for comma separation:
Caused by:  javax.mail.internet.AddressException: Illegal address in string

Unless someone knows a suitable format to make javamail happy, I think I'm out of luck on this approach.

yeah unfortunately I think you have to go with the approach that Ruma said she couldnt use , which is associating an email address for each line. While this can be a bit annoying it is the requirement for many bursting apps.

How are you building the infoset? If you are using SQL you should be able to basically create a seperate (but duplicate) record for the two different email columns so that it ends up getting bursted individually...

when you say duplicate you really mean 2 different columns right ?

What I'm saying is if you had a row like (in csv for lack of a better way to display it):

ABC,XYZ,123,joe@some.com,mark@some.com

You can write the sql to produce a dataset that gives you:

ABC,XYZ,123,joe@some.com
ABC,XYZ,123,joe@mark@some.com

so that you could burst this appropriately.

That is if I'm understanding the desire correctly...

Do you know whether the smart note actually gets bursted by this because smart note does not know how to parse and interpret a comma as 2 different emails. I have tried this and this does not work.

I think the issue is that it bursts it to AN email - and it simply looks at whatever field is delivered as "an email" - even if it is multiples separated by commas/semicolons, etc...

That's why I suggested actually pushing to it two different records (which really come from the one record) - one with each email on it. That way each email gets bursted individually.

George, I think you had a typo that may have been confusing. I think you meant to say:

You can write the sql to produce a dataset that gives you:

ABC,XYZ,123,joe@some.com
ABC,XYZ,123,mark@some.com





What I'm saying is if you had a row like (in csv for lack of a better way to display it):

ABC,XYZ,123,joe@some.com,mark@some.com

You can write the sql to produce a dataset that gives you:

ABC,XYZ,123,joe@some.com
ABC,XYZ,123,joe@mark@some.com

so that you could burst this appropriately.

That is if I'm understanding the desire correctly...

However you write your sql:

for eg - mark.some@yahoo.com,asst1@yahoo.com the smart note will not parse and treat the string as 2 different emails. ie if both of them are in one column.

If you use 2 columns and have 2 different emails in 2 different columns when you are bursting you have to specify the column which you would like the smart note to burst by. In this case you are forecd to choose a single column name. There is no way you can shoose 2 column names.

Thanks Ruma - yes, definitly a victim of the cut and paste...that's exactly what I meant -