creating weekly status report of user tasks
- hi all,
i have a task that "the tasks done by the users for a week must be collected and stored into excel or word document."
in this how to write an application through C# coding for this...
or through any other way...
pls provide me some ideas r help in this fact..
Thanks in Advance..
Regards,
siva..
Answers
Hi siva,
I think the best approach is to create a custom timer job (one having the SPWeeklySchedule schedule, see: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spweeklyschedule.aspx), and create the document based on the Microsoft Office Open Xml standards on server side based on the task list data.
About Custom timer jobs
Creating Custom SharePoint Timer Jobs
http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx
MOSS Timer Jobs - Create Your Own!
http://www.andrewconnell.com/blog/archive/2007/01/10/5704.aspx
Using a Config File for Windows SharePoint Services Timer Jobs
http://www.thesug.org/Blogs/mossmania/archive/2009/04/17/Using_a_Config_File_for_Windows_SharePoint_Services_Timer_Jobs.aspx.aspx
Creating Custom Timer Jobs in Windows SharePoint Services 3.0
http://msdn.microsoft.com/en-us/library/cc406686.aspx
Debugging SharePoint Timer Jobs
http://sharethelearning.blogspot.com/2007/12/debugging-sharepoint-timer-jobs.htmlOffice Open XML
http://en.wikipedia.org/wiki/Office_Open_XML
Hope that helps to start.
Peter- Marked As Answer byAaron Han - MSFTModeratorFriday, November 13, 2009 10:37 AM
All Replies
Hi siva,
I think the best approach is to create a custom timer job (one having the SPWeeklySchedule schedule, see: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spweeklyschedule.aspx), and create the document based on the Microsoft Office Open Xml standards on server side based on the task list data.
About Custom timer jobs
Creating Custom SharePoint Timer Jobs
http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx
MOSS Timer Jobs - Create Your Own!
http://www.andrewconnell.com/blog/archive/2007/01/10/5704.aspx
Using a Config File for Windows SharePoint Services Timer Jobs
http://www.thesug.org/Blogs/mossmania/archive/2009/04/17/Using_a_Config_File_for_Windows_SharePoint_Services_Timer_Jobs.aspx.aspx
Creating Custom Timer Jobs in Windows SharePoint Services 3.0
http://msdn.microsoft.com/en-us/library/cc406686.aspx
Debugging SharePoint Timer Jobs
http://sharethelearning.blogspot.com/2007/12/debugging-sharepoint-timer-jobs.htmlOffice Open XML
http://en.wikipedia.org/wiki/Office_Open_XML
Hope that helps to start.
Peter- Marked As Answer byAaron Han - MSFTModeratorFriday, November 13, 2009 10:37 AM
- A more simplified solution, minus the code, would be to just to create a filtered view of these task items in the task list, and then once a week, manually click <actions> and <export to spreadsheet>
Another more automated option would be to create an alert as a "weekly summary" for this filtered view. See my blog post on creating alerts from filtered views:
http://www.sharepoint911.com/blogs/laura/Lists/Posts/ViewPost.aspx?ID=7
Laura Rogers, MCSE, MCTS
SharePoint911: SharePoint Consulting
Blog: http://www.sharepoint911.com/blogs/laura
Twitter: WonderLaura - hi LauraRogers,
Thanks for your kind information..
My task is to make it automatic... every monday the task list should be exported and stored in another site..
For this i think timer jobs can be used... how to use timer jobs how to schedule them..is there any tutorial for it.
In case of alerts only emails are sent how to collect the information of tasks...
Thanks in advance..
Regards,
Siva.
