topic Re: File upload. in Application Development and Automation Discussions

File upload.

sachin_mathapati — Tue, 23 Mar 2010 05:25:27 GMT

Hi All,

There is a text file which has special character at the end of every line.

I am uploading this text file into SAP using FM 'GUI_UPLOAD'.

Because of this special character, the data is not uploading into SAP properly.

Any pointers to resolve the above problem.

Thanks and Regards,

Sachin M M

Re: File upload.

Former Member — Tue, 23 Mar 2010 05:28:00 GMT

before passing the internal table to GUI_UPLOAD..

please remove that spl character from Internal table...

using replace stmt...

Re: File upload.

Former Member — Tue, 23 Mar 2010 05:29:14 GMT

Run a Check on the uploaded data (internal table) by looping through line by line (work area),

by using the statement -

IF <line> CN 'ABCDEFGH......1234567890'.

<discard line from being upload>

ENDIF.

Have you tried this approach already??

Regards

Dedeepya C

Re: File upload.

Former Member — Tue, 23 Mar 2010 06:19:52 GMT

Try to convert your XLS data to SAP.

Using below FM

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

I_LINE_HEADER = ''

I_TAB_RAW_DATA = IT_RAW " WORK TABLE

I_FILENAME = P_SOURCE

TABLES

I_TAB_CONVERTED_DATA = IT_DATATAB[] "ACTUAL DATA

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

IF SY-SUBRC EQ 0.

WRITE: 'ok'.

ENDIF.

Hope this helps.

Regards,

Neha Rai

Re: File upload.

Former Member — Tue, 23 Mar 2010 06:22:42 GMT

What is the file type you are using?

Re: File upload.

Former Member — Tue, 23 Mar 2010 06:24:47 GMT

Hi,,

to read the special character upload the excel file using FM

ALSM_EXCEL_TO_INTERNAL_TABLE

this will uplaod the special char as well.

hope this will help you in resolving your query

thanks,

tanmaya

Re: File upload.

sachin_mathapati — Tue, 23 Mar 2010 06:29:16 GMT

Hi Vikranth,

I am using 'ASC' file type.

Regards,

Sachin M M

Re: File upload.

Former Member — Tue, 23 Mar 2010 06:38:39 GMT

Hi Sachin,

Make sure you make has_field_seperator as 'X' if the text file is tab seperated. And did you declare a field for the special variable too in the upload internal table? If so what is the type of that field?

Vikranth

Re: File upload.

sachin_mathapati — Wed, 14 Jul 2010 05:10:43 GMT

thanks