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.
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,
...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...
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.
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
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.
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.
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.
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').
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
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
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005