The VIP 101 series is designed to introduce new users to VIP, Curiosity's fully connected process automation engine. In this second video, you will learn how to read data from a Microsoft Excel Worksheet, inputting the data from each row into a separate XML file.
Following on from Lesson 1, this video will introduce you to the following general concepts:
The process of using one VIP flow to invoke another;
Working with encrypted flows/
You will learn how information read by one flow can be fed dynamically into another, while also learning about more sophisticated forms of iteration.
If you want to follow the steps shown in the video in your own environment, please download the Excel Worksheet and VIP flow used in the video here. You will require a licensed version of VIP.
00:09 Introduction to the example task
01:12 Review of the example Excel Worksheet
01:58 Start building your VIP flow – read data from the Excel Sheet
a. 02:10 Use and parameterise the "ReadExcel<DataTable>" action and System.DataTable .Net object. Please refer to the Microsoft documentation to learn more about this common .Net object
4. 03:31 Loop to read data from the spreadsheet and create Dynamic Arguments
a. 03:49 Nest the "ForEach" action within your VIP flow and use the DataTable.Select .Net object
b. 04:30 Use Dynamic Arguments to create a dynamic list of parameters
c. 05:31 Set an Enumerable Range to read iteratively over a counted number of rows and columns
5. 07:21 Invoke an encrypted VIP flow from another flow
a. 08:26 Review the arguments that will be passed into the flow
b. 09:00 Review the XML template files
6. 09:47 Set the flow to iterate and dynamically set parameters
a. 12:34 Feed data read from the XML into the template files
b. 13:57 Specify outputs to create one file per row
7. 15:57 Run the flow and review the resultant XML files