DMS Template

I was looking to see if another memeber may have created a template for a Document Management System, and would like to share. Any Ideas on the subject would be useful as well.

DM is quite a broad topic - can you some details of what you want to do ?

We are wanting to move our paper records to an electronic "File Cabinet" if you will. We was looking for a Document management system, Simple if availible, but would like to have:

1. Checkin/Checkout
   
2. Versioning
   
3. Organized by Groups and Subgroups.
   
4. Download counter and log (by user, IP, browser, date and hour)
   
5. Documents can be owned by a specific registered user, or a group.
   
6. Email Notification.
   
7. File Download page.
   I have been charged in building this, but was hoping someone may have already created something similiar as a template to start from, before I began the project. I think I may have some trouble with the Checkin/checkout feature, Download Counter/Log area.

1. Checkin/Checkout
   
2. Versioning
   
3. Organized by Groups and Subgroups.
   
4. Download counter and log (by user, IP, browser, date and hour)
   
5. Documents can be owned by a specific registered user, or a group.
   
6. Email Notification.
   
7. File Download page.
   I have been charged in building this, but was hoping someone may have already created something similiar as a template to start from, before I began the project. I think I may have some trouble with the Checkin/checkout feature, Download Counter/Log area.
   

Can be done ... you might be lucky and find a template but just in case...
check in / checkout would simply need a 0/1 field based on which the file access link is enabled/disabled.. if you want to log who did what you can create a sep table and Master|Detail relationship
Same approach with versioning - store different versions via different table etc..
Depending on which DB you have you could stored data in the DB but PHPR has a file upload control (right click on filename field and choose Edit As - File ...
Groups are built into the admin screen generated by App Wizard - sub groups might be more tricky..but you could create them as Main - Sub and copy the perms by hand..also set dynamic permissions in security Tab, and users can see all data and edit their own... the combination of the two simplifies things...and addresses document ownership - just add a field called owner to each table...
Log table is already in another post - search the forum - download counter can be create by logging downloads then querying the count in PHP snippet...
Email notifications (with/without attachs) are covered in other posts..
File download page is just a list of uploaded files with the filename displayed as File type (right click filename field - Display As File etc..)
Each component is reasonably straightforward once you are up to speed with PHPR ... but a bit of work to fit them together smoothly...