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

            Activity

            snehal.katkar Snehal Katkar (Inactive) logged work - 21/Nov/17 05:47 AM
            • Time Spent:
              3h
               

              Analysis

            snehal.katkar Snehal Katkar (Inactive) logged work - 22/Nov/17 05:48 AM
            • Time Spent:
              6h
               

              Analysis, code debugging

            snehal.katkar Snehal Katkar (Inactive) logged work - 28/Nov/17 09:27 PM
            • Time Spent:
              3h
               

              Analysis, code change, testing

            snehal.katkar Snehal Katkar (Inactive) logged work - 29/Nov/17 11:57 AM
            • Time Spent:
              5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 30/Nov/17 12:16 AM
            • Time Spent:
              0.5h
               
              <No comment>
            snehal.katkar Snehal Katkar (Inactive) logged work - 30/Nov/17 11:57 PM
            • Time Spent:
              3h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 05/Dec/17 07:34 AM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 05/Dec/17 03:18 PM
            • Time Spent:
              0.5h
               

              3C analysis

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 12/Dec/17 12:36 PM
            • Time Spent:
              0.5h
               

              code review

            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 14/Dec/17 12:55 PM
            • Time Spent:
              4h
               

              Testing on LB

            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 15/Dec/17 04:45 PM
            • Time Spent:
              5h
               

              Testing on LB, discussion with dev

            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 18/Dec/17 11:56 AM
            • Time Spent:
              5h
               

              testing on LB

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 18/Dec/17 02:09 PM
            • Time Spent:
              1h
               

              discussions

            suraj.sokasane Suraj Sokasane (Inactive) logged work - 18/Dec/17 03:34 PM
            • Time Spent:
              7h
               

              Discussion with Snehal
              WT-10853 Code changes analysis
              Election Import Solutions

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 19/Dec/17 02:59 PM
            • Time Spent:
              0.5h
               
              <No comment>
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 19/Dec/17 03:33 PM
            • Time Spent:
              8h
               

              Repro on Local
              Local and Stage/Prod code compare
              Scenario understanding
              Repro on Prod
              Code changes
              Unit Testing
              Discussion with Jaideep and Snehal.

            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 20/Dec/17 09:54 AM
            • Time Spent:
              2h
               

              Stage testing

            suraj.sokasane Suraj Sokasane (Inactive) logged work - 20/Dec/17 01:51 PM
            • Time Spent:
              4.5h
               

              code chackin to various branches : UI refresh, UI refresh LB, Production
              Checking out New Production branch, UI refresh LB branch.

            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 21/Dec/17 12:25 PM
            • Time Spent:
              1h
               
              <No comment>

              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