Import data form file in .xlsx - format, which is used in excel, to database (to table or list)
Where you can use action:
Post Workflow, Button
Parameters:
Name of table or list (type:text) - name of table or list, to which you want import data
Block reimport (type: Logical)(optional parametr) - when a value of TRUE is set, the reimport option will not be available in the window and the additive option will be permanently selected. If you set the value to FALSE or leave the field empty, both additive and reimport options are available in the window.
When you do this ActionStep, you will see this window:
Option with additive and reimport
Option with no reimport
You need to choose file, you want to import to Database (headers of file and table/list have to be same, but headers can be in a different order and in file can be more of them)
Addative option - new data is added as successive entries in a table or list without editing the previous data.
Reimport option - old data is replaced by new data in a table or list.
0 Comments