WORKTERRAProject Type: software

WORKTERRA

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

Paycheck import - support for column wise import

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Cancelled
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Recruit
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Others
    • Reported by:
      Harbinger
    • Company:
      New Facility Not Added
    • Module:
      Recruit

      Description

      Moving tickets for Cancellation

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-7660 View bad file import Getting failed

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

          Bug - A problem which impairs or prevents the functions of the product. WT-7661 Format Paycheck:showing validation message when adding line item name

          • Critical - This problem will block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-5133 LONG New client - Needs Workterra Paycheck Management

          • Critical - This problem will block 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 Samir [ samir ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 07/Jan/17 04:25 PM
            • Time Spent:
              9h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 15h [ 54000 ]
            Time Spent 9h [ 32400 ]
            Worklog Id 17951 [ 17951 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 5h [ 18000 ]
            Time Spent 9h [ 32400 ] 19h [ 68400 ]
            Worklog Id 17954 [ 17954 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 07/Jan/17 07:45 PM
            • Time Spent:
              10h
               

              Development with Jaideep.

            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)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Rashmita Dudhe [ rashmita.dudhe ]
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            For column wise paycheck import is getting failed

            See below error Log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidationColumnWise.ImportData->ImportValidationColumnWise.ProcessImportDataFile->ImportValidationColumnWise.GetDataForInsertCheck
            ErrorMessage: Incorrect syntax near the keyword 'from'.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - For column wise paycheck import is getting failed See below error Log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidationColumnWise.ImportData->ImportValidationColumnWise.ProcessImportDataFile->ImportValidationColumnWise.GetDataForInsertCheck ErrorMessage: Incorrect syntax near the keyword 'from'.
            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: Re-open(10212)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 3h [ 10800 ]
            Time Spent 19h [ 68400 ] 21h [ 75600 ]
            Worklog Id 18049 [ 18049 ]
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            I analysed the issue, It was because only socialsecurityno was set as isunique.
            SocialSecurityNo, EffectiveDate and LineItemName should be set as is unique. This will solve the issue.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - I analysed the issue, It was because only socialsecurityno was set as isunique. SocialSecurityNo, EffectiveDate and LineItemName should be set as is unique. This will solve the issue.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Rashmita Dudhe [ rashmita.dudhe ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 09/Jan/17 06:39 PM - edited
            • Time Spent:
              2h
               

              LB Testing

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 09/Jan/17 06:57 PM
            • Time Spent:
              3.5h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (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)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7660 [ WT-7660 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-7661 [ WT-7661 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Summary Recruit import - support for column wise import Paycheck import - support for column wise import
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on LB Environment.
            For Column Wise Import consider below scenarios:
            1]Tab File format
            2]CSV file Format
            3]Single employee records.
            4]Multiple Employee In Same file
            5]Also Verified on View paycheck Page Imported Data is proper for all employee.

            Working fine as expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on LB Environment. For Column Wise Import consider below scenarios: 1]Tab File format 2]CSV file Format 3]Single employee records. 4]Multiple Employee In Same file 5]Also Verified on View paycheck Page Imported Data is proper for all employee. Working fine as expected.
            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 -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment WT-7632_Testcase.xls [ 36965 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 9h [ 32400 ]
            Original Estimate 24h [ 86400 ] 30h [ 108000 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 9h [ 32400 ] 8h [ 28800 ]
            Time Spent 21h [ 75600 ] 22h [ 79200 ]
            Worklog Id 18169 [ 18169 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 5h [ 18000 ]
            Time Spent 22h [ 79200 ] 25h [ 90000 ]
            Worklog Id 18170 [ 18170 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 7h [ 25200 ]
            Time Spent 25h [ 90000 ] 23h [ 82800 ]
            Worklog Id 18049 [ 18049 ]
            Worklog Time Spent 2h [ 7200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 7h [ 25200 ] 6h [ 21600 ]
            Time Spent 23h [ 82800 ] 24h [ 86400 ]
            Worklog Id 18169 [ 18169 ]
            khandu.kshirsagar Khandu Kshirsagar (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: Stage Deployed(11602)
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on Stage Environment.
            For Column Wise Import consider below scenarios:
            1]Tab File format
            2]CSV file Format
            3]Single employee records.
            4]Multiple Employee In Same file
            5]Also Verified on View paycheck Page Imported Data is proper for all employee.
            Working fine as expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage Environment. For Column Wise Import consider below scenarios: 1]Tab File format 2]CSV file Format 3]Single employee records. 4]Multiple Employee In Same file 5]Also Verified on View paycheck Page Imported Data is proper for all employee. 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: On Hold(10215)
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Waiting for Client Confirmation

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Waiting for Client Confirmation
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 10/Jan/17 02:38 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 5.5h [ 19800 ]
            Time Spent 24h [ 86400 ] 24.5h [ 88200 ]
            Worklog Id 18324 [ 18324 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 10/Jan/17 02:53 PM
            • Time Spent:
              2h
               
              <No comment>
            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 -
            Remaining Estimate 5.5h [ 19800 ] 3.5h [ 12600 ]
            Time Spent 24.5h [ 88200 ] 26.5h [ 95400 ]
            Worklog Id 18332 [ 18332 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 2.5h [ 9000 ]
            Time Spent 26.5h [ 95400 ] 27.5h [ 99000 ]
            Worklog Id 18170 [ 18170 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 10/Jan/17 06:39 PM - edited
            • Time Spent:
              4h
               

              Test case writing and LB testing.
              Stage testing

            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 11/Jan/17 06:14 PM
            • Time Spent:
              4h
               

              Stage Testing

            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 2.5h [ 9000 ] 0h [ 0 ]
            Time Spent 27.5h [ 99000 ] 31.5h [ 113400 ]
            Worklog Id 18902 [ 18902 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 31.5h [ 113400 ] 35h [ 126000 ]
            Worklog Id 18921 [ 18921 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Link This issue relates to WT-5133 [ WT-5133 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 03/Feb/17 09:08 AM
            • Time Spent:
              1h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 35h [ 126000 ] 36h [ 129600 ]
            Worklog Id 23146 [ 23146 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Status Update Completed [ 18480 ]
            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 ]
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Closed

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Closed
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Company LONG Building Technologies [ 13604 ] New Facility Not Added [ 18435 ]
            Description Moving tickets for Cancellation
            Environment Others [ 18445 ]
            Issue Type Enhancement [ 4 ] Support Activity [ 10301 ]
            Support Task Type Customization [ 11204 ]
            Workflow WT_Features [ 30146 ] WT_Support [ 63935 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Closed [ 6 ] Reopen [ 4 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Resolution Cancelled [ 10300 ]
            Status Reopen [ 4 ] Resolved [ 5 ]
            Transition Time In Source Status Execution Times
            Rashmita Dudhe (Inactive) made transition -
            New Request Pending for Approval
            		2d 17h 35m 1
            Rashmita Dudhe (Inactive) made transition -
            Pending for Approval Approved for Development
            		5s 1
            Rashmita Dudhe (Inactive) made transition -
            Approved for Development In Development
            		3s 1
            Rashmita Dudhe (Inactive) made transition -
            In Development In LB Testing
            		2s 1
            Rashmita Dudhe (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		9h 1
            Rashmita Dudhe (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		3s 1
            Rakesh Roy (Inactive) made transition -
            Approved for Stage Stage Testing
            		121d 18h 4m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		278d 21h 27m 1
            Rakesh Roy (Inactive) made transition -
            Pending for Production Approval Approved for production
            		2m 5s 1
            Rakesh Roy (Inactive) made transition -
            Approved for production In Production Testing
            		1m 5s 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            		2m 41s 1
            Rakesh Roy (Inactive) made transition -
            Production Complete Closed
            		6m 14s 1
            Prashant Samal (Inactive) made transition -
            Closed Reopen
            		5h 16m 1
            Prashant Samal (Inactive) made transition -
            Reopen Resolved
            		2m 11s 1

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 30h Original Estimate - 30h
                  30h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 36h
                  36h