Focal Point
Column Titles possible with COMMA format output?

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

May 03, 2006, 10:40 AM
ed_k
Column Titles possible with COMMA format output?
Running WebFOCUS 711 and distribution is thru Report Caster with COMMA as output type.

User is now requesting titles and it seems it's not possible? Most other output types include the titles in the output! (EXCEL and TABT, etc)

Any ideas for easy work around?

Thank you,
Ed K.
May 03, 2006, 11:09 AM
susannah
did you try FORMAT COMT




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 03, 2006, 11:28 AM
ed_k
COMT isn't avalable as a output choice in the schedule output option.

Also, the documentaion ReportCaster Format for Scheduled Output omits COMT as a choice.
May 03, 2006, 03:04 PM
ed_k
susannah
Your suggestion got me thinking of a workaround...:
1) use HOLD as COMT (which did create headings)
2) schedule a 2nd procedure to FTP the file

Thank you... it's working as needed!
May 03, 2006, 05:21 PM
susannah
you could just make the COMT file in your agent and then write and execute a script in your fex to upload the the ftp; one single process ...
here's how...
change the get to a put
use lcd to move around on the ftp site
use cd to move around on your own drive


FILEDEF CHFTP DISK GET.FTP
-RUN

-WRITE CHFTP open ftp.somesite.com
-WRITE CHFTP USERID
-WRITE CHFTP PASSWORD
-WRITE CHFTP ascii
-* stands for local change directory
-WRITE CHFTP lcd \
-WRITE CHFTP lcd mydir
-WRITE CHFTP get somefile.csv
 
-WRITE CHFTP close
-WRITE CHFTP quit
-RUN
 
DOS ftp -i -s:GET.FTP
-RUN 





In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 04, 2006, 12:54 PM
ed_k
THANK YOU!

susannah, the technigue you suggested worked great!!! Back to a single schedule again... I appreciate the help!
Ed