Page 1 of 1

Export workflow form data

Posted: Mon Sep 23, 2019 8:26 am
by kouadio

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"
  <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"/>
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

Posted: 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

Posted: 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

Posted: 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: ... -node.html ( sample to get a variable -> Object should cast to Input, Select etc... ) ... l#addGroup ( first add group ) ... tiesSimple ( then save metadata )