About Getting Same Value in Both Rows in Website using Excel.

[RohitSuperCool0097]

Hi All,
I am Adding Invoice Details in New Invoice Window in Invoicely Website using Excel Sheet using Blue Prism 6.0 Studio. I am using HTML Mode for Automating To Enter Product Details in Enter Product Description in New Invoice in Invoicely Website. But I am getting Duplicate Values in Multiple Rows for Product Details in Enter Invoice Details in Invoicely Webiste. I need help about Issue in Flow in Add Product Details in Enter Invoice in Invoicely VBO. I am sharing the Screenshot of the Flow and Result Window.
View attachment Product_Item_Description_Table.png

 

[VJR]

Hi RohitSuperCool0097,

Are you passing the Product Data collection from the 'Read Products Data from Excel' to the 'Enter Product Item Details' page?
Or have you made the Collection available to all pages by clicking the check box in its properties?

Either way you do, the collection should be made available to the 'Enter Product Item Details' page.

In that page, the flow should be somewhat similar like the below:

-Read Products data from Excel
-Count no of rows in Collection -> [Count]
-Set [RowNumber] = 0 "Data Item to increment row inside the collection"

-Start Loop

-Calc stage to increment [RowNumber] by 1
-Enter Product Item
-Calculate Amount
-Write Product Amount
-Select Unit of Product

-Add Decision stage for the below condition:
--If [RowNumber] = [Count] "this means you have reached the last row of collection and no new item needs to be added" -> Yes -> go to End loop

--If No -> "this means there are still rows in the collection and new new item needs to be added" -> Select New Item option -> go to End Loop


-End Loop

-Click Save button

 

[RohitSuperCool0097]

Are you passing the Product Data collection from the 'Read Products Data from Excel' to the 'Enter Product Item Details' page?

Thanks Sir For Reply. Yes Sir I am passing values from Read Product Data from Excel to Enter Product Item Details Action Page in Invoicely VBO.

 

[RohitSuperCool0097]

-Set [RowNumber] = 0 "Data Item to increment row inside the collection"

Hello Sir, I did not understand How to Set [RowNumber] = 0. Whether I need to declare [RowNumber] as field in Collection and Excel? Can you Send me How Data Flow Diagram of Collections and Enter Product Item Details would be.

 

[VJR]

Hello Sir, I did not understand How to Set [RowNumber] = 0. Whether I need to declare [RowNumber] as field in Collection and Excel?

[RowNumber] is a "Data Item to increment row inside the collection"
Have a Data Item and in its properties give its Initial Value as 0.

 

[RohitSuperCool0097]

Hello Sir, I am sending you the screenshots of Flow. Please let me whether the Flow is correct or not. Also Please Help me about Adding Decision Stage for Getting Last Row Count of Collection, What to Declare in Decision Properties in Enter Product Item Details.

 

[VJR]

Hello Sir, I am sending you the screenshots of Flow. Please let me whether the Flow is correct or not. Also Please Help me about Adding Decision Stage for Getting Last Row Count of Collection, What to Declare in Decision Properties in Enter Product Item Details.

What is the output data item of Count Collection?

 

[RohitSuperCool0097]

Hello Sir!
As Suggested by you. I used count and RowsNumber as 0 Data Items and also used Decision Stage. But I am Getting Such Output. Please suggest the Proper Solution to Problem. I am sending the Screenshots of Flow and Result of Flow of Invoicely VBO. The RowsNumber Value is 8 and Count Value is 3. The RowsNumber Value is getting incremented by 1. Sir, Please Let me know about Issue in Flow.

 

[VJR]

Hello Sir!
As Suggested by you. I used count and RowsNumber as 0 Data Items and also used Decision Stage. But I am Getting Such Output. Please suggest the Proper Solution to Problem. I am sending the Screenshots of Flow and Result of Flow of Invoicely VBO. The RowsNumber Value is 8 and Count Value is 3. The RowsNumber Value is getting incremented by 1. Sir, Please Let me know about Issue in Flow.

Hi RohitSuperCool0097,
I cannot suggest you a complete approach as I am not in direct interaction with the system you are working on. But I can guide you with inputs and you can share if something doesn't sound right or if its not workable for you.
Basically you need to loop through the collection and get each row. At first you can read each row of some sample data in a fresh new test page.
In your diagram once you are reading outside the loop and again after loop has started. Probably that may be causing the same first item to be read again.

 

[RohitSuperCool0097]

Ok Sir! I would try as you suggested try with loop through the collection and getting each row of Collection.

 

[VJR]

Ok Sir! I would try as you suggested try with loop through the collection and getting each row of Collection.

Yes you can check this by displaying each collection row in some data item.