KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


Regarding :Error while extracting CSV file

Share

subbiah.doss@gmail.com

Posts : 5
Points : 267
Join date : 2017-03-08
Location : Chennai

Regarding :Error while extracting CSV file

Post by subbiah.doss@gmail.com on Wed Mar 08, 2017 12:38 pm

Hi, we were trying to extract a csv file in to a kapow custom variable and it displays a error message as follows.Can you help us in understanding and fixing the error. the step configuration is as below:-

Exception Message is thrown "3/2/2017 6:04:32 AM Exception caught:

Com.KapowTech.RoboSuite.Api.RobotErrorResponseException: The robot generated the following error: RobotErrorResponse(date=3/2/2017 4:04:32 AM,robotFileUrl=library:/DownloadTransactionLog.robot,executionId=8f162af7000001a8,robotRunId=0,robotId=-1,errorMessage="Error from the Extract CSV (old version) action. No CSV rows could be found in the found tag.",errorLocation= Get User Session{ Snippet Info - Restore Session From Server - Load Admin Page - Validate Current Session - Find User? - (Unnamed Try step) - Session still valid? - Session Reused - (Unnamed Try step) - Page = Find User? - Has Search Button? - Save Session On Server - Success - Return Message - Empty UserSession } - Transaction Log - Find Account{ messageReturned = false - Assign Page Check Pattern - Select Destination Page - (Unnamed Try step) - Fill Input Form - (Unnamed Try step) - Click Search - (Unnamed Try step) - Success? - Init Counter } - Set date range with time{ - Select Month - Enter Date - Select Year - Select Hour - Select Minutes - - Select Month - Enter Date - Select Year - Select Hour - Select Minutes } - Filter on type and status{ (Unnamed Try step) - Transaction Type? - (Unnamed Try step) - Transaction Status? } - (Unnamed Try step) - (Unnamed Try step) - Download Log To Memory - (Unnamed Try step) - Choose output method - Return Objects? - (Unnamed Try step) - "Acc Type:" Label - Extract Csv Type - Do Nothing - Summary info - CSV Data - Count columns - Extract Transaction Log from CSV{ (Unnamed Try step) - No records in CSV - Replace "" with ' - ReplaceControlCharacters{ Replace Control Characters } - Replace Value Line Breaks - Create Page From CSV - (Unnamed Try step) - Personal? - Extract 18 column CSV[1] },errorLocationCode={{t0-a2-t0-a-t0-a2-t0-a6}-a-{a3-t0-a-t0-a-t0-a-b0-a}-{a12}-{t0-a-t0-a}-t0-t0-a-t6-a-b0-a-t0-a6-{b1-t0-a2-{a}-a2-t0-a-i0}})
at Com.KapowTech.RoboSuite.Api.Engine.Remote.ResponseCollectingRqlHandler.UpdateAndThrowException(RqlException e)
at Com.KapowTech.RoboSuite.Api.Engine.Remote.ResponseCollectingRqlHandler.HandleResponse(RqlResponse response)
at Com.KapowTech.RoboSuite.Api.Engine.Remote.RemoteRqlEngineRqlRequestHandle.NextRqlResponse()
at Com.KapowTech.RoboSuite.Api.Engine.AbstractRqlEngine.Request(RqlRequest request, IRqlHandler handler)
at Com.KapowTech.RoboSuite.Api.Engine.Deploy.DeploymentSupportRqlEngine.Request(RqlRequest rqlRequest, IRqlHandler rqlHandler)
at Com.KapowTech.RoboSuite.Api.RobotExecuter.Request(RqlRequest rqlRequest)

avatar
Shyam Kumar
Ranks

Posts : 82
Points : 1746
Join date : 2013-07-05
Location : Kerala, India

Re: Regarding :Error while extracting CSV file

Post by Shyam Kumar on Wed Mar 08, 2017 3:24 pm

Hi

Subbiah doss,

your attached step configuration images too small and difficult to see. Please attach images in large size.

Thank you..

subbiah.doss@gmail.com

Posts : 5
Points : 267
Join date : 2017-03-08
Location : Chennai

Re: Regarding :Error while extracting CSV file

Post by subbiah.doss@gmail.com on Wed Mar 08, 2017 5:38 pm

Attached the screenshot of the step configuration


Last edited by subbiah.doss@gmail.com on Wed Mar 08, 2017 5:44 pm; edited 1 time in total (Reason for editing : added screen shot for the step configuration)
avatar
Shyam Kumar
Ranks

Posts : 82
Points : 1746
Join date : 2013-07-05
Location : Kerala, India

Re: Regarding :Error while extracting CSV file

Post by Shyam Kumar on Thu Mar 09, 2017 7:03 pm



Hi Subbiah doss,



Actually the main reason is you are try to extract a csv file in to a kapow custom variable. But the kapow provide only the custom data type is Excel (Excel (Simple)) only.



And you are using to Extract CSV action step for extract content from a csv file. This action step have some limitations. Because old version of csv file contents inside <pre> tag. But the latest version of csv changed this to <tr> tag. This may change frequently based on the up-gradation of the product. May be this is the main reason to avoid Extract CSV action step from the new versions.




Instead of using this step we can use other method for extract CSV content, like just load the file (if you have multiple file use looping) and loop each tag and extract data. If you are using Extract CSV action step we can do all mapping together, here need to give separate action steps for each extraction. Other wise you can use Convert step action. It will work smoothly.




Expecting your feedback and suggestions..

Thanks and Regards,

Shyam kumar


subbiah.doss@gmail.com

Posts : 5
Points : 267
Join date : 2017-03-08
Location : Chennai

Re: Regarding :Error while extracting CSV file

Post by subbiah.doss@gmail.com on Thu Mar 09, 2017 7:40 pm

But shyam ,we are currently using older version of the kapow and was working fine till the recent change.

as per the new change when no record is in csv file we are populating a message in to the csv sheet(please refer the pasted csv  "ErrorGeneratingReport.png") 
and when this message is populated it generates error only for these csv files with message.

it works fine in reading the csv file when the recors are there in CSV file    (please refer the pasted csv  "ReportWithoutError.png")

Also i have attached the error step configuration("errorstepconfiguration.png")

as per the exception message the things go fine til this step.it gets exception in this step as defined in errorstepconfiguration.png.
how to overcome this and change the step configuration to work for the csv defined in  ErrorGeneratingReport.png

    Current date/time is Sun Nov 19, 2017 6:22 am