WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-12252

Effective Date format issue for Employee Import

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Others
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 41

      Description

      *Scenario - *
      1) On Template Settings set date format as 'YYYYMMDD'.
      2) Add Employee's effective date field in sub template and map it to 'Employee Effective Date'.
      3) Manual or Scheduled import gets failed.

      Cause -
      When system tries to convert date value string to date format, it throws an exception. Ex. ''20100101' string can not convert to Date'. Since, string value don't have any separator, CType function can not convert it to appropriate date format.

      Correction -
      Code change is needed

        Attachments

        1. ElectioneffectiveDate.txt
          0.4 kB
        2. EmpEffectiveDate.txt
          0.7 kB
        3. FinalUpdatedTestcases.xls
          28 kB
        4. FW 1211 Sprint - Development Approval.msg
          51 kB
        5. FW Hot Fix and Development Approval Request.msg
          60 kB
        6. RE Approvals.msg
          34 kB
        7. Testcases.xls
          26 kB
        8. UpdatedTestcases.xls
          28 kB
        9. WaiveDate.jpg
          WaiveDate.jpg
          195 kB
        10. WaiveDate.txt
          0.5 kB
        11. WT-12252 Data.xls
          19 kB

          Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. WT-12735 Fix Import File Failures

          • Medium - Has the potential to affect progress.
          • Closed
          is caused by

          Enhancement - An improvement or enhancement to an existing feature or task. WT-10805 User generation for failed Imports after Employee data is inserted - Implementation

          • Medium - Has the potential to affect progress.
          • Production Complete
          is duplicated by

          Support Activity - Support Activity WT-12449 CVHP - Import failure

          • High - Serious problem that could block progress.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. NF-5470 Effective Date format issue for Employee Import

          • Medium - Has the potential to affect progress.
          • Resolution Setting

            Activity

            Ascending order - Click to sort in descending order
            snehal.katkar Snehal Katkar (Inactive) created issue -
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-8876 [ WT-8876 ]
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 3h [ 10800 ]
            Worklog Id 92009 [ 92009 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 3h [ 10800 ] 9h [ 32400 ]
            Worklog Id 92010 [ 92010 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Snehal Katkar [ snehal.katkar ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Developer Snehal Katkar [ snehal.katkar ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Original Estimate 0h [ 0 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 9h [ 32400 ] 12h [ 43200 ]
            Worklog Id 93419 [ 93419 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Description *Scenario - *
            1) On Template Settings set date format as 'YYYYMMDD'.
            2) Add Employee's effective date field in sub template and map it to 'Employee Effective Date'.
            3) Manual or Scheduled import gets failed.

            *Cause -*
             When system tries to convert date value string to date format, it throws an exception. Ex. ''20100101' string can not convert to Date'. Since, string value don't have any separator, CType function can not convert it to appropriate date format.

            *Correction -*
             It will get resolved under enhancement WT-8876.             		*Scenario - *
            1) On Template Settings set date format as 'YYYYMMDD'.
            2) Add Employee's effective date field in sub template and map it to 'Employee Effective Date'.
            3) Manual or Scheduled import gets failed.

            *Cause -*
             When system tries to convert date value string to date format, it throws an exception. Ex. ''20100101' string can not convert to Date'. Since, string value don't have any separator, CType function can not convert it to appropriate date format.

            *Correction -*
            Code change is needed
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-8876 [ WT-8876 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue is duplicated by WT-12449 [ WT-12449 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 12h [ 43200 ] 12.5h [ 45000 ]
            Worklog Id 93743 [ 93743 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: On Hold(10207)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 13h [ 46800 ]
            Worklog Id 94681 [ 94681 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            QA Jayshree Nagpure [ jayshree.nagpure ]
            Root Cause Bug [ 18430 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Labels Manual_import
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 13h [ 46800 ] 13.5h [ 48600 ]
            Worklog Id 94786 [ 94786 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue is caused by WT-10805 [ WT-10805 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Root Cause Bug [ 18430 ] Scenario/Requirement Missed [ 18432 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 41 - Bugs [ 95 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 12/Dec/2017
            Dev Estimates 22
            Remaining Estimate 0h [ 0 ] 8.5h [ 30600 ]
            Original Estimate 0h [ 0 ] 22h [ 79200 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue duplicates WT-12735 [ WT-12735 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Estimates 6
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for development [ 18453 ]
            Development Approval Yes [ 18474 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 8.5h [ 30600 ] 3.5h [ 12600 ]
            Time Spent 13.5h [ 48600 ] 18.5h [ 66600 ]
            Worklog Id 95609 [ 95609 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0.5h [ 1800 ]
            Time Spent 18.5h [ 66600 ] 21.5h [ 77400 ]
            Worklog Id 95610 [ 95610 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 22/Dec/17 [ 2017-12-22 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment Testcases.xls [ 69855 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Progress(10206)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Attachment FW 1211 Sprint - Development Approval.msg [ 69871 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Review Date 12/Dec/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 21.5h [ 77400 ] 22h [ 79200 ]
            Worklog Id 95776 [ 95776 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to NF-5470 [ NF-5470 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to NF-5470 [ NF-5470 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to NF-5470 [ NF-5470 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to NF-5470 [ NF-5470 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to NF-5470 [ NF-5470 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment EmpEffectiveDate.txt [ 70054 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment ElectioneffectiveDate.txt [ 70055 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment WaiveDate.txt [ 70056 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment WaiveDate.jpg [ 70057 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment UpdatedTestcases.xls [ 70058 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Snehal Katkar [ snehal.katkar ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 22h [ 79200 ] 26h [ 93600 ]
            Worklog Id 96183 [ 96183 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            satyap Satya made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 26h [ 93600 ] 31h [ 111600 ]
            Worklog Id 96622 [ 96622 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 31h [ 111600 ] 32h [ 115200 ]
            Worklog Id 96679 [ 96679 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 32h [ 115200 ] 37h [ 133200 ]
            Worklog Id 96730 [ 96730 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 37h [ 133200 ] 37.5h [ 135000 ]
            Worklog Id 96987 [ 96987 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 37.5h [ 135000 ] 45.5h [ 163800 ]
            Worklog Id 96999 [ 96999 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 45.5h [ 163800 ] 52.5h [ 189000 ]
            Worklog Id 97001 [ 97001 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Attachment FW Hot Fix and Development Approval Request.msg [ 70437 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Deployment Approval Approved for stage deployment,Approved for production deployment [ 18455, 18457 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Attachment RE Approvals.msg [ 70438 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment FinalUpdatedTestcases.xls [ 70475 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 22/Dec/17 [ 2017-12-22 ] 20/Dec/17 [ 2017-12-20 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Production Due Date 21/Dec/2017
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 52.5h [ 189000 ] 57h [ 205200 ]
            Worklog Id 97216 [ 97216 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Swapnil Eksambekar [ swapnil.eksambekar ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Attachment WT-12252 Data.xls [ 70600 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 57h [ 205200 ] 58h [ 208800 ]
            Worklog Id 97378 [ 97378 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 58h [ 208800 ] 60h [ 216000 ]
            Worklog Id 97785 [ 97785 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Production Complete(10222)Level 1 values: Closed(10223)

              People

              Assignee:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Reporter:
              snehal.katkar Snehal Katkar (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 22h Original Estimate - 22h
                  22h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 60h
                  60h