CSV not recognized in read CSV activity

Learn Academic Alliance
, ,
#1

Howdie all.

I am currently doing the “Build your first Automation” in the “RPA Starter” course. I downloaded all the practice files and programs necessary. I am currently at the 3m mark in the “automate with studio X” subsection where I am to add an activity of “read CSV” but when I click on the browser it does not show the CSV files in it. I have tried downloading it several times replacing the files. I also notice it does not show the report file. but does have the “.settings” file.

If it helps I run Windows 7 and have the current version of Excel.

This is my first Forum topic and Im VERY new. I read over the beginners guide but if I am in the wrong place or tagged something inappropriately let me know.

Thanks.

#2

Hi there @kilroydacat

Can you elaborate on what the error is. Does the file not get downloaded at all ? Or whether the file is corrupted or does it not show?

#3

the file doesnt show up in the browser in the studio X activity “Read CSV”. the file seems to be fine. I can open it in excel and notepad. But when I try to attach it to the activity it wont show up.

#4

Show up in the sense when you try to select the file?

#5

yes when I click the little folder icon in studiox it opens and the file isnt displaying

#6

Then change the search setting to ‘All FIles’ (Check highlighted option)

image
image936×589 39.1 KB

#7

not available.

#8

can you post screenshot on what is available step by step?

#9

CSV file not recognized
CSV file not recognized1920×1080 296 KB

#10

Well then you are better off directly giving the absolute path to the CSV file

1 Like
#11

edit. Sorry. just found an error trying again

CVS complete path
CVS complete path1920×1080 398 KB

#12

read CSV failed
read CSV failed1920×1080 301 KB

#13

Okay Fixed it. It works thanks.

#14

Does the path exists? THe error says it does not, maybe validate the file path…

#15

OKay great. :slight_smile:

1 Like