Customised Wrkflow for sending out an email

Question

Hi,

I m a newbie.I need ideas on how to proceed further.The problem is stated below:

Set of reports/rdl is present in reports library.The Workflow shud be started exactly at some point of time.It has to send an email to a group of people.The main catch is..the content of the email.As the workflow is automatic ,wrkflow has to check whether the data is uploaded in SQL database and if data is uploaded to SQL Database which of the RDL's present in Reports Library can be viewed should be the content of email.So mainly workflow should be able to check database and say which of the RDL's can be viewedPls let me know how to design this workflow.

Eg: An RDL contains Today's transaction - Wrkflow shud check the database if any data has been uploaded with today's date.if present ,body of the email shud contain QQQQ.rdl can be viewed.


Regards,
Raghav

Answer 1

Running workflow at some point of time is not a good idea. This problem seems like you need to use TimerJob for this problem, not Workflow.

Answer 2

Hi Raghav

I don’t think checking the database is necessary. Actually, all the files uploaded to SharePoint document library will be stored in SQL database.

The RDL can be included in email as an attachment or you can place a link to the document in email body so that the receiver will be able to view the report.

For how to create a custom activity to send an email message with an attachment, please refer to:
http://msdn.microsoft.com/en-us/library/cc627284.aspx

If you want to include a link to the report in email body, references below will help you to get start.
http://office.microsoft.com/en-us/sharepointdesigner/HA102390421033.aspx
http://www.vizitsp.com/blog/June-2009/SharePoint-Viewer-Inside-a-Document-Workflow

Best Regards

Answer 3

Hi,

Jevgeni,Thnx for ur reply.I will check that option.

Answer 4

Hi Lily Wu,


Thanks for ur reply.The reason for checking SQL Database is to check whether the data is  uploaded.Yes all RDL's are being uploaded to Sharepoint Document Library.As its a Dly reports one has to upload the data everyday.If data not uploaded,so there is no point in viewing RDL's as it be of any use.So i thought of creating a workflow to check the SQL Database if data is uploaded meaning if there is a change in number of records,then automatically send out an email to a concerned person saying can be viewed QQQQ.rdl as  data is ready for the same.

Any info on how to proceed would be highly appreciated.




Raghav