Home > Forum > Database > insert into database

insert into database
0

MVP

Hi Arthuzad,
the question is very vague, but i'll give few shots to answer:

1. Inserting / Updating on database provided by WEBCON breaks EULA point 3.6 / 1.23 (https://webcon.com/wp-content/uploads/2025/05/WEBCON_EULA_EN_2025.pdf).
2. If you need to import some data into a dictionary, then the easiest option would be Import/Export by Excel
* https://docs.webcon.com/docs/2025R2/Studio/Studio_ToolBar_Import/
3. If there is a lot of records required >500, then it might be better to do it via Cyclic Action, or REST Api, I've written a series which describes both ways: https://blog.lumenn.pl/importing-data-to-webcon-1/

In reply to: Maksymilian Stachowiak

Hi Arthuzad,
the question is very vague, but i'll give few shots to answer:

1. Inserting / Updating on database provided by WEBCON breaks EULA point 3.6 / 1.23 (
https://webcon.com/wp-content/uploads/2025/05/WEBCON_EULA_EN_2025.pdf).
2. If you need to import some data into a dictionary, then the easiest option would be Import/Export by Excel
* https://docs.webcon.com/docs/2025R2/Studio/Studio_ToolBar_Import/
3. If there is a lot of records required >500, then it might be better to do it via Cyclic Action, or REST Api, I've written a series which describes both ways: https://blog.lumenn.pl/importing-data-to-webcon-1/

there needs only one item to be inserted, and the data should come from the mentioned item list. as i said i have created a query with "insert into" but i don't know how guid wll be generated and how to access wanted dictionary

MVP
In reply to: Arthuzad

there needs only one item to be inserted, and the data should come from the mentioned item list. as i said i have created a query with "insert into" but i don't know how guid wll be generated and how to access wanted dictionary

I'm assuming there are 2 processes then:
1. Dictionary
2. Process which on some form has an item list.

If you want to add something to the dictionary - by "insert" i'm assuming it's a new document, then you could try to use start a subworkflow action:
* https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/StartWorkFlow/
for updating an item in a dictionary you could try to use update related workflow instance:
* https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/UpdateParentWorkflow/

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings