Newbie here trying UiPath as a Proof of Concept for a client. So, time is kind of a constraint.
Have an excel file with Permit Numbers and File Names. (I was able to accomplish this part)
Excel File is in /Documents/UiPath/Project folder
Downloaded files are in /Downloads/Project name
I am stuck at the step where I need to select filename that matches Permit number when uploading.
Search for a Permit Number in the Web application.
Under Records, click to Add a File.
In the upload popup, navigate to a folder in “Downloads”.
Select the file name that matches the Permit Number
Upload that file.
Like I said - Newbie and first topic. Any help is appreciated!
Read the excel by using read range workbook activity and store in a data table.
Use for each file in folder (The Path of the folder which contains the files i.e,Pdf’s)
for each row in datatable
assign ReplacedStr=CurrentRow(“Permit Numbers”).ToString.Replace(“-”,“”)
if ReplacedStr.StartsWith(CurrentFile.Name)
Type into Currentfile.Name
Click on Open
Question - It seems like you are replacing File Names with the Permit Numbers first. That may not work in this case.(Have not tried)
What I need to do this: Search for the Permit Number, in the section where attachments are added, when you click the Add/upload button, go to the folder where all the files are downloaded and select the filename that matches the Permit Number that was used for the search.
The same Permit Number can have multiple file names to be uploaded (like in the below scenario)
Anil_G
Yoichi
Akash_Javalekar1
jast1631
k.sakaguchi0804
singh_sumit
Nisha_K21
shaik.muktharvalli1
postwick
naoko0623