Open Source Document Management System | OpenKM

Hi,

i'm testing openkm and need to add Costumer Id as Metadata. My costumers are stored in a external table in sql server, so i need metadata field can access this table to show id and description and save id.

Is metadata the way ?

Thank's in advance

This is the way but there's some restriction with community version. In professional version we have implemented the logic for loading data with plugins ( class what connect to external database or does other things and fill options into the select dynamically ) unfortunately it is not present into community edition and will be necessary some time until this technology be introduced there. Here must be done two major changes, first introduce the plugins technology and then changes in the select metadata.

Might be there's another solution modify the source code an use the TabDocumentExtension to create a new document tab ( add an iframe to a jsp and from there set the logic for doing the remote sql query to get the fields into the remote table ).

We can try to guide you on it.