Focal Point
[SOLVED]EDAMAIL WF8

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

February 04, 2016, 02:33 PM
Jay Potter
[SOLVED]EDAMAIL WF8
I am trying to run the EDAMAIL command. Below is my code. I keep getting a Cannot include resource specified EDAMAIL" error. Is there a command I need to add to point to where the EDAMAIL program is?

  
EX EDAMAIL to=jpotter@EnclaraPharmacia.com,toaddr=jpotter@EnclaraPharmacia.com, from=DBTeam@EnclaraPharmacia.com,subject='Monthly Enclara Pharmacia Dashboard', filetype=PDF,filename= &OUTPUT_FILENAME

This message has been edited. Last edited by: Jay Potter,


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
February 04, 2016, 04:21 PM
Waz
This is from 8.1.05, but should be the same for yours.

The example does not have the parameter and equal signs

EX EDAMAIL


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 04, 2016, 04:22 PM
BabakNYC
Do you have access to the Reporting Server? Double check Workspace/Email SMTP Server and make sure you have all the parameters filled out.


WebFOCUS 8206, Unix, Windows
February 04, 2016, 04:29 PM
Jay Potter
I am running this from the content folder. Should I be running it from the reporting server?


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
February 04, 2016, 04:33 PM
Jay Potter
WAZ

I do have the parameters and equal signs. The link you sent me to is where I copied and pasted the command from the bottom of the page and replaced values with my values.

Do you see any equals? I did put the command between the code tags.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
February 04, 2016, 04:46 PM
Waz
Ah, thats the extended form.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 04, 2016, 04:50 PM
Waz
I noticed a space in the command that you posted after filename=, is that in your code ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 04, 2016, 04:51 PM
BabakNYC
If you're running this from a Content Folder add -MRNOEDIT to your EX.
-MRNOEDIT EX EDAMAIL to=jpotter@EnclaraPharmacia.com,toaddr=jpotter@EnclaraPharmacia.com, from=DBTeam@EnclaraPharmacia.com,subject='Monthly Enclara Pharmacia Dashboard', filetype=PDF,filename= &OUTPUT_FILENAME





WebFOCUS 8206, Unix, Windows
February 05, 2016, 06:19 AM
Jay Potter
Thanks that let me execute the command. Now it can't find the file. The file is created just before the command is executed. It is a very complicated compound report that can't be burst.

Here are the commands I use to save the file.

FILEDEF DASHBOARD_PDF DISK &OUTPUT_FILENAME
COMPOUND LAYOUT HOLD AS DASHBOARD_PDF FORMAT PDF

I tried using the FILEDEF and the file name itself and it doesn't find it. Is that because when the file is created, it is created via the client server and when the EDAMAIL looks for it, it is looking from the reporting server? Does the reporting server need access to the file which resides in a shared folder on a different server?


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
February 07, 2016, 04:03 PM
Waz
This worked for me, although the PDF document did not show the rendered PDF, only the content.


TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS MAILTST FORMAT PDF
END

-RUN

-MRNOEDIT EX EDAMAIL to={emailaddr},toaddr={emailaddr}, from={emailaddr},subject='EDAMAIL Test', filetype=PDF,filename=mailtst.pdf




Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 07, 2016, 09:03 PM
Jay Potter
Thank You everyone. I got it working now. I think the problem was that I had a space between the equal sign and filename.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
February 09, 2016, 04:03 PM
Waz
quote:
I noticed a space in the command that you posted after filename=, is that in your code ?


Can you veryify ?

So anyone else that encounters this issue have an answer


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 09, 2016, 04:38 PM
Jay Potter
After further review the problem was not the space. I used a FILEDEF command and used the definition name instead of the actual file name. The reason I did that is because the reporting server does not have access to the file. We are working on getting the reporting server access.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
February 09, 2016, 04:49 PM
Waz



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!