Read CSV: Could not find file 'path to csv file'

Help
1

Hi,

The error states could not find the file but file does exist:
Read CSV: Could not find file ‘C:\Users\xxx\UiPath\Assignment2_GenerateYearlyReportPerformer\Data\Temp\Report-RU567434-2018-January.csv’

Invoke System1_Create Yearly Report workflow: Could not find file ‘C:\Users\xxx\UiPath\Assignment2_GenerateYearlyReportPerformer\Data\Temp\Report-RU567434-2018-January.csv’.

System exception.Could not find file ‘C:\Users\xxx\UiPath\Assignment2_GenerateYearlyReportPerformer\Data\Temp\Report-RO874232-2018-March.csv’. at Source: Invoke System1_Create Yearly Report workflow: Read CSV

The problem is these activities are executed slightly before the file gets saved. How to overcome this without impacting the performance?

Thank you!!

2

Hi @ashoka187

Are you able to find the file manually use path exists activity and check

Thanks
Ashwin.S

3

You can use a path exists and a while loop to wait for the file to be fully saved. The robot will loop until the file finishes saving and then it will find it and you can continue from there.

4

Hi Ashwin,

Yes it does exists; except that the file gets saved (fraction of second) after that particular activity is executed…

5

Hi Daniel,

I implemented in a little different way; PFB the screen… So after the while loop read csv is executed:

image
image524×515 9.64 KB

Do you suggest any faster solution or is this the perfect?

6

It can be even simpler:
image

7

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