Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Reportcaster - FTP and send out mail at the same time.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Reportcaster - FTP and send out mail at the same time.
 Login/Join
 
Gun
Silver Member
posted
Hi

On Calling DSTRUN - Report Caster Job Runs - FTP's a file to Server

Is it possible to send out an acknowledgement mail without an attachment to the user(who initiated the DSTRUN).

OR

Is there a way to send mail from report caster without attachment(provided by send as inline message is disabled), an acknowledgement mail.

This message has been edited. Last edited by: Gun,


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Gun
Silver Member
posted Hide Post
Any Thoughts, Need to send a mail without attachment from report caster. Any alternatives


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Alex
Platinum Member
posted Hide Post
When you set up your RC job you can select a short or long notification to be sent never, always, or on error to whoever you want.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Gun
Silver Member
posted Hide Post
I have a dynamic list and it needs to be a mail template kind. As in (Hi, The Job requested by is complete. Please check the ftp server)


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Alex
Platinum Member
posted Hide Post
You can set up a post procedure to run to execute a dynamic distribution.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Gun
Silver Member
posted Hide Post
Please find the detailed process

1. User selects an Option
2. DST RUN Calls the JOB
3. JOB Transfers the file to FTP
4. DST RUN to send out the mail to the selected user is called
5. This mail needs to go without attachment. If i try to create a dummy fex without data. It fails to go and says no report to distribute.

Please let me know your thoughts.

Thank you


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Alex
Platinum Member
posted Hide Post
You could add a small procedure at the end of your main program that selects the individual to who the email will go and send via EDAMAIL.

   
DEFINE FILE CAR
MSG/A100='Your file is uploaded.....';
END
TABLE FILE CAR
SUM MSG
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS MAIL_FILE FORMAT HTML
END
-RUN
EX EDAMAIL bob.example@yahoo.com,,edamail test,A,HTML,MAIL_FILE


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Gun
Silver Member
posted Hide Post
It gave me this error

ERROR: ERROR_MR_FEX_NOT_FOUND Can't create item object based on provided item key EDAMAIL.fex

Thank you


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Gun
Silver Member
posted Hide Post
Hi Alex

I created a procedure, But I am now getting communication node error.

Thank you,


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Alex
Platinum Member
posted Hide Post
Set your email configuration on the WebFOCUS server.

http://server_name:8121/webconsole
Workspace > Configuration > E-Mail SMTP Server

Could be under the General tab if release prior to 7703


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Gun
Silver Member
posted Hide Post
Hi Alex

Its working. Thank you for your help. Just a Last Step.

Thats the Code

DEFINE FILE CAR
MSG/A1000='Your file has been uploaded...';
END
TABLE FILE CAR
SUM MSG
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS MAIL_FILE FORMAT HTML
END

-RUN
-MRNOEDIT EX EDAMAIL person@abc.com,,Your ID,,HTML,MAIL_FILE

I have removed the "A", Since, I want the body to be

"Your file is uploaded"

But I get the below in my mail. I need to remove these tags. Any thoughts.

< !--Olap java_script-->
HTML
HEAD
META name="HandheldFriendly" content="True"
META name="PalmComputingPlatform" content="True"
TITLE WebFOCUS Report /TITLE
/HEAD
BODY
TABLE BORDER CELLPADDING=1
TR
TD
Your file has been uploaded.../TD
/TR
/TABLE
/BODY
/HTML

This message has been edited. Last edited by: Gun,


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Gun
Silver Member
posted Hide Post
Any Ideas/Thoughts...


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Alex
Platinum Member
posted Hide Post
Try using a text rather than an HTML output format
FILEDEF MAIL_FILE DISK baseapp/MAIL_FILE.TXT
DEFINE FILE CAR
MSG/A1000='Your file has been uploaded...';
END
TABLE FILE CAR
SUM 
     MSG AS ''
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE HOLD AS MAIL_FILE FORMAT WP
END
-RUN
EX EDAMAIL Your_email,,edamail test,,WP,MAIL_FILE.TXT


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Gun
Silver Member
posted Hide Post
Thank you Alex. Its working..!!


7.7, Windows, HTML
 
Posts: 38 | Registered: December 30, 2011Report This Post
Don Garland
Guru
posted Hide Post
set your mail client to read HTML in the BODY


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
 
Posts: 291 | Location: Greater Cincinnati  | Registered: May 11, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Reportcaster - FTP and send out mail at the same time.

Copyright © 1996-2020 Information Builders