topic Re: GUI_UPLOAD issues in Application Development and Automation Discussions

GUI_UPLOAD issues

Former Member — Mon, 26 Mar 2012 05:48:06 GMT

Hello,

I am trying to download a big chunk of file into an internal table which has a size of 60000 rows using 'GUI_UPLOAD'. When I check number of rows or internal table size after executing the FM in debug mode, the internal table have only 6699 rows instead of 59900 rows. Is there a constraint on number of rows in GUI_UPLOAD function module. Please share your thoughts or solution to my problem.

Thanks

Re: GUI_UPLOAD issues

ShyamPindiproli — Mon, 26 Mar 2012 06:02:04 GMT

You can alternatively make a try using the Static method - of the GUI Front End Services

'CL_GUI_FRONTEND_SERVICES =>GUI_UPLOAD'.

Re: GUI_UPLOAD issues

Former Member — Mon, 26 Mar 2012 06:19:56 GMT

Hi Ben,

Read this thread completely . http://scn.sap.com/thread/492737

Hope will solve your issues while uploading.

Regards,

Saravana.S

Re: GUI_UPLOAD issues

Former Member — Mon, 26 Mar 2012 06:30:31 GMT

try with this

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

Re: GUI_UPLOAD issues

former_member222709 — Mon, 26 Mar 2012 06:46:06 GMT

Hi Ben,

You can use 'GUI_UPLOAD' for records upto 65,535 rows, but, there are some issues while using xls. If you want to check the reason for the reduced number of rows, then, debug the internal table used in 'GUI_UPLOAD'. Locate the record where the truncation happens. Probably, whenever 'GUI_UPLOAD' comes across special characters in an xls file, it considers the encounter record as a comment till the same special character is repeated. So look out for ',",!, etc. in your excel file and you might get the problem.

Finally, this can be resolved either by using 'GUI_UPLOAD' with a text file or using the new OLE Methods with 'CL_GUI_FRONTEND_SERVICES'.

Hope this helps.

Regards,

Pranav