topic Add Attachment in Application Development and Automation Discussions

Add Attachment

Former Member — Tue, 28 Oct 2008 10:40:03 GMT

Hi,

i try to Add attachment to mail the i send (i use class bcs) ,

and i have

document->add_attachment( EXPORTING i_attachment_type = 'RAW' " First Attachment

i_attachment_subject = 'attach1.txt'

i_att_content_text = lt_attach ).

Re: Add Attachment

uwe_schieferstein — Tue, 28 Oct 2008 10:43:22 GMT

Hello Ferry

Have you had already a look at sample report BCS_EXAMPLE_5 ?


REPORT bcs_example_5.

* This example shows how to send
*   - a simple text provided in an internal table of text lines
*   - and an attached MS word document provided in internal table
*   - to some internet email address.
*
* All activities done via facade CL_BCS!
...

Regards

Uwe

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 10:44:38 GMT

what is the problem you are facing..?

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 10:44:52 GMT

HI ,

Sorry i don't complete my first massge .

when i run the progarm i get dump.

this is what i get:

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_REF_IS_INITIAL', was not

caught and

therefore caused a runtime error.

The reason for the exception is:

An attempt was made to access a component (variable: "DOCUMENT") with a 'ZERO

object reference (points to 'nothing').

An object reference must point to an object (an instance of a class)

before it can be used to access a component.

Either the reference has not yet been set or it was set to 'ZERO' using

a CLEAR statement.

APPEND 'Test Attachment' TO lt_attach.

 document->add_attachment( EXPORTING i_attachment_type    = 'RAW'    " First Attachment
                                        i_attachment_subject = 'Test'
                                        i_att_content_text   = lt_attach
                                        i_attachment_size = '21' ).

what i miss here?

Best Regards

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 10:47:53 GMT


document->add_attachment( EXPORTING i_attachment_type    = 'RAW'    " First Attachment
                                        i_attachment_subject = 'Test'
                                        i_att_content_text   = lt_attach
                                        i_attachment_size = '12' ).  "try with 12

also check the example mentioned above by UWE it is a good example.

Did you create the document object..?

Edited by: Vijay Babu Dudla on Oct 28, 2008 6:48 AM

Re: Add Attachment

uwe_schieferstein — Tue, 28 Oct 2008 10:50:41 GMT

Hello Ferry

Before using the document instance you need to create it:


*---------------------------------------------------------------------*
*       FORM main                                                     *
*---------------------------------------------------------------------*
FORM main.

  try.
*     -------- create persistent send request ------------------------
      send_request = cl_bcs=>create_persistent( ).

*     -------- create and set document with attachment ---------------
*     create document from internal table with text
      APPEND 'Hello world!' TO text.
      document = cl_document_bcs=>create_document(
                      i_type    = 'RAW'
                      i_text    = text
                      i_length  = '12'
                      i_subject = 'test created by BCS_EXAMPLE_2' ).

*     add attachment to document
*     BCS expects document content here e.g. from document upload
*     binary_content = ...
      CALL METHOD document->add_attachment
        EXPORTING  i_attachment_type = 'DOC'
                   i_attachment_subject = 'My attachment'
                   i_att_content_hex    = binary_content.

*     add document to send request
      CALL METHOD send_request->set_document( document ).
...

Regards

Uwe

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 10:52:27 GMT

Hi Vijay ,

Thanks,

i try to Change the number like u write and i have the same error .

Regards

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 11:06:50 GMT

did you check the example program BCS_EXAMPLE_5, if you are still getting the error post the code. did you call the method create_document inside your program.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 11:15:01 GMT

Hi Uwe ,

thanks i Try your code (bcs_example_5) and i don't get dump!

the problem now is that i dont get the attchment (i get the mail) ,maybe u have idea ?

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 11:24:21 GMT

try to pass some attachement and see.

CALL METHOD document->add_attachment
        EXPORTING  i_attachment_type = 'DOC'
                   i_attachment_subject = 'My attachment'
                   i_att_content_hex    = binary_content.  "if you don;t have any content in this
"you will not get any attachment.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 11:28:59 GMT

Hi Vijay,

Thanks,

what i add to my code is exactly this:

APPEND 'Hello world!' TO lt_attach.
    document = cl_document_bcs=>create_document(
                    i_type    = 'RAW'
                    i_text    = lt_attach
                    i_length  = '12'
                    i_subject = 'test created by BCS_EXAMPLE_2' ).

    CALL METHOD document->add_attachment
      EXPORTING
        i_attachment_type    = 'DOC'
        i_attachment_subject = 'My attachment'
        i_att_content_hex    = binary_content.

*     add document to send request
      CALL METHOD send_request->set_document( document ).

How i bring content to binary_content ?

P.S. when i add the line :

CALL METHOD send_request->set_document( document ).

i still get the dump that i had before.

Best Regards

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 11:32:47 GMT

show the complete code. the example working fine for me, i am getting the attachment also. but it is empty one. do one thing copy the code exacly and check. some where you are doing a mistake.

if you are not able to proceed show your code once.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 11:57:27 GMT

Hi Vigay,

&----

*& Report YY_SEND_MAIL

&----

REPORT yy_send_mail.

TYPE-POOLS abap.

DATA: lo_send_request TYPE REF TO cl_bcs,

send_request TYPE REF TO cl_bcs,

lo_document TYPE REF TO cl_document_bcs,

lo_recipient TYPE REF TO cl_cam_address_bcs,

lo_exception TYPE REF TO cx_bcs,

lv_sent_to_all TYPE os_boolean,

lt_attach TYPE soli_tab, " Attachment content

lt_flds TYPE TABLE OF w3fields WITH HEADER LINE,

document TYPE REF TO cl_document_bcs,

bcs_exception TYPE REF TO cx_bcs,

lv_error_txt TYPE string,

lt_header TYPE TABLE OF w3head WITH HEADER LINE,

lt_html TYPE TABLE OF w3html WITH HEADER LINE,

ls_tab_header TYPE w3head.

DATA: binary_content TYPE solix_tab.

DATA : lt_comp_tab TYPE abap_component_tab WITH HEADER LINE,

tab_ref TYPE REF TO data,

line_ref TYPE REF TO data,

line_type TYPE REF TO cl_abap_structdescr,

tab_type TYPE REF TO cl_abap_tabledescr,

data_describer TYPE REF TO cl_abap_datadescr.

FIELD-SYMBOLS : <table> TYPE table,

<line> TYPE any,<field> TYPE any.

PARAMETERS : table TYPE tabname DEFAULT 'HRP1001' ,

fld1 TYPE fieldname DEFAULT 'OTYPE',

fld2 TYPE fieldname DEFAULT 'OBJID',

mailto TYPE adr6-smtp_addr .

------For Dynmic Selection of table & fields -

TRY.

lt_comp_tab-name = fld1.

lt_comp_tab-type ?= cl_abap_datadescr=>describe_by_data( field1 ).

APPEND lt_comp_tab.

lt_comp_tab-name = fld2.

lt_comp_tab-type ?= cl_abap_datadescr=>describe_by_data( field2 ).

APPEND lt_comp_tab.

CATCH cx_sy_move_cast_error.

EXIT.

ENDTRY.

TRY.

line_type ?= cl_abap_structdescr=>create( lt_comp_tab[] ).

tab_type ?= cl_abap_tabledescr=>create( line_type ).

CATCH cx_sy_move_cast_error.

ENDTRY.

CREATE DATA : tab_ref TYPE HANDLE tab_type,

line_ref TYPE HANDLE line_type.

ASSIGN tab_ref->* TO <table>.

ASSIGN line_ref->* TO <line>.

Select Data--

perform select_data_from_table.

MOVE : 'Table Data' TO ls_tab_header-text,

'Arial' TO ls_tab_header-font,

'2' TO ls_tab_header-size.

LOOP AT lt_comp_tab.

MOVE lt_comp_tab-name TO lt_header-text.

MOVE : sy-tabix TO lt_header-nr,

'red' TO lt_header-bg_color.

APPEND lt_header.

ENDLOOP.

CALL FUNCTION 'WWW_ITAB_TO_HTML'

EXPORTING

table_header = ls_tab_header

TABLES

html = lt_html[]

fields = lt_flds[]

row_header = lt_header[]

itable = <table>.

TRY.

lo_send_request = cl_bcs=>create_persistent( ).

lo_document = cl_document_bcs=>create_document( i_type = 'HTM'

i_text = lt_html[]

i_subject = 'Table' ).

APPEND 'Hello world!' TO lt_attach.

document = cl_document_bcs=>create_document(

i_type = 'RAW'

i_text = lt_attach

i_length = '12'

i_subject = 'test created by BCS_EXAMPLE_2' ).

CALL METHOD document->add_attachment

EXPORTING

i_attachment_type = 'DOC'

i_attachment_subject = 'My attachment'

i_att_content_hex = binary_content.

add document to send request

CALL METHOD send_request->set_document( document ).

lo_send_request->set_document( lo_document ).

lo_recipient = cl_cam_address_bcs=>create_internet_address( mailto ).

lo_send_request->add_recipient( EXPORTING i_recipient = lo_recipient

i_express = 'X' ).

lo_send_request->set_send_immediately( 'X' ).

lv_sent_to_all = lo_send_request->send( 'X' ).

COMMIT WORK.

ENDTRY.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 12:11:52 GMT

"comment the below line 
"CALL METHOD send_request->set_document( document ).  "since no object send_request
"in your example

lo_send_request->set_document( lo_document ).
lo_recipient = cl_cam_address_bcs=>create_internet_address( mailto ).
lo_send_request->add_recipient( EXPORTING i_recipient = lo_recipient
i_express = 'X' ).
lo_send_request->set_send_immediately( 'X' ).
lv_sent_to_all = lo_send_request->send( 'X' ).
COMMIT WORK.

ENDTRY.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 12:24:41 GMT

Hi Vijay ,

Thanks ,

i do that but still don't get the attchment,maybe u have other idea?

Regards

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 12:27:37 GMT

Hi Ferry,

You are using two instances of classes

1) cl_document_bcs ( lo_document & document ) &

2) cl_bcs ( lo_send_request & send_request ).

You are getting the dump bcoz u r creating the instance lo_send_request but using the instance send_request !!!.

Same is being done with the instances of cl_document_bcs.

use any one(only one) of the two instances...

Check the corrected code below, Here i have attached the same

html file.

TYPE-POOLS abap.

DATA: lo_send_request TYPE REF TO cl_bcs,
send_request TYPE REF TO cl_bcs,
lo_document TYPE REF TO cl_document_bcs,
lo_recipient TYPE REF TO cl_cam_address_bcs,
lo_exception TYPE REF TO cx_bcs,
lv_sent_to_all TYPE os_boolean,
lt_attach TYPE soli_tab, " Attachment content
lt_flds TYPE TABLE OF w3fields WITH HEADER LINE,
document TYPE REF TO cl_document_bcs,
bcs_exception TYPE REF TO cx_bcs,
lv_error_txt TYPE string,
lt_header TYPE TABLE OF w3head WITH HEADER LINE,
lt_html TYPE TABLE OF w3html WITH HEADER LINE,
ls_tab_header TYPE w3head.
DATA: binary_content TYPE solix_tab.

DATA : lt_comp_tab TYPE abap_component_tab WITH HEADER LINE,
tab_ref TYPE REF TO data,
line_ref TYPE REF TO data,
line_type TYPE REF TO cl_abap_structdescr,
tab_type TYPE REF TO cl_abap_tabledescr,
data_describer TYPE REF TO cl_abap_datadescr.


FIELD-SYMBOLS : <table> TYPE table,
<line> TYPE ANY,<field> TYPE ANY.

PARAMETERS : table TYPE tabname DEFAULT 'HRP1001' ,
fld1 TYPE fieldname DEFAULT 'OTYPE',
fld2 TYPE fieldname DEFAULT 'OBJID',
mailto TYPE adr6-smtp_addr .

TRY.
    lt_comp_tab-name = fld1.
    lt_comp_tab-type ?= cl_abap_datadescr=>describe_by_data( fld1 ).
    APPEND lt_comp_tab.
    lt_comp_tab-name = fld2.
    lt_comp_tab-type ?= cl_abap_datadescr=>describe_by_data( fld2 ).
    APPEND lt_comp_tab.
  CATCH cx_sy_move_cast_error.
    EXIT.
ENDTRY.

TRY.
    line_type ?= cl_abap_structdescr=>create( lt_comp_tab[] ).
    tab_type ?= cl_abap_tabledescr=>create( line_type ).
  CATCH cx_sy_move_cast_error.
ENDTRY.

CREATE DATA : tab_ref TYPE HANDLE tab_type,
line_ref TYPE HANDLE line_type.

ASSIGN tab_ref->*  TO <table>.
ASSIGN line_ref->* TO <line>.

SELECT * FROM (table) INTO CORRESPONDING FIELDS OF TABLE <table> UP TO 10 ROWS.

MOVE : 'Table Data' TO ls_tab_header-text,
       'Arial'      TO ls_tab_header-font,
       '2'          TO ls_tab_header-size.

LOOP AT lt_comp_tab.
  MOVE lt_comp_tab-name TO lt_header-text.
  MOVE : sy-tabix TO lt_header-nr,
         'red'    TO lt_header-bg_color.
  APPEND lt_header.
ENDLOOP.

CALL FUNCTION 'WWW_ITAB_TO_HTML'
  EXPORTING
    table_header = ls_tab_header
  TABLES
    html         = lt_html[]
    fields       = lt_flds[]
    row_header   = lt_header[]
    itable       = <table>.

TRY.
    lo_send_request = cl_bcs=>create_persistent( ).
    lo_document = cl_document_bcs=>create_document( i_type = 'HTM'
                                                    i_text = lt_html[]
                                                    i_subject = 'Table' ).
    lo_document->add_attachment( i_attachment_type    = 'HTM'
                                 i_attachment_subject = 'My attachment'
                                 i_att_content_text   = lt_html[] ).
    lo_send_request->set_document( lo_document ).
    lo_recipient = cl_cam_address_bcs=>create_internet_address( mailto ).
    lo_send_request->add_recipient( EXPORTING i_recipient = lo_recipient
    i_express = 'X' ).
    lo_send_request->set_send_immediately( 'X' ).
    lv_sent_to_all = lo_send_request->send( 'X' ).
    COMMIT WORK.
  CATCH cx_bcs INTO bcs_exception.
ENDTRY.

Cheers,

Jose.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 12:41:07 GMT

HI Jose,

Thanks ! ,

when i copy your program to new i get the attachment , i try to find the diff now.

i don't understand way i don't get it because i remove the line of the code like Vijay says and i still don't get it in my code.

i get the attachment in HTM file maybe u can give example how can i get it with word/excel ?

Best Regards

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 12:53:27 GMT

i just looked for the line which caused the dump. the bcs example is very informative check it once.

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 13:04:01 GMT

HI Vijay,

Thanks i do it now.

now i have other problem when i write words in the attachment i see it in the word document with space and with strange square between the words maybe u have idea ?

e.g. if i write Hello world i get just the word hello with square between the words.when i do copy paste it don't bring the square.

H e l l o

Regards

Re: Add Attachment

Former Member — Tue, 28 Oct 2008 13:10:50 GMT

that is binary format. if you have some word document you can send it. in otherway you can try some thing like this..

data: text_content       type soli_tab.
      append 'THis is attachemnt' to text_content.
      append 'THis is attachemnt' to text_content.
      append 'THis is attachemnt' to text_content

CALL METHOD document->add_attachment
        EXPORTING  i_attachment_type = 'TXT'
                   i_attachment_subject = 'My attachment'
                   I_ATT_CONTENT_TEXT   = text_content.