Company: Link Technologies
Case No: L11719. Project: 11.40: LinkSOFT Version 11.4
Logged By: Sanjay (Link Technologies) on 10 Sep 2019 03:55PM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 21.00 (Weight: 21.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Rashna, Sanjay
Resolve By: Friday, 13 September 2019 12:00 AM [1662 days since logged date]
Status: Closed
Subject: Improvements to handling Email from LinkSOFT
Summary:    Refactor and improve the way email addresses are validated and sent from LinkSOFT
Audit Notes:
10 Sep 201903:55PM Comment 1 by Sanjay (Link Technologies) Case 11719 added to project 11.00
10 Sep 201904:13PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-09-2019 04:13 PM Time Taken: 13.50

Development work for this case has been completed.

The change will be available in version:11.0.0910

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

  1. Added email address validation before sending emails. This validation happens in the menus "Email Log" and "Report Email Log". Email address validation does not happen when the Report is emailed using "Email Reports" from Business Intelligence "Reports" menu.
  2. Emails can be separated by ":",";" or ","
  3. Improved validation process so Reports are not created until the emails are validated. This will improve performance where reports take a long time to generate
  4. Users can now see which email address is invalid. Previously, the invalid email was difficult to sight.
  5. Made "Email Log" and "Report Email Log" email validation consistent
  6. Added Email Address Validation to Email Log and Report Email Log

2. Affected Areas:

  1. Email Log
  2. Report Email Log

3. The issue was caused by:

  1. Improvement and Refactoring

4. Notes
5. Next Step
: UAT


11 Sep 201912:59PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-09-2019 12:00 AM Time Taken: 2.50

Hi Sanjay

Below test cases need attention:

Test Case 1 - Notes are not updated to state why the email has "Failed"

  1. Set the system mode to "Test"
  2. Navigate to LinkWeb - Business Intelligence - Email Log.
    1. Add a new email with "Subject" and "Body" as "Get quote for Laptop".
    2. "To Address" as "rashna2linktechnologies.com.au"
    3. Send this email.
  3. The status changes from  "Ready"  --> "Retry" --> "Failed". No comments is added to the "Notes". 
  4. With respect to comment 2, item 1.4 the notes should be updated to state that the email address is invalid.

Test Case 2 - BCC and CC email addresses are not validated under "Report Email Log"

  1. Set the system mode to "Test".
  2. Set the test email address as "rashna2linktechnologies.com.au".
  3. Schedule the "Applicant Profile" report. 
  4. The above creates an  email  under "Report Email Log". The email fails. Notes is updated that a recipient is not specified.
  5. Now update the system code to "Live".
  6. Edit the line in 4 above. Set:
    1. To Address as - rashna@linktechnologies.com.au
    2. CC address as - vineshwar2linktechnologies.com.au
    3. BCC address as - sitlalinktechnologies.com.au
  7. Resend the email.
  8. Email is sent to invalid CC and BCC addressaa

Thanks
Rashna


12 Sep 201901:41PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-09-2019 01:41 PM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:11.003

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

  1. Added logging of Retry and Failed events to Email Notes
  2. Event log also gets updated

2. Affected Areas:

  1. Email Log
  2. Reports Email Log

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step
: UAT


13 Sep 201909:55AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-09-2019 09:55 AM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1
  1. Set the system mode to "Test"
  2. Navigate to LinkWeb - Business Intelligence - Email Log.
    1. Add a new email with "Subject" and "Body" as "Get quote for Laptop".
    2. "To Address" as "rashna2linktechnologies.com.au"
    3. Send this email.
  3. The status changes from  "Ready"  --> "Retry" --> "Failed"

Validate that the notes is updated to state that the "To", "CC" and "BCC" are invalid.


Pass
2Verify that users are unable to set the "To Address" as rashna2linktechnologies.com.au or rashnalinktechnologies.com.au on "Email Log" Pass
3
  1. Set the system mode to "Test".
  2. Set the test email address as "rashna2linktechnologies.com.au".
  3. Schedule the "Applicant Profile" report. 
  4. The above creates an  email  under "Report Email Log". The email fails. Notes is updated that a recipient is not specified.
  5. Now update the system code to "Live".
  6. Edit the line in 4 above. Set:
    1. To Address as - rashna@linktechnologies.com.au
    2. CC address as - vineshwar2linktechnologies.com.au
    3. BCC address as - sitlalinktechnologies.com.au
  7. Resend the email.
Validate that the notes is updated to state that the "To", "CC" and "BCC" are invalid. 
Pass
4Verify that users are unable to set the "To", "CC" and "BCC" as rashna2linktechnologies.com.au or rashnalinktechnologies.com.au on "Email Log" 
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.002.9012
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step

  1. Closure

    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11719 in the subject line of all emails regarding this issue.

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