Page 1 of 1

incrimental automatic script error

PostPosted:Thu Feb 28, 2013 6:25 am
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,

Re: incrimental automatic script error

PostPosted:Fri Mar 01, 2013 6:28 am
by edwsin
anyone could help me with this...?

Re: incrimental automatic script error

PostPosted:Sun Mar 03, 2013 9:01 am
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 ).

Re: incrimental automatic script error

PostPosted:Mon Mar 04, 2013 9:53 am
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..?

Re: incrimental automatic script error

PostPosted:Tue Mar 05, 2013 12:49 pm
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...

Re: incrimental automatic script error

PostPosted:Thu Mar 07, 2013 6:55 am
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)

Re: incrimental automatic script error

PostPosted:Fri Mar 08, 2013 6:43 pm
by jllort
From database query you should select jdbc for this kind of query.