Skip to main content
Solved

Simple Excel plugin

  • January 22, 2021
  • 7 replies
  • 748 views

Forum|alt.badge.img+3

Hi, I have created a simple excel plugin layout for the Purchase_Receipt_Rep order report but nothing happens when I print and choose ‘Email Report’. Is there something that needs to be setup on the server to allow the Excel plugin or is my xml wrong?

 

 

Best answer by ChanakaAmarasekara

Hi,

In your RPL that is attached to this thread the plug-in class is 

ifs.application.reportingservices.impl.extendedformatter.excelplugin.SimpleExcelPlugin

not

ifs.application.printagentservice.impl.extendedformatter.excelplugin.ExcelPlugin

So it will definitely not work. The correct class for Apps8 is 

ifs.application.printagentservice.impl.extendedformatter.excelplugin.ExcelPlugin

also there is a space at the beginning.

Add the sender in the RPL as well.

When ordering make sure that you don’t have the email checkbox ticked in the Print Dialog.

You should only print to the NO_PRINTOUT logical printer.

Regards,

Chanaka

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

In order for this to work you need to print to a logical printer. Normally for just sending an email you need to print to the NO_PRINTOUT logical printer. 

So make sure,

  1. When you select the ‘Email Report’ from your application a print job is placed for a logical printer. If you are printing from the Print Dialog, you can just press OK.
  2. From the Print Manager check if the print job is there and if the job completes successfully and the job is not errored out.
  3. Check your mail server setting. Maybe the connect MAIL_SENDER is not properly configured. If this is the case the application message created in OUT or NOTIFICATION queue will be errored out. Check the states there.
  4. Check if you mail server allows sending mails to the email domains that you have given. Some companies blocks sending mails to outside email address.

Hope this helps to solve your issue.

 

Regards,
Chanaka


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • January 25, 2021

Hi Chanaka,

 

Thanks for you response. I checked the Print Manager as you suggested and found the following entry. Have you any suggestions on what I need to do to fix this?

 

 

Regards 

Mark


ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

It’s hard to tell with just the screenshot. If you hover on the message column or increase the width you should see the full error message or query the print_job_tab for the print key and see the full message.

My guess is that there was an error when the plugin class was been initiated. It’s different for tracks.

Apps 10

ifs.application.reportingservices.impl.extendedformatter.excelplugin.SimpleExcelPlugin

Apps 9 and below

ifs.application.printagentservice.impl.extendedformatter.excelplugin.SimpleExcelPlugin

Regards,

Chanaka

 

 


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • January 27, 2021

Hi Chanaka

 

I’ve checked on the screen and in the print_job_tab and there isn’t any more information for the error

Print_Job_Tab 

We are running Apps 8 and you mentioned for that the below plugin class ifs.application.printagentservice.impl.extendedformatter.excelplugin.SimpleExcelPlugin.

Is there anything for me to look at with that or do you think it is just my xml for the Purchase_Receipt_Rep,  (see attached). I’ve renamed from .rpl to .txt to allow it to be attached.

 


ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

In your RPL that is attached to this thread the plug-in class is 

ifs.application.reportingservices.impl.extendedformatter.excelplugin.SimpleExcelPlugin

not

ifs.application.printagentservice.impl.extendedformatter.excelplugin.ExcelPlugin

So it will definitely not work. The correct class for Apps8 is 

ifs.application.printagentservice.impl.extendedformatter.excelplugin.ExcelPlugin

also there is a space at the beginning.

Add the sender in the RPL as well.

When ordering make sure that you don’t have the email checkbox ticked in the Print Dialog.

You should only print to the NO_PRINTOUT logical printer.

Regards,

Chanaka


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • February 1, 2021

Thank you so much! That is now working. I just made the changes as you suggested in your post and it worked


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • February 1, 2021

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings