Csv issue

Help
1

Write CSV: Object reference not set to an instance of an object.

Anyone can fix this issue?.Let me know the solution

2

@ganesh_rajan

Have you initialized the datatable object before using “Write CSV” activity.

Regards,
Ranjith.

3

You mean this one.

image

image

4

Can you please elaborate and let me know what is the data you are providing to opData … is it f on some Excel or web application data scrapping or some csv you have read.

5

Actually i scrapping the data from linkedin web page…

for example
1.job name 2.company name 3.job location

these 3 column name

opData means is scrapping object name.that object name pass to csv file…these 3 attributes data displayed in csv file.

csv file is a final output part

6

@ganesh_rajan before writing the datatable to csv try placing an output datatable which will convert the datatable to string format and place the output string to a message box and check if you ar getting values from linkedin …if not issue is with data scrapping

7

ok…i’ll try…thanks

8

Ganesh, as mentioned by Indrajit, there must be an issue with the data scraping considering you’re not getting any values in your datatable. Try rescraping your data from the page and check if you’re getting any values. Also, before you write on to the CSV, use an if to check if the table variable is not nothing. If it isn’t, ONLY THEN proceed to write to csv.

9

hi sid

linkin has thrown an exception

Source: Get IMAP mail messages

Message: Please log in via your web browser: Check Gmail through other email platforms - Gmail Help (Failure)

Exception Type: AuthenticationException

MailKit.Security.AuthenticationException: Please log in via your web browser: Check Gmail through other email platforms - Gmail Help (Failure)
at UiPath.Mail.Activities.GetMailActivity.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)

You know how to fix this issue?

10

Check SSL Connection in properties of Activity