- I am downloading two files from the Storage bucket.
- Saving it to my location.
- Comparing them and saving the unmatched records to a different Excel and performing some actions.
- I want to make the path relative, so the user doesn’t have to change the path in the config file.
HOW DO I MAKE MY PATH RELATIVE SO THAT ANY USER CAN USE THE ROBOT ONCE I PUBLISH IT.
In that case, File should be inside project folder. And then you can pass Relative file path instead of Absolute file path.
Can you help me out with a small example?Saving it after downloading and reading it from the same folder
Hi Dimple ,
Can you try as used in this post .
getting error message,
Download Storage File: Could not find a part of the path ‘C:\Users\xyz\Downloads’.
Hope the below steps would help you resolve this
Have two folders in your project folder
Name One of the folders as Input and
Another one as output
Now once while down loading the saving the file mention the file path as “Input\”
So that it gets saved in that folder
Now while reading the file for that Input folder
First use a assign activity like this
strfilepath = Directory.GetFiles(“Input”)(0).ToString
Pass this string variable strfilepath as input to excel application scope and read it with read range
Now you will be having the data in a data tale and write it with WRITE RANGE activity from workbook activities and mention the file path like this
“Output\”+”anyname you want”+”.xlsx”
This will now get saved in output folder
Then we can use DELETE FILE activity where pass the input as Strfilepath
- Now while writing
I will try this,Thankyou
@Palaniyappan So this will work once I publish this from orchestrator and then the user runs from any system.
Because it’s inside the project folder only
Even when ran by others the folders are still accessible being inside the project folder
I am getting this error once I publish it to Orchestrator. But it works fine while I Run it from Studio.
Try opening that machine and run it from robot assistant instead of studio and see how it works
I am working from the same machine and tried to run from Assistant as well, but it is giving the same error. @Palaniyappan
It is throwing an error while downloading the file, the location for which the error is coming up is different from the working project location.
So what i did to fix it is, since initially the folder that i created in my workspace to save the downloaded file, was not getting created in the error path(C:\-----), i manually created a new folder with the same name over there and now it is running
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.