• Metadata Get select field type values extenernal

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #44744  by binarycat
 
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
 #44748  by jllort
 
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.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.