Setting up a weekly digest in Sharepoint

Question

I'm currently working on a MOSS 2007 site and i need to set up a "system" which will e-mail all the changes in all the lists and libraries in the site.

I'm new to the Sharepoint world, i wonder if it is possible.

P.S. I have no access to the Central Administration panel. (If it has anything to do with my purpose)

Thanks

Answer 1

I'm afraid you can only setup the alert on a list (or item) basis. In the list you go to Actions => Alerts => When to send alerts => Weekly. I didn't check the Central Admin since you don't have access in your scenario.

Answer 2

You can write custom timer job to do this task.

You could do it in this way:

1. Create custom timer job feature, set timerjob schedule.
2. On FeatureActivated event add that timerjob to SharePoint and have a [Persisted] property like SiteUrl in timerjob, which you could pass in constructor to let timerjob determine with which site to work with.
3. Use SPWeb.SiteUsers to get all users in SharePoint.
4. Loop each user, open new SPSite impersonated as each user.
5. On SPSite.RootWeb (SPWeb) execute GetSiteData (read community comments for some great examples and explanation on how to use it). Use Query that queries items where Modified field has value greater than (follow link for important info to query correctly) what you want.
6. Generate html out of your data and SPUtility.SendMail.

There is a scheduled reminder job feature available. However it works only on 1 List scope. But you can download source code, open RmdJobDefinition class and just see how it works to assist you writing your own class.

Good luck.