Folder Quote

[axel76]

Hello,
is it possible by admin assign dir quota ?
Any user can upload without limits, and use all hard disk spacce..

Alex

[steinm]

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

[axel76]

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

[steinm]

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

[axel76]

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

[steinm]

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

[axel76]

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 " ..

[steinm]

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

[steinm]

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