Open Source Document Management System | OpenKM

Hi,

I am trying to make a script to auto unlock documents if they have been locked for more then a day. Currently i am facing an issue where users use Word to check out the documents, save them so they can email the document to someone (subscription is not working...) then try to check in the document. In this process word cannot check in the document so they try to use IE to check in but it says for the same user that the node is locked. To fix this i have to login to unlock through repository in admin view...

So i am now thinking to use a script to fix that until i get the subscription working... Any ideas on the code to accomplish this? well i am thinking of this:
Of course i have no idea on the actual variable name so i need help with that...

This kind of job can be implemented using the Crontab feature. You can make an XPath query to get the locked nodes (see samples in administration) and after that, unlock them.

pavila wrote:This kind of job can be implemented using the Crontab feature. You can make an XPath query to get the locked nodes (see samples in administration) and after that, unlock them.

thx pavila, i got the xpath query: I checked out the samples but i could not understand them... I used the query translator to kind of get this in sql since im more familiar with that...
The translator cant seem to recognize update though...: But i think this does not address the check in feature...?

In order to unlock you need to use the OpenKM API or de Jackrabbit low-level API. The XPath is only to retrieve the list of locked nodes.

Something like

OKMDocument.getInstance().lock(null, docPath);