topic RE: Input new order Consolidation execice in University Forum

Input new order Consolidation execice

mathieuchopplet — Mon, 30 Aug 2021 17:54:00 GMT

Hello,
I don't understand how to pass the csv data to input orders in centrix data solution.
I open centrix, get to the input order page, but I don´t know how to pass the information from the Queue to Centrix.
I suppose that I shoul pass the information in "start" in BO New Order, but how do you get data from the queue?
BO New Order:

Process Page 1 (Excel)
Process Main page:

May I have any help?

Thanks a lot!!

------------------------------
luc chopplet
------------------------------

RE: Input new order Consolidation execice

HarpreetKaur — Tue, 31 Aug 2021 01:08:00 GMT

Hello,

I believe the Get Next Item Action should be before your Centrix launch and navigate logic.
The high-level flow you process Main Page should follow is :
Open Excel and grab info >> Populate that info into the BP queue >> Grab the queue item info using Get Next Item >> Centrix Logic >> Mark Exception/Completed

Regards
Harpreet

------------------------------
Harpreet Kaur Product Consultant
------------------------------

RE: Input new order Consolidation execice

mathieuchopplet — Tue, 31 Aug 2021 12:52:00 GMT

HI,

Thanks for your prompt answer.

I still have an error, as I can't figure out how to populate centrix.

The error is:

Internal : Failed to evaluate expression in row 1 of Write Stage 'Product Code & Unit price' on page 'New Order' - The collection has no current row

I think I correctly get the information from excel:

I modified my main page as you suggest:

But I have the error on my "New Order" Object studio.

This is how I made product and price...but clearly it's not correct..

If you have any idea, it would be highly appreciated.

Thanks.

RE: Input new order Consolidation execice

John__Carter — Tue, 31 Aug 2021 13:16:00 GMT

Hi Luc - maybe this will help you:

The CSV has rows of data and each row represents a case/customer/order/whatever. The CSV is read into a collection data item, where again each row is a case. The collection is added to the queue, and each case is represented as a queue item.

The Get Next Item action that Harpreet mentions is they way to lock an item so that nobody else can work the same case - remember the queue could be shared by many digital workers. Once we have locked an item, we can go ahead and do the work - in this example, create the order. When the work is done, we use the Mark Completed action to update the queue item. Then we go back to Get Next Item to work another case; if Get Next Item outputs no Item ID, we know there are no more items available.

To pass data to a VBO so that it can write into the application, we must create input parameters in the Start stage. Once this is done, when an Action stage is added to the process, you can see the parameters required by the VBO.

The data in each case is available in the Data collection output of the Get Next Item action. This collection is used to provide inputs to the Action stge, eg [Data.Product Code]

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Input new order Consolidation execice

mathieuchopplet — Tue, 31 Aug 2021 15:10:00 GMT

HI John,

Thanks for your help.

Almost got it...I have an error : "Internal : Failed to evaluate expression in row 1 of Write Stage 'Product Code & Unit price' on page 'New Order' - The field 'Product Code' doesn't exist within this collection". It is correctly spelled.

From process Page 1 / get next item I have the following:

Then I pass it to Input order in the main page:

Then to the start properties of Input Order

Then as an input in the Action properties:

Then as input in BO/new order

Then in Write stage:

Do you know what I am missing?

Thanks!

RE: Input new order Consolidation execice

John__Carter — Tue, 31 Aug 2021 15:38:00 GMT

In the VBO start stage, try using individual parameters, like Product Code and Unit Price, rather than passing the whole collection.

Also, it looks like something has gone wrong at the 'read csv' step because your collection doesn't look right. It should have 5 columns, with each value in a cell. But here you have 1 column with all the values concentrated in the same cell. I think this is the reason for your 'field doesn't exist within this collection' error.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Input new order Consolidation execice

mathieuchopplet — Thu, 02 Sep 2021 09:18:00 GMT

Hello,

Thanks a lot for your help. Do you know how can I have the correct information, in the action get next item?

Get Worksheet As Collection (fast) has an output names Orders_collection.

Which seems correct:

Next, the action stage Add to Queue has the following inputs:

Ouptuts:

Then, the Get next item, has the following inputs and outputs:

But QueueData register the information as follows:

Thanks a lot!!

RE: Input new order Consolidation execice

John__Carter — Thu, 02 Sep 2021 10:16:00 GMT

Hi Luc - the output collection from reading the CSV file is the one that should be used as the input to Add to Queue. But check that the collection is correctly formatted, with the data in individual cells and rows, not squashed together as you had it previously. In effect what should achieve is this:

Read N rows of data from the file into collection A, with each row split into data fields
Add collection A to the queue to create N queue items. Then forget about collection A.
Use Get Next Item to lock the next available queue item and extract its data into collection B. Collection B will look like A but will have only 1 row.
Use the data in collection B to create the order
Mark the queue item as complete
Repeat from step 3 until all queue items have been worked

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Input new order Consolidation execice

mathieuchopplet — Sun, 12 Sep 2021 07:07:00 GMT

Hi, John,
Thanks a lot for your help!!

------------------------------
luc chopplet
------------------------------