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     CREATING DYNAMIC SUBJECT LINE FR E-MAIL DISTRIBUTION

Read-Only Read-Only Topic
Go
Search
Notify
Tools
CREATING DYNAMIC SUBJECT LINE FR E-MAIL DISTRIBUTION
 Login/Join
 
Silver Member
posted
Hi,
can someone give me an example of how to create a subject line dynamically.i want to display the parameters that i pass to the report in my subject line.
Thanks
 
Posts: 37 | Registered: December 28, 2005Report This Post
Platinum Member
posted Hide Post
Good Morning Chelsea :
Are you talking about email distribution via Report Caster ?

Please also update your signature to show your platform / WF release etc. It always helps when people try to answer your Q.

Thanks,
Sandeep M.


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
Chelsea,
Please also look at this previous forum entry on the same topic -

Linky

Hope that helps,
Sandeep M.


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Silver Member
posted Hide Post
Hi BlueZone,
i tried the example that is there in the report-caster help and it worked when i assigned the parameter and the value in the advanced tab of the task option of the schedule and usedit in the subject line .what i want to see is if there is a way that we specify the parameter in the subject line and it takes the value of the parameter from the report rather then specifying the valued in the advanced option of reportcaster.
Thanks
 
Posts: 37 | Registered: December 28, 2005Report This Post
Silver Member
posted Hide Post
HI,
any ideas on how this can be done
thanks
kumar
 
Posts: 37 | Registered: December 28, 2005Report This Post
<RickW>
posted
You may be able to do something with the RC API - maybe setMailSubject(String)function but that's probably not what your looking for since it's a bit complex.
 
Report This Post
Virtuoso
posted Hide Post
Sounds like a new feature request.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Platinum Member
posted Hide Post
I am trying to do have a subject line say: REPORT XX (followed by the current date).
I tried REPORT XX '&DATE' in the subject line but did not see the date appear in the actual subject line. Instead, I saw 'REPORT XX' and in the log i saw it say unknown parameter DATE.
Must I specify elsewhere this parm? How/where?

Thanks, Ira
wf 536 AIX533


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Expert
posted Hide Post
I checked on this once. It is not supported.

Someone may have already requested and NFR (New Feature Request) but it doesn't hurt to give IBI more ammunition. So I would suggest that you open a case.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
GinnyJakes - Thanks, I had opened up a case. I was wondering what do you think of this as a workaround (dare I say that?)

table &DATE to save file - read it back in to an &&variable. include that condition in a where clause somehow. Would subject line then recognize that &&? Not totally thought out yet as you can see - just a thought...


Ira
AIX 533 wf 5.3.6 (dev) 5.3.3 (prod) 7.6.1 (test)


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Expert
posted Hide Post
I don't think that will work. Please see a very similar thread and Gerry's comments about what is allowed and not allowed. According to Gerry, the variable has to be in Report Caster, i.e. specified in the Advanced tab of the task.

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/5351054062


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
why not build a quick jsp to do a one time submission and set the subject line as you see fit.

Simple Example (/rcaster/custom/scheduleExample.jsp) -- sorry, there was a wee typo:
<%-- $Revision: 1.2 $: --%>
<%@ page language="java" import="ibi.broker.beans.*,ibi.broker.beans.handler.*,java.util.*,java.text.*" %>
<jsp:useBean id="schedFact" scope="request" class="ibi.broker.beans.DSTSchedFactory" />
<%

     /* 
      *  Expected parameters to be passed:
      *
      *  emailFrom = User email who processed the merchandise request.
      *  emailTo   = User who initialiated the merchandise request.
      *  merchId   = Unique merchandise request id.
      *  random    = Random number passed from the calling process.
      *
      */
		Date now = new Date();
		SimpleDateFormat formatter = new SimpleDateFormat( "yyyyMMdd" );
		
		DSTAuthenticate auth = new DSTAuthenticate();

                // expected parameters.
		String emailFrom = request.getParameter("emailFrom");
		String emailTo = request.getParameter("emailTo");
		String country = request.getParameter("COUNTRY");
                String car = request.getParameter("CAR");

		auth.setUser("admin");
		auth.setPass("");
		auth.setAgentProperty("localhost:8200");
		
		// build subject line with passed parms
		String emailSubject = "*** Some Description: Country: " + country + " Car: " + car + " ***"; 
		String interval = "O";
		String startdate = formatter.format(now);
		String starttime = "0600";
		String fex = "merchandise_request_confirmation";
		String[] parNames = {"COUNTRY","CAR"};
		String[] parValues = { country, car };

		schedFact.setAuthenticate(auth);

		schedFact.setIBIB_casteruser("admin");    
		schedFact.setIBIB_jobdesc("*** Some Description.  This will be deleted anyway ***");                            	
		schedFact.setIBIB_active("Y");                                    	
		schedFact.setIBIB_priority("3");                                  	

		schedFact.setIBIB_interval(interval); //Run Once   	
		schedFact.setIBIB_startdate(startdate);                            	
		schedFact.setIBIB_starttime(starttime);                                	
		schedFact.setIBIB_listtype(DSTSchedFactory.ADDRESSTYPE_SINGLEADDRESS); //send to one address	
		schedFact.setIBIB_distlist(emailTo); // access list name    	
		schedFact.setIBIB_method(DSTSchedFactory.METHOD_MAIL);   
		schedFact.setIBIB_mailfrom(emailFrom);
		schedFact.setIBIB_mailuser(emailFrom);
		schedFact.setIBIB_mailsubject(emailSubject);
		schedFact.setIBIB_asvalue("sent.htm");
		schedFact.setIBIB_mulpart("N");

		// notification 
		schedFact.setIBIB_notifyflag(DSTSchedFactory.NOTIFYFLAG_INACTIVE);  	
		schedFact.setIBIB_tasktype(DSTSchedFactory.TASKTYPE_EDA_FOCEXEC); 
		schedFact.setIBIB_servername("EDASERVE");
		schedFact.setIBIB_taskobj(fex); //URL being Schedled
		schedFact.setIBIB_execid("server-userid");
		schedFact.setIBIB_execpass("server-password");
		schedFact.setIBIB_sendformat(DSTSchedFactory.SENDFORMAT_HTML);

		schedFact.setIBIB_paramname(parNames);
		schedFact.setIBIB_paramvalue(parValues);

		schedFact.setIBIB_servername("EDASERVE");  
		
		// delete the job after execution.
		schedFact.setIBIB_deletejob("Y");

		DSTBeanHandler h = schedFact.getCreateScheduleHandler();
		h.processRequest();
		DSTAPIStatus status = h.getAPIStatus();
		int code = status.getErrorCode();
		if(code != DSTAPIStatus.NO_ERROR) {
			out.println("Code = " + code + "; Message = " + status.getErrorMessage());
			return;

		}

		DSTBeanResult result = h.getBeanResult();
		Vector xml = result.getXML();		
		String sid = null;
		String stag = "<IBIB_scheduleid>";
		String etag = "</IBIB_scheduleid>";
		for(int i = 0; i < xml.size(); i++) {
			String temp = (String)xml.elementAt(i);			
			int index = temp.indexOf(stag);
			if(index != -1) {
				int end = temp.indexOf(etag);
				sid = temp.substring(index + stag.length(), end);
				break;
			}
		}
		out.println("Schedule ID = " + sid);
	
%>
<html>
     <head>
     </head>
     <body>
          <h2>Some Confirmation message.</h2>
     </body>
</html>  


Call with:
  
http://server:port/rcaster/custom/scheduleExample.jsp?e...TRY=JAPAN&CAR=DATSON

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


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Virtuoso
posted Hide Post
Hi Dhagen,
This is nice, the first time I see an example of this functionality.
This can be a good start to do something like this where we need a looping for a rather complex report where burst does not work.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Platinum Member
posted Hide Post
Dhagen, I gotta check it out. This is good! Thanks. GinnyJakes and all other helpful ones - thank you. IBI has an NFR put in place. In the interim their official line is HTTP://TECHSUPPORT.INFORMATIONBUILDERS.COM/SPS/93411036.HTML (see the solution section)...


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Virtuoso
posted Hide Post
Ira

there is a little typo in your hyperlink, it looks ok, but it is not.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Platinum Member
posted Hide Post
[URL=HTTP://TECHSUPPORT.INFORMATIONBUILDERS.COM/SPS/93411036.HTML]

Frank, you are absolutely correct. The link actually appeared as 'infromation' instead of 'information' . Try it now...


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Expert
posted Hide Post
Dhagen,

This is good stuff. I was easily able to set this up with your example.

Much better than DSTRUN.

Cheers,

Francis.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Dhagen,

Where is this JSP stuff documented?

I searched for "setIBIB_sendformat" on the IBI Tech Support site and the only document displayed wasDSTSchedFactory for WebFOCUS 4.3.

Thanks,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
Francis,

Go here:

http://documentation.informationbuilders.com/masterindex/webfocus_53.asp

Look under the API section.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
Mickey,

Thank you. I have the API document. I have to say it is quite useless! It provides detailed Java syntax but very poor examples.

I cannot find the text "SENDFORMAT_HTML" anywhere on IBI.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 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     CREATING DYNAMIC SUBJECT LINE FR E-MAIL DISTRIBUTION

Copyright © 1996-2020 Information Builders