Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5470

Effective Date format issue for Employee Import

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold

      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

      This ticket is for tracking NF checkin for WT-12252

        Attachments

        1. 5470.jpg
          5470.jpg
          204 kB
        2. 5470Error.txt
          0.2 kB
        3. FinalUpdatedTestcases.xls
          28 kB

          Issue Links

            Activity

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) created issue -
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (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)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Snehal Katkar [ snehal.katkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Review Date 12/Dec/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Dev Due Date 12/Dec/2017
            Development Approval Yes [ 18474 ]
            Root Cause Scenario/Requirement Missed [ 18432 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            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 -
            Attachment 5470.jpg [ 69987 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment 5470Error.txt [ 69988 ]
            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 In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Snehal Katkar [ snehal.katkar ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 95939 [ 95939 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Rashmita Dudhe [ rashmita.dudhe ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 1h [ 3600 ] 3h [ 10800 ]
            Worklog Id 96117 [ 96117 ]
            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 Rashmita Dudhe [ rashmita.dudhe ] Snehal Katkar [ snehal.katkar ]
            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 ]
            jaideep.vinchurkar Jaideep Vinchurkar (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)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            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 FinalUpdatedTestcases.xls [ 70681 ]
            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: On Hold(10211)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 3h [ 10800 ] 5h [ 18000 ]
            Worklog Id 97653 [ 97653 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Stage Testing [ 10201 ] Resolution Setting [ 11616 ]

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5h
                  5h