cancel
Showing results for 
Search instead for 
Did you mean: 

Sending Report output in CSV format to email address

karthik_narayan2
Explorer
0 Kudos

Hello Experts,

I am not able to get the output of the report in .CSV or HTML format instead i am receiving it as text file (report.csv.txt).

Scenario is like this:

Created report to get the job status for last 24 hours and trying to send the output of report to email address.

design:

In Job chain:

Step 1: runs - System_Reportrun

Step 2: runs - System_Mail_Send with following parameters:

Relative Job: Step 1 , Job 1

Job file : *.CSV

Please help me how to get the output file in .csv format in email as attachment.

Thanks,

Accepted Solutions (0)

Answers (2)

Answers (2)

gmblom
Active Contributor
0 Kudos

Hello,

have a look at: http://scn.sap.com/thread/3360049

Regards Gerben

Former Member
0 Kudos

Hi Karthik,

To solve this issue plz follow the following steps.

1. Create a new job like Report_Email with mail type job definition with following parameters.

     a.Mail_To

     b.REPORT_ID

     c.SUBJECT

     d.REPORT_TITLE

     4.EMAIL_DESCRIPTION

SOURCE

------------------

<HTML>

<BODY>

<H2>${REPORT_TITLE}</H2>

${EMAIL_DESCRIPTION}

</BODY>

</HTML>

[Attachments]

@{Name}=Job ${REPORT_ID}:*.csv

[Headers]

#set the reply-to address

subject=${SUBJECT}

reply-to=${Mail_To}

[Body]

Content-Type=text/html; Charset=UTF-8

2. Create a Job chain.

3. In step 1 add the job whose out put is in CSV file.

4 In step 2 add Report_Email add fill the parameters details.

5. Run the chain.

6 . U will receive the Email with.csv file to receipient

Please revert if any issues