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

Export Preview > Showing zero records exported on export preview even if the file has records

    Details

    • Type: Bug
    • Status: In LB Testing
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have
    • Browser:
      Google Chrome

      Description

      Hi Snehal Katkar,

      Found issue while checking WT-9242 as below

      Issue #: When

      1) file type changed from Changes Only to Full File on Template Settings page
      2) Click on save button
      3) Click on Preview

      Result: Shows zero records exported but downloaded file has many records.

      Expected Result: The actual Count of records should be displayed instead of zero records

      PFA screenshot below

      As per discussion with Vinayak Kulkarni it is due to import . So assigning it to you .

      CC:Hrishikesh Deshpande Rakesh Shahane

        Attachments

          Issue Links

            Activity

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Link This issue is caused by WT-9242 [ WT-9242 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description Hi [~snehal.katkar],

            Found issue while checking WT-9242 as below

            Issue #: When

            1) file type changed from Changes Only to Full File on Template Settings page
            2) Click on save button
            3) Click on Preview

            *Result*: Shows zero records exported but downloaded file has many records.

            Expected Result: The actual Count of records should be displayed instead of zero records

            PFA screenshot below

            As per discussion with [~Vinayak.Kulkarni] it is due to import . So assigning it to you .

            CC:[~hrishikesh.deshpande] [~rakesh.shahane]




             
            Hi [~snehal.katkar],

            Found issue while checking WT-9242 as below

            Issue #: When

            1) file type changed from Changes Only to Full File on Template Settings page
            2) Click on save button
            3) Click on Preview

            *Result*: Shows zero records exported but downloaded file has many records.

            Expected Result: The actual Count of records should be displayed instead of zero records

            PFA screenshot below

             !Export Preview.jpg|thumbnail!

            As per discussion with [~Vinayak.Kulkarni] it is due to import . So assigning it to you .

            CC:[~hrishikesh.deshpande] [~rakesh.shahane]




             
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Priority Medium [ 3 ] High [ 2 ]
            snehal.katkar Snehal Katkar (Inactive) logged work - 05/Oct/17 09:26 PM
            • Time Spent:
              1h
               

              Analysis

            snehal.katkar Snehal Katkar (Inactive) logged work - 06/Oct/17 09:27 PM
            • Time Spent:
              2h
               

              analysis

            snehal.katkar Snehal Katkar (Inactive) logged work - 09/Oct/17 09:28 PM
            • Time Spent:
              6h
               

              Analysis, coding, discussion with Aniruddha and Ganesh

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Review Date 10/Oct/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Developer snehal katkar [ snehal.katkar ]
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 84084 [ 84084 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 1h [ 3600 ] 3h [ 10800 ]
            Worklog Id 84085 [ 84085 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 3h [ 10800 ] 9h [ 32400 ]
            Worklog Id 84089 [ 84089 ]
            snehal.katkar Snehal Katkar (Inactive) logged work - 11/Oct/17 12:41 AM
            • Time Spent:
              5h
               

              Coding, code review, code check in, testing

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Aniruddha Dev [ aniruddha.dev ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 25/Oct/2017
            Stage Due Date 23/Oct/17 [ 2017-10-23 ]
            Original Estimate 0h [ 0 ]
            Hide
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Concern: Export Preview > Showing zero records exported on export preview even if the file has records

            Cause: 'ImportExportRecordSummary' table is used to store values of bad records, successful records and total records. We removed the code from import, related to this table. And displayed those values using hash. For export same code was getting used. So, for export new values were not getting set, instead default values were appearing on screen i.e. '0'. Please refer to WT-10897.

            Correction: Added a check to identify whether the current call is intended to import or export. No functionality as been changed for export side.

            Files Having Changes:
            1)https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/Web/Web Projects/WORKTERRA/Areas/Customization/Models/EDI/ImportExportRecordDetails.cs

            Affected Areas:
            1) Manual Export - Record count
            2) Export Preview - Record count
            3) Exported files - Record cunt

            Scenarios to Test:
            1) On above pages, record count should get displayed correctly instead of 0.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Concern: Export Preview > Showing zero records exported on export preview even if the file has records Cause: 'ImportExportRecordSummary' table is used to store values of bad records, successful records and total records. We removed the code from import, related to this table. And displayed those values using hash. For export same code was getting used. So, for export new values were not getting set, instead default values were appearing on screen i.e. '0'. Please refer to WT-10897 . Correction: Added a check to identify whether the current call is intended to import or export. No functionality as been changed for export side. Files Having Changes: 1) https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/Web/Web Projects/WORKTERRA/Areas/Customization/Models/EDI/ImportExportRecordDetails.cs Affected Areas: 1) Manual Export - Record count 2) Export Preview - Record count 3) Exported files - Record cunt Scenarios to Test: 1) On above pages, record count should get displayed correctly instead of 0.
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 9h [ 32400 ] 14h [ 50400 ]
            Worklog Id 85422 [ 85422 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified above fix on LB for export preview and regular export from Manual Import /Export page. record count in Export preview and manual exported files are proper.
            Working as expected LB and Ready for Stage

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified above fix on LB for export preview and regular export from Manual Import /Export page. record count in Export preview and manual exported files are proper. Working as expected LB and Ready for Stage
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            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
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            As WT-9242 not deployed on stage today, Changing its status to Prod Deployment on Hold . This is working fine but will test once WT-9242 is deployed on stage

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - As WT-9242 not deployed on stage today, Changing its status to Prod Deployment on Hold . This is working fine but will test once WT-9242 is deployed on stage
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            aniruddha.dev Aniruddha Dev (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)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Labels Manual_Export
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Development
            13d 2h 1
            Aniruddha Dev (Inactive) made transition -
            In LB Testing Stage Testing
            7d 1h 18m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing Reopened in Stage
            106d 2h 9m 1
            Rakesh Roy (Inactive) made transition -
            Reopened in Stage In Development
            9s 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            6d 1h 58m 2

              People

              Assignee:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 14h
                  14h