Company: Link Technologies
Case No: L08950. Project: 09.40: LinkSOFT Version 9.4
Logged By: Alvis (Link Technologies) on 01 Dec 2017 11:41AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 14.00 (Weight: 14.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 31 January 2018 12:00 AM [2332 days since logged date]
Status: Closed
Subject: Consolidate "sending mail configurations" and setup to use DOT NET Mail
Summary:    
  1. Move all database mail to dot netmail.
  2. All the email parameters need to be company specific. e.g from email address can be different for each company.
  3. Add logging capability similar to report email log and move it to BI section with report email log.

Justification

  1. Linksoft uses 2 mail transport system to simplfy we should 1.
  2. Error logging with dot.net mail is more detailed and visible to the user.
  3. Users can resend failed mail from dot.net
Audit Notes:
01 Dec 201711:41AM Comment 1 by Alvis (Link Technologies) Case 8950 added to project 8.3
12 Jan 201812:32PM Comment 2 by Alvis (Link Technologies) Case 8950 added to project 900
19 Apr 201808:51AM Comment 3 by Sanjay (Link Technologies) Case 8950 removed from project 999
19 Apr 201808:51AM Comment 4 by Sanjay (Link Technologies) Case 8950 added to project 09.4
19 Apr 201811:46AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-04-2018 11:46 AM

Agreed design:

  1. Move menu "Administration ~> Email Log" to "Business Intelligence ~> Email Messages"
  2. Use DOT NET Mail to send messages
  3. Remove processes to DB Mail
  4. Add ability to create a new email
  5. Add ability to edit emails with status <> "Sent"
  6. Add ability to delete
  7. Add notes user control to store log information
  8. Add ability to RESEND
  9. This should have similar functionality to "Report Email Log"

23 Apr 201803:30PM Comment 6 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 23-04-2018 03:30 PM Time Taken: 6.00
Development work for this case is in progress.
The change will be available in version: 94

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

  1. Added a schedule to pick up LT_SYS_MSG_Notification emails using procedure: LT_SYS_MSG_Notifications_SELECT
  2. After sending email, this procedure is called: LT_SYS_MSG_Notifications_UPDATE

2. The issue was caused by:

  1. NA

    3. Next Step

    1. Changes were made in DEV-HELPDESK. Please sync framework components from DEV-HELPDESK to DEV-LINKSOFT
    2. Change procedure  "LT_SYS_MSG_Notifications_SELECT" to handle selection criteria used by DB Mail
    3. Change procedure  "LT_SYS_MSG_Notifications_UPDATE" to handle Logging previously used by DB Mail
    4. Disable and remove/Cleanup all DB mail references and configurations

    23 Apr 201804:25PM Comment 7 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-04-2018 04:25 PM Time Taken: 2.00

    The following have been completed:

    1. Changed procedure LT_SYS_MSG_Notifications_SELECT to handle multiple processes running at the same time.
    2. Changed procedure LT_SYS_MSG_Notifications_UPDATE to handle error logging and retry attempts
    3. Moved retry attempts to Configuration -> General Settings
    4. Removed process "SYS006" and its related rules.
    5. Moved Email Log to display under Business Intelligence
    Next Step:
    1. Make UI changes for Email Log

    23 Apr 201805:59PM Comment 8 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 23-04-2018 05:59 PM

    I have made changes to the Email Log form to allow Add/Edit and Delete.

    Please complete procedures: LT_SYS_MSG_Notifications_DELETE,..._UPDATE2 ( UPDATE2 should handle Insert and Update)

    DEV Sites have been updated.


    26 Apr 201809:08AM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-04-2018 09:08 AM Time Taken: 1.00

    Procedures for Insert, update, and delete have been completed.

    Assigned to UAT.


    02 May 201804:26PM Comment 10 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-05-2018 04:26 PM Time Taken: 1.00

    System test completed.

    Verified the following:

    1. Tested Add of Email Log maintenance under Business Intelligence menu in POS Web. - Failed. Application Name is not provided to procedure LT_SYS_MSG_Notifications_UPDATE2.
    2. Created an alert entry to the notifications. The email was successfully received.

    Note:

    1. Settings for "mail server" and "mail from address" is configured in the web.config file.
    2. Ensure that the flag "EnableEmailScheduler" is set to "Yes" in the web.config file.

    regards
    Alvis


    03 May 201802:47PM Comment 11 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-05-2018 02:47 PM Time Taken: 1.00
    Development work for this case has been completed.
    The change will be available in version: 9401

    1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

    1. Added "Application Name" to procedure LT_SYS_MSG_Notifications_UPDATE2

    2. The issue was caused by:

    1. Application Name was not interfaced

      3. Next Step

      1. UAT

      09 May 201801:23PM Comment 12 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 01:23 PM Time Taken: 1.00

      System test completed.

      Verified: Tested Add of Email Log maintenance under Business Intelligence menu in POS Web. - Pass


      14 May 201802:03PM Comment 13 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-05-2018 12:00 AM Time Taken: 2.00

      Hi Sanjay, 

      This case has been successfully tested.

      Documentation has been updated on the case.

      • Business Intelligence -- Email Log.

      Test Environment
      • Version 9400 Beta 2
      • Database - LINKSOFT on QA1
      • Application on QA1
      • OS - Windows 7

      Test Plan

      Test NoDescriptionStatus
      1Click on "Add New", the form should open without errorsPass
      2Enter the "Subject" as "Test", "To Address" as "rashna@linktechnologies.com.au" and body as "Test". Save this and email should be successfully sent.Pass
      3Enter the "Subject" as "Test", "To Address" as "rashna@linktechnologies.com.au" and body as "Test". Save this and email should be successfully sent. Enter "CC Address" as "vineet@linktechnologies.com.au" and "BCC Address" as "karishma@linktechnologies.com.au". Email should be sent to all addresses.
      		Pass
      4Enter the "Subject" as "Test", "To Address" as "rashna@linktechnologies.com.au" and body as "Test". Save this and email should be successfully sent. Delete the record by clicking on the "Red X"
      		Pass
      5Click into the details and "Add Notes". Notes should be successfully added.Pass


      16 May 201803:46PM Comment 14 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-05-2018 03:46 PM
      Thanks Rashna 

      09 Oct 201908:14AM Comment 15 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08950 in the subject line of all emails regarding this issue.

      Document size: 9.8 KB
      For call complaints, please contact the Managing Director of the company using this form.