May 03, 2006, 10:40 AM
ed_kColumn 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:28 AM
ed_kCOMT 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_ksusannah
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
susannahyou 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
May 04, 2006, 12:54 PM
ed_kTHANK YOU!
susannah, the technigue you suggested worked great!!! Back to a single schedule again... I appreciate the help!
Ed