I’ve been playing around a bit, but am struggling to get the following done. I have a file which I’d like to download an a daily base. This file is generated every night and then stored in a cloud drive. The first part of the filename is like “Dummy Name - Group X - 2020-04-08 00_39 CEST.xlsx”. Tomorrow the name will be like “Dummy Name - Group X - 2020-04-09 00_39 CEST.xlsx”. Each new report thus has the data and time of generating this report. How can I make sure UI Path downloads this report based on the first part of the file name. I’ve tried using a fuzzy match, but it doesn’t seem to work.
Thanks a ton, Anders. Unfortunately, I wasn’t clear in my post that I’m actually referring to a cloud drive on a website. One of our systems allows us to schedule the creation of reports. They are then stored (in the way I described above) on a cloud drive, which you can only access via a browser. I can access this page through a static URL.
I can completely follow your clear instructions, but am not sure how to apply this logic to a URL, rather than a folder on my local machine.
Many thanks for any follow-up instructions. And I’ll definitely check-out all the other extremely useful video’s you’ve created! Really cool stuff
Sure, then we first need to download the files, we need:
(1) Datascrape the files (you’ll get all the names into a datatable)
(2) Now I will make a For Each Row and then download each one of the files with a dynamic selector
If you only need one file (like the one from today), then I would apply a filter to the For Each Row.
After that you got the files needed and you could go with the process in my video.
Ps. You could also just download all the files and then apply the ‘today’ filter afterwards as I did it in the video.
I see that the emphasis here was in a dynamic file name, i am stuck with downloading files with dynamic file types(PDF,Word,xlxs,etc etc).
Anders have a video where he saves/scrape the data and url to excel document, so i went and change that and scrapped a website where i want to download some documents, however those documents are not of simmilar types and at the moment i can only save one type.
I am using DownlodFileActivity i got from managed packages.
Here i am downloading the vendow_master excel sheet so automatically below document type will be also mentioned
So provide the file path as C:\ (some before filepath parts)\vendor_master instead of
C:\ (some before filepath parts)\vendor_master.xlsx
Not really, your answer did not clarify anything, you see if you follow that video i attached above and i ommit the filetype it will only save a file without a filetype, but the urls/link i am downloading from has the file type
Kindly help me as below clarification which is:
Download the single excel file from Web application and move to another folder and open the file to processed further.
Please help me any one also.