GUI_UPLOAD

[Former Member]

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

[Former Member]

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 ?

[Former Member]

hi sasi ,

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

[Former Member]

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 ..

[Former Member]

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.

[Former Member]

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

[Former Member]

hi sasi ,

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi sasi ,

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

[Former Member]

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