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

I need a solution to manage Physical Book Lending Library. Is it possible to do it in SharePoint 2010? If yes, how to go about it?

Thanks!

share|improve this question
    
Can you provide some details, like what exactly you are trying to manage? Is this a lending library? and collector's library? An office library? Is it merely meant as an inventory? –  Dave Wise Jul 19 '12 at 15:51
add comment

3 Answers 3

up vote 2 down vote accepted

The simple approach would be to create a list in a site, define the fields you wish to keep track of (title, ISBN, abstract, etc). Then make sure that all of the people that you wish to be able to use the list have 'Contribute' permissions.

If the library is self-managed then require checkout to modify an item. Then, the user can merely 'Check out' the book, then 'check in' the book when they return it. If there is a librarian that will be a gatekeeper then there is no need to check-in/out. In either case, versioning would also be handy.

That's the super-simple approach. I can think of a few significantly more usable approaches that would require a fair amount of SharePoint background in order to implement.

share|improve this answer
    
What if you have about 5000 books? That is too many for a single sharepoint list. Would an Access web database be better? –  BGM Oct 21 '13 at 20:21
    
A SharePoint list can hold 50,000,000 items so the quantity is not an issue. The 5,000 limit comes into play when you attempt to pull back more than 5,000 items or run a query that requires iterating over 5,000 items. This can be easily solved by proper field indexes and then querying only for that data. –  Dave Wise Oct 21 '13 at 20:30
    
Really? 50 million?! Then a simple sharepoint list would be all we need for 5000 books? That would be pretty ideal - and searchable. I understand what you mean now by limit. What do you mean by "proper field indexes"? –  BGM Oct 21 '13 at 20:34
    
Oops, I misspoke. SharePoint lists can only hold 30,000,000 items - technet.microsoft.com/en-us/library/cc262787.aspx#ListLibrary. –  Dave Wise Oct 21 '13 at 20:37
    
An index is merely a field in your sharePoint list that is used often when selecting data. Good candidates are typically the most exclusive filter used on a common view. In this case, it could be Year, Artist, ISBN, whatever makes sense in your case. Here is a Microsoft Video that explains the steps - office.microsoft.com/en-us/sharepoint-server-help/…. Also, once you create an index, the indexed field must be listed first in your views that use it. Otherwise, it is not used and you will get the 5,000 item warning on the view. –  Dave Wise Oct 21 '13 at 20:42
show 1 more comment

To develop a book lending library you will need to create a list with a custom Book content type and your site columns like DateOut, DateToReturn, Borrower ...etc.

You will require a user management and registering system. If your users are in Active Directory meaning company employees it is easy but if this is for general pulbic you can use the ASP.NET way with a SQL database.

Once you have users in DB, you will need them to appear in SharePoint as users. Then you can associate them with lending entries.

It will be a simple list but you will need a custom web part to view and manage the entries.

So, you need the site columns, content types, lists, web parts and some pages and master page for UI desgn and a user management mechanism.

share|improve this answer
add comment

You can also take a look at http://SEBLib.com.

share|improve this answer
2  
While this may theoretically answer the question, we prefer inclusion of the essential parts of the answer here, and to provide the link for reference. See answer for general guidelines. Also, answers should be relevant, and preferably not just a link to a commercial site. Thanks. –  SPDoctor Oct 7 '12 at 19:31
    
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. –  John Chapman Oct 17 '12 at 14:18
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.