Options
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 11 subscribers
  • Views 158 views
  • Users 0 members are here
Related

M-Files tool for exporting to SQL

sivan nahon

Hello,

I am using the free M-Files tool for exporting to SQL.
In the SQL table, I display workflow stages that currently have a process in that stage within the system.
Is it possible to export to the SQL table workflow stages that do not currently have any process in them?
The goal is to ensure that if stages are added or removed in the workflow in M-Files, the list of stages in the SQL table will update accordingly.

Parents
  • 0

    I assume you are using the Reporting and Data Export feature to export data to the SQL database? This module exports object data only, so by default you only get those states exported which have at least one object in them.

    One approach you could try is to enable "Export the change history of this property" in the History and Old Values tab for the State property, then you could get also those states that objects have gone through at some point during their lifecycle even if no object is currently in those states. This would still not help with new states you are adding to the workflow until an object has gone through them.

  • 0 in reply to Joonas Linkola

    Maaaaybe, we can have a bit more indirect approach ?

    1. export the workflow states list to a CSV file
    2. use M-Files importer to create objects with workflow and workflow state as metadata property definitions 
    3. export those objects to SQL
    4. Get a view in SQL using ID's of workflow states
    5. refresh the CSV whenever you need the report 

    Is this information worth this much effort ? Totally up to you No mouth

Reply
  • 0 in reply to Joonas Linkola

    Maaaaybe, we can have a bit more indirect approach ?

    1. export the workflow states list to a CSV file
    2. use M-Files importer to create objects with workflow and workflow state as metadata property definitions 
    3. export those objects to SQL
    4. Get a view in SQL using ID's of workflow states
    5. refresh the CSV whenever you need the report 

    Is this information worth this much effort ? Totally up to you No mouth

Children
No Data
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.