topic Re: GUI_UPLOAD in Application Development and Automation Discussions

GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 19:23:49 GMT

Thanks everyone for replying to my earlier question, seems that becoz of some issue, I couldnt see the left option to reward points to any of you... I am sorry for that.

I have seen people have replied saying do not use GUI_UPLOAD, Is there any reason on not using this FM?

My problem is still persistent, I think I have to move file and see that might help me.

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 19:26:15 GMT

Hi Pranav,

GUI_UPLOAD is normally used to upload text files. For uploading excel file, its better to use <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b>.

Regards

Aneesh.

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 19:33:38 GMT

Did you change the forward slash to a back slash?

FILENAME = 'C:\myfile.xls'

Rob

Message was edited by:

Rob Burbank

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 19:38:25 GMT

Yes Rob, I did that too and even I closed the file as well, but then also no success.

Do I need to put url into some variable and then use that ?

Here is what all I checked :

File is not open

I went to windows explorer and typed file name which i have given in function module and I can see the file with data into that.

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 19:43:30 GMT

In the root directory?

Rob

Re: GUI_UPLOAD

rodrigo_paisante3 — Tue, 03 Jul 2007 19:43:57 GMT

What is your version??

Maybe this is a bug...

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 19:55:28 GMT

In your original program using GUI_UPLOAD, were you getting a dump or an error message?

Rob

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 20:22:24 GMT

Hi,

You can not upload an XLS file using GUI_UPLOAD. Please use following FM to upload XLS files:\

FAA_FILE_UPLOAD_EXCEL

TEXT_CONVERT_XLS_TO_SAP

ALSM_EXCEL_TO_INTERNAL_TABLE

In ALSM_EXCEL_TO_INTERNAL_TABL, you have to format the uploaded date before using it. So, use FAA_FILE_UPLOAD_EXCEL which internally calls ALSM_EXCEL_TO_INTERNAL_TABL, formats data and gives back formatted data in an internal table.

<b>

Also, use '\' instead of '/' in C:/myfile.xls'.</b>

You can also call a FM 'F4_FILENAME' to get the file.

Reward points if the answer is helpful.

Regards,

Mukul

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 20:43:23 GMT

I have moved my code to another SAP system and there I am not getting error message for file not available but I am getting some absurd dump message...

have long chain of "###################################### sheet1 ............................ ########### sheet 2.........

something of this type...

When i am replacing the xsl to txt and create .txt file, it works ...

Re: GUI_UPLOAD

RichHeilman — Tue, 03 Jul 2007 20:49:07 GMT

Again, if you did not download the file using GUI_DOWNLOAD, then you will get junk data when trying to use GUI_UPLOAD, so you need to use the mentioned(example in your other thread) function module which uses OLE technology to upload.

Regards,

RIch Heilman

Re: GUI_UPLOAD

Former Member — Tue, 03 Jul 2007 21:03:22 GMT

Does it mean that I need to use GUI_DOWNLOAD before GUI_UPLOAD ?

Message was edited by:

pranav .

Re: GUI_UPLOAD

RichHeilman — Tue, 03 Jul 2007 21:07:47 GMT

If that is the requirement. But it could be that this file is not created by SAP, it could be some other system creating this file, right? In that case, it does not make sense to use GUI_DOWNLOAD. The idea here is that if you download the data to PC using GUI_DOWNLOAD and setting the parameter, WRITE_COLUMN_SEPERATOR(something like this), then the system will write the file in such a way that it is easily read back using GUI_UPLOAD and you would set the parameter HAS_COLUMN_SEPERATOR(i think that is the name). Otherwise, you need to upload the excel file using the said funciton module, or writing your OLE code.

REgards,

Rich HEilman