Export Activity Log in to a file

[mohan]

Is there any way to export Activity Log in to a file using automated scripts or openkm web service.
I know that OKM_ACTIVITY table has all the log details but is there any way to fetch data and i am using default database that comes with openkm(hsqldb).

[jllort]

Should be using scripting,

I suggest create csv file, probably will be easiest.
Here you got example to write file log http://wiki.openkm.com/index.php/CSV_importer

The lib com.googlecode.jcsv is included into openkm by default, you can try to use to create CSV file.

Take in consideration in near future change to mysql or other dbms, is not good idea use HSQL in production environment ( and be sure you got backup )