on 03-07-2012 2:40 PM
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.