 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Generating One Report In Multiple Locations
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Generating One Report In Multiple Locations Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Generating One Report In Multiple Locations | Login/Join |
| Member |
Hello, I hope I am posting this in the correct location. I was wondering if it is possible to run a single webfocus report and have its output generate in two separate locations. For example, my report currently works and I use: APP MAP FOCHOLD &&SDRIVE|Clients\ClientName\Validation APP HOLD FOCHOLD FILEDEF EXAMPLENAME DISK &&SDRIVE|Clients\ClientName\Validation\Client_Summary.pdf This works for generating a report at this given location. However, when I try something like: APP MAP FOCHOLD &&SDRIVE|Clients\ClientName\Validation APP HOLD FOCHOLD FILEDEF EXAMPLENAME DISK &&SDRIVE|Clients\ClientName\Validation\Client_Summary.pdf FILEDEF EXAMPLENAME DISK &&SDRIVE|Clients\DifferentClient\Validation\Client_Summary.pdf It does not generate this output in both locations, it generates the report in the last given location. Is there a way to achieve this? A secondary question would be if there is a way to achieve this, will it work with all file types (mainly PDF and CSV)?This message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 7.6 Windows, All Outputs | ||
|
| Silver Member |
it looks like the the file name is overriding. try something like this APP MAP FOCHOLD &&SDRIVE|Clients\ClientName\Validation APP HOLD FOCHOLD FILEDEF EXAMPLENAME DISK &&SDRIVE|Clients\ClientName\Validation\Client_Summary.pdf APP MAP FOCHOLD &&SDRIVE|Clients\ClientName\Validation APP HOLD FOCHOLD FILEDEF EXAMPLENAME DISK &&SDRIVE|Clients\ClientName\Validation\Client_Summary.pdf APP MAP FOCHOLD &&SDRIVE|Clients\ClientName\Validation APP HOLD FOCHOLD FILEDEF EXAMPLENAME DISK &&SDRIVE|Clients\DifferentClient\Validation\Client_Summary.pdf Webfocus 7.1.6, Webfocus 7.7, Webfocus 8 | |||
|
| Expert |
what about a simpler approach? just produce the pdf into your agent then copy it out to as many places as you want, with a good old DOS command CMD COPY Client_Summary.pdf &&SDRIVE|Clients\etc...
| |||||
|
| Member |
Thank you for the response! Yes, I could always utilize a DOS command I just wanted to know if there was a way to accomplish it within Data Migrator within a webfocus report. This is one example I gave but the functionality would be spread across many clients if there was a quick way to do this within webfocus. Is there really no way to do this because a .fex or .mas gets generated in one place and cannot be created in multiple locations? WebFOCUS 7.6 Windows, All Outputs | |||
|
| Expert |
You can't expect WebFOCUS to generate a report in two locations simply because you issued two FILEDEF statements. Since the two statements use the same 'ddname', the second overrides the first. You can either run the report request twice or use susannah's idea of copying the file. I would map the two paths as different apps and then use the APP COPYFILE command to copy the PDF from one app folder to the other: APP COPYF[ILE] app1[/app1a...] {filename1|*} filetype1 app2[/app2a...]
{filename2|*} {filetype2|*} [IFEXIST] [DROP]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 | |||
|
| Virtuoso |
Think simple ... as Susannah advises. What about this: TABLE FILE GGSALES SUM UNITS BY CATEGORY ON TABLE HOLD AS APPFOLDER1/FILE1 FORMAT PDF END HOLD AS APPFOLDER2/FILE2 FORMAT PDFYou can repeat this extra HOLD for as many times as you like, provided you do not do anything to 'disturb' the internal matrix (like a -RUN or some other Focus command). GamP
| |||||||||
| ||||||||||
| Member |
Thank you for the advice and responses everyone, I will try out what has been recommended here today. WebFOCUS 7.6 Windows, All Outputs | |||
|
| Expert |
GamP, very interesting! Where is this documented? 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 | |||
|
| Expert |
brilliant , Gamp... i remember this technique now..buried way deep in the gray matter... | |||
|
| Master |
I've used this command when I was using FOCUS for z/OS. In the FOCUS for Mainframe v7.7 manual you will find: From a report request, use
ON TABLE HOLD [AS filename] [FORMAT fmt] [MISSING {ON|OFF}][VIA program]
or
hold_field HOLD [AS filename] [FORMAT fmt] [MISSING {ON|OFF}][VIA program]
After a report is executed, use
HOLD [AS filename] [FORMAT fmt] [MISSING {ON|OFF}][VIA program] I did not see the 'HOLD after a report is executed' in the corresponding section of the WebFOCUS manual/documentation. Perhaps it was inadvertently omitted?This message has been edited. Last edited by: David Briars,
| ||||
|
| Expert |
This looks intriguing
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 | |||
|
| Virtuoso |
It's not the first time you asked about this: ON TABLE HOLD ... VIA program (2005!) I found one snippet of documentation: ON TABLE HOLD [AS filename][FORMAT fmt][MISSING {ON|OFF}][VIA program] . . . VIA program For external applications only. It is a user-coded program that creates the HOLD data file. It defaults to the FOCUS internal format for fields; the ALPHA option is also available. Other formats, such as FOCUS or LOTUS, are not available when you use a program with the HOLD command. -- apparently Focus will feed the program records (rows from the internal matrix), one at a time -- with a record layout corresponding either to SAVB or SAVE format. (No mention of what is presented of the Table request has multiple verbs ... but I guess the multi-level internal-matrix structure gets flattened)This message has been edited. Last edited by: j.gross, | |||
|
| Platinum Member |
GamP is correct. That is the easiest method to store a couple of one-offs on the fly. I prefer to use report caster ftp if there a lot of report copies that need to be stored. Performing a separate HOLD/SAVE after the END of the main request has been around since my early VAX days, at least. In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle | |||
|
| Member |
Kept it simple and used a !COPY /Y command before the "-EXIT" at the end of the report. The "ON TABLE HOLD AS" suggestion was a great idea but since these reports all have "-RUN" in them after each TABLE FILE, it wasn't viable in my case. Thanks all for the time and suggestions! WebFOCUS 7.6 Windows, All Outputs | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Generating One Report In Multiple Locations
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Generating One Report In Multiple LocationsCopyright © 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 |