topic Re: long text upload problem from excel in Application Development and Automation Discussions

long text upload problem from excel

former_member420959 — Thu, 07 Nov 2013 14:33:53 GMT

hello,

i have an excel file with a column for long text in it.

im using TEXT_CONVERT_XLS_TO_SAP fm to upload to itab

but the long text field is filling only upto 255 characters.

searched a lot in sdn reagrding this and common solutins are:

use ALSM_EXCEL_TO_INTERNAL_TABLE fm

copy ALSM_EXCEL_TO_INTERNAL_TABLE and table strcuture in it and increase length of it

and use gui_upload.

i tried all these things but none worked out for me.

pls help

Ujwal

Re: long text upload problem from excel

FredericGirod — Thu, 07 Nov 2013 14:38:34 GMT

Hi,

for me the Excel file is limit to 40 char field long

if you want more, you must use CSV file

but maybe someone will have a better solution

regards

Fred

Re: long text upload problem from excel

former_member420959 — Thu, 07 Nov 2013 15:23:08 GMT

CSV file is not preferred by the user.

Anyways thanks for reply.

Ujwal

Re: long text upload problem from excel

Former Member — Thu, 07 Nov 2013 16:19:23 GMT

It took a little looking, but it looks like you could :

copy ALSM_EXCEL_TO_INTERNAL_TABLE to Z_ALSM_EXCEL_TO_INTERNAL_TABLE
copy structure ALSMEX_TABLINE to Z_ALSMEX_TABLINE changing value to a longer length.
Then work backward testing and correcting.

There'd be a whole lot of work to do to make it all work out in the end, but I'd think it could be done...

Neal

Re: long text upload problem from excel

Former Member — Thu, 07 Nov 2013 16:29:35 GMT

Looks like this note for ISOil pumps it up to 200 characters...

1739333

Neal

Re: long text upload problem from excel

Former Member — Thu, 07 Nov 2013 16:37:14 GMT

But maybe you'd like a simpler solution?

What if your users put the first 50 characters on the existing row. Then they insert additional rows with only long text up to 50 characters until they get the whole text in. In your logic, then you can assume that if the key cells are blank then the text should be appended to the long text of the last key...

Neal

Re: long text upload problem from excel

venkat_aileni — Thu, 07 Nov 2013 16:50:31 GMT

Hello Ujwal,

Kindly go through below link, a very useful Document written by Ranjan Mohanty.

http://scn.sap.com/docs/DOC-45423

-Venkat

Re: long text upload problem from excel

Former Member — Thu, 07 Nov 2013 17:04:37 GMT

That is one heck of a great find!

Re: long text upload problem from excel

former_member420959 — Fri, 08 Nov 2013 06:47:19 GMT

hi Venkat,

i have seen the link already and followed it.

but no use.its taking only 255 characters into internal table.

Ujwal

Re: long text upload problem from excel

Former Member — Fri, 08 Nov 2013 06:57:23 GMT

Hi Ujwal,

What is the field length of your internal table coumn ? Did you try gving more than 255 in the field length ?

Thanks,

Ajay Bose

Re: long text upload problem from excel

nabheetscn — Fri, 08 Nov 2013 07:03:20 GMT

Hi Ujwal

Did you create your Z FM with same length as mentioned in documents.. Please hsare your sample code.

Nabheet

Re: long text upload problem from excel

Former Member — Fri, 08 Nov 2013 10:28:43 GMT

Hi ,

Can you check this Internal Table Declaration in this document http://scn.sap.com/docs/DOC-45423

it takes more then 255 Character .

Regard's

Smruti

Re: long text upload problem from excel

former_member420959 — Fri, 08 Nov 2013 11:26:14 GMT

yes i gave 2000 characters

Re: long text upload problem from excel

former_member188282 — Fri, 08 Nov 2013 11:50:12 GMT

Hi UJwal,

First of all, some assumption MUST be made as how the input file will be formatted.

So, if you needed to update the long text id 'BEST' and object 'MATERIAL' of all materials given in a file, that file must have in its structure the material code, a line id and a fixed length field with the text. So if the long text for material code 10 comprises of 260 characters, you could requeste that the input txt file has the following structure (tab delimited):

matnr(18), line(3), line(100)

10(tab)1(tab) bla bla ..... (100 chars)

10(tab)2(tab) bla bla ...... (100 chars)

10(tab)3(tab) bla bla.... (remaining 60 characters)

the respective program then would be as follows:

REPORT zupload_texts.
EXTERNAL TABLES DEFINITIONS *************************
TABLES: mara.  
VARIABLES DEFINITIONS *****************************
DATA: wl_file TYPE string.  
INTERNAL TABLES DEFINITIONS *************************
DATA:  BEGIN OF i_data OCCURS 0,         matnr LIKE mara-matnr,         lino(3) TYPE n,         txt(100) TYPE c,       END OF i_data. DATA: wa_data LIKE i_data. DATA: i_lines LIKE tline OCCURS 15 WITH HEADER LINE,      i_thead LIKE thead.  
SELECTION SCREEN / OPTIONS - PARAMETERS *****************
SELECTION-SCREEN SKIP 2. SELECTION-SCREEN BEGIN OF BLOCK bl1 WITH FRAME.PARAMETERS:  p_file LIKE ibipparms-path OBLIGATORY DEFAULT 'C:\'.SELECTION-SCREEN SKIP 1.PARAMETERS: p_lang LIKE makt-spras OBLIGATORY DEFAULT sy-langu. SELECTION-SCREEN   END OF BLOCK bl1.  
INITIALIZATION  EVENT  ***************************
INITIALIZATION.  AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.  CALL FUNCTION 'F4_FILENAME'    IMPORTING      file_name = p_file.  
START OF SELECTION EVENTS ****************************
START-OF-SELECTION.
  MOVE p_file TO wl_file.
  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                = wl_file
      filetype                = 'ASC'
      has_field_separator     = ';'
    TABLES
      data_tab                = i_data
    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.
    WRITE:/ text-001.
    EXIT.
  ENDIF.
END-OF-SELECTION.
  LOOP AT i_data.
    wa_data = i_data.
    i_lines-tdformat = 'TX'.
    i_lines-tdline = i_data-txt.    " current line's characters
    APPEND i_lines.
"at the and of the material, save its long text
    AT END OF matnr.
      i_data = wa_data.
      DATA: w_size TYPE i.
      i_thead-tdname = '000000000000000000'.
      w_size = STRLEN( i_data-matnr ).
      w_size = 18 - w_size.
      i_thead-tdname+w_size = i_data-matnr.
      i_thead-tdobject = 'MATERIAL'.
      CALL FUNCTION 'CREATE_TEXT'
        EXPORTING
          fid         = 'BEST'
          flanguage   = p_lang
          fname       = i_thead-tdname
          fobject     = i_thead-tdobject
          save_direct = 'X'
          fformat     = '*'
        TABLES
          flines      = i_lines
        EXCEPTIONS
          no_init     = 1
          no_save     = 2
          OTHERS      = 3.
      IF sy-subrc <> 0.
        WRITE:/ text-002, i_data-matnr.
      ENDIF.
      CLEAR: i_lines, i_lines[].
    ENDAT.
  ENDLOOP.
  WRITE:/ 'Program ended'.

Regards,

Rajesh.B