Export workflow form data

OpenKM a de nombreuses fonctionnalités interessantes, mais demande un minimum de configuration pour être pleinement exploité.

Moderator: dedisoft

Forum rules
Avant de poser une question, merci de regarder la documentation du wiki ou d'utiliser la fonction recherche du forum. Et rappelez vous que nous n'avons ni boule de cristal ni possibilité de lire dans les pensées, aussi pensez à spécifier quelle version d'OpenKM vous utilisez ainsi que la version du navigateur web et du système d'exploitation. Pour de plus amples informations lisez Comment reporter un bug efficacement (anglais).
Post Reply
kouadio
Senior Boarder
Senior Boarder
Posts: 45
Joined: Wed Jan 09, 2019 9:26 am

Export workflow form data

Post by kouadio » Mon Sep 23, 2019 8:26 am

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.

jllort
Moderator
Moderator
Posts: 10911
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Export workflow form data

Post by jllort » Wed Sep 25, 2019 8:29 pm

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.

Post Reply