Company: Link Technologies
Case No: L12673. Project: 13.30: LinkSOFT Version 13.30
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 01 Feb 2022 08:55PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 29.00 (Weight: 32.00)
Version: 13.30
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Sanjay
Resolve By: Monday, 21 March 2022 11:59 PM [807 days since logged date]
Status: Closed
Subject: Upload of "KPI Type" fails when using long Values in KPI TYPE
Summary:    

Hi Sanjay

When testing the Upload templates created as per Reference Case No: L12552 and found the below issues in "uploading of KPI Maintenance". Refer query below:

When uploading KPI Maintenance, there are facing validation errors: below is a comparison of 2 rows that have both dash characters.

  1. Column "D" in the KPI Maintenance excel is "KPIType"
  2. Row 4 KPI type is "HCM - Succession Planning development and upskilling" 
  3. and Row 11 KPI Type is "IT - Security Enhancement"
  4. Both these KPI Type's are already created in the system
  5. Both the KPI Type's have a dash (-)
  6. However, when uploading, Row 4 says failed but Row 11 is validated
Refer to Figure 1: KPI Maintenance Upload Validation 


This is being tested in their training environment, requesting if we can take a look into this. 

They have requested to allow commas, full stop, dashes, quotation (, . - ; ), etc when performing the upload process.

Audit Notes:Edited by aarti on 18/03/22 10:11. Edited by sanjay on 18/02/22 10:15. Edited by sanjay on 15/02/22 14:06. Edited by sanjay on 03/02/22 13:25. Edited by sanjay on 02/02/22 15:50. Edited by sanjay on 02/02/22 14:09. Edited by aarti on 02/02/22 08:10. Edited by aarti on 01/02/22 20:55. 
02 Feb 202209:18AM Comment 1 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 02-02-2022 03:15 PM
Hi Aarti, can you reproduce this in QA8? you should be able to use DEMO environment.

02 Feb 202211:09AM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 02-02-2022 04:57 PM Time Taken: 1.00

Hi Sanjay

Issue replicated – refer environment details:

  1. URL: 10.0.0.18/LINKSOFT
  2. Database: Link Technologies - DEMO
  3. Login: standard Link Admin username and password


Scenario:

  1. Uploaded KPI Types using excel “CompanyAdministrationDropdown”
  2. This was successfully uploaded
  3. Now uploaded KPI Maintenance using excel “PerformanceManagementKPIMaintenance”
  4. Received validation error “Failed - KPI Type is Invalid” in lines 4, 9, and 10. Refer to Figure 1.
  5. Verified the KPI Type in line 4 “HCM - Succession Planning| development and upskilling” – this was uploaded successfully in step 1. Refer to Figure 2.

 

Refer to Figure 1:



Refer to Figure 2:



02 Feb 202201:24PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-02-2022 06:09 PM

Hi Aarti, I had a look at this and found that the KPI TYPE should not exceed 50 Characters. This is the initial design of the system.

I will release a patch with the validation message stating the issue. We can look at extending the field width in future versions.

I will leave the case assigned to Development so we can issue a Patch for this validation.


02 Feb 202202:09PM Comment 4 by Sanjay (Link Technologies) Case L12673 added to project 13.30
02 Feb 202202:10PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-02-2022 08:09 PM Time Taken: 1.00

Skype Message:

AARTI

Hi Sanjay

with reference to the comment "KPI TYPE should not exceed 50 Characters."

In TLTB case, they have been using KPI Type which is more than 50 characters..

They have one KPI Type (dropdowns) which is 228 characters already in the application

Sanjay 2:06 PM
Hi Aarti, yes I will look in and see what field width we have used and release a patch accordingly. ill try and get this by Friday


02 Feb 202202:22PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-02-2022 08:22 PM Time Taken: 1.00

Hi Aarti,

Can you do an Upload of other fields that are long, E.G Score type, Measure etc so that we can test this once?

maybe create a file with some additional score Types and other fields that are long enough for TLTB. Upload this and I can make sure it's done once

03 Feb 202210:50AM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-02-2022 01:55 PM Time Taken: 13.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 13.30 and PATCH for V13.20 as 13.20.0203

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

  1. Changed the KPI Maintenance upload file to use CODE instead of Description. The code is limited to 50 characters
  2. Added validations for File upload in the areas specified in Table 1

3. Affected Areas:

  1. File Upload for Leave Transactions and KPI Maintenance

4. The issue was caused by:

  1. Upload template should use Code instead of Description. This will allow users to use large descriptions while maintaining 50 characters in the "Code" fields.

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


PART B -
Development Reference (Place descriptor for objects changed)
:


Table 1 - Added validations for the following codes

Upload TypeField NameSizeComments
LeaveApplicationEmployeeID50Added Validation
 LeaveType50Added Validation
KPIAppraisalTemplateCode50Added Validation
KPIGroupCode50Added Validation
KeyPerformanceMaintenanceCode50Added Validation
 KPIType1Added Validation
 ScoreTypeFormat50Added Validation
KeyPerformanceMeasureCode50Added Validation

03 Feb 202211:32AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-02-2022 04:50 PM Time Taken: 6.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Upload Leave Applications with Leave Code > 50 Characters
Message to say Leave Type cannot be > 50 Characters
Pass

2Upload KPI Appraisal Template
When KPI Type, Maintenance Code or Score Format > 50 Characters, Validation Message
Pass

3
Invalid Code for KPI Type, Maintenance Code or Score Format
Pass

4
The score type has to be 1 character
Pass

5
Description fields allow up to 8000 characters
Pass

Environment Details

  1. OS version: Win10
  2. Application version: 13.30
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: UAT on 13.20 and Closure


03 Feb 202201:37PM Comment 9 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 03-02-2022 07:28 PM Time Taken: 1.00

The following tests were performed:

Table 1 - Test Results

No

Test Case

Expected Result

Pass/Fail

Comments

1

Upload KPI Appraisal Template

KPI Type code validated

Pass

 

2

 

Score Type code validated

Pass

 

3

 

Score Format validated

Pass

 


Environment Details

  1. Application version: 13
  2. URL: 10.0.0.18/LINKSOFT
  3. Database: Link Technologies - DEMO
  4. Login: standard Link Admin username and password

03 Feb 202201:37PM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-02-2022 07:37 PM
Status changed to UAT

03 Feb 202203:30PM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-02-2022 09:29 PM
13.20 Patch release completed. 

08 Feb 202211:50AM Comment 12 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 08-02-2022 05:43 PM Time Taken: 1.00

Hi Sanjay

There is one particular KPI Maintenance that is failing to upload. The codes for KPIType, ScoreType, and ScoreFormat are active in its maintenance tables, however, uploading this KPI gives we get this error message:

"Failed - Data is invalid. Expected 7 columns.KPI Type cannot be more than 50 characters in length ScoreType cannot be more than 1 character in length Score Format is Invalid" 

There are other KPI Maintenances that are using the same "ScoreType, and ScoreFormat" but these have been uploaded successfully.

Refer to Figure 1: KPI Maintenance Upload Validation