Enhancement #6202

[UAT3-9 - UAT_218] - Promotion >> Registration - Import Company

Added by Norhaidah Md Dasuki over 8 years ago. Updated over 8 years ago.

Status:Closed - End of life cycleStart date:April 18, 2016
Priority:HighDue date:April 21, 2016
Assignee:Norhaidah Md Dasuki% Done:

100%

Category:KIV_Phase2Spent time:-
Target version:-

Description

To include salutation in import from excel script.

6/4/2016 - This issue has been log as Production issue due to urgency. Refer Support #6048
[TPMS_Prod080]

11/4/2016 - [KD] Salutation not save in database. When view company details, salutation not appear.

20160426 - tpms.csv Magnifier (650 Bytes) Aditya Prathama, April 26, 2016 14:37

Enhancement #6202_Test Result -UAT_246.docx (1.22 MB) Norhaidah Md Dasuki, May 26, 2016 16:40

History

#1 Updated by Norhaidah Md Dasuki over 8 years ago

  • Category changed from KIV_Phase1 to KIV_Phase2

#2 Updated by Najmi Pasarudin over 8 years ago

  • Assignee changed from Najmi Pasarudin to Aditya Prathama

#3 Updated by Aditya Prathama over 8 years ago

  • File 20160426 - tpms.csvMagnifier added
  • Assignee changed from Aditya Prathama to Norhaidah Md Dasuki
  • % Done changed from 0 to 100

Finding: Actualy the problem is not from TPMS Apps. it from data user provide for column Salutation. Because they provide data for example salutation is Mr inside the csv, but inside the DB salutation is MR not Mr so the apps will store empty salutation because cant found "Mr" inside db.
Solution: adding to force data for salutation to always all upper case to avoid similar mistake. Notes(Data which already imported using Import company that affect due this issue need to be fix salutation manually)

updated apps deployed at http://172.25.96.137/matrade-tpms/login

for testing csv attached to this ticket.

#4 Updated by Tan Lee Yong over 8 years ago

Will this fix caused the display and report to show the salutation on upper case, like MR. Aditya. If yes, does customer accept this solution?

#5 Updated by Tan Lee Yong over 8 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#6 Updated by Norhaidah Md Dasuki over 8 years ago

  • Status changed from Development / Work In Progress to User Acceptance Test

Currently all report generated in TPMS does not required to display Salutation. For that there is not issue if we proceed on the fixes as its only to be able to be view in the Company Registration details screen.

#7 Updated by Norhaidah Md Dasuki over 8 years ago

  • Status changed from User Acceptance Test to Development / Work In Progress
  • Assignee changed from Norhaidah Md Dasuki to Tan Jeng Wei
  • % Done changed from 100 to 80

#8 Updated by Norhaidah Md Dasuki over 8 years ago

  • Status changed from Development / Work In Progress to User Acceptance Test
  • Assignee changed from Tan Jeng Wei to Norhaidah Md Dasuki
  • % Done changed from 80 to 100

#9 Updated by Norhaidah Md Dasuki over 8 years ago

  • Subject changed from [UAT1&2 - UAT_218] - Promotion >> Registration - Import Company to [UAT3-9 - UAT_218] - Promotion >> Registration - Import Company

#10 Updated by Norhaidah Md Dasuki over 8 years ago

  • Status changed from User Acceptance Test to Development / Work In Progress
  • Assignee changed from Norhaidah Md Dasuki to Aditya Prathama
  • % Done changed from 100 to 90

promotion - to include salutation in import from excel script

12/5/2016 - Salutation only saved at "representative" but not saved in "contact information"

Adit, please fix.

#11 Updated by Aditya Prathama over 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Aditya Prathama to Siti Norahayu Mohd Desa

Fixed please retest

#12 Updated by Norhaidah Md Dasuki over 8 years ago

  • File Enhancement #6202_Test Result -UAT_246.docx added
  • Status changed from Internal Testing to User Acceptance Test
  • Assignee changed from Siti Norahayu Mohd Desa to Norhaidah Md Dasuki
  • % Done changed from 90 to 100

26/5/2016 - Reported issue has been fixed. Send to User to retest.

#13 Updated by Norhaidah Md Dasuki over 8 years ago

  • Status changed from User Acceptance Test to Pending Prod Deployment

27/5/2016 [Helmi] - All issue had been successfully retest and closed. Pending for Production Deployment

#14 Updated by Norhaidah Md Dasuki over 8 years ago

  • Status changed from Pending Prod Deployment to Closed - End of life cycle

Production Deployment
31/5/16 [Rizal} - Deployed to production - War. File TPMS_v031

Also available in: Atom PDF