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

Effective Date format issue for Employee Import

    XMLWordPrintable

    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
    • Dev Estimates:
      22
    • QA Estimates:
      6
    • Code Reviewed By:
      Jaideep Vinchurkar
    • Development Approval:
      Yes
    • Deployment Approval:
      Approved for stage deployment, Approved for production deployment

      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. Testcases.xls
          26 kB
        2. FW 1211 Sprint - Development Approval.msg
          51 kB
        3. EmpEffectiveDate.txt
          0.7 kB
        4. ElectioneffectiveDate.txt
          0.4 kB
        5. WaiveDate.txt
          0.5 kB
        6. WaiveDate.jpg
          WaiveDate.jpg
          195 kB
        7. UpdatedTestcases.xls
          28 kB
        8. FW Hot Fix and Development Approval Request.msg
          60 kB
        9. RE Approvals.msg
          34 kB
        10. FinalUpdatedTestcases.xls
          28 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

              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