Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Let's say you are building a Project Management solution where each Project equals one site (SPWeb object). Each project has it's properties like: Project Manager, Budget, Customer, Description, Status etc... that need to be stored. Beside these, site contains other project items like documents, tasks etc...

What do you think would be the best practice to store these, some options I am considering, but I am open to suggestions here:

  • Custom list on this site (PROS: Easy to edit, CONS: data is not uniform for single list)

  • Embedded into SPWeb.Properties (PROS: Easy to develop with, CONS: No built-in user UI and other SharePoint UI benefits)

  • Custom list(s) on root of this site collection (PROS: Centralized, CONS: Requires custom per-project security to implement)

  • Custom Database (PROS: Relational, CONS: No SharePoint benefits here...)

share|improve this question
    
Good Pro's and con's! –  Dennis G Mar 12 '12 at 9:09
add comment

3 Answers 3

up vote 3 down vote accepted

I built a similarly structured project management solution in a previous life and used a list to store those details, the list only contained one item, and the columns were the project's metadata.

Worked quite well for rollup across all the projects to get details for all.

share|improve this answer
    
This is exactly what I have done before as well and agree that it worked out really well. –  Jaap Vossers Sep 16 '10 at 10:51
    
Interesting, two questions: 1) What if there are too many columns? 2) How did you aggregate all these on Project Portfolio level? –  Toni Frankola Sep 16 '10 at 13:22
    
I had a site (SPWeb) in which all projects (each of which an SPWeb) resided, and I used a simple DataViewWebPart which used recursion to extract a particular content type (the list details). Doesn't matter how many columns there are, you pick and choose using a View. –  James Love Sep 16 '10 at 16:30
add comment

Microsoft provides some guidance in this area.

SharePoint patterns & practices Application Settings Manager

share|improve this answer
add comment

Have you tried http://spconfigstore.codeplex.com/ . There is a config category column that can relate to the Project This is a 2007 solution

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.