 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| mail report on request | Login/Join |
| Virtuoso |
I want to create a report where the users can key in a client code. After hitting the run code the report is not shown on screen but send to the user by the email address that is connected to that specific client code. Will that be possible and how can this be done. I know how to create a report that is scheduled on time with reportcaster, but now this could be a RC process that is not scheduled but will run on request.
| ||||||
|
| Expert |
Frank, If you do not want to / can not go down the route of Report Caster, then (as you're on windows) an alternative would be to write the report to a network drive and build a VBScript file to use CDONTS to deliver your email and attach the file. T
| |||||||||
|
| Virtuoso |
Tony I was thinking of RC since that application can handle the report and the mailing with the burst value in a proper way. If you know a better/other way to do this, I would appreciate to hear your suggestions. I'm also thinking of a complete different approach. I will let the user enter a report request. That request is sent to a small database which holds the userid, datetime, and the desired portfolio code. Every 5 or 10 minutes a RC process cheques this database on new entries and handles these new records. This has two advantages, 1) It's secure. Whatever the user will do, the report is only send to the one who is allowed to see the data since the user can not change the mailadres which is in the database and linked to the portfolio id. 2) It build's a logfile.
| |||||||
|
| Virtuoso |
We use both the methodology from your last post and JG's suggestion for a couple of different applications. The DSTRUN works well. For a couple of the more important apps, we log the requests to a database with user and destination information and RC runs peridoically to distribute the reports that have not been processed (determined by updating "flag" fields in the database after the RC run. This is completely tied in with system security so email address is tied to the user id, as you mention. Also, we have a complete list of requests, processing times, etc. and can go back and reprocess if three were RC problems. The other option not mentioned is to use the schedule functionality allowed by WF/RC to allow a user to schedule their own job and then set the flag for Delete Schedule since it will not be run more than once. Have not gone this route, but it seems to be the most straightforward. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Gold member |
Frank: Here is what we use to 'simulate' the MRE Run in Background functionality. When a user enters whatever information is needed, (in your case, the Client Code) and clicks 'SUBMIT', we execute a fex in the back. This Fex will look up the user's information (like email address etc.) from a data source. Then, we make an API call to Report Caster, scheduling the job to start running 5 minutes from the current time. The distribution method in our case is FTP, but you can set it to be email (with the report as an attachment or in the enmail itself). I think this is similar to what JG said earlier, but did not understand what was meant by "As the first part of your focexec have it write the content of the distribution file which would be, for example xyz@email.com,,$" Diptesh Diptesh WF 7.1.7 - AIX, MVS | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |