Cleanup okm preserving configurations

[quelo1972]

I have installed OpenKM 6.2.4-DEV (build: 8003), how can I cleanup my installation from all document and data obtaining a fresh situation but preserving all the configurations?
Thanks in advance.

[pavila]

You can delete all documents from the repository or make some SQL delete to empty tables. The best (and more safe way) is setting hibernate.hbm2ddl to create.

[jllort]

In administration -> configuration you can export configuration parameters ( I think is want you want no ? ).
Then you should make some script to export users and roles, something like it:

Code: Select all

SELECT 'INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) VALUES (''' + USR_ID + ''', ''' + USR_NAME + ''', ''' + USR_PASSWORD + ''', ''' + USR_EMAIL + ''', ''' + USR_ACTIVE + ''');' FROM OKM_USER;
SELECT 'INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES (''' + ROL_ID + ''', ''' + ROL_ACTIVE + ''');' FROM OKM_ROLE;
SELECT 'INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES (''' + UR_USER + ''', ''' + UR_ROLE + ''');' FROM OKM_USER_ROLE;