Unauthorized Access Exception

Help
, ,
1

Hello Folks, I am doing my assignment from Yearly report, Advanced Training Assignment 2.

I am Unable to read the CSV file since the folder is not accessible.
I changed the security on the folder for “Everyone” to read and access.

Please let me know.

1 Like
2

Hi
Welcome to uipath community
Were we able to access that folder manually
Cheers @priyanrece

3

I follow your posts all the time. You are incredible Palaniyappan :slight_smile:

2 Likes
4

Yes I can access manually. I select the file and it works. If I select folder, it says cant access :frowning: Have been stuck

5

Capture
Capture1580×931 142 KB

1 Like
6

@Palaniyappan This is the error

7

@priyanrece

Access denied type of errors are often caused by either antivirus software blocking the files or lack of enough permissions to the folders. Could you test it with antivirus temporarily disabled?

8

Hi
Mention the full path of the csv file
Like
“Yourfolderpath\yourfilename.csv”

And try once
Cheers @priyanrece

9

Still the same error @lakshman I disabled the anitvirus for 1 hour

10

It works, but mentioning folder doesnt work.

As part of assignment, I have to mention folder.

The CSV file is getting saved. Opening the “Read CSV” function is not working if I mention folder.

@Palaniyappan

1 Like
11

@Lahiru.Fernando Any suggestions?

12

Yes buddy
That activity will take the filepath as input and not the folder path alone
So if we know the folder path only
Then from that we can get the Filename using this expression
arr_files = Directory.GetFiles(“yourfolderpath”,”*.csv”)
Where arr_file is a variable of type array of string
—now use a FOR EACH activity and pass the above variable as input and
—inside the loop use a READ CSV activity and mention the file path input as item.ToString

Cheers @priyanrece

13

Thanks Thanks, my understanding was incorrect earlier. Input should always be file and not the Folder path @Palaniyappan

1 Like
14

Check on task manager if excel processes are still running. Kill those processes and try to rerun. If you are still unable to kill all they might be running on the background, you can restart your pc/laptop so that it would all be closed and refreshed. Hope this helps :slight_smile: :smiley:

image
image1081×739 45.3 KB

15

Yah
That file path can be passed as input to READ CSV activity
To be simple if we pass a folder how does that activity read csv knows whether it’s a csv file or not

Cheers @priyanrece

1 Like
16

@Palaniyappan Thanks much, it worked. input is always a file and never a folder path :slight_smile:

1 Like
17

Cheers @priyanrece

18

@Palaniyappan For UI Path Advanced certification, they have mentioned to use WorkItems and not Queues. But I am comfortable with Queues, can I use Queues for the exam?? They have not mentioned about using Queues in the grading pattern though.

19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.