• incrimental automatic script error

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
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.
 #21561  by edwsin
 
hi,
i recently tried to execute a script written in this page:
http://wiki.openkm.com/index.php/Increm ... utonumeric

When i tried to execute, it gets an error, and when i tried to click return it does not bring me back to the previous page (administration-metadata).
How to fix this...?

what i want to achive is:
1. Create a document number, manually or
2. Create a document number automatic based on document type & department
3. Setup version number minor/major changes manually (choose is it a major or minor changes)

*i tried to upload attachment in this forum, but i get this message: Sorry, the board attachment quota has been reached.

Best Regards,
 #21589  by jllort
 
The example on wiki is correct sure. On Which openkm version are you trying, because is only for 6.x or upper. The example will only covers create new number based stored to metadata ( ensure you have registered it ). For what you want you should modify somethings in default script in order to identify departament ( some logic to identify it ).
 #21599  by edwsin
 
jllort wrote:The example on wiki is correct sure. On Which openkm version are you trying, because is only for 6.x or upper. The example will only covers create new number based stored to metadata ( ensure you have registered it ). For what you want you should modify somethings in default script in order to identify departament ( some logic to identify it ).
I was trying to registered and it gets error, i am using v 6.2.2, and now i could not back to the correct page :(
is there any way how to fix this..?
 #21612  by jllort
 
You can delete all metadata from table OKM_NODE_PROPERTY and you can delete any sequence at SELECT * FROM OKM_DB_METADATA_SEQUENCE;

Hope this can help you in some way. If you do not explain problem with more detail it's difficult for us help you. At least we should need to know if you have modified in some way the initial script, which error you get etc...
 #21627  by edwsin
 
jllort wrote:You can delete all metadata from table OKM_NODE_PROPERTY and you can delete any sequence at SELECT * FROM OKM_DB_METADATA_SEQUENCE;

Hope this can help you in some way. If you do not explain problem with more detail it's difficult for us help you. At least we should need to know if you have modified in some way the initial script, which error you get etc...
How can i do that...?
i tried from: database query, choose type: metadata, table: no data
but nothing happen after i click execute SQL script.

I tried to upload screenshoot in this forum, but i get this error: sorry, the board attachment quota has been reached
What i was trying is just to execute the script (provided in the link on my first post)

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.