Couldn't read the data from SAP Table

[venkatramankal1]

After spying the SAP table, trying to read the data from the SAP Table and blue prism keeps on scrolling down and it is not reading the data from the table. When I manually scrolled down it finishes and giving the multiple times duplicated records. 

Sometimes it throws error, can anyone knows the solution, please let me know, Thanks

------------------------------
venkatraman kaliyaperumal

------------------------------

[NileshJadhavBP]

can you give some pause or wait after each scroll and try.

Thanks
Nilesh Jadhav

------------------------------
Nilesh Jadhav
Senior RPA Specialist
------------------------------

[venkatramankal1]

Hi, We are using read stage to read the data from SAP Table. There is no option to pause or wait in the read stage

------------------------------
venkatraman kaliyaperumal
Support Analyst
Electrolux
Asia/Kolkata
------------------------------

[GeorgeBorghouts]

Hi all, perhaps superfluous, but i wrote a tiny ( 100% freeware, nothing commercial) app that lets you download SAP table data. It also can filter on SAP table entries. You can start and instruct it via commandline from your flow. Will download to CSV and/or Excel. Solves issues of scraping/scripting etc. We here use it with BP ourselves. You can get a copy at https://youtu.be/-S3kQkYto0Q
I do not think you should use it for many million records tables but for others it does the job.
Rgds,
George


------------------------------
George Borghouts
------------------------------

[VedSengupta]

Hello Venkatraman,
Since it is SAP I am more or less sure you can export the data to some flat file.
Or else open the data in Worksheet in BASIS (Pivot Table and attach that workbook and take into collection).

Please let me know if any more information is required on how to achieve this solution. All the best,

------------------------------
------------------------------
Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore | INDIA
*If you find this post helpful mark it as best answer*
------------------------------
------------------------------

[EVIPUTI]

Can you try saving the SAP table to .xlsx , may be a right click and save ? I do have seen someone using this https://sourceforge.net/projects/extract-table-for-sap/ . Not very sure if it will help you !

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification Developer
Amazon
------------------------------
------------------------------