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

            Activity

            Hide
            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
            Hide
            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
            Hide
            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 !
            Hide
            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
            Hide
            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*
            Hide
            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 !
            Hide
            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.
            Hide
            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
            Hide
            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?
            Hide
            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
            Hide
            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.

              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