Focal Point
[SOLVED] report caster date stamp

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

March 03, 2015, 08:24 AM
Geoff Fish
[SOLVED] report caster date stamp
Has anyone ever used a date stamp in the ouput name of a reportcaster job? On the task tab where you can give the file aname.

It would be like this WSSU_upload_mmddyy.txt. Today’s file would have been WSSU_upload_030315.txt. Its to feed a third party system and it would be SFTP'd

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


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
March 03, 2015, 08:44 AM
njsden
I believe I've achieved something similar in the past by using the burst feature. Just define an alpha field with the date pieces you want in there, make that your first BY field NOPRINT and configure your schedule to burst. The burst value is appended to the file name upon delivery. Last time I did something like that was in WF 7.6 so things may have changed a bit since then but the functionality should still remain.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
March 03, 2015, 09:13 AM
Geoff Fish
quote:
Originally posted by njsden:
I believe I've achieved something similar in the past by using the burst feature. Just define an alpha field with the date pieces you want in there, make that your first BY field NOPRINT and configure your schedule to burst. The burst value is appended to the file name upon delivery. Last time I did something like that was in WF 7.6 so things may have changed a bit since then but the functionality should still remain.



So did you burst it to a single location? we have used dynamic distribution to distribute emails before but have not "burst" with SFTP


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
March 09, 2015, 08:52 PM
<Kathryn Henning>
This functionality is available now starting in release 8.1.03. While this won't help Geoff today as he is currently on release 7.7.03, I wanted to post this for anyone searching for information on this in the future.

Regards,

Kathryn
March 10, 2015, 07:55 AM
Geoff Fish
Thanks


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML