Page 1 of 1

Export workflow form data

PostPosted:Mon Sep 23, 2019 8:26 am
by kouadio
Hi,

I have a form like this:
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE workflow-forms PUBLIC "-//OpenKM//DTD Workflow Forms 2.4//EN"
                                "http://www.openkm.com/dtd/workflow-forms-2.4.dtd">
<workflow-forms>
  <workflow-form task="avis favorable">
    <input label="Date" name="date" data="date" readonly="true" />
    <input label="Direction" name="direction" data="direction" readonly="true" />
    <input label="Quantite" name="quantite" data="quantite" readonly="true" />
    <textarea label="Observation" name="observation" data="observation" readonly="true" />
    <input label="Avis responsable superieur" name="responsable" data="responsable" readonly="true" />
    <input label="Avis controle de gestion" name="cgai" data="cgai" readonly="true" />
    <input label="Avis DAF" name="daf" data="daf" readonly="true" />
    <button name="supprimer" label="supprimer" transition="supprimer"/>
  </workflow-form>
</workflow-forms>
And I would like to find in the database information filled in the different fields of my form.
My goal is to export this data to excel or do a word mail merge with an ODBC connector.
Thank you for everything.

Re: Export workflow form data

PostPosted:Wed Sep 25, 2019 8:29 pm
by jllort
If for you is enough the latest values, you should get the fields and save as metadata ( in a transaction ). If you need full trace of all the stages, then should build your own table and save there.

Re: Export workflow form data

PostPosted:Fri Dec 13, 2019 2:12 pm
by kouadio
I created metadata fields identical to those of the workflow form. How should I proceed to have the form data automatically embedded in the specified metadata group?

Re: Export workflow form data

PostPosted:Sun Dec 15, 2019 7:17 pm
by jllort
In the trasaction, you have the values into the workflow variables. Then you should get the variables and using OpenKM API set the metadata fields:

URL what should read:
https://docs.openkm.com/kcenter/view/wf ... -node.html ( sample to get a variable -> Object should cast to Input, Select etc... )
https://docs.openkm.com/kcenter/view/ok ... l#addGroup ( first add group )
https://docs.openkm.com/kcenter/view/ok ... tiesSimple ( then save metadata )