KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
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.


2 posters

    Regarding :Error while extracting CSV file

    avatar
    subbiah.doss@gmail.com


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

    Regarding :Error while extracting CSV file Empty Regarding :Error while extracting CSV file

    Post by subbiah.doss@gmail.com 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:-
    Regarding :Error while extracting CSV file Kapows10

    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)

    Shyam Kumar
    Shyam Kumar
    Ranks


    Posts : 113
    Points : 4344
    Join date : 2013-07-05
    Location : Kerala, India

    Regarding :Error while extracting CSV file Empty Re: Regarding :Error while extracting CSV file

    Post by Shyam Kumar 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..
    avatar
    subbiah.doss@gmail.com


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

    Regarding :Error while extracting CSV file Empty Re: Regarding :Error while extracting CSV file

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

    Attached the screenshot of the step configuration
    Regarding :Error while extracting CSV file Kapows11


    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)
    Shyam Kumar
    Shyam Kumar
    Ranks


    Posts : 113
    Points : 4344
    Join date : 2013-07-05
    Location : Kerala, India

    Regarding :Error while extracting CSV file Empty Re: Regarding :Error while extracting CSV file

    Post by Shyam Kumar 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.

    Regarding :Error while extracting CSV file Img110

    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.

    Regarding :Error while extracting CSV file Img211


    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.

    Regarding :Error while extracting CSV file Img310


    Expecting your feedback and suggestions..

    Thanks and Regards,

    Shyam kumar

    avatar
    subbiah.doss@gmail.com


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

    Regarding :Error while extracting CSV file Empty Re: Regarding :Error while extracting CSV file

    Post by subbiah.doss@gmail.com 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.pngRegarding :Error while extracting CSV file Errorg11Regarding :Error while extracting CSV file Errors12Regarding :Error while extracting CSV file Report13Regarding :Error while extracting CSV file Report13

    Sponsored content


    Regarding :Error while extracting CSV file Empty Re: Regarding :Error while extracting CSV file

    Post by Sponsored content


      Current date/time is Fri Nov 15, 2024 1:40 pm