I have multiple pdf URLs in in my excel sheet. i need to download one by one pdf. then i rename pdf , move to another folder. kindly share your knowledge and workflow.
Use Download file from URL
activity. Here you can directly give the desired file location and name.
Thanks,
Ashok
Use Download file from URL Activity to download the file from the URL.
Then use Rename file, Move file activities to rename and Move the downloaded file.
Hope it helps!!
To automate the process of downloading PDFs from URLs listed in an Excel sheet, renaming them, and moving them to another folder using UiPath, follow these steps:
Workflow Outline
Read the URLs from the Excel sheet.
Download each PDF from the URLs.
Rename the downloaded PDF.
Move the PDF to another folder.
Thanks,
Purushotham
Hello @domsmgtmeet22
You can read the Excel Workbook to a Datatable and iterate the rows in a “For Each Row in Data Table”.
Then you can grab the URL from the column that contains the download links, and then download the file via the “Download File from URL” Activity.
Regards
Soren
our url have this format
\192.168.28.15\kcn\PresTC\PDF\CN170000136470_OPCN00987150.pdf
not working this method
Can you try this:
Install UiPath.FTP.Activities
package
Use Download Files
activity to download the file.
Thanks,
Ashok
Manually how you are downloading the file from URL, Could you share the steps how you are doing… @domsmgtmeet22
Then we will try to understand your query and suggest a solution to you.
Hope you understand!!
It seems these are not URLs, but rather the paths of PDF files stored in a network folder.
Try the following steps and let me know if it works:
- Use the “Copy File” activity, and enter one of the file paths from excel in the Source field.
- Specify the local folder path in the Destination field.
Then, check if the file is copied to the local folder.
Hope you understand!!
kindly share workflow sir.
There is no much activities using here just using only one Copy file activity… @domsmgtmeet22
→ Drag and drop the Copy file activity from Activities panel.
→ Copy the first URL in excel sheet manually and paste in From field.
→ Give any of the folder path of your local in the To field.
Then go to local folder and check the file copied or not. If throwed any exception share the screenshot with us.
Hope you understand!!
its working Thankyou.
It’s my pleasure… @domsmgtmeet22
Make my post Mark as solution to close the loop.
Happy Automation!!