Blue Prism Object Studio

Item studio is mainly utilized to develop the items. Inside the object, all of us have different types associated with actions as follows:

  • The application form Modular to Spy the sun and rain.
  • Initialize page and cleanup page.

Creating the Object from Object Studio

Right after launching the Blue Prism, open Studio tab, right click on Objects and choose Create Object.

The screenshots obviously clarify the procedure of creating objects:

Blue Prism Object Studio Blue Prism Object Studio

Give a name for new business object.

Blue Prism Object Studio

This will create an object in objects list.


Different Stages in Object Studio

The several stages in the Thing Studio are listed under:

  • Link.
  • Block.
  • Read.
  • Write.
  • Navigate.
  • Code.
  • Wait.
  • Process.
  • Page.
  • Action.
  • Decision.
  • Choice.
  • Calculation.
  • Multi Calculation.
  • Data Item.
  • Collection.
  • Loop.
  • Note.
  • Anchor.
  • End.
  • Exception.
Blue Prism Object Studio

As soon as you create an object, typically the initialize, cleanup and activity pages will be developed and the initialize webpage will be launched with all the above mentioned stages.

Typically the below Business Object (VBO) will give you more detailed explanation showing how the stages can be taken and how the VBO works.


Understanding Collections to Excel

Multiple values saved in the type of rows and columns are collections.

All of us call add rows to collections using the below two ways:

  • Making use of Internal VBO as "collections".
  • Applying "Utility-Collection Manipulation" VBO.

Create a Business Object

Enter the name of the enterprise object you like to be able to create as proven under:

Blue Prism Object Studio

Today, enter the description regarding the business object since displayed below:

Blue Prism Object Studio

Now, click on Finish.

Blue Prism Object Studio

Double click on the newly created VBO to open it.

Blue Prism Object Studio

Inside the action tab, the start and ending stages will be created by standard with a hyperlink to them, select the link and delete, so that the actual stages can be implemented within it.

Create a collection and then add rows to the collection using the internal VBO.

Blue Prism Object Studio

Give the collection name, description and offer details in fields: brand, type, description and career fields. Use Add field to incorporate any extra field.

Blue Prism Object Studio
Blue Prism Object Studio
Use Loop Stage

Pick Loop from the levels, loop will have start and ending parts. That is employed to execute the stages in the trap with the mentioned iterations.

Blue Prism Object Studio

Give the name for the trap and select the right collection from the decline down list.

Blue Prism Object Studio
Create four date items

Making use of the data item stage, create four data items as given below:

  • C no
  • C name
  • Limit
  • Jdate
Blue Prism Object Studio

Use Multi Calculation to add data to the collection in empty row.

Blue Prism Object Studio
Blue Prism Object Studio

Give a name to that multiple calculation, drag the manifestation from collection list in order to expression, and drag the particular data items from your information item list to maintain Within values.

  • Link the stages using Link and save the Business object.
  • Execute the VBO by clicking on play button.
Blue Prism Object Studio

The end result will be with the particular proper outputs which had been provided in the selection as demonstrated below:

Blue Prism Object Studio

We will understand the collections with Excel as shown below:

1st, we need to produce an instance and get the output as 'handle' then open the function book name and complete the handle as insight parameters.

It will eventually write the work publication name, then perform one more action get worksheet since collections.


Step 1: Create instance

Action:

  • Name: Create instance
  • Description: Create instance

Business Object:

Ms Excel VBO

  • Action: Create Instance
  • Output: Handle

Step 2: Open
  • Business Object: Ms Excel VBO.
  • Action: Open workbook.

Input:

Value = Handle. File Name.
Output: store in workbook.

Step 2: Open
  • Business Object: Ms Excel VBO.
  • Action: Open workbook.

Input:

Value = Handle. File Name.
Output: store in workbook.

Step 4: Read data into collections
  • Business Object: Ms Excel VBO.
  • Action: Get worksheet as collection (Fast)
Output: store in Customer Details.

Step 5: Loop

Go to the Loop properties.

  • Name: Read data from collection.
  • Description: Read data from collection.
  • Collection: Customer Details.

Step 6: Multi Calculation
  • Name: Customer data.
Customer details. Blue Prism Object Studio

Understanding Choice with Collection and Excel

We should create student Data with the given data:

  • Grade A >=90
  • Grade B >=75
  • Grade C >=60
  • Grade D >=50

Step 1: Create instance

Action:

  • Name: Create instance.
  • Description: Create instance.

Business Object:

Ms Excel VBO

  • Action: Create Instance.
Output: Handle

Step 2: Open
  • Business Object: Ms Excel VBO.
  • Action: Open workbook.
  • Input:

    Value = Handle

    File Name.

    Output: store in workbook.

    Step 3: Show
    • Business Object: Ms Excel VBO.
    • Action: Show.

    Input:

    Value = Handle.


    Step 4: Read data into collections
    • Business Object: Ms Excel VBO.
    • Action: Get worksheet as collection (Fast)
    Output: store in Students Details.

    Step 5: Loop

    Go to the Loop properties.

    • Name: Read data from collection.
    • Description: Read data from collection.
    • Collection: Student details.

    • Step 6: Choice
      Choice Name Choice Criterion
      Grade A Student Details Marks>=90 and <=100
      Grade B Student Details Marks>=75
      Grade C Student Details Marks>=60

      Blue Prism Object Studio

      Create 1 data item as Grade.

      Now, create calculation as follows:

      • Grade A
      • Grade B
      • Grade C

      Before loop, we need to configure all the values.

      Take the Action stage:

      Name: Default Cell.

      Business Object: Ms Excel VB.

      Action: Active workbook.

      Then After,

      Perform another action: Current Cell.

      Business Object: Ms Excel VBO.

      Action: get Active Cell.

      Output store in Current cell.

      Then After,

      Write the data into excel.

      Business Object: Ms Excel VBO.

      Action: Set Cell Value.

      Perform another action: Go to Next Cell.

      Business Object: Ms Excel VBO.

      Action: Go to Next Empty cell down.

      Input: store in current cell.

      Blue Prism Object Studio
      Blue Prism Object Studio