LAE

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

Originally posted by: snbkumar

Hi Team,

I need to get a set of data and split that into multiple xls files based on a code. Eg. If Code=1, then the records go to SubFile1 and so on. The code value is dynamic, it can be 1, B, Z, AD, etc.

Once all the files are created, I need to send the files to certain email ids based on the codes. Eg: Code=1, then send SubFile1 to EmailID1 and so on.

I also need to wait until all the preliminary processes complete, the output file (MasterFile) generated, *reviewed manually* and then do this emailing activity.

Please let me know how if Lavastorm supports this.
Any quick assistance is greatly appreciated.

Thanks,
Bharath

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

Originally posted by: lnason

What version of LAE are you using?

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

Originally posted by: snbkumar

Hi lnason,

I am using BRE v 4.5.1.

Thanks,
Bharath

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

Originally posted by: snbkumar

Any updates please?

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

Originally posted by: lnason

Bharath,

Unfortunately, you are probably going to be restricted in what you can do because of the LAE version you are using. If at all possible, you'll want to upgrade.

Next question - Are you running the desktop version of LAE or are you working with the server version. I ask because I'm not aware of any nodes available in 4.X versions of the software that would allow you to send emails with attachments from the desktop version. If you are working with the server version, there may be some options available.

I'm attaching two sample graphs that handle some of the requirements you have listed above, but there is nothing in here that will send an email.

In order to use the graphs you will need to:

- Update the DataDirectory parameter to point to a directory on your desktop/server
- Save the Save_Excel_Files graph as a brx into your DataDirectory (File->Save as BRX...)

The "Split_Data_Send_Email" graph uses the Execute BRX node to run the "Save_Excel_Files" graph once for each "type" value (which would be the Id value in your case) in the sample data. Once the Execute BRX node is complete, a DirectoryList node is used to scan the DataDirectory for all excel files that were created. A lookup is then executed for each file to determine which email address to use. The last "Email Code" composite node is just a placeholder for now.

Luke

Split_Data_Send_Email.brg
Save_Excel_Files.brg

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

Originally posted by: snbkumar

Hi Luke,

You are awesome. That worked and has given a new dimension to my thought process in Lavastorm development.
Keep rocking!

Thanks,
Bharath