Search code examples
sharepointsharepoint-2010sharepoint-2007sharepoint-api

Querying sharepoint data

I have a requirement to retrieve data from share point (I guess it is 2010, but will check with admin if relevant) and generate an excel report/chart. Say we have a bug tracking system in share point. Currently, I could create a view and see some statistics, but I need to plot a graph to see historically (every week) how the number of bugs changed. For example,

  • get the number of bugs filed in a specific week
  • do some grouping based on type/severity
  • based on classification get number of bugs solved that week etc.

If I can get the numbers based on date range, I may use excel to plot the graph.

After some reading, SharePoint object model come close to what I used to work with (Oracle DB). I understand it may be entirely different from tradition db and querying.

Please help me with

  1. What is the best method to approach this?
  2. Is there a good book/resource.

Thanks a lot,
bsr

Solution

  • The easiest apprach would be to LINK to the sharepoint lists using Access 2007 or 2010 and then export the data to Excel for further processling. Of course, you could also write a program that uses CAML query to access the data. Your requirement sound straightforward, unless you need to automate the reporting process, the simplest approach would be to access the lists via an access database.

    You could also create a web service via REST that pulls the data directly into Excel.