Page 1 of 1

Export workflow form data

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

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.