Focal Point
[CLOSED] EDAMAIL - Not working for filename with Upper case letters

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

December 14, 2018, 11:29 AM
rboya
[CLOSED] EDAMAIL - Not working for filename with Upper case letters
Hi,

I am trying to send email with an attachment. But it fails to search the file in the folder if the file name has uppercase letters.

My file name is ABC.txt

DM log shows as below

EDAMAIL: FILE abc not found.

if I rename ABC.txt to abc.txt it works. But I dont want to rename it.

Any suggestions how to use EDAMAIL for attaching files with uppercase letters in its name.


Thanks,

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
December 14, 2018, 11:52 AM
BabakNYC
Could you share your exact syntax with us? Also, what version of WebFOCUS are you using?


WebFOCUS 8206, Unix, Windows
December 14, 2018, 12:07 PM
rboya
Please find the proc below

-SET &&SUB='Audit report';
-SET &PATH = 'app_7t_out/';
-SET TRGFNAME = 'ABC.txt'
-SET &FILEPATH = &PATH || &TRGFNAME;
-SET &MSGBODY= 'Please find attached Audit report.' ;


EX EDAMAIL &&RECIPIENT_EMAIL,,&&SUB,A,TXT,&FILEPATH,'&MSGBODY.EVAL'
-RUN

WebFocus version - WebFOCUS 8105


WebFOCUS 8
Windows, All Outputs
December 17, 2018, 10:29 AM
jgelona
rboya, you might check to see if FILECASE is set. We are Linux so we force all file names to lowercase with SET FILECASE=LOWER in edasprof. But if your servers are Windows servers, I wouldn't think that case matters. ABC.txt should be the same file as abc.txt. In Linux/UNIX they are not, but it shouldn't matter if your servers are Windows servers.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.