Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report Library Email Notification
Go
New
Search
Notify
Tools
Reply
  
Report Library Email Notification
 Login/Join
 
Member
posted
Hi All.
I would like to use the email feature to notify users, however, our users do not got to the library directly instead they access it through a dashboard view.

I've tried providing the dashboard view URL as the 'Report Library URL' in the Report Caster schedule but this results in an invalid URL as RC tacks on report/version info to the URL.
I also tried removing the Report Library URL value and including the dashboard URL in the body of the message. This does work, however, RC inserts the dynamic URL it builds (as described above) in the email body.

Has anyone run into this type of issue before and what type of workaround did you use? Thanks in advance.


WebFOCUS 7.6
Windows 2003 Server
Output: PDF & Excel
 
Posts: 5 | Registered: December 03, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
Devon,

I want to make sure that I understand your request. It sound you you have the following:

1) A schedule that creates a report that outputs to report library.
2) users who log into a dashboard application and click on a library tab and then expand the appropriate items to see the report.
3) You wish to send the users an email that has link to
a) the dashboard
b) See a) and then the report library tab
c) See b) and expand the appropriate items
d) See c) and then show the report.

Is this correct?

Fernando


Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
 
Posts: 264 | Registered: October 10, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Yes that sounds about right. My problem is with step #3.
I can't send the link to the dashboard out as the 'Library URL' since that gets manipulated by RC. I can provide it in the body of the email message but RC inserts the 'Library URL' it generates into the email.


WebFOCUS 7.6
Windows 2003 Server
Output: PDF & Excel
 
Posts: 5 | Registered: December 03, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
Devon,

Post an example of what your current email looks like and hilight what is wrong with it.

Fernando


Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
 
Posts: 264 | Registered: October 10, 2006Reply With QuoteReport This Post
Member
posted Hide Post
With the dashboard URL in the 'Report Library URL' the message body looks like this:

Please click each of the following link(s) to view the report(s).

http://hostname/ibi_apps/worp/jsp/WORP_Views.jsp?action...12rcmmqft1&version=1

Note the id and version is added to the URL.


WebFOCUS 7.6
Windows 2003 Server
Output: PDF & Excel
 
Posts: 5 | Registered: December 03, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
Devon,

I am correct in saying that this URL will open the report in library and you really want to open the dashboard first?

If so, then you may want to build a fex in the dashboard that takes this URL as a parameter and then opens it. That you way you can build a call the dashboard, and execute your fex which would then open up this URL.

Fernando


Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
 
Posts: 264 | Registered: October 10, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Devon and Fernando,
I am having a problem when using Report Caster to schedule a report with the Report Library Email notification is sending my users the incorrect URL to all reports using the Report Library feature when run. My users now have to login into the dashboard to find the report file in the report library, instead of being able to just click on the link. This did not start happening until we upgraded to Webfocus 8...


WebFOCUS 8.0.08
DEVStudio 8.0.08
Windows 7
All Outputs
 
Posts: 2 | Location: Ada, Ohio | Registered: May 11, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
I am pretty sure you need to use the
RESTful Web Services License for this kind of thing in WF8. Are you still using Dashboards or did you convert those over to Portals?

If for some reason they are already logged in when they open that email you might get away with setting up an alternate security zone but you would have to talk with an IBI rep about that.

Also, you should update your tag to include WF8 release info.

EDIT: Checkout Viewing Library Content >> Email a Library Report and related documentation

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


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Reply With QuoteReport This Post
Member
posted Hide Post
Thank you for your time and knowledge. I wish, we had RESTful. I am merely sending an email notification to an access list with a dynamic URL to the report in the report library, so I hope this is not something we have to purchase additionally. This functionality was provided in Webfocus version 7... We just updated to version 8.


WebFOCUS 8.0.08
DEVStudio 8.0.08
Windows 7
All Outputs
 
Posts: 2 | Location: Ada, Ohio | Registered: May 11, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report Library Email Notification

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.