 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED]EDAMAIL WF8 | Login/Join |
| Guru |
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_FILENAMEThis message has been edited. Last edited by: Jay Potter, WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster | ||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
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 | |||
|
| Guru |
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 | |||
|
| Guru |
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 | |||
|
| Expert |
Ah, thats the extended form. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
I noticed a space in the command that you posted after filename=, is that in your code ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
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 | |||
|
| Guru |
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 | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Guru |
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 | |||
|
| Expert |
Can you veryify ? So anyone else that encounters this issue have an answer Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Guru |
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 | |||
|
| Expert |
 Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |