topic Re: Upload data into ZTABLE using GUI_UPLOAD in Application Development and Automation Discussions

Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Fri, 04 Oct 2013 15:49:04 GMT

Hi Friends,

I am using GUI_UPLOAD FM to upload data into database table(ZTABLE). ZTABLE is having three fields material, long description and owner. Since I am using GUI_UPLOAD I can upload only either tab delimited or .CSV file. So I am using .CSV file and i am using below code

LOOP AT IT_OUT1 INTO IS_OUT1.

READ TABLE IT_OUT1 INTO IS_OUT1 INDEX SY-TABIX.

LTEXT = IS_OUT1.

SPLIT LTEXT AT ',' INTO IS_OUT-MATNR IS_OUT-LONG_DESC IS_OUT-OWNER.

APPEND IS_OUT TO IT_OUT.

CLEAR IS_OUT1.

ENDLOOP.

IS_OUT1 is the output table from FM GUI_UPLOAD.

IS_OUT is the table to update ZTABLE.

Issue I am facing is : Long Descprition field is containing comma' s(,) in my file. So When I am splitting the text I can get long descprition only till first comma.

Hope you got my problem. Please suggest if you get anything.

Thanks,

Gowrinath.

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 02:27:18 GMT

Hi Gowrinath,

Maybe you can change the comma separator with the semi colon separator, in your pc's settings. So when you create .CSV file, it will use the semicolon separator. And you can use this in split instruction.

Regards,

Renzo.

Re: Upload data into ZTABLE using GUI_UPLOAD

Arun_Prabhu_K — Sat, 05 Oct 2013 03:16:31 GMT

Hello Gowrinath.

I would suggest you to use the FM TEXT_CONVERT_XLS_TO_SAP to upload .xls / .xlsx / .txt etc. data to internal table.

Then if you have an internal table of the same structure as the Z table, you can upload the data at one shot.

For instance,

TYPES: begin of ttab.

INCLUDE STRUCTURE Ztable.

TYPES: end of ttab.

DATA : itab TYPE TABLE OF ttab WITH HEADER LINE.

modify Ztable from table itab. "(If record with same primary key exists, this will UPDATE

Else INSERT into Ztable)

COMMIT WORK.

Regards.

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 04:19:21 GMT

If i am getting this right, the only problem is comma in long description field.

Why dont u you simply the Statement:

 LOOP AT IT_OUT1 INTO IS_OUT1.
  READ TABLE IT_OUT1 INTO IS_OUT1 INDEX SY-TABIX.
Replace all occurance of ',' in is_out1-long_description with ''.
    APPEND IS_OUT TO IT_OUT.
    CLEAR IS_OUT1.
 ENDLOOP.

( this will remove all comma's from the field)

Let me know if i am still not getting your Problem.

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 04:35:43 GMT

First of all...

what is the use for these 2 line..

READ TABLE IT_OUT1 INTO IS_OUT1 INDEX SY-TABIX.

LTEXT = IS_OUT1.

I guess there is no need of read table. and assigning data in new variable. You can use code...

LOOP AT IT_OUT1 INTO IS_OUT1.

clear IS_OUT.

SPLIT IS_OUT1 AT ',' INTO IS_OUT-MATNR IS_OUT-LONG_DESC IS_OUT-OWNER.

APPEND IS_OUT TO IT_OUT.

CLEAR IS_OUT1.

ENDLOOP.

I think we can't handle this error from here,You need to make some changes , while calling GUI_UPLOAD FM.

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 04:48:34 GMT

Dear, If he will remove all the comma's, how he will split his data based on condition..

in LTEXT i guess data is coming like this. 09304,raw,data,sap

His problem is now while he is splitting his data (raw,data -- is long_description but due to , only Raw is coming in long desc. )

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 04:50:30 GMT

It would be great if you share some more code with us. Esp that FM GUI_UPLOAD logic, you have written in your program

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 05:40:49 GMT

Hi Arun,

Field for Long Description have to store more than 255 characters. ie the reason why i went for GUI_UPLOAD. Will FM suggested by you stores more than 500 characters.

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 06:06:30 GMT

Hi Renzo,

I appreciate your answer.

But I can't suggest my client to change the settings. Is there any other way to figure out the problem. I believe FM GUI_UPLOAD supports only .CSV and .txt files and output internal table is having only field(text). Please correct if I am wrong.

Gowrinath.

Re: Upload data into ZTABLE using GUI_UPLOAD

Arun_Prabhu_K — Sat, 05 Oct 2013 06:19:54 GMT

Haven't come across this issue before.

The FM I suggested cannot read more than 255 characters.

For your problem, try making use of individual field length to fetch the data into separate fields.

Like Material = ltext+0(18) (18-Material field length)

Long text = ltext+18(500) (500-Long description field length) and

Owner = ltext+518(N). (N-Owner field length, which I don't know )

Regards.

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 06:34:01 GMT

Hi Arun,

Thank You.

What if my file contains data as following

Material Description Owner

d32231 Bag *****

d5656555..(upto 18 characters) shoes..... *****

Material number may not be 18 characters all the time.So while splitting if we use code suggested by you then there is a chance of description to enter into material field.

Thanks,

Gowri.

Re: Upload data into ZTABLE using GUI_UPLOAD

Arun_Prabhu_K — Sat, 05 Oct 2013 08:00:41 GMT

On seeing your data, if you upload the file, automatically via GUI_UPLOAD it will go into the individual fields of internal table provided the fields are tab delimited in the file.

Between each field, if tab delimiter is maintained,right?

If it so, then why worrying about splitting?

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 08:42:17 GMT

Share the code you have written for FM GUI_UPLOAD.. I think some issue with that only.

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 09:06:02 GMT

Hi Gowrinath

Yes FM GUI_UPLOAD can only upload Tab Delimited and CSV format.

Since you are uploading long text data i would suggest your client to user tab delimited format when they are saving the file in excel.

The other way around this problem is that u need to write a code to filter out all the commas and only use first and the last one.

matno,de,scri,pti,on,owner

like above u need to use only first and the last comma rest are part of your long text.

Regards
Arpit Gupta

Re: Upload data into ZTABLE using GUI_UPLOAD

Former Member — Sat, 05 Oct 2013 09:49:49 GMT

Hi Gowrinath,

You can try copying the standard FM TEXT_CONVERT_XLS_TO_SAP.

Copy the standard structure and make it to whatever field length you want.

Just try it out. There is nothing to lose in trying. 🙂

Ajay Bose

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 13:55:28 GMT

Hi Chandra,

Below is the code I am using

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = v_file

FILETYPE = 'ASC'

* HAS_FIELD_SEPARATOR = 'X'

* HEADER_LENGTH = 0

* READ_BY_LINE = '#'

* DAT_MODE = 'X'

* CODEPAGE = ' '

* IGNORE_CERR = ABAP_TRUE

* REPLACEMENT = '#'

* CHECK_BOM = ' '

* VIRUS_SCAN_PROFILE =

* NO_AUTH_CHECK = ' '

* IMPORTING

* FILELENGTH =

* HEADER =

TABLES

DATA_TAB = IT_OUT1

* 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.

LOOP AT IT_OUT1 INTO IS_OUT1.

READ TABLE IT_OUT1 INTO IS_OUT1 INDEX SY-TABIX.

LTEXT = IS_OUT1.

SPLIT LTEXT AT ',' INTO IS_OUT-MATNR IS_OUT-LANGU IS_OUT-NAME IS_OUT-COLOR IS_OUT-SHORT_DESC IS_OUT-LONG_DESC IS_OUT-STATUS_CAT IS_OUT-EMP_DISC IS_OUT-PRICE_BOOK IS_OUT-DROPSHIP.

APPEND IS_OUT TO IT_OUT.

CLEAR IS_OUT1.

ENDLOOP.

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 13:56:16 GMT

Sorry Arun I am supposed to use only .CSV file.

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 14:01:47 GMT

Is there any possibility of preparing final internal table without splitting?

Re: Upload data into ZTABLE using GUI_UPLOAD

gowrinath_gundu — Sat, 05 Oct 2013 15:39:25 GMT

Hi Friends,

I came up with idea of moving long descprition field of my file to last. Need to discuss with client.

One more issue: Since my long description is more tha 255 characters I am using a field of type string to store this data in database table .But in my programs when I am using that table, For example,

TABLES : ZTEST.

DATA : IT TYPE STANDARD TABLE OF ZTEST.

I am getting below error

"ZTEST" must be a flat structure. You cannot use internal tables, strings,

references, or structures as components

(ZTEST is having field LONG_DESC of type string)

Please suggest.

Thanks,

Gowrinath.

Re: Upload data into ZTABLE using GUI_UPLOAD

former_member392866 — Sat, 05 Oct 2013 18:30:36 GMT

Hi Gowrinath,

the solution given by Gupta should solve your problem(By considering first & last commas) ...

You should give rewards to the persons who solves the problem (or) helps to solve the problem .

For any other problems/suggestions please open a new discussion and close the current discussion .

If you do like this in future the searching criteria will be helpful to others who gets the same type of issues.

Please don't integrate multiple questions in one discussion. Thank you .

Regards,

Balaji.