WORKTERRAProject Type: software

WORKTERRA

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

Import - Recruit data - Implementation

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Recruit
    • Labels:
      None
    • Module:
      BenAdmin - Import
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 19

      Description

      Import should support for recruit data import.
      Details, deliverable and estimates to be filled once WT-6796 is completed.

        Attachments

        1. ApplicantReport-DBFieldMapping-Remarks.xlsx
          11 kB
        2. Applicant Reports.xlsx
          377 kB
        3. Candidate Demographics Data.txt
          0.8 kB
        4. Candidate Job Application.txt
          0.3 kB
        5. Database Structure.xls
          146 kB
        6. Job Data Import.txt
          0.5 kB
        7. RecruitImportAnalysis.docx
          15 kB
        8. Recruit import - Mandatory Fields.xls
          11 kB
        9. WT-6796_testcase.xls
          21 kB

          Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. WT-8238 Import Recruit-DTS not showing for JOB data type import

          • Critical - This problem will block progress.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-7616 Export > Getting server error on LB on DTS and Field Mapping

          • High - Serious problem that could block progress.
          • Closed
          is caused by

          Support Activity - Support Activity WT-5710 LONG Applicant data load into Workterra Stage

          • Medium - Has the potential to affect progress.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-7608 Recruit- Candidate Data-Candidate social security No In DTS

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

          Bug - A problem which impairs or prevents the functions of the product. WT-7611 Recuirt:Job Data: specialization (DTS filed ) not showing on DTS page

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

          Bug - A problem which impairs or prevents the functions of the product. WT-7612 Recruit :Job Data:Duplicate entry inserted and import is getting failed.

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-7631 Recruit Job data-validation message is wrong

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-7633 Candidate Data import:Getting failed When we import same file second time

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-7634 Job Data Import Is getting Failed

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-7635 import template not getting open for Recruit Module

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) created issue -
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint WT Sprint 18 [ 34 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Rashmita Dudhe [ rashmita.dudhe ]
            chitrakrao Chitra Rao (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Vijayendra Shinde [ ID10506 ]
            Hide
            Permalink
            chitrakrao Chitra Rao (Inactive) added a comment -

            Hi
            Please let us know the status of ticket and ETA ?
            Satya
            Vijayendra Shinde
            Amannda Johnson

            We have call with LONG team on wed 12/14 AM
            ty,
            Chitra

            Show
            chitrakrao Chitra Rao (Inactive) added a comment - Hi Please let us know the status of ticket and ETA ? Satya Vijayendra Shinde Amannda Johnson We have call with LONG team on wed 12/14 AM ty, Chitra
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vijayendra Shinde [ ID10506 ] Vishal Bajad [ vishal.bajad ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Developer Vishal Bajad [ vishal.bajad ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint WT Sprint 18 [ 34 ] WT Sprint 19 [ 35 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue is caused by WT-5710 [ WT-5710 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Approval can be found in WT-5710

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Approval can be found in WT-5710
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 16/Dec/16 01:27 PM
            • Time Spent:
              5h
               

              In Analysis, Understanding current implementation for Recruit module (Process, Implementation)

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ]
            Original Estimate 8h [ 28800 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 3h [ 10800 ]
            Time Spent 5h [ 18000 ]
            Worklog Id 14052 [ 14052 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 19/Dec/16 01:09 PM
            • Time Spent:
              5h
               

              Analysis on Implementation for Recruit Data

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 0h [ 0 ]
            Time Spent 5h [ 18000 ] 10h [ 36000 ]
            Worklog Id 14268 [ 14268 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Attachment RecruitImportAnalysis.docx [ 35383 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 04/Jan/2017
            Dev Estimates 80
            Original Estimate 8h [ 28800 ] 80h [ 288000 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Attachment ApplicantReport-DBFieldMapping-Remarks.xlsx [ 35385 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Attachment Database Structure.xls [ 35386 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Attachment Applicant Reports.xlsx [ 35387 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 20/Dec/16 01:22 PM
            • Time Spent:
              8h
               

              Understand DB Structure
              Populate DB fields for Candidate data import.
              Added Import Type : Candidate Data and Job Data.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 10h [ 36000 ] 18h [ 64800 ]
            Worklog Id 14552 [ 14552 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 21/Dec/16 01:57 PM
            • Time Spent:
              8h
               

              Analysis
              DTS Mapping for Candidate , Application , Jobs

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 18h [ 64800 ] 26h [ 93600 ]
            Worklog Id 14814 [ 14814 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 21/Dec/16 03:20 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 26h [ 93600 ] 26.5h [ 95400 ]
            Worklog Id 14833 [ 14833 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 22/Dec/16 12:13 PM
            • Time Spent:
              1.5h
               

              import code walk through

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 26.5h [ 95400 ] 28h [ 100800 ]
            Worklog Id 15025 [ 15025 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 22/Dec/16 01:36 PM
            • Time Spent:
              8h
               

              Write a Business logic for Recruit Import

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 28h [ 100800 ] 36h [ 129600 ]
            Worklog Id 15085 [ 15085 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 23/Dec/16 01:02 PM
            • Time Spent:
              8h
               

              Writing a Business logic for Recruit Import.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 36h [ 129600 ] 44h [ 158400 ]
            Worklog Id 15286 [ 15286 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 23/Dec/16 03:25 PM
            • Time Spent:
              2.5h
               
              <No comment>
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 25/Dec/16 05:09 AM
            • Time Spent:
              8h
               

              Writing a Business logic for Recruit Import.

            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 26/Dec/16 05:10 AM
            • Time Spent:
              8h
               

              Writing a Business logic for Recruit Import.

            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 44h [ 158400 ] 49h [ 176400 ]
            Worklog Id 15619 [ 15619 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 5h [ 18000 ]
            Time Spent 49h [ 176400 ] 44h [ 158400 ]
            Worklog Id 15619 [ 15619 ]
            Worklog Time Spent 5h [ 18000 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 2.5h [ 9000 ]
            Time Spent 44h [ 158400 ] 46.5h [ 167400 ]
            Worklog Id 15620 [ 15620 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 2.5h [ 9000 ] 5h [ 18000 ]
            Time Spent 46.5h [ 167400 ] 44h [ 158400 ]
            Worklog Id 15620 [ 15620 ]
            Worklog Time Spent 2.5h [ 9000 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 2.5h [ 9000 ]
            Time Spent 44h [ 158400 ] 46.5h [ 167400 ]
            Worklog Id 15621 [ 15621 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 26/Dec/16 05:19 PM
            • Time Spent:
              6h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 2.5h [ 9000 ] 0h [ 0 ]
            Time Spent 46.5h [ 167400 ] 52.5h [ 189000 ]
            Worklog Id 15625 [ 15625 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 27/Dec/16 05:10 AM
            • Time Spent:
              8h
               

              Writing a Business logic for Recruit Import.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 52.5h [ 189000 ] 60.5h [ 217800 ]
            Worklog Id 15653 [ 15653 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 60.5h [ 217800 ] 68.5h [ 246600 ]
            Worklog Id 15654 [ 15654 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 68.5h [ 246600 ] 76.5h [ 275400 ]
            Worklog Id 15656 [ 15656 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 27/Dec/16 01:09 PM
            • Time Spent:
              7h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 76.5h [ 275400 ] 83.5h [ 300600 ]
            Worklog Id 15774 [ 15774 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 27/Dec/16 02:57 PM
            • Time Spent:
              2.5h
               
              <No comment>
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 83.5h [ 300600 ] 86h [ 309600 ]
            Worklog Id 15804 [ 15804 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 27/Dec/16 03:00 PM
            • Time Spent:
              8h
               

              Writing Business logic for Recruit Import.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 86h [ 309600 ] 94h [ 338400 ]
            Worklog Id 15806 [ 15806 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 28/Dec/16 01:46 PM - edited
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 28/Dec/16 05:01 PM
            • Time Spent:
              9h
               

              Writing business logic and unit testing for Candidate Import , Job Import , Job Application Import.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 94h [ 338400 ] 103h [ 370800 ]
            Worklog Id 16032 [ 16032 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 29/Dec/16 01:46 PM - edited
            • Time Spent:
              2h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 103h [ 370800 ] 104h [ 374400 ]
            Worklog Id 16194 [ 16194 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Worklog Id 16194 [ 16194 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 104h [ 374400 ] 105h [ 378000 ]
            Worklog Id 16195 [ 16195 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 105h [ 378000 ] 106h [ 381600 ]
            Worklog Id 16195 [ 16195 ]
            Permalink
            vijayendra Vijayendra Shinde (Inactive) logged work - 29/Dec/16 06:00 PM - edited
            • Time Spent:
              2h
               

              Internal discussion about candidate import.

            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 30/Dec/16 01:52 PM
            • Time Spent:
              2h
               

              Unit Testing

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 106h [ 381600 ] 108h [ 388800 ]
            Worklog Id 16474 [ 16474 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 02/Jan/17 05:45 AM - edited
            • Time Spent:
              5h
               

              Unit Testing and Implementation for Plain Text Password for Candidate.

            vijayendra Vijayendra Shinde (Inactive) made changes -
            Time Spent 108h [ 388800 ] 110h [ 396000 ]
            Worklog Id 16658 [ 16658 ]
            vijayendra Vijayendra Shinde (Inactive) made changes -
            Time Spent 110h [ 396000 ] 110.5h [ 397800 ]
            Worklog Id 16659 [ 16659 ]
            vijayendra Vijayendra Shinde (Inactive) made changes -
            Worklog Id 16658 [ 16658 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 02/Jan/17 01:54 PM
            • Time Spent:
              1.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 110.5h [ 397800 ] 112h [ 403200 ]
            Worklog Id 16721 [ 16721 ]
            Permalink
            vijayendra Vijayendra Shinde (Inactive) logged work - 02/Jan/17 06:00 PM
            • Time Spent:
              0.5h
               

              Candidate import discussion.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 112h [ 403200 ] 117h [ 421200 ]
            Worklog Id 16790 [ 16790 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Worklog Id 16790 [ 16790 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 03/Jan/17 01:22 PM
            • Time Spent:
              8h
               

              Discussion on TableRef and Page ID mismatch.
              Started Code changes to use existing page id to avoid duplication entries for pages.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 117h [ 421200 ] 125h [ 450000 ]
            Worklog Id 16936 [ 16936 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 03/Jan/17 03:02 PM
            • Time Spent:
              1h
               

              code review and follow up

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 125h [ 450000 ] 126h [ 453600 ]
            Worklog Id 16984 [ 16984 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 04/Jan/17 01:53 PM
            • Time Spent:
              8h
               

              Code changes to avoid duplicate fields entry.
              All changes are checked in to LB and it will deployed on LB with Next deployment patch.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 126h [ 453600 ] 134h [ 482400 ]
            Worklog Id 17213 [ 17213 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 04/Jan/17 03:29 PM
            • Time Spent:
              1h
               

              code review and discussion

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 134h [ 482400 ] 135h [ 486000 ]
            Worklog Id 17257 [ 17257 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Component/s Recruit [ 10002 ]
            Component/s BenAdmin [ 10000 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment WT-6796_testcase.xls [ 36687 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Attachment Recruit import - Mandatory Fields.xls [ 36701 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Attachment Candidate Job Application.txt [ 36702 ]
            Attachment Job Data Import.txt [ 36703 ]
            Attachment Candidate Demographics Data.txt [ 36704 ]
            Hide
            Permalink
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Please find attached Files for Recruit Import ,

            Mandatory fields for Recruit Import (Candidate , Job , Applicant ) Recruit import - Mandatory Fields.xls
            File format for Candidate Import Candidate Demographics Data.txt
            File format for Job Import Job Data Import.txt
            File format for Candidate Job Application Import Candidate Job Application.txt

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Please find attached Files for Recruit Import , Mandatory fields for Recruit Import (Candidate , Job , Applicant ) Recruit import - Mandatory Fields.xls File format for Candidate Import Candidate Demographics Data.txt File format for Job Import Job Data Import.txt File format for Candidate Job Application Import Candidate Job Application.txt Thanks !
            hrishikesh.deshpande Hrishikesh Deshpande (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)
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 05/Jan/17 01:53 PM - edited
            • Time Spent:
              2h
               

              code review, discussion and follow ups

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 135h [ 486000 ] 137h [ 493200 ]
            Worklog Id 17572 [ 17572 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Worklog Id 17572 [ 17572 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 05/Jan/17 01:55 PM
            • Time Spent:
              8h
               

              Unit Testing and Code changes and Import file format creation.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 137h [ 493200 ] 145h [ 522000 ]
            Worklog Id 17576 [ 17576 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7611 [ WT-7611 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7612 [ WT-7612 ]
            rashmita.dudhe Rashmita Dudhe (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)
            Original Estimate 80h [ 288000 ] 160h [ 576000 ]
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this on LB Environment.
            Verified below Import Type:
            1]Candidate data import
            2]Job Data import
            3]Job application Import

            Covered all test cases which are attached in Sheet.

            Found some issues during testing link to the enhancement jira

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this on LB Environment. Verified below Import Type: 1]Candidate data import 2]Job Data import 3]Job application Import Covered all test cases which are attached in Sheet. Found some issues during testing link to the enhancement jira
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) 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)
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 06/Jan/17 04:23 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 06/Jan/17 04:45 PM
            • Time Spent:
              3h
               
              <No comment>
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 06/Jan/17 04:45 PM
            • Time Spent:
              9h
               

              Unit testing , bug fixing , code fixes and deployment on LB.

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 145h [ 522000 ] 148h [ 532800 ]
            Worklog Id 17942 [ 17942 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 148h [ 532800 ] 157h [ 565200 ]
            Worklog Id 17943 [ 17943 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 07/Jan/17 12:30 AM - edited
            • Time Spent:
              3h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7631 [ WT-7631 ]
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7633 [ WT-7633 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7634 [ WT-7634 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7608 [ WT-7608 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7635 [ WT-7635 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 07/Jan/17 04:26 PM
            • Time Spent:
              10h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 157h [ 565200 ] 167h [ 601200 ]
            Worklog Id 17952 [ 17952 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Vishal Bajad [ vishal.bajad ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 167h [ 601200 ] 169h [ 608400 ]
            Worklog Id 17978 [ 17978 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 169h [ 608400 ] 172h [ 619200 ]
            Worklog Id 18002 [ 18002 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Worklog Id 18002 [ 18002 ]
            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)
            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)
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Attachment Recruit import - Mandatory Fields.xls [ 36701 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Attachment Recruit import - Mandatory Fields.xls [ 36875 ]
            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)
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Hi Vishal Bajad,
            CC:Rakesh Roy,Jaideep Vinchurkar,Hrishikesh Deshpande

            Verified this on Stage Environment.
            Verified below Import Type:
            1]Candidate data import
            2]Job Data import
            3]Job application Import
            Covered all test cases which are attached in Sheet.

            *tried to Import Client given file it is went to bad.
            File is combination two tables
            Please check*

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Hi Vishal Bajad , CC: Rakesh Roy , Jaideep Vinchurkar , Hrishikesh Deshpande Verified this on Stage Environment. Verified below Import Type: 1]Candidate data import 2]Job Data import 3]Job application Import Covered all test cases which are attached in Sheet. *tried to Import Client given file it is went to bad. File is combination two tables Please check*
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 09/Jan/17 03:30 PM
            • Time Spent:
              7h
               

              Bug fixing as reported in QA testing.

            Hide
            Permalink
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi Rashmita Dudhe ,

            This issues has been resolved and checked into LB and stage, it will deployed with next patch.

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Rashmita Dudhe , This issues has been resolved and checked into LB and stage, it will deployed with next patch. Thanks !
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 172h [ 619200 ] 179h [ 644400 ]
            Worklog Id 18128 [ 18128 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 09/Jan/17 06:41 PM - edited
            • Time Spent:
              6h
               

              tested on Stage with All reported issue

            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Rashmita Dudhe [ rashmita.dudhe ]
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 179h [ 644400 ] 185h [ 666000 ]
            Worklog Id 18171 [ 18171 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Worklog Id 18171 [ 18171 ]
            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)
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Stage Imported Client given file.
            Working fine as expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage Imported Client given file. Working fine as expected.
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 11/Jan/17 03:52 PM
            • Time Spent:
              4h
               

              Implemention for Dynamic Table Ref ID to avoid script failing issues.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 185h [ 666000 ] 189h [ 680400 ]
            Worklog Id 18545 [ 18545 ]
            ashwin.wankhede Ashwin Wankhede (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)
            ashwin.wankhede Ashwin Wankhede (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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 12/Jan/17 02:54 PM
            • Time Spent:
              2h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 189h [ 680400 ] 191h [ 687600 ]
            Worklog Id 18825 [ 18825 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 12/Jan/17 06:16 PM
            • Time Spent:
              8h
               

              Lb testing.
              Stage testing

            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 191h [ 687600 ] 199h [ 716400 ]
            Worklog Id 18904 [ 18904 ]
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 13/Jan/17 03:33 PM
            • Time Spent:
              1h
               
              <No comment>
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 199h [ 716400 ] 200h [ 720000 ]
            Worklog Id 19182 [ 19182 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue causes WT-7616 [ WT-7616 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 17/Jan/17 03:18 PM
            • Time Spent:
              1h
               

              documentation

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 200h [ 720000 ] 201h [ 723600 ]
            Worklog Id 19621 [ 19621 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Permalink
            vishal.bajad Vishal Bajad (Inactive) logged work - 24/Jan/17 11:57 AM
            • Time Spent:
              2h
               

              Code check in to Production.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 201h [ 723600 ] 203h [ 730800 ]
            Worklog Id 20745 [ 20745 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue blocks WT-8238 [ WT-8238 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 02/Feb/17 10:14 AM
            • Time Spent:
              4h
               

              production testing

            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 203h [ 730800 ] 207h [ 745200 ]
            Worklog Id 22613 [ 22613 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Assign back to me when 8238 Deployed on Production

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Assign back to me when 8238 Deployed on Production
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Vishal Bajad [ vishal.bajad ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status In Development [ 10007 ] Mockup Approval [ 10010 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Mockup Approved [ 10012 ] In Development [ 10007 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Rashmita Dudhe [ rashmita.dudhe ]
            Hide
            Permalink
            chitrakrao Chitra Rao (Inactive) added a comment -

            Please confirm if 'Applicant reports.xls' data is imported into wt stage?

            Show
            chitrakrao Chitra Rao (Inactive) added a comment - Please confirm if 'Applicant reports.xls' data is imported into wt stage?
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 17/Feb/17 11:30 AM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Chitra Rao,

            I have verified 'Applicant reports.xls' Email Id is mandatory and Unique filed not provided in file System uniquely identified Candidate by using Email id.
            Job Group code and JOB group, most recent activity are not implemented in System.

            Work City, Work Location, Disposition are Job Data Import Fields it not in Candidate application data Import.

            For Hire date is the concept of Ben admin for Recruit should we consider it as tentative Job application date.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Chitra Rao , I have verified 'Applicant reports.xls' Email Id is mandatory and Unique filed not provided in file System uniquely identified Candidate by using Email id. Job Group code and JOB group, most recent activity are not implemented in System. Work City, Work Location, Disposition are Job Data Import Fields it not in Candidate application data Import. For Hire date is the concept of Ben admin for Recruit should we consider it as tentative Job application date. Thanks, Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 207h [ 745200 ] 208h [ 748800 ]
            Worklog Id 25819 [ 25819 ]
            Hide
            Permalink
            chitrakrao Chitra Rao (Inactive) added a comment -

            We will have to review this data in applicant report and understand steps/options to load.
            Job group/Jobcode implementation has to be taken up in system.

            Show
            chitrakrao Chitra Rao (Inactive) added a comment - We will have to review this data in applicant report and understand steps/options to load. Job group/Jobcode implementation has to be taken up in system.
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] chitra rao [ chitrakrao ]
            Transition Time In Source Status Execution Times
            Vishal Bajad (Inactive) made transition -
            New Request Pending for Approval
            		14d 21h 17m 1
            Vishal Bajad (Inactive) made transition -
            Pending for Approval Approved for Development
            		6d 5h 36m 1
            Vishal Bajad (Inactive) made transition -
            Approved for Development In Development
            		6s 1
            Rashmita Dudhe (Inactive) made transition -
            In Production Testing Reopen in Production
            		14d 13h 42m 1
            Rashmita Dudhe (Inactive) made transition -
            Reopen in Production In Development
            		6s 1
            Vishal Bajad (Inactive) made transition -
            In Development Mockup Approval
            		4d 1h 4m 1
            Vishal Bajad (Inactive) made transition -
            Mockup Approval Mockup Approved
            		10s 1
            Vishal Bajad (Inactive) made transition -
            Mockup Approved In Development
            		3s 1
            Vishal Bajad (Inactive) made transition -
            In LB Testing Reopen in Local
            		2d 1h 21m 3
            Vishal Bajad (Inactive) made transition -
            Reopen in Local In Development
            		1d 20h 37m 3
            Vishal Bajad (Inactive) made transition -
            In Development In LB Testing
            		14d 15h 12m 5
            Vishal Bajad (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		7s 2
            Vishal Bajad (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		6s 2
            Vishal Bajad (Inactive) made transition -
            Approved for Stage Stage Testing
            		6s 2
            Vishal Bajad (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		15d 12h 23m 2
            Vishal Bajad (Inactive) made transition -
            Pending for Production Approval Approved for production
            		7s 2
            Vishal Bajad (Inactive) made transition -
            Approved for production In Production Testing
            		9s 2
            Rashmita Dudhe (Inactive) made transition -
            In Production Testing Production Complete
            		13d 22h 57m 1

              People

              Assignee:
              chitrakrao Chitra Rao (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Developer:
              Vishal Bajad (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 160h Original Estimate - 160h
                  160h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 208h
                  208h