File path is breaking

kmkaot

I want a create PDF file,

2. with local path. file path was stored in a SMTP table.
4. saved file using save as pdf function
6. when I want attach the file
7. name is breking into line like d:\temp\invoice.pdf like
8. 
9. temp
10. Invoice.pdf
    
    Please help me how to retrive file from path
    
    Warm regards
    Krsh

Kishorm

To retrieve the filename only you can keep stripping of everything upto the next slash, something like this...

FileName := FilePathAndName;
WHILE STRPOS(FileName,'\') > 0 DO
  FileName := COPYSTR(FileName, STRPOS(FileName,'\') +1);

kmkaot

Thanks
Actually I want my file name should be for example 'D:\temp\invoice.pdf'
not
like this
d:
Temp
Invoice.pdf

Please help me,

Kris

Kishorm

That is only splitting when you display it using MESSAGE or ERROR because the backslash character is being interpreted as a new line. In order to work around this you could convert it to a forward slash when displaying it, e.g.

MESSAGE(CONVERTSTR(FileAndPathName,'\','/'));

kmkaot

SMTPsetup.GET;
SenderName:=SMTPsetup."Email sender Name";
SenderAddress:=SMTPsetup."Email sender email";
Recipients:=vendorRec."E-Mail"+';'+SMTPsetup."Manager Email";

kSubject:="No."+' PO for '+FORMAT(Amount);
kBody:=' ';
Tofile := Name;
Tofile := "No."+'.pdf';


FileName := SMTPsetup."Path to Save Report" + Tofile;
FileName := CONVERTSTR(FileName,'/','\');
MESSAGE(CONVERTSTR(FileName,'/','\'));


CurrPage.SETSELECTIONFILTER(Rec);
REPORT.SAVEASPDF(405, FileName, Rec);

CLEAR(email);
email.CreateMessage(Recipients,'','',kSubject,kBody,FALSE,FALSE);
email.AddBodyline(' Dear Sir/Madam');
email.AddBodyline('<BR><BR>');
email.AddBodyline(' PO Document '+"No."+' '+"Pay-to Name"+' approved ');
email.AddBodyline('<BR><BR>');
email.AddBodyline('Operations');
email.AddBodyline('<BR><BR>');
email.AddBodyline('Shura');
email.AttachFile(FileName);
email.Send();

Kishorm

You have the slash and backslash the wrong way round in your message - see my previous post

kmkaot

file path works only with back slash '\' not '/'.

i am i right?

Kishorm

I think it might work with either (even though traditionally it's been \ from the good old DOS days ). Give it a try.

For displaying in a message though, it doesn't really matter I would have thought.

vaprog

kmkaot wrote: »

file path works only with back slash '\' not '/'.

i am i right?

No! Windows handles forward slashes just all right as path separators in file paths. Many programs do not, though. On the command line, you need to quote a path containing forward slashes, because the forward slash is the traditional option start character on DOS/Windows command lines.

Back to NAV: For a MESSAGE command to display a file path properly, use value substitution:

MESSAGE('%1',FileName);

Backslashes in the String parameter get converted to Newlines, backslashes in the Valuen parameters are preserved. (See link above.)

With appending the file to the eMail message, I did not have any issue. No conversion needs to be done. It won't hurt, though, because of what I said in the beginning.