Difference between revisions of "Automated Email Installation"

Revision as of 23:38, 8 March 2016

SME Automatic Outbound Email Event
The purpose of this add on program is to automatically notifiy Techs and Customers of creation/closing and scheduling of Service Tickets or Issues within SME. This bundled with the SME ability to handle incoming mail can create a powerful tool for capturing and issuing emails automatically without SME being open, or user interaction.

Requirements

SME version 7.1 or later
SME Web services setup on IIS for incoming mail. SME does not capture emails directly.
SME Field Scheduler for setup of Incoming and Outgoing Mail
Admin account in SME must have a valid and working SMTP outgoing email, see Email Settings
Exclusive Access is Required - All Users Must Be Out of SME

Not covered in this add on

Sending Tickets to customer automatically
Email campaigns

SME Field Scheduler Install Setup

The Field Scheduler is used to choose the setting of both incoming and outgoing mail. The interface as shown below displays the options that available. A description of what each event being selected is provided below the event header.

1. If C:\Users\Public\High5software is not the default directory, then you must click on the browse button to navigate to location of SME5.exe
2. Once you have found the directory you should be able to select your company in the select company drop down.
3. In the Email Add-On section, you can choose which events you wish to enable.
4. Once you are done you click Install Field Scheduler. Close the application when it completed.

Inbound Account Setup

Server part of Mail services is hosted by high 5 Software. Login requirements for your inbound accounts will be required to set up the capturing portion.

Outbound Account Setup

The automatic outbound email utilizes the settings found under the Administrator.

Modifying outbound looks and information Emails

It is possible to modify the outbound emails look and information. If you are interested please notify high5 software. The automatic outgoing email templates have a few basic rules that, when followed, make it pretty easy to work with:

You need to have a Subject and a Summary field - these translate to Email Subject and Email Body in the sent email. -Seen in code as "as Subject" and "as Summary"

You are pulling from service/Install "a", and customer contact "b" as your available database fields to work with.

If it's a non-text field (Such as ordernumber, which is a number), you must use: cast([field] as varchar(max))

Wrap all fields in isnull([field],) so as not to break the report on null database values.

Otherwise, you're just writing the email text and adding some simple HTML for formatting.

' ' = new line.

Sample Template:

'[' + cast(a.OrderNumber as varchar(max)) + '] for : ' + a.CustName as Subject, isnull(a.CustName,'') + ' ' + isnull(a.addressblock, '') + ' ' + a.Summary' + ' ' + cast(a.ordernumber as varchar(max)) + ' ' + 'Services Performed:' + ' ' + isnull(a.ServPerf,'') as Summary

For a test order with these fields: Custname: TestCust OrderNumber: 200 Address: 3243 15th St SomeAddress, SomePlace Services Performed: "Went to the place and did the stuff" Summary: Some Job

The above template would give you this layout:

Email Subject: [200] for : TestCust

Email Body: TestCust 3243 15th St SomeAddress, SomePlace Some Job

200

Services Performed: "Went to the place and did the stuff"

The standard outgoing email format looks like this:

'[' + cast(a.OrderNumber as varchar(20)) + '] for : ' + a.CustName as Subject, a.CustName + ' ' +isnull(a.AddressBlock, '') + ' ' +'Bemuda Elevator Service Order ' + cast(a.DateTimeIn as varchar(100)) + ' has been ' +isnull( a.OrderStatus,'') + '.' + ' ' + 'Priority Level:' +isnull(cast(a.Priority as varchar(20)),'') + ' ' + 'Summary:' +isnull(a.Summary, 'Summary') + ' ' + 'Contract type:' +isnull(a.SLACategory, 'FSMA or E&L')+ ' ' + 'Order number : '+isnull(cast(a.RefNum as varchar(20)),'') +' Technician assigned: ' + isnull(a.AssignedTo, 'Nobody') + '.' + ' ' +'Site contact: ' + b.Name + ' ' + isnull(b.Email, '') + ' ' +'Services Requested: ' + ' ' + isnull(a.ServReq,'') + ' ' +'change order status on arrival & leaving job; + ADD A TIME TICKET WITH NOTE: ' + ' ' + isnull(a.ServPerf,'') + ' ' as Summary

@@ Line 1: / Line 1: @@
 '''SME Automatic Outbound Email Event'''
-<br>The purpose of this add on program is to automatically notified Techs and Customers of creation/closing
+<br>The purpose of this add on program is to automatically notifiy Techs and Customers of creation/closing
 and scheduling of Service Tickets or Issues within SME. This bundled with the SME ability to handle
 incoming mail can create a powerful tool for capturing and issuing emails automatically without SME