topic Re: GUI_UPLOAD in Application Development and Automation Discussions

GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 10:52:42 GMT

hi gurus ,

i'm using gui_upload for uploading a file from excel to sap . . now problem is .. when upload 8 gb file into sap using gui_upload what would be the probloem i would face .. Please Let me know how to get recovery from that problem . thanks

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 10:57:01 GMT

Probably the system would get hanged up. You might have to do it in pieces and are you talking about an 8 GB Excel File ?

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 10:58:27 GMT

hi sasi ,

thanks for ur answer .. what u mean doin it in pieces ...

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 10:59:36 GMT

Hi Prem,

There is a limitation for excel that only some 65000 line can be there.

As an alternative, you can go for a TAB delimited text file.

Regards,

Ravi

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:00:09 GMT

hi sasi ,

for example i have 100 records in excel . can i upload 10 and next 10 as follows records pls let me know if it is possible . i think is not possible to do that ..

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:02:02 GMT

hi sasi ,

is it possible to have n number of rercords in tab delimited file

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:02:35 GMT

When you upload, do not upload the whole excel at once. consider uploading some 10K records( or wherever you think your program breaks). at a time. There are some threads on the huge upload in SDN, Please search for them if i come across any of them i'll let u know.

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:03:43 GMT

Hi,

yes it is possible for sure........

using the function module

ALSM_EXCEL_TO_INTERNAL_TABLE.... mention the begin row and end_row fields in it... and you will get only those many records from Excel.

Regards,

Siddarth

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:04:22 GMT

hi sasi ,

thanks for ur useful reply . please let me know to upload in packets . thanks

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:05:19 GMT

If possible go for an LSMW or BDC. In my opinion GUI_UPLOAD would be a least preference

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:07:44 GMT

hi siddarath ,

i'm using crm server so i cant use alsm function module only i can use only gui_upload . please let me know in gui_upload i need to upload in packets

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:09:03 GMT

Hi Premchander,

did you try with FM ALSM_EXCEL_TO_INTERNAL_TABLE... this really works.... I have used it in my requirements... and it had solved the purpose....

Regards,

Siddarth

Re: GUI_UPLOAD

Former Member — Mon, 27 Apr 2009 11:12:54 GMT

Hi,

give a try with ALSM function module once, if it works, if it doesnot, i dont think with GUI_UPLOAD it is possible..........

Is it possible for you to use OLE....

if so... then you can use that

Regards,

Siddarth