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

Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:50:25 GMT

Hi All,

I have a text file which contains few records delimited by tab.

I am trying to upload the contents of the file into an internal table using the FM GUI_UPLOAD

But, I am getting run time error 'Type conflict when calling a function module'.

The code that I had written is shown below.

Please let me know where I went wrong.

REPORT Z84364BDC .

TYPES : BEGIN OF ITAB_TP,

MATNR TYPE MARA-MATNR,

EAN11 TYPE MARA-EAN11,

END OF ITAB_TP.

DATA : FILE_ITAB TYPE STANDARD TABLE OF ITAB_TP.

DATA : ITAB_WA TYPE ITAB_TP.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-T01.

PARAMETERS : P_FILE TYPE RLGRAP-FILENAME DEFAULT 'D:\Example.txt'.

SELECTION-SCREEN END OF BLOCK B1.

***FILLING THE INTERNAL TABLE****

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = P_FILE

FILETYPE = 'ASC'

has_field_separator = ','

tables

data_tab = FILE_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.

Re: Runtime error while using GUI_UPLOAD

SuhaSaha — Mon, 09 Feb 2009 08:52:00 GMT

Hello,

Its because of

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = P_FILE "--> Should be type STRING

Suhas

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:53:18 GMT

Then,

Could you please tell me how do I select the file name from the Selection screen.

Can you give me an example please?

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:55:05 GMT

Hi,

REPORT Z84364BDC .

TYPES : BEGIN OF ITAB_TP,

MATNR TYPE MARA-MATNR,

EAN11 TYPE MARA-EAN11,

END OF ITAB_TP.

DATA : FILE_ITAB TYPE STANDARD TABLE OF ITAB_TP.

DATA : ITAB_WA TYPE ITAB_TP.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-T01.
PARAMETERS : P_FILE TYPE RLGRAP-FILENAME DEFAULT 'D:\Example.txt'.
SELECTION-SCREEN END OF BLOCK B1.

DATA : g_file type string.


****FILLING THE INTERNAL TABLE*****
g_file = p_file
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = G_FILE            " Change
FILETYPE = 'ASC'
has_field_separator = ','
tables
data_tab = FILE_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.

If you are looking for F4 help..

at selection-screen on value-request for filename.
  call method CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG
      exporting
        MULTISELECTION = abap_false
        FILE_FILTER = '*.slnk'
        DEFAULT_EXTENSION = 'slnk'
      changing
        FILE_TABLE = retFileTable
        rc = retRc
        user_Action = retUserAction.
  read table retFileTable into fileName index 1.

Edited by: Avinash Kodarapu on Feb 9, 2009 2:25 PM

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:55:15 GMT

Hi,

the function module gui_upload, accepts the filename as a string variable....

hence do the following

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-T01.

PARAMETERS : P_FILE TYPE RLGRAP-FILENAME DEFAULT 'D:\Example.txt'.

SELECTION-SCREEN END OF BLOCK B1.

data : w_file type string.

w_file = p_file.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = W_FILE

FILETYPE = 'ASC'

has_field_separator = ','

tables

data_tab = FILE_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.

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:55:49 GMT

hi,

use it as parameter itself..

once after getting filename into p_file...

declare one variable of type string..i.e., v_file type string..

v_file = p_file.

in function gui_upload..

pass v_file..

Rgds.,

subash

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:56:26 GMT

Hi,

'Type conflict when calling a function module'.

Which means the filename should be of type "string"

parameter: P_file type string default'D:....'

try this one.

Regards

Vijay

Re: Runtime error while using GUI_UPLOAD

SuhaSaha — Mon, 09 Feb 2009 08:56:48 GMT

Hello,

Try like this:


DATA: V_FILE TYPE STRING.

V_FILE = P_FILE.

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = V_FILE

BR,

Suhas

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 08:57:21 GMT

hi ..

take

parameters p_file type string default'.....'

regards

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:01:09 GMT

Hi Babu,

Declare P_FILE of TYPE STRING.

Regards,

Nitin.

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:01:34 GMT

Hi,

While using variable which you will pass it to a FM, declare them according to the parameters of the FM.

If you check like that for gui_upload the file name is 'STRING' type.

w_file type string.
...

w_file = p_file.
"Now pass w_file to the FM

Regards,

Manoj Kumar P

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:02:48 GMT

Hi,

filename should be of type "string"

Declare like this

g_file type string.

Regards,

Jyothi CH.

Edited by: Jyothi Chinnabathuni on Feb 9, 2009 2:34 PM

Edited by: Jyothi Chinnabathuni on Feb 9, 2009 2:36 PM

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:07:56 GMT

Hi,

you need to maintain 'X' in has_field_seperator instead of ',' , y becoz it is tab delimited..

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'P_FILE'

FILETYPE = 'ASC'

has_field_separator = 'X' " File is TAB DELIMITED

tables

data_tab = FILE_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.

Regards

Kiran

Edited by: Kiran Saka on Feb 9, 2009 10:08 AM

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:10:44 GMT

Thanks one and all. Finally I got it.

But, there seems to be a problem in internal table.

My File contents are as below:

20,7000001

36,7255355

58,7252335

59,7250253

68,5235213

78,2533558

88,7285283

89,7250552

90,7253353

98,7022525

170,7225352

But, after running the above program the first field of internal table(file_itab-mara) is filled with all the above values.The second field has got nothing in it.

What could be the problem?

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:12:05 GMT

HI,

Using the F4 help option u can select the file name and path..

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

program_name = syst-repid

dynpro_number = syst-dynnr

field_name = ' '

CHANGING

file_name = p_file.

IF sy-subrc <> 0.

ENDIF.

hope this will help u.. use thsi one..

let me know if u face any more probs..

Regards

Vijay

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:12:14 GMT

hi,

in function moudle...put field separator as...

has_field_separator = 'X' " File is TAB DELIMITED

rgds.,

subash

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:13:10 GMT

Hi,

You should write file type as string .

see the bellow example.

DATA : FILE_ITAB TYPE STANDARD TABLE OF ITAB_TP.

DATA : ITAB_WA TYPE ITAB_TP.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-T01.

PARAMETERS : P_FILE TYPE RLGRAP-FILENAME DEFAULT 'D:\Example.txt'.

SELECTION-SCREEN END OF BLOCK B1.

DATA : g_file type string.

***FILLING THE INTERNAL TABLE****

if p_file is not initial.

g_file = p_file

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = G_FILE " Change

FILETYPE = 'ASC'

has_field_separator = ','

tables

data_tab = FILE_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.

Thanks,

Rajendra

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:14:36 GMT

The file is delimited by Comma field as mentioned above.

Below is the code that I had written. But, I face the same problem

REPORT Z84364BDC .

TYPES : BEGIN OF ITAB_TP,

MATNR TYPE MARA-MATNR,

EAN11 TYPE MARA-EAN11,

END OF ITAB_TP.

DATA : FILE_ITAB TYPE STANDARD TABLE OF ITAB_TP.

DATA : ITAB_WA TYPE ITAB_TP.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-T01.

PARAMETERS : P_PATH TYPE RLGRAP-FILENAME DEFAULT 'D:\Example.txt'.

SELECTION-SCREEN END OF BLOCK B1.

DATA : P_FILE TYPE STRING.

P_FILE = P_PATH.

****FILLING THE INTERNAL TABLE*****

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = P_FILE

FILETYPE = 'ASC'

has_field_separator = 'X'

tables

data_tab = FILE_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.

***Displaying the Material*****

LOOP AT FILE_ITAB INTO ITAB_WA.

WRITE:/ ITAB_WA-MATNR.

ENDLOOP.

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:15:42 GMT

Hi,

its a common problem with this FM "GUI_IPLAOD" i.e type conflict while passing parameters. U just need declare a string variable like:

DATA: T_FILE type STRING.

and then before calling function Module "GUIOUpload" assign your parameter value to this string variable.

T_FILE = P_FILE.

and then call function module like :

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = T_FILE " ***** passing parameter should type string (T_FILE)**************

FILETYPE = 'ASC'

has_field_separator = ','

tables

data_tab = FILE_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

Re: Runtime error while using GUI_UPLOAD

Former Member — Mon, 09 Feb 2009 09:17:39 GMT

Hi,

Write like this

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = P_FILE

FILETYPE = 'ASC'

has_field_separator = 'X' "Tab delimited

Regards,

Jyothi CH,