I require assistance in creating a workflow to upload PDF files on a web based application.
I have a folder which has more than 500 files and an excel file which has corresponding details of each file. The excel file contains the file name in of the column.
When using the upload files option in web based application, a browse folder window opens from there files need to be selected
Now the catch is that only five files can be selected at a time.
Once the five files are selected i also need to update the values from excel onto the web application for which i can use the lookup activity.
However i need assistance on how i can only select five files.
Kindly provide assistance on how i can create the activity using Studio X
Read the Excel file using the Use Excel File activity and point to your Excel file. Use For Each Excel Row activity to loop through your rows which contain the filename and details. Store each file path as FullPath = FolderPath + “” + CurrentRow(“FileName”).ToString.
Create a List variable of type List of String and name it FilesToUpload. Inside the For Each Excel Row loop, add the FullPath to FilesToUpload. If FilesToUpload.Count = 5 then call the upload process and clear the list after upload. After the loop ends, if there are leftover files in FilesToUpload, upload them as well.
For uploading the files, click the upload button in the web page to open the file picker window. Use Type Into activity with String.Join(" ", FilesToUpload) to type all file paths separated by spaces, then press Enter to confirm.
After each batch upload, for each file in that batch use Lookup Data Table or other methods to get corresponding details from Excel and type into the web form fields.
Use below activities in sequest to get 5 rows from excel column at a time.
At the end(after log message activity) use type into activity to type string in file picker box.
