Starting Multiple Workflow Instances from an Excel File

0

Hi Piotr,
Yes, it is possible, one way would be to allow import of data to item list*, and when data is already imported, then you could go with start a subworkflow action**

* https://docs.webcon.com/docs/2025R2/Studio/Process/Attribute/Basic/Itemlist/ILConf/ILGenral
** https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/StartManyWorkFlows/

Yes, it worked as expected, however, I’m having an issue with the automatic filling of fields.
Is it even possible in my case to populate one list of items with data from another?Regular fields are being filled correctly, but unfortunately the second item list is not.

I'd need some more context to answer if it's possible in your use case :)
What are current list items?
What columns do they store?
Should it happen on the form?
On path transition?
What data should be moved from one to another? Maybe some examples?

Hi Piotr,

let's first solve your IMPORT-problem. I attached a screenshot with an example of loading an excel-file into an itemlist.
I hope i did understand your problem right.

Bye,
Bjoern

FOR YOUR INFO: This example is a different one to PIC 1 !!!!
----------------------------------------------------
Hi Piotr,

after successfully importing the EXCEL-File, I myself always use a path to an end-step.

There I add an Action "on Entry":
-Tab BASIC: Selecting the new workflow process with its path (like in the PIC 2)
-Tab DATA: Here i use a SELECT to put the item list value from one row into a single target sub-workflow
-> For all itemlist rows: SELECT {itemlist column 1 of actual row} AS {target form field of new instance in the sub-workflow}..... (see PIC 2)

I hope, this helps,
bye,
Bjoern

I have one application in which I want to enable launching multiple workflows using an XML file.
I have one list of items called 'Importer'
And another list of items, let's call it 'Target'.

In 'Importer' I have a field 'Gross' as a floating-point number, and the same in the 'Target' list.

In the starting step, I created a new path that registers bulk orders (start subprocesses (SQL)).

Configuration in the attachment.

There will be more fields, but for now I'm trying to do only this one field.

Hi Bjoern,

Trying to replicate your example.
I created a new process to import the file.
On the final step I created a new action, details attached.
The list of items as well as the attributes themselves are not blocked but the values do not transfer to the list of items in the sub-workflow

Looks good so far.

Maybe its your SQL: are that form fields out of the Objects column?
I wondering because of the DB at the end.

I made a more detailed screenshot. Please verify and try again.

Bye,
Bjoern

I understand the ideas, but I can't find the error.
'DB' means database field name

Subworkflows start, but fields do not complete, they are empty

Thanks for this: 'DB' means database field name -> different name cause of different language CHECK
-------
Hi Piotr,

I’m sorry – everything looks good.

One last idea/question: your TARGET isn’t an itemlist form field, is it?

In my example, I’m using the itemlist to start the sub-workflow, copying the itemlist values into “normal” form fields for each row (each row -> new sub-workflow instance).

Bye,
Bjoern

I want my item list (import from file) to complete the ‘normal’ fields as well as the item list.

But whether I try to pass values only to the ‘normal’ fields, or to the item list, or to both at the same time, the values don't transfer anyway

And yes, in my case also each row is a new sub-workflow