+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Feature Request (https://community.letodms.com/forumdisplay.php?fid=7)
+--- Thread: Folder Quote (/showthread.php?tid=603)
Folder Quote - axel76 - 11-30-2012
Hello,
is it possible by admin assign dir quota ?
Any user can upload without limits, and use all hard disk spacce..
Alex
RE: Folder Quote - steinm - 11-30-2012
(11-30-2012, 04:32 PM)axel76 Wrote: Hello,
is it possible by admin assign dir quota ?
Any user can upload without limits, and use all hard disk spacce..
Good idea, but probably not so simple to implement. There must be a function with sums all document file sizes recursivly for a folder. That can be very time consuming. What about previous versions of a document?
Do they count?
Uwe
RE: Folder Quote - axel76 - 11-30-2012
Hello,
It will be simple if you count and store ( into db table ) the size of any document after upload.
If user remove doc delete the size from db.
In the uplad page count into db ( not into folder ) total size assigned for folder, and if is out of quota disable upload button, and show alert..
What do you think about ?
Alex
RE: Folder Quote - steinm - 12-01-2012
(11-30-2012, 11:47 PM)axel76 Wrote: Hello,
It will be simple if you count and store ( into db table ) the size of any document after upload.
If user remove doc delete the size from db.
In the uplad page count into db ( not into folder ) total size assigned for folder, and if is out of quota disable upload button, and show alert..
So where exactly should the size of a document be stored. In the database record of document?
Uwe
RE: Folder Quote - axel76 - 12-01-2012
You should create a new column ( size ) in the tblDocuments,
or create a new table ( size_documents ) correlated to id documents.
Add new column ( quota ) in tblFolders.
When user go to upload page, SUM the total size docs and match with folder quota.
This will work with all platforms, will be very fast, and low CPU usage.
Regards,
Alex
RE: Folder Quote - steinm - 12-02-2012
(12-01-2012, 05:46 PM)axel76 Wrote: You should create a new column ( size ) in the tblDocuments,
or create a new table ( size_documents ) correlated to id documents.
Add new column ( quota ) in tblFolders.
When user go to upload page, SUM the total size docs and match with folder quota.
This will work with all platforms, will be very fast, and low CPU usage.
IMHO, this is too simple. If there is folder with a quota and that quota is exceeded I could simply create a new subfolder and upload more documents. If I want to prevent that, I have to check for any quota of any parent folder.
Uwe
RE: Folder Quote - axel76 - 12-02-2012
Yes, this is correct
What do you think to move the column quota in the user table ?
In this case users can make subfolders, but total size will be match with the user and not with any specific folder..
When admin create new user, can setup " user max quota " ..
RE: Folder Quote - steinm - 12-02-2012
(12-02-2012, 06:06 PM)axel76 Wrote: Yes, this is correct
What do you think to move the column quota in the user table ?
In this case users can make subfolders, but total size will be match with the user and not with any specific folder..
When admin create new user, can setup " user max quota " ..
That sounds like a better option. It still requires to grap all documents of a user and to sum up the file size, but that can be done much more sufficient. Should previous versions be taken into account
Uwe
RE: Folder Quote - steinm - 12-19-2012
(12-02-2012, 07:14 PM)steinm Wrote:(12-02-2012, 06:06 PM)axel76 Wrote: Yes, this is correct
What do you think to move the column quota in the user table ?
In this case users can make subfolders, but total size will be match with the user and not with any specific folder..
When admin create new user, can setup " user max quota " ..
That sounds like a better option. It still requires to grap all documents of a user and to sum up the file size, but that can be done much more sufficient. Should previous versions be taken into account
The next version of LetoDMS (probably 4.0.0) will have quota support on user basis. It can globally defined in the settings and overridden for each single user.
Uwe