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
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 21/Nov/17 05:47 AM
            • Time Spent:
              3h
               

              Analysis

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

              Analysis, code debugging

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

              Analysis, code change, testing

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

              3C analysis

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

              code review

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

              Testing on LB

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

              Testing on LB, discussion with dev

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

              testing on LB

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

              discussions

            Permalink
            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

            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 19/Dec/17 02:59 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            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.

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

              Stage testing

            Permalink
            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.

            Permalink
            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