18.07.2022
09:46
Hi Guys,
just wonder if there is any option to import data into Webcon not into the item list, but as a separate workflow elements. I want to implement Asset Management workflow, but need to enter into the system few thousand items (PC's, servers etc.), which are currently stored in another SQL database.
18.07.2022
10:26
Hi Patryk!
This should be an easy task ;-)
Have a look at the 'Start a subworkflow (SQL)' action.
You have to create a DB connection first to your assets DB, then you should be able to implement the specific SQL statement for this action.
Best regards, Nik
18.07.2022
11:58
Hi Patryk!
This should be an easy task ;-)
Have a look at the 'Start a subworkflow (SQL)' action.
You have to create a DB connection first to your assets DB, then you should be able to implement the specific SQL statement for this action.
Best regards, Nik
Hi Nik,
so simple... I just have been always using this function to kick off subworkflows connected to the current instance, forgot that you can start urelated workflow as well.
Regards,
Patryk
18.07.2022
12:10
Hi Nik,
so simple... I just have been always using this function to kick off subworkflows connected to the current instance, forgot that you can start urelated workflow as well.
Regards,
Patryk
Hi Patryk!
Yes, they should be unrelated ;-)
Best regards, Nik
18.07.2022
14:35
As you mention that you have thousands of items, start them in batches , otherwise they will all be started within one transaction....
You can do this by using the TOP n in your SQL Statement. Maybe you can start with top TOP 100 or event TOP 50. Depends a bit how long it takes to start a workflow, which depends on the actions you execute on your path. You might have to try and error a bit.
When using batches you have to keep track, which records you've already imported.
You can to this either by adding a new boolean field, which you then set in the Filter Query. See attached image.
Or you could store the external id in the workflow you started and then use an Not in Statement to filter the already imported records.
However this is not the best idea performance wise.
18.07.2022
15:22
As you mention that you have thousands of items, start them in batches , otherwise they will all be started within one transaction....
You can do this by using the TOP n in your SQL Statement. Maybe you can start with top TOP 100 or event TOP 50. Depends a bit how long it takes to start a workflow, which depends on the actions you execute on your path. You might have to try and error a bit.
When using batches you have to keep track, which records you've already imported.
You can to this either by adding a new boolean field, which you then set in the Filter Query. See attached image.
Or you could store the external id in the workflow you started and then use an Not in Statement to filter the already imported records.
However this is not the best idea performance wise.
@Jenni
thanks for this tip, I will do it in the batches. It is going to be roughly 1,5-2k records I believe, so then even doing 50 at once will not take that long, taking into account that we are talking about switching from one system to the other for probably next 20 years or so.
