Blue Prism University

last person joined: 5 hours ago 

Discuss and learn more about Blue Prism University and certification.
Expand all | Collapse all

Need active hyperlink in results element in VBO

  • 1.  Need active hyperlink in results element in VBO

    Posted 09-04-2020 19:45
    Edited by Bernadette Stroeder 09-04-2020 21:06
    Hi all,

    This one is frying my brain. I've created a process hoping to end up with a list of hyperlinks in an Excel sheet. Process works, but the links are plain text rather than active links to a document. What am I doing wrong?

    Ideallly instead of a hyperlink spied from the results field, I need to download the htm file to a folder.
    Thanks
    Bernadette

    ------------------------------
    Bernadette Stroeder
    ------------------------------


  • 2.  RE: Need active hyperlink in results element in VBO

    Posted 09-06-2020 22:45
    Hi Bernadette,

    Since the links are inserted as in plain text format within the Excel cell, please try inserting the data with using Excel function called HYPERLINK.  
    For instance, insert as =HYPERLINK("www.abcd.org").

    ------------------------------
    Jega Avinasinathan
    Customer Support Engineer
    Blue Prism
    ------------------------------



  • 3.  RE: Need active hyperlink in results element in VBO

    Posted 09-07-2020 12:09
    Thank you Jega. I've decided to go a bit further and actually download the file and save in a folder, but the end file is .htm. Can you help me there? How can I transfer an htm doc to, say Word and store it in a folder?

    Best
    Bernadette
    BP Enthusiast/Sweden

    ------------------------------
    Bernadette Stroeder
    ------------------------------



  • 4.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 01:54
    Hi Bernadette,

    Thank you for your response.
    If you prefer your HTML document to be opened and saved as in Word format or prefer to transfer the HTML into any specific folder location, please consider import and utilising MS Word VBO and Utility - File Management VBO where you may find appropriate Actions according to your RPA design requirements. These VBOs are generally available within Blue Prism Automate folder.

    If you are using 64bit, it would be in
    C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO
    Otherwise, it would be located under
    C:\Program Files (x86)\Blue Prism Limited\Blue Prism Automate\VBO



    ------------------------------
    Jega Avinasinathan
    Customer Support Engineer
    Blue Prism
    ------------------------------



  • 5.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 11:19
    Thanks again Jega,

    Downloading the html file to a folder sounds like the simplest solution. However, I'm quite new to BP and though I created an action to download the file to a folder it doesn't work. I suspect the reason is the expression for Source URL, but since I will use this to download various documents I'm unclear what to do. Is there a stage that I'm missing? Thinking of Get URL (have heard of that) but not sure how that will feed into the file download.

    Hope you can help with this as well.

    Best regards
    Bernadette

    ------------------------------
    Bernadette Stroeder
    ------------------------------



  • 6.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 11:32
    Bernedette,

    You can do this with a calculation:

    "=HYPERLINK(" & Chr(34) & [URL] & Chr(34) & ")"

    I tried to do this using single quotes, but the VBO didn't like this.

    Best of Luck,


    ------------------------------
    Matthew Paisley
    Sr. Solutions Engineer
    Blue Prism
    America/New_York
    ------------------------------



  • 7.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 11:55
    Hi Matthew,

    Huge thanks! I'm really keen to get this resolved today so I can move on. Am loving the quick responses on this forum. 
    I used your expression, but am getting an error: Missing data URL. 

    Must be a stage not done yet? I'm so close!

    Regards
    Bernadette

    ------------------------------
    Bernadette Stroeder
    ------------------------------



  • 8.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 12:45
    Bernadette,

    What VBO method are you using?  I am using the Write Collection action of the VBO, but this should also work with Set Cell Value.

    As Jega mentions in his reply, the BP Excel VBO writes plain text to the spreadsheet. Using blueprism.com as an example, you need to write the cell as:

    "=HYPERLINK("http://blueprism.com")" 

    The problem is that BP doesn't allow double quotes within double quotes, """.  To remedy this, you prepare the string using ASCII characters Chr(34) as follows:

    "=HYPERLINK(" & Chr(34) & "http://blueprism.com)" & Chr(34)

    In my example below I use the variable [URL] so my calculation stage uses the formula:

    "=HYPERLINK(" & Chr(34) & [URL] & Chr(34) & ")"

    Hope  this helps.

    ------------------------------
    Matthew Paisley
    Sr. Solutions Engineer
    Blue Prism
    America/New_York
    ------------------------------



  • 9.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 13:51
    Hello Matthew,

    I'm using the Download file function in the file management utility as Jega suggested, rather than the Word VBO. This is a steep but enjoyable learning curve. I've tried that option and now getting the lovely exception: "Illegal characters in path". Maybe I'm over thinking it.

    I've created a process to call up an SEC report for companies imported as a collection. Everything works until I get to the actual document (random example link here: https://www.sec.gov/Archives/edgar/data/0001571996/000157199620000045/dell-20200731.htm

    I want to download the document showing on this page to a folder. I thought the download file function would do the trick but it doesn't. I think I'm missing a stage but I'm trying to keep the process simple. As a newbie, it is difficult to know what to do next. 

    Thanks again

    Regards
    Bernadette

    ------------------------------
    Bernadette Stroeder
    ------------------------------



  • 10.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 14:25
    Bernedette,

    What is the format of the file that you are downloading.  Can you provided a sample that doesn't contain proprietary or customer related information?

    ------------------------------
    Matthew Paisley
    Sr. Solutions Engineer
    Blue Prism
    America/New_York
    ------------------------------



  • 11.  RE: Need active hyperlink in results element in VBO

    Posted 09-08-2020 14:38
    Hi Matthew

    The link is to a file that is freely available to visitors of the sec.gov website. The link I inserted is just an example, but I have a list of company names for which I need to extract quarterly reports and store in a folder so colleagues can view and use them. No customer related or proprietary information here.

    I've got this far but am stumped as to the simplest way to transfer the contents of the htm page to a folder.

    Thanks again for your time.
    Regards
    Bernadette

    ------------------------------
    Bernadette Stroeder
    ------------------------------