Read CSV - unable to load document

csv
activities

#1

Scenario: Unable to read CSV file using the Read CSV activity.

Steps to reproduce:

Current Behavior: Exception while loading CSV file

Expected Behavior: Load CSV file and populate data table

Studio/Robot/Orchestrator Version: 2017.1.6456

Last stable behavior:
Last stable version: Stable
OS Version: Windows 7 Professional SP1
Others if Relevant: (workflow, logs, .net version, service pack, etc): .NET 4.0.30319.42000

Hello-

I am unable to load the CSV as part of one of the lessons. Below is the exception I get:
N.B: Even though the file is available in the correct path a File Not Found Exception is shown.

Main has thrown an exception

Source: Read CSV

Message: Could not load file or assembly ‘CsvHelper, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8c4959082be5c823’ or one of its dependencies. The system cannot find the file specified.

Exception Type: FileNotFoundException

System.IO.FileNotFoundException: Could not load file or assembly ‘CsvHelper, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8c4959082be5c823’ or one of its dependencies. The system cannot find the file specified.
File name: ‘CsvHelper, Version=2.0.0.0, Culture=neutral, PublicKeyToken=8c4959082be5c823’
_ at UiPath.CSV.Activities.ReadCsvFile.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)_
_ at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)_
_ at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)_

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Thanks
Matt.


#2

Readd Excel activities pack. That file not found is not about the file you’re trying to read but one of the assemblies needed to do so.


#3

Thank you Andrzej. It did work!!!


#4

Hello Andrzej

kindly provide the step by step guidance to solve this error. me too face the same above mentioned error. since we are new to UI Path tool please guide us like a noob :slight_smile:

Respectfully,
Jack


Read CSV Randomly Stopped Working
#5

Hello Jack,

Go to Manage Packages in the Activities pane (or press Ctrl+p). From the Installed section uninstall Excel activities pack. Then go to Available section and install it back.
This should reinstall CsvHelper libraries as well, which were the cause of this error.

Cheers,
Andrzej


#6

Hello Andrzej,

Its working fine now. thanks for the detailed and quick response.

Respectfully,
Jack


#7

Hi,

Please see the below tutorial,

Thank,
akrthik