topic Re: Using GUI_UPLOAD in Application Development and Automation Discussions

Using GUI_UPLOAD

Former Member — Thu, 11 Dec 2008 15:13:12 GMT

Hello,

I recently ran the GUI_UPLOAD FM and successfully uploaded a comma seperated txt file. I have verified the contents of the DATA_TAB with 1,304 records. Now that the file has been uploaded do I use GUI_UPLOAD to read the file as well? Also, can you advise as to the physical location where the file exists in SAP?

Thanks in advance for any assistance.

Re: Using GUI_UPLOAD

Former Member — Thu, 11 Dec 2008 15:15:01 GMT

see upload is for uploading the file to the application server you need to find out what is the transaction you were updating.

Check the following tables where you have inserted the data.

Re: Using GUI_UPLOAD

Former Member — Thu, 11 Dec 2008 15:23:57 GMT

Thank you for your reply,

I ran the FM from transaction SE80. I did not update any tables with the data from the txt file. I only uploaded the txt file.

How can I now read the txt file via ABAP?

Thanks again,

Re: Using GUI_UPLOAD

Former Member — Thu, 11 Dec 2008 15:28:27 GMT

Hi Christopher,

I am not sure if I understood your question right, but the uploaded Raw data can be converted into an internal table using the FM TEXT_CONVERT_XLS_TO_SAP if the uploaded file is an Excel. Define the table used for this FM similar to the structure of the file uploaded.

Depending upon the type of file uploaded, use the respective FM.

TEXT_CONVERT_CSV_TO_SAP

TEXT_CONVERT_TEX_TO_SAP

TEXT_CONVERT_TXT_TO_SAP

TEXT_CONVERT_XLS_TO_SAP

TEXT_CONVERT_XML_TO_SAP

Not sure if that was what you are looking for, but please let us know!

Vijay

Edited by: Vijay V on Dec 11, 2008 4:30 PM

Re: Using GUI_UPLOAD

Former Member — Thu, 11 Dec 2008 15:40:17 GMT

Thanks ViJay,

I'll check out the TEXT_CONVERT_CSV_TO_SAP FM.

I suppose what I am most unclear about at this point is, outside of defining an internal table structure like the txt file, how do I go about referencing the uploaded txt file in order to populate the internal table with the data from the txt file?

Thanks again for your assistance,