Digital Exchange

 View Only
last person joined: 3 days ago 

This community is a place to discuss Blue Prism DX assets and development.

Expand all | Collapse all

Queue Reports VBO on DX

  • 1.  Queue Reports VBO on DX

    Posted 05-02-2022 12:29
    I was looking for Queue Reports VBO on DX but could not locate it.

    Though I was able to find it in one of the developer jumpstart here.

    Since it is not on DX so thought to raise a query here about the same.

    Is it safe to use this VBO or not.

    ------------------------------
    Thanks & Regards,
    Tejaskumar Darji
    Sr. RPA Consultant-Automation Developer
    ------------------------------


  • 2.  RE: Queue Reports VBO on DX

    Posted 05-02-2022 13:36
    We are also using Queue report VBO from this option only.

    i think few VBO are on developer jumpstart page before DX was introduced(may be).

    ------------------------------
    Neeraj Kumar
    Technical Architect
    ------------------------------



  • 3.  RE: Queue Reports VBO on DX

    Posted 05-02-2022 18:16
    Hi @Tejaskumar Darji,

    As @Neeraj Kumar pointed out, this asset is only available on the portal at the moment. You can find it here. We'll work on getting it moved over to the DX.

    Cheers,

    ​​​

    ------------------------------
    Eric Wilson
    Director, Integrations and Enablement
    Blue Prism Digital Exchange
    ------------------------------



  • 4.  RE: Queue Reports VBO on DX

    Posted 05-02-2022 23:39
    Hi Eric,

    I don't know who maintains that VBO or if it's intended to be left as is, but there are a few issues with it. Off the top of my head, one of the issues is that it cannot correctly run multiple times in the same run as it will keep adding to the same collection thus creating duplicate rows. Basically it doesn't seem to clear out its collection when the action is called subsequent times.

    I didn't spend much time looking into it because I like reinventing the wheel I guess. Just wanted to mention it so you could take note of it or let whoever maintains it to consider checking on its functionality at least regarding subsequent calls in the same session.

    ------------------------------
    Dave Morris
    3Ci at Southern Company
    Atlanta, GA
    ------------------------------



  • 5.  RE: Queue Reports VBO on DX

    Posted 05-02-2022 23:50
    Hi @Dave Morris,

    Thanks for the feedback. I'm not sure who's responsible for it right now. Once we bring it on to the DX​, my team will pick up the support though. 😉

    Cheers,

    ------------------------------
    Eric Wilson
    Director, Integrations and Enablement
    Blue Prism Digital Exchange
    ------------------------------



  • 6.  RE: Queue Reports VBO on DX

    Posted 05-03-2022 16:23
    Thank you everyone for your responses.

    This VBO will bring better reporting solutions to the users.

    ------------------------------
    Thanks & Regards,
    Tejaskumar Darji
    Sr. RPA Consultant-Automation Developer
    ------------------------------



  • 7.  RE: Queue Reports VBO on DX

    Posted 12-06-2022 16:14
    Hi @Dave Morris, @Tejaskumar Darji,

    Apologies for the delay on this. ​We've finally published the Queue Report VBO on the DX, and now we're looking over the design in order to address reported issues.

    @Dave Morris - You had reported "...doesn't seem to clear out its collection when the action is called subsequent times." Which action(s) are you referring to? Would it be Create Performance Report (from multiple queues)​ or Create Performance Report (from items) actions? I've taken a quick look through the VBO and it seems there's a single Collection that doesn't have the Reset to Initial Value whenever this page runs option checked.​

    @Tejaskumar Darji - I saw your post yesterday about the issue of embedded Collections throwing an exception​. We'll look into that.

    Cheers,​

    ------------------------------
    Eric Wilson
    Director, Integrations and Enablement
    Blue Prism Digital Exchange
    ------------------------------



  • 8.  RE: Queue Reports VBO on DX

    Posted 12-06-2022 18:55
    @Eric Wilson The action "Get Data From Items". It's been a while since I looked into this, but I'm glancing at what I did previously to address the issue, and what I did was to put a code stage at the beginning of that action that called a new function/sub in the Global Code to clear the DataFromItems DataTable whenever that action begins to run. I'm sure there may be a simpler way to do it, but below is what I added to the Global Code. The first line below was already there and I'm just including it to show where I placed the Sub, though I guess that doesn't matter. Anyway, I call ClearDataFromItems() right when Get Data From Items starts. I'm sure you may implement a fix differently, but I wanted to point how I did it.

    This page/action appears to be called from several other pages/actions so I suppose this would affect all of them. In any case, the main thing I found was that it was adding duplicate rows when calling the action multiple times from in the same process within the same session because that DataTable was not being cleared or overwritten each time but instead was being appended to.

    Public DataFromItems As DataTable
    
    Public Sub ClearDataFromItems()
    	If DataFromItems Is Nothing Then
    		'Do nothing
    	Else
    		'Clear DataFromItems
    		DataFromItems = Nothing
    	End If
    End Sub​


    ------------------------------
    Dave Morris
    3Ci at Southern Company
    Atlanta, GA
    ------------------------------



  • 9.  RE: Queue Reports VBO on DX

    Posted 12-07-2022 00:01
    Thanks for the feedback @Dave Morris. I've got one more question for you and @Tejaskumar Darji. We're been toying with a mechanism to support inclusion of Collection data. I don't recall why exactly the original developer(s) of this VBO didn't implement support for it. What we've done is added logic to take any embedded Collection and convert it to JSON. We then write it to the output Collection as text. Would that be beneficial, or should we stick with the original design of ignoring embedded Collections?

    Cheers,​​

    ------------------------------
    Eric Wilson
    Director, Integrations and Enablement
    Blue Prism Digital Exchange
    ------------------------------



  • 10.  RE: Queue Reports VBO on DX

    Posted 12-07-2022 06:15
    Honestly, I felt that Queue Reports VBO is doing so many operations using code stages like excel formulas, excel templates, pivot tables, etc etc. making it a more complex solution just for the reporting. Also, it is a Queue Reporting right so we do not need any data inside the queue, I'm not sure why we are looking inside the data of a queue and why the nested collection is required here.

    So instead of going with that VBO, I have seen people prefer "Get Report Data Action from Default WorkQueue VBO itself which will be a more simple, easy, and more efficient solution. (Considering that WQ data is gonna be huge in most cases)

    Also, this is the reason why I was checking if we can replicate the same Control Room-"Export Current View as Report" option in some utility itself to get the CSV exports easily. As we already have this option in Control Room so there must be some SQL query or something running in the backend. This will also streamline the format of reports when generated manually OR generated by automation. - Thread Reference 

    My thought is to keep it very simple and straightforward and then later we can add more new functions to enrich the Reporting Utility in Blue prism.

    These are just my thoughts on this from the design and general requirement perspective. Please share your thoughts as well so that we all can bring a great reporting feature to BP.



    ------------------------------
    If I was of assistance, please vote for it to be the "Best Answer".

    Thanks & Regards,
    Tejaskumar Darji
    Sr. Consultant-Technical Lead
    ------------------------------



  • 11.  RE: Queue Reports VBO on DX

    Posted 12-09-2022 08:32
    Hi Tejaskumar,

    I would recommend you have a process that will use the 'Get Report Data Action from Default Work Queue VBO' to get the specific queue data into the collection and then you can write the collection data into an excel file and save it.
    Whenever you need a queue report you can run the process and you can also schedule it as per your requirement this will make our job simple and easy as there are multiple Input data you can specify to get daily queue reports.


    Thank you,
    Chirag Patel.
    (IgniteIPA)


    ------------------------------
    Chirag Patel
    ------------------------------



  • 12.  RE: Queue Reports VBO on DX

    Posted 12-12-2022 14:58
    @Eric Wilson I agree that it'd be a good idea too implement the conversion of the collection into JSON. However, I would suggest, in case you weren't already going to do this, making the default functionality mimic what it was doing before so that outputs are consistent. But a flag input to include collections in the output seems like it'd work well so that people could opt in to that collection output.


    ------------------------------
    Dave Morris
    3Ci at Southern Company
    Atlanta, GA
    ------------------------------



  • 13.  RE: Queue Reports VBO on DX

    Posted 12-12-2022 16:58
    Thanks @Dave Morris. The new VBO has been posted to the DX. We've added a flag to the Get Data From Items action that allows you to control whether embedded Collections are ignored or not. The default value is True which means they will be ignored (same functionality as what was previously supported). If you're calling this action directly, as opposed to it being called as an action within one of the other actions, you can set that​ flag to False and the output Collection will include the embedded Collections as actual BP Collections instead of JSON. I think that will make things easier for anyone who may want to iterate those embedded Collections.

    The actions that generate the actual reports continue to function as they did previously meaning embedded Collections are ignored.

    Cheers,

    ------------------------------
    Eric Wilson
    Director, Integrations and Enablement
    Blue Prism Digital Exchange
    ------------------------------



Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support

FAQs

The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.