[CLOSED] combine dynamic distribution with fixed email addresses

August 31, 2017, 09:54 PM

sh98110

We have an application that is sending out notices based on completion phases- different notices for different people every day. Therefore, I am using RC and a dynamic distribution list, per the doc, and this part works fine.

However, I was surprised to see that I could not ADD an additional fixed (to administrators) email address to this distribution list- no commas or semi-colons allowed on the Distribution TO... box when Dynamic Distribution list is selected.

I then thought of running the task twice, but it appears that one schedule, with two tasks, can NOT have two distribution lists, one for each task. I vaguely recall that this may be by design, but I am not sure- has anyone else run into THAT problem?

Is there any alternative to creating two schedules for the same job, one for a dynamic distribution list, and another for a fixed distribution list?

Does anyone know when ReportCaster (we are currently on 8.0.09) starts supporting CC and BCC addresses?

Thanks in advance.

This message has been edited. Last edited by: FP Mod Chuck,

WebFOCUS 8
Windows, All Outputs

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

September 01, 2017, 10:35 AM

TexasStingray

Here is a potential solution. in the procedure you have that generated the distribution list modify it. instead returning the data hold say as DLIST like so

  
BY DEST
BY VALUE
ON TABLE HOLD AS DLIST FORMAT FOCUS
END
? HOLD DLIST
-* The above line will give the you the format and lengths you need to the 2 computes below
TABLE FILE CAR
PRINT COUNTRY NOPRINT
AND COMPUTE DEST/??? = 'texasstingray@somewhere.com';
AND COMPUTE VALUE/??? = 'somevalue';
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS DLIST2 FORMAT FOCUS
END

USE
DLIST AS DLIST
DLIST2 AS DLIST
END

TABLE FILE DLIST
PRINT DEST VALUE
ON TABLE PCHOLD FORMAT XML
END

Hope this help. I think you only need VALUE if it is a bursted report.

Scott

September 01, 2017, 10:53 AM

jgelona

The dynamic distribution is generated by a program that is run. The program can build whatever you need.

In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.

September 01, 2017, 04:55 PM

sh98110

quote:
Originally posted by David Briars:

For the same schedule - task we created two distribution 'methods': one is a 'Dynamic Distribution List' type and the other a 'Email Address' type.

When clicking the 'Distribution' button, in ReportCaster, you will see next to the 'New' button, the opportunity to create n number of distribution methods.

David- we are on 8.0.09- I cannot get the New button to work when there is an existing Distribution method- do you recall if this was a new feature in 8.1x?

Also, when you are running with two lists, are they a mix of burst (normally for Dynamic Distribution) and fixed (to make up for lack of a CC)? I ask because the manual is not clear if this type of distribution mix can be done in a single schedule.

Thanks.

WebFOCUS 8
Windows, All Outputs

September 04, 2017, 04:57 AM

Tony A

SH,

You can combine burst and non-burst into a single list/file (dynamic or otherwise) by changing the burst value to "*" (no quotes) to signify "Any value". e.g.

amy_alberts@localhost,ENGLAND,$
david_bradley@localhost,ITALY,$
chuck_dickens@localhost,*,$

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

September 05, 2017, 09:49 AM

David Briars

quote:
David- we are on 8.0.09- I cannot get the New button to work when there is an existing Distribution method- do you recall if this was a new feature in 8.1x?

I do see this feature listed in the 'WebFOCUS New Features Release 8.1 Version 05 - Chapter 6 Scheduling and Distributing Information' manual.

quote:
Also, when you are running with two lists, are they a mix of burst (normally for Dynamic Distribution) and fixed (to make up for lack of a CC)? I ask because the manual is not clear if this type of distribution mix can be done in a single schedule.

In our (8105M) scenario, the first distribution, for the same schedule/task, uses a 'Dynamic Distribution List' to burst, and the 2nd distribution list has fixed recipients (the 'admins').

September 15, 2017, 11:56 AM

FP Mod Chuck

Steve

I checked with Product Management on the bc and bcc and here is what I found out.

CC and BCC are coming in 8202 for use with the Email Address(s) option but not with Distribution Lists or Files.

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats

September 16, 2017, 11:50 AM

Doug

Tony A, Thanks, I forgot about the use of an asterisk in this situation.

quote:
You can combine burst and non-burst into a single list/file (dynamic or otherwise) by changing the burst value to "*" (no quotes) to signify "Any value". e.g.

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206