Focal Point
[CLOSED] Put DateTime Stamp in ReportCaster Job Output file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7027030376

October 10, 2014, 10:35 AM
Neelima
[CLOSED] Put DateTime Stamp in ReportCaster Job Output file
Hi All,

Firstly, I want to thank to all for handing me the solution for my WebFOCUS Query.

I have one other question Related with ReportCaster jobs. How can I add time-stamp to output file name.

Example:-
-* File MainFile.fex
TABLE FILE CAR
BY BURST_VALUE
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, HFREEZE=OFF, $
ENDSTYLE
END

And When we will be scheduling the Job for above Report. We will receive file with MainFile.html name. But I need a ouptfile name like "MainReport_10_10_2014 7_07 PM.htm".


Please provide some solution for same.

Regards,
Neelima Gupta

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
October 10, 2014, 03:51 PM
Tony A
Neelima,

Use the search option above to search on "report caster variable". This has been discussed many times and I think the answer is still "no, not within normal use".

However, the Forum members are a very clever lot and many suggestions have been ventured and may suit your current needs.

I would hazard a guess that this may be something that might be considered for a future release.

T



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 
October 11, 2014, 04:12 PM
Neelima
Thanks Tony for Respond on my post,
I have researched and found some trick to Append current date and time with Report Caster file output name like to create a temporary field and use as first BY field with NOPRINT Statement (like Burst Field). and i got my desired result.
But the same time, I need to achieve bursting functionality also. And currently I am struggling with this only.
Is there any another way to do the same.

Thanks,
Neelima

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


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
October 13, 2014, 02:27 AM
Ram Prasad E
Hi,

You should use Wildcard Characters in burst value in the distribution list.

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
October 13, 2014, 02:56 AM
Martin vK
Hi Neelima,

I have succesfully achieved this by using a dynamic distribution list, as in the dynamic list you can also determine at run-time what the first part of your file name will be, so no problem to include a datetime stamp. It also provides more flexibility in bursting as you do not need to keep your distribution list up-to-date in ReportCaster.

Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
October 14, 2014, 05:10 AM
Neelima
Hi Martin,

Thanks for reply.. How can i check the first part of file name dynamic list. Please share code snippet for same.

Thanks and Regards,
Neelima Gupta


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
October 15, 2014, 03:18 AM
Ram Prasad E
You need to use wildcard search for burst value.

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/