topic Re: error while using GUI_UPLOAD in Application Development and Automation Discussions

error while using GUI_UPLOAD

former_member654348 — Fri, 20 Feb 2009 06:11:14 GMT

I am using GUI_UPLOAD to transfer the data from flat file ( | separated) into the internal table.

But while executing, its giving error like 'cannot interpret the data in the file'.

kindly help me out in this regard.

Re: error while using GUI_UPLOAD

former_member632729 — Fri, 20 Feb 2009 06:15:47 GMT

Hi,

Check the parameters what ur passing ... exact or not...

for more info go through this link:[http://www.experts-exchange.com/Database/Software/ERP/SAP_ERP/Q_21278801.html]

Re: error while using GUI_UPLOAD

Former Member — Fri, 20 Feb 2009 06:22:19 GMT

used HAS_FIELD_SEPARATOR in import parameters?

Re: error while using GUI_UPLOAD

former_member654348 — Fri, 20 Feb 2009 06:25:51 GMT

yes, I am exporting this parameter.

Check the code.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = filename

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = i_tab1

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Re: error while using GUI_UPLOAD

Former Member — Fri, 20 Feb 2009 06:40:24 GMT

check formats of any date/time/qauntity fields in ur upload file

Re: error while using GUI_UPLOAD

Former Member — Fri, 20 Feb 2009 08:22:52 GMT

you can take the table like

Types: begin of gty_texts_file,

line(500) type c,

end of gty_texts_file.

data: gt_text_file type table of gty_texts_file.

you can pass this table to your FM

Re: error while using GUI_UPLOAD

RaymondGiuseppi — Fri, 20 Feb 2009 08:42:38 GMT

I fear that GUI_UPLOAD expects a TAB(TYPE X VALUE '09') separator, not a '|'.

Regards

Re: error while using GUI_UPLOAD

Former Member — Mon, 23 Feb 2009 07:51:34 GMT

Hi,

It is better you use Fm WS_UPLOAD.

regards,

Lokesh

Re: error while using GUI_UPLOAD

Former Member — Mon, 23 Feb 2009 09:41:55 GMT

Hi,

check with the parameters passing in the function module like file name and file type...

Regards,

Madhu

Re: error while using GUI_UPLOAD

Former Member — Thu, 02 Apr 2009 14:33:51 GMT

I think the filename your are passing is not of string type.

I think you are taking file from user by using f4 and so its datatype is not string but rplg-filename

so make another variable of type string and store the filename into that

Re: error while using GUI_UPLOAD

Former Member — Fri, 03 Apr 2009 04:54:40 GMT

hi,

check all the fields are matching comparing with file and internal table. and close the file when u r exicuting the program. use the following code

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename =

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'x '

HEADER_LENGTH = 0
READ_BY_LINE = 'X'
DAT_MODE = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
CHECK_BOM = ' '
VIRUS_SCAN_PROFILE =
NO_AUTH_CHECK = ' '
IMPORTING
FILELENGTH =
HEADER =

tables

data_tab = itab.

EXCEPTIONS
FILE_OPEN_ERROR = 1
FILE_READ_ERROR = 2
NO_BATCH = 3
GUI_REFUSE_FILETRANSFER = 4
INVALID_TYPE = 5
NO_AUTHORITY = 6
UNKNOWN_ERROR = 7
BAD_DATA_FORMAT = 8
HEADER_NOT_ALLOWED = 9
SEPARATOR_NOT_ALLOWED = 10
HEADER_TOO_LONG = 11
UNKNOWN_DP_ERROR = 12
ACCESS_DENIED = 13
DP_OUT_OF_MEMORY = 14
DISK_FULL = 15
DP_TIMEOUT = 16
OTHERS = 17

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

hope it will help

~linganna