LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: kim_rana

Is there a way to send an email from Lavastorm?

I have input data which contains a number of rows for each ID. I want to split this data per ID then email it out to different recipients.
Is this possible?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rpigneri

Dear Kim,

The Lavastorm Analytic Engine and Lavastorm Desktop will have a new node in version 4.1.5 for sending e-mail from a graph. This node fulfills exactly the purpose you have described: for each row in your input data, you can send an e-mail to a specific recipient. You can define the recipients on a per-row basis by including their e-mail address in the data, or you can set up a list of recipients to receive all rows of data. 4.1.5 is scheduled to be released in a few weeks so when you upgrade, this node will automatically be available to you.

If you happen to have multiple sets of data rows, and you want to send one e-mail per set rather than per row, you can use an Aggregate (Agg) node to group the data to one row per ID and then send out a single e-mail per ID.

Hope that helps,

Rocco

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: kim_rana

Thanks Rocco.

Does this new email node allow you to attach files too?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rpigneri

Dear Kim,

Could you clarify a bit what sorts of things you would like to attach? Are you looking to send all the input data in a single attachment to a specific e-mail address, or are you interested in different functionality?

Also, could you provide a higher-level view of what you hope to accomplish? It is possible that there is a different approach that would be easier.

Thank you,

Rocco Pigneri

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: kim_rana

Hi Rocco,

My output is something like the below:

ID Name Code
1 John xxx2
1 John xxx3
1 John xxx4
2 Tim xxx7
2 Tim xxx2
3 Larry xxx9
3 Larry xxx3

I want to be able to email all data in rows where ID=1 to John, ID=2 to Tim and ID=3 to Larry as an attachment.

Will this work with the new email node?

Kim

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Kim, if you wanted to send that data, the email node in its current form could be used with an Agg node as mentioned above. I have attached a sample graph that demonstrates the use.

Then you can use the Email node, to email each of those people...and in the message, you could have the 'codes' information. It would not be an attachment, but all the data could be assembled into the email.

If your code field is longer, you can use "\n" in the groupString to create one for each line.

I hope this helps.
Cheers
Rich
Attachments:
Example Graph.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sassy1

Hi Rich,

I was searching and found this forum on emails from Lavastorm. Can you please tell me when version 4.1.5 will be available? This sounds like a great enhancement.

Also, I'm trying to find out for a user if Lavastorm has (or will have) Alerts that generate emails. She is looking for data quality report/alerts to be generated and sent to her based on a specific criteria. Is this at all possible?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Brain 4.1.6 was released on Feburary 8th, 2010

I'm not sure what you're asking for as to "Alerts". I have several graphs where I notify an audience that certain conditions were found within a graph.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sassy1

My version reads "BRE v 4.1.4.2 Build 266"

So, we need to apply new patches/get new version?

Can you please send me an example of where Lavastorm generates an email to user(s) based on a threshold that's reached? For example, if a field goes above a specified value, can Lavastorm email out a notice of this occurrance?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

You will need to update your client software, and should really update the server to match it. The Latest version of the client is currently 4.1.6, and the server is 4.1.6.1. I have attached an example graph which shows an email being sent based on conditions in the data...an agg is used to group up the results to send, and then a metacheck is used to only execute the sendmail node if there are results to send.

Cheers
Rich
Attachments:
ThreshholdExample.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dinokape

Is there a way to attach a file to e-mail (Excel, zip, or any other format other than plain ascii text in the message body)? I'm running Lavastorm version 4.1.7.0 and I can see Send E-mail node which is fairly easy to use, but it doesn't allow me to attach a file.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

The attached SMTP mailer node has a number of features:
1) You can supply an (optional) list of files to be attached.
2) If you add an input pin, then BRD data can be sent directly in the message body. "Column Order" can limit which fields are sent and the order they appear in.
3) On the Parameters2 screen you can specify various features for sending thru an SMTP server
4) If your input data has email addresses, then you can send individual records to various Recipients based upon the RecipientsField
Attachments:
smtp.brn

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dinokape

Appreciate your prompt answer, the node is great and works fine. My only concern is that you need to specify the password in smtpPass which is clear text and can be seen by anybody who opens the graph. Is there a way of encrypting that?

I know I can specify a parameter as password type in the Parameter Declarations, which sort of hides the password and displays it as *****, however, the password is still not encrypted and can be easily obtained from there. Alternatively, is there a way of doing it in the same way as Send E-mail standard node, which doesn't require authentication on the SMTP server?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

It all depends upon the particular server that you are trying to connect to. Some companies have "relay" servers that do not require any authentication, some companies lock down their servers to the point that you can't even think about anonymous relay.

If your (unix) Brain server is properly configured, you can simply use "localhost", and not be asked for user/pwd, but again.. that will be dictated by your particular corporate security policy.

The entire issue of hiding userid/password is something we really should take up in a separate thread. You have the same problem with database passwords, etc.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Azad Thalor

Hi Team,

Please let us know how to attach any file for example excel spreadsheet in Send E-mail node.

this option is not visible. However, other options like SmtpServerName, FromAddress, MessageSubject, ToAddress in Parameters 1 tab are visible.

Please suggest.

Thanks and regards,
Azad Thalor
+234 8169636582

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: techm_aritra

Hi Team,

Please provide and example for attaching file and sending mail by using LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: simon.wilby

Hi,

There is a release of lal very soon on 4.6 and 5.0 platforms which includes the Send Email+ node - this allows for attachments in emails. please monitor the following thread for when this is available.

Updates-to-the-LAL-library

Regards

Simon

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: techm_aritra

Hi Simon,
The problem is I want to do it using LAE 4.5.3.
Please provide a solution and example for that.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: techm_aritra

Originally posted by: techm_aritra
					

Hi Simon,

The problem is I want to do it using LAE 4.5.3.

Please provide a solution and example for that.
			

Hi Simon,

Please provide an example of a following case

1) Read data from a file
2) send those data via email

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: simon.wilby

Hi,

Sorry, I can't help on the older versions of lae. Have you tried the smtp.brn attachment that Stony provided in this thread?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

You could always use this library which does work with 4.5.3 server version however use at your own risk
Attachments:
mail.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: techm_aritra

Thanks

I am able to send mail with attachement

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: MichaelUl

Is there a way to place the date and time in the Subject line of e-mails?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

If you edit the Subject Line and put {{^CurrentDate^}} then the subject will include the current date every time you execute the node in BRE.

HOWEVER!!!!
If you produce a BRX to run the graph on the server.. this will not work.. the value for that parameter is compiled into the BRX and every time you run the node, it will be stuck on the date when you published the BRX. Unfortunately, there's not a clean way around this restriction at this time.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Have you looked at the "Send Email+" node yet from the lal1 library? According to the lal1 download page it is compatible with LAE 4.6, and 5.0.0.1. (I've used it successfully with an LAE server running 5.0.0.0 in Linux)

For the MessageSubject parameter you can either type the subject line into the node, or tell it to use the value in a field for the subject. The same is true for the ToAddress, MessageBody, and FilesToAttach parameters.