Skip to Content

Sending Report output in CSV format to email address

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2013 at 12:24 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2013 at 06:40 AM

    Hello,

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

    Regards Gerben

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.