Company: Link Technologies
Case No: L09508. Project: 10.10: LinkSOFT Version 10.1
Logged By: Rashna (Edge Business Solutions) on 15 Aug 2018 08:00AM
Priority: Medium
Product: Helpdesk
Group: Software Defect
Time Taken: 2.00 (Weight: 2.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Thursday, 16 August 2018 11:59 PM [2082 days since logged date]
Status: Closed
Subject: Duplicate organisation code is created when data is imported from 9.4 to 9.5 - Helpdesk.
Summary:    

Hi Alvis, 

Can you please advise if the current functionality is valid.

  1. A NEW database has a default organization code.
    1. Navigate to Company Administration -- Organisations
    2. Code = 1001
    3. Description = Your Company Name.
  2. The 9401 helpdesk database also had an organisation code as 1001. Description as "Link Demo".
  3. Before importing the data, I updated the description of the organization in 95 to "Link Demo" also.
  4. However, when the data was imported two entries were created for the organization with code 1001. Refer to Figure 1.


I know we have the ability to disable one entry, but the duplicate entries at the first place are not valid.

Test Environment

  • Version 9500
  • Database - HELPDESK-UAT-LINKFJ

Figure 1: Organisation



Thanks
Rashna

Audit Notes:Edited by rashna on 08/12/20 09:43. Edited by alvis on 05/10/18 11:41. Edited by rashna on 15/08/18 08:00. Edited by rashna on 15/08/18 08:00. 
15 Aug 201802:15PM Comment 1 by Alvis (Link Technologies) Case 9508 added to project 09.5
15 Aug 201802:56PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-08-2018 02:56 PM Time Taken: 1.00
Development work for this case has been completed.
The change will be available in version: 9.5

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

  1. Added unique index on "Organisation" code to prevent the duplicate import of data.

2. The issue was caused by:


    3. Next Step



    23 Aug 201807:39AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-08-2018 07:39 AM
    Proceed with UAT using LinkSOFT95BETA2

    24 Aug 201801:08PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-08-2018 01:08 PM Time Taken: 1.00
    Hi Sanjay
    QA Results
    Tests carried out according to requirements specified on the case header

    Test Results Summary

    Table 1 - Summarised list of issues
    NoTest Description Pass/Fail 
    1
    Create helpdesk database as   HELPDESK-941-LINKFJ set the organization as 1001 - LinkDemo 941 
    Pass
    2Create helpdesk database as   HELPDESK-95B2-LINKFJ set the organization as 1001 - LinkDemo 95Pass
    3Import the helpdesk database from 941 to 95. Validate that after data import only entry is exist under "Organisation" as LinkDemo 95 Pass

    Environment Details

    1. OS version:Windows Server 2012
    2. Application version:9.5  Beta 2
    3. Setup: Demo 
    4. Server : QA4
    5. Database:HELPDESK-941-LINKFJ &  HELPDESK-95B2-LINKFJ

    Steps to reproduce failed scenarios:

    1. N/A

    Next Step
    Case assigned Sanjay for closure.


    28 Aug 201809:13AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-08-2018 09:13 AM
    Thanks Rashna 

    09 Oct 201908:14AM Comment 6 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
    08 Dec 202009:43AM Comment 7 by Rashna (Edge Business Solutions) ETC was changed from 16/08/2018 to 16/08/2018
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09508 in the subject line of all emails regarding this issue.

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