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

[sagarmemane92]

Need help if someone done this task earlier.

Thanks in advance

[raluca_edu]

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

[sagarmemane92]

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

[slangley]

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

[sagarmemane92]

Hi,

I have done this by using the scheduler

Thanks & Regards,

Sagar

[Constantine]

Hello @sagarmemane92,

Try to replace this:

body: Hi /* HTML */

with that:

body: emailContent /* HTML */

 Also you don't define rowvalue2 variable inside the loop.

/ Constantine

[slangley]

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