Skip to main content
1-Visitor
February 19, 2020
Question

I want to send grid data(Daily,Weekly,Monthly) automatically through mail in thingWorx 8.5

  • February 19, 2020
  • 2 replies
  • 2084 views

Need help if someone done this task earlier.

 

Thanks in advance

2 replies

17-Peridot
February 21, 2020

Hi,

 

First, you need to create a Notification Thing that implements the MailServer Template and add your SMTP settings in Configuration. This is needed to be able to send emails.

After this, how emails should be sent? Automatically, at the end of day, end of month, specific hours or when you are clicking a button? What do you want to trigger the emails to be sent? Maybe you can use a scheduler if you want specific hours/day.

Based on the trigger, you need to create service that send email (SendMessage Snippet from your Notification Thing)

In the SendMessage you can add the content of the email. I don't have an example, but probably you can provide an infotable as input to SendMessage. The infotable is the result that is filtering your grid.

 

Here is a link explaining Notifications: http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FComposer%2FThings%2FNotifications.html

 

 

Hope it helps,

Raluca Edu

1-Visitor
February 21, 2020

Hey raluca

 

I want to send the data automatically.I am using the data table .In service i am fetching the data and in subscription i am sending trying to send the data in html format through mail.But unfortunately my subscription not calling .I don't exactly error.(Script log- Error in: EMS_Scheduler_Sagar.Weekly_PF_Report javascript service)

Here I am attaching the service and subscription file 

 

 

Thanks in advance 

 

Sagar

 

Support
March 11, 2020

Hi @sagarmemane92.

 

Have you tested to be sure the email configuration is correct and working?  Is the subscription enabled?

 

If these questions don't lead you to a solution, please provide the logs located in \ThingworxStorage\logs and the configuration details.

 

Regards.

 

--Sharon

Support
March 19, 2020

Hi @sagarmemane92.

 

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon