Company: Link Technologies
Case No: L09726. Project: 11.40: LinkSOFT Version 11.4
Logged By: Sanjay (Link Technologies) on 28 Nov 2018 09:26AM
Priority: High
Product: Helpdesk
Group: Enhancement
Time Taken: 22.00 (Weight: 22.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 30 November 2018 12:00 AM [1976 days since logged date]
Status: Closed
Subject: Helpdesk cases with large images are causing performance issues and Alert display issues
Summary:    

Gmail clips messages that are more than 102KB in size. Since Link Helpdesk Images are embedded in the email, this contributes to the email message size.

To resolve the issue we will perform the following:

  1. Create a function that checks the email message size and reduces the size to comply with GMAIL size
  2. The function can be called: LT_SYS_EmailMessageCorrection_fn
  3. To reduce the size, we can remove embedded images and replace it with the text "Image can be viewed on the helpdesk"

--- Previous header content below this line ---

Helpdesk images are stored in the Database as well as on the site files depending on how the image is pasted. 

We need to transform the images so storage is consistent and the size is limited to the configured value.

To resolve this we will perform the following changes:

  1. Add a configuration in c"configuration" on the Image Size limit
  2. When images are pasted, save them on the Database instead of the Site folder
  3. Review alert display and correct
Audit Notes:Edited by sanjay on 11/09/19 14:05. Edited by sanjay on 17/12/18 11:06. 
28 Nov 201809:26AM Comment 1 by Sanjay (Link Technologies) Case 9726 added to project 10.2
28 Nov 201809:32AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-11-2018 09:32 AM Time Taken: 1.50
Added document size to the end of the "Report Document" so we can see which cases are causing the issue.

17 Dec 201808:08AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-01-2019 12:00 AM Time Taken: 1.50
Development will continue in 10.2

17 Dec 201811:05AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-12-2018 11:05 AM Time Taken: 4.50

Gmail clips messages that are more than 102KB in size. Since Link Helpdesk Images are embedded in the email, this contributes to the email message size.

To resolve the issue we will perform the following:

  1. Create a function that checks the email message size and reduces the size to comply with GMAIL size
  2. The function can be called: LT_SYS_EmailMessageCorrection_fn
  3. To reduce the size, we can remove embedded images and replace it with the text "Image can be viewed on the helpdesk"

23 Jan 201909:20AM Comment 5 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 23-01-2019 09:20 AM Time Taken: 2.50

Consider the following:

  1. Add a configuration to set the email size as some clients using OUTLOOK will not have this issue. The default size is 102KB.
  2. Create a system function LT_SYS_RemoveImageFromHTML_fx
  3. When an email is added to the email log, implement the above.

23 Jan 201905:06PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-01-2019 05:06 PM Time Taken: 3.50

Development work for this case has been completed.

The change will be available in version: 10.2

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

  1. Added a configuration "EmailSizeToRemoveImage". Default value is 102KB
  2. Created function LT_SYS_RemoveImageFromHTML_fx to strip image data

2. The issue was caused by:

  1. Change request

3. Next Step:

  1. UAT

4. Notes:

  1. When an email is created in the email log, the system function will check the size of the email content. If size is greater than [Configured Value] (default is 102kb) then it will strip the images from the email body.

31 Jan 201901:32PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-02-2019 12:00 AM Time Taken: 3.50
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
1In the demo database, set "EmailSizeToRemoveImage" to 200KB. Configuration should be successfully saved Pass
2In the demo database, add "Figure 1" with an image size as 330KB and "Figure 2" with an image size as 5KB on case 9048. The images should be removed from the notificationPass
3Create a detailed case with a 2KB image. The image should remain in the notification.Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 10.2
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT102

Steps to reproduce failed scenarios:

Next Step: for consideration,

We are displaying the message as "Image has been removed to reduce size". Can we state "
Image can be viewed on the helpdesk" as indicated in the case header? As it is, a user would be unclear of the next step. They might say it is a bug in the system that has removed  the image or will contact us to ask why it has been removed and where can they view it.

On the contrary, not all users have access to Helpdesk.  We might need to think of a better message.

Note:

Reassign case to me for documentation after addressing the above.


    06 Feb 201902:45PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-02-2019 02:45 PM Time Taken: 1.50
    Hi Rashna, we carefully considered the text to place in the emails. We will leave this as it is for now.  thx.

    07 Feb 201908:55AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-02-2019 12:00 AM Time Taken: 1.50
    Case re-opened for documentation.

    14 Feb 201907:44AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-02-2019 07:44 AM Time Taken: 2.00

    Documentation updated under Link Web Applications Portal -- Company Administration -- Configuration -- General Setting.

    Case is now closed.


    09 Oct 201908:14AM Comment 11 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: L09726 in the subject line of all emails regarding this issue.

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