Idea ID: 1768466

able to copy/paste server names from excel and CSV in HPOO.

Status : Declined
over 2 years ago

Production : HPOO.

Description :

In HPOO Flows, we have to manually put multiple servers separated by delimiter "

" or ",".

Many users are want to have a feature which will be able to copy/paste server names from excel (where servers are in one column and each server is on a separate row).

Most of enterprise software supports importability from common spreadsheet such as Excel and CSV.

  • The ability to get and use data from external sources like Excel or CSV files is what OO can do with the available out of the box content. Using the file system operations in your workflows can address this need.

    Considering there is no community support on this idea and there are available ways to achieve what is requested we are declining this idea for now.

  •  and  , you can use Micro Focus RPA to retrieve or change files and then use them in your automation process. Basically, the RPA can mimic what the user is doing on his machine. Now, with RPA you can combine API steps or backend tasks as you have them in OO with UI steps and create a complete end to end process that uses both.

    Micro Focus RPA has OO technology at its foundation so you can reuse all OO content.

  • Hi . The following are only my personal suggestions from our experiences. Whatever works best for you might be different depending on what you have available.

    1. The file-based operations we're using are simply the ones from the MF Base content pack, found under Library/Operations/File System. Ideal for sourcing local files from the Workers, perhaps with a (network) share we've made for users to access. Or what we mostly do is read from a centrally accessible server, by using the operations under Library/Operations/Remote Command Execution.
    But if you want a user to be able to import files from their desktop, I'm not sure this can be done directly with OO just yet. I'm pretty certain you could get to a solution using Micro Focus RPA and agents on the user's desktop, but we don't have much experience with that yet.

    Perhaps someone from Micro Focus could confirm the above?

    2. We integrated with ITSM via the product's API and made some operations of our own around that, for specific use cases. Vice versa, ITSM is able to use the OO API to trigger flows. Quite specifically, the ITSM team is making use of their own specific workflows (in ITSM) where at specific tasks OO flows are triggered. These flows do their thing, they read or change records as needed, while ITSM waits. Once done, ITSM notices the OO flow run is done and continues.

    I'm not sure whether I can go deeper into technical details, but hopefully this gives you a rough idea of how you could arrange a process to suit your needs.

  •  Little new to Orchestrator...

    Exactly looking for the operations/ flow executions you have suggested.

    1. Unable to find file-based operations in Library actually. Further after creating content pack, can an end user of OO URL import a csv at their desktop and run the flow as per his/ her requirement? Or the file must be present on a particular server?

    2. How have to achieved integration to ITSM with OO to process action on ITSM Ticket? 

  • Hi, Florin.

    This is for end-users who run health checks on multiple servers on daily basis. 

    We changed the flow to take whitespace as delimitor to resovle the problem. 

    We no longer need this feature.

    Thank you.