When you are starting your journey with digitization of processes with WEBCON, there is a probability, that you'll already have some data - let it be excel file, or some SQL tables. I'll focus on importing from SQL, because you can import Excel to SQL it's basically working with SQL.

Importing dictionaries is rather simple with import/export buttons on reports, so for now I won't focus on it, and we'll jump into more complex example - starting new instances from SQL database.

I'm gonna use AdventureWorks database, you can grab it if you want to follow along, or just use data which will have one-to-many relationship, as we will be working with two tables.

This article will be split into three parts:

Example application - you are here :)
Import with cyclic actions
Import with REST API
I thought about this as one topic, but while writing article it just grew...

Part 1: Example application

To import the data, we need a place - application, to which we would like to bring new informations. In this part i'll show you specifics of this one configuration, and later we will get to importing the data.

Workflows

To not worry about the forms/workflows i'm going to make them rather simple, so canceled sales will not exist here:

--- title: Customer --- %%{init: {'theme':'dark'}}%% flowchart LR A(Start) -->|Register| B[Active]

--- title: Product --- %%{init: {'theme':'dark'}}%% flowchart LR A(Start) -->|Register| B[Active] A -->|Register blocked| C B -->|Mark blocked| C[Blocked] C -->|Mark active| B

--- title: Sale --- %%{init: {'theme':'dark'}}%% flowchart LR A(Start) -->|Order| B[Ordered] A -->|Register| F[Finished] B -->|Confirm order| C[Preparation] C -->|Sent| D[Delivery] D -->|Delivered| F

Each workflow will have separate form, but I'll keep them in same process. Tree will look like this: