Restore only 1 file

[drh]

Hello forum,
I have a question regarding restoration of a single file. Suppose a user who has read and write permissions to a particular file accidentally deletes the file in OpenKM. Is there anyway to restore from backup, just that 1 file. I am assuming that we are using the default database and that the entire linux system is backed up each night.

If it is possible, what steps would need to be taken. In this example, let's say the file is named myfile.txt and is stored in the okm:root folder.

Thanks,
Dave

[jllort]

Has user deleted the trash too ?

[drh]

Thanks for the reply jllort.
What would happen if the user did delete the trash. Users are always doing something that causes administrators to have nightmares. I just need to know if a single file could be restored. Suppose my boss is using openKM (which I think is a great piece of software) and decides some directory containing numerous files is no longer needed. So she deletes the directory and the entire contents. A month later she comes to me and says, I need you to restore such and such directory that I deleted last month. So I have a good backup of the entire server because my job depends on it. Now how would I go about restoring that deleted directory? I can't overwrite the entire openKM database because thousands of documents have been added / edited / whatever in the last 30 days.

Is it possible to restore those deleted files? If so, can someone give me a brief outline on how to go about this? It doesn't have to be detailed, just an overview. Depending on whether this is possible is the difference between using openKM (my preference) and continue to look for an acceptable solution.

Sorry I have been away for a while working on other pressing projects.

Thank you.
Dave

[jllort]

Actually we've not utility to browser backup repository to extract only some files ( it's something to be cooked ). The only solution you've got not is tedious ... you might mount other openkm in other computer and extract file from there. Now it's the only solution ... the most elegant one it's still not yet done implemented - we know ! -

[drh]

jllort,
thanks for being so honest.
I think this still may be workable. If I understand you correctly, you don't currently have a ready to go solution. Is this something that is currently being developed or is this a future enhancement?

I have a couple of ideas that may help out in the interim. Not being familiar with OpenKM, I would need help implementing.

First, Is there any way that permissions could be set up so that users are not allowed to "purge" the trash folder? Only allow the administrator to purge files from trash? If this is already possible, where would I find instructions on how to do this? If not, how difficult would this be? How could I help?

Second, OpenKm already has a function to export to a .zip file. Could this function be used daily on the entire database? Possibly using crontab to execute. The .zip file could be archived and if needed, unzipped and the deleted file or files could be easily imported back into OpenKM. I understand that the .zip file could/would be quite large. Maybe the .zip could be broken up into smaller pieces. Again, not being familiar with OpenKM's inner workings, I would not be able to implement without help.

I would certainly lend any assistance to help in working this out. I really want to use OpenKM, but before I propose this to management, I want to make sure I understand OpenKM's strengths and current weaknesses (if any).

Thanks,
Dave

[jllort]

OpenKM 5.0. has now yet developed:
1- all options menu configurable ( show / hide )
2- all button menu configurable ( show hide )
3- show / hide major stacks
4- show / hide dashboard buttons
5- show / hide tabs ( desktop, search etc... )
You can make your own extensions
http://wiki.openkm.com/index.php/Create ... extensions
http://wiki.openkm.com/index.php/Widget_library

It covers the case "hide option menu", actually it'll be to entire installation, but we've got in mind to make configurable by roles too.

About recovering file procedure from backup, the idea is a repository browser utility ... it's not trivial implementation.

The most easiest way to doing copy new files is connecting openkm as a network drive and make a rsync to other disc ( that's the most easiest ) ... for my point of view ... it's duplicate repository size ... but meanwhile we could not finishing the utility probably it's best option to you

Other option could be ... make some minimal utility by webservies and by query only copy the las month new / modified files

[drh]

Hey jllort,
thanks for the update and the brief roadmap of 5.0. I have various applications using mysql and I use a script to backup these databases daily. If I migrated from HSQLDB to MySQL, I could use the same backup script. Then in the case I needed to restore a file, I could open the archived db using openKM, export the files and/or directories I need, then import them into the live openKM database. That would work until version 5 comes out with a better solution. It sure would be nice to be able to show/hide menus, buttons, etc. Only give the users what they need to perform their job. Sounds great! Ready to make my case to management.
Thanks,
Dave