CREATING DYNAMIC SUBJECT LINE FR E-MAIL DISTRIBUTION

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

December 12, 2007, 10:29 AM

ira

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

December 12, 2007, 11:08 AM

GinnyJakes

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

December 13, 2007, 10:33 AM

ira

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

December 13, 2007, 04:27 PM

GinnyJakes

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

December 14, 2007, 11:28 AM

dhagen

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

December 14, 2007, 02:28 PM

FrankDutch

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

December 14, 2007, 02:44 PM

ira

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

December 14, 2007, 03:03 PM

FrankDutch

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

December 17, 2007, 10:42 AM

ira

[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

April 30, 2008, 01:04 PM

Francis Mariani

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

April 30, 2008, 01:31 PM

Francis Mariani

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

April 30, 2008, 02:14 PM

mgrackin

Francis,

Go here:

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

Look under the API section.

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

April 30, 2008, 02:36 PM

Francis Mariani

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