Uploaded image for project: 'Project Simple'
  1. Project Simple
  2. ST-298

Emails list screen - EmailReport

    Details

    • Environment:
      Production
    • Module:
      BenAdmin - Customization
    • Reported by:
      Support
    • Company:
      All Clients/Multiple Clients
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Good To Have
    • Sprint:
      WT Sprint 38 - Enhancement
    • Severity:
      Simple

      Description

      For recording purpose, a report needs to be created which records the date time for email sent to an employee
      This is useful for tracking purpose.

        Attachments

        1. Email_List_Updated.doc
          26 kB
        2. Email_List.docx
          18 kB
        3. Email_List.xlsx
          10 kB
        4. Email-List.JPG
          Email-List.JPG
          135 kB
        5. Email Report Lists.png
          Email Report Lists.png
          125 kB
        6. Re Sprint 38 Enhancement Starting from 925 and Ending on 1006.msg
          54 kB

          Issue Links

            Activity

            gaurav.sodani Gaurav Sodani (Inactive) created issue -
            satyap Satya made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100)Level 1 values: Report(10109) Parent values: BenAdmin(10100)Level 1 values: Customization(10113)
            Hide
            satyap Satya added a comment -

            Below are additional comments on this requirement

            email functionality in the system - should have full visibility into the actual emails that were sent and when they are sent. I know on occasion we have asked DEV for a list and I know this has been talked about as an enhancement. Could you please advise if this is something we could move up on the enhancement roadmap?

            Samir: We have this item in betterment tasks. In this we will be developing a new page which will display all out going emails message with category filter with export to excel feature. This can be moved up in the betterment list.

            Show
            satyap Satya added a comment - Below are additional comments on this requirement email functionality in the system - should have full visibility into the actual emails that were sent and when they are sent. I know on occasion we have asked DEV for a list and I know this has been talked about as an enhancement. Could you please advise if this is something we could move up on the enhancement roadmap? Samir: We have this item in betterment tasks. In this we will be developing a new page which will display all out going emails message with category filter with export to excel feature. This can be moved up in the betterment list.
            Hide
            satyap Satya added a comment -

            Hi Swapnil,

            As discussed, let's create Mockup for this requirement & come up with estimation & analysis document by Friday, 15th Sept 2017.

            Regards,
            Satya Prakash

            Cc: Rakesh Shinde Rakesh Roy Vijay Siddha Samir Gaurav Sodani

            Show
            satyap Satya added a comment - Hi Swapnil, As discussed, let's create Mockup for this requirement & come up with estimation & analysis document by Friday, 15th Sept 2017. Regards, Satya Prakash Cc: Rakesh Shinde Rakesh Roy Vijay Siddha Samir Gaurav Sodani
            satyap Satya made changes -
            Assignee Prasanna Karlekar [ prasanna ] Swapnil Pandhare [ swapnil.pandhare ]
            Description For recording purpose, a report needs to be created which records the date time for email sent to an employee
            This is useful for tracking purpose
            For recording purpose, a report needs to be created which records the date time for email sent to an employee
            This is useful for tracking purpose.
            Issue Importance Good To Have [ 11802 ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Priority Medium [ 3 ] Highest [ 1 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 14/Sep/17 11:41 AM
            • Time Spent:
              4h
               

              Discussion with Rakesh
              Discussion with Satya
              Analysis

            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 15/Sep/17 11:43 AM
            • Time Spent:
              2h
               

              Analysis

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Issue Type Enhancement [ 4 ] Analysis [ 10711 ]
            Status New Request [ 10029 ] In Analysis [ 10008 ]
            Workflow WT_Features [ 51725 ] WorkTerra_Analysis_ver 1.0 [ 52336 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ]
            Original Estimate 12h [ 43200 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 8h [ 28800 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 79240 [ 79240 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 6h [ 21600 ]
            Time Spent 4h [ 14400 ] 6h [ 21600 ]
            Worklog Id 79242 [ 79242 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Attachment email list.jpg [ 61744 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Sprint WT Sprint 37 - Enhancement [ 86 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Sprint WT Sprint 37 - Enhancement [ 86 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 20/Sep/17 11:36 AM
            • Time Spent:
              5h
               

              Analysis
              Discussion
              Document creation and ETA

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Summary Date time stamp for email templates Email list
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Summary Email list Email list screen
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 21/Sep/17 11:37 AM
            • Time Spent:
              3h
               

              Document creation,
              Discussion with Niteen, Sudhir

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Attachment Email_List.docx [ 62294 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Attachment Email_List.xlsx [ 62295 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Attachment Email_List.docx [ 62294 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Attachment Email_List.docx [ 62296 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 38 - Enhancement [ 88 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Niteen Surwase [ niteen.surwase ]
            Dev Due Date 06/Oct/2017
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 25/Sep/17 11:05 AM - edited
            • Time Spent:
              4h
               

              Analysis and Debugging code for Assign Payroll and classes to implement same functionality in Email List.

            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 25/Sep/17 12:28 PM
            • Time Spent:
              1h
               

              Discussion with Niteen & Sudhir.

            niteen.surwase Niteen Surwase (Inactive) logged work - 25/Sep/17 05:04 PM
            • Time Spent:
              6.25h
               

              Analysis to fetch data
              DB Scripts for Email Screen
              Creating BL and MVC files

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 0h [ 0 ]
            Time Spent 6h [ 21600 ] 12.25h [ 44100 ]
            Worklog Id 81233 [ 81233 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 12.25h [ 44100 ] 16.25h [ 58500 ]
            Worklog Id 81365 [ 81365 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 16.25h [ 58500 ] 21.25h [ 76500 ]
            Worklog Id 81466 [ 81466 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 21.25h [ 76500 ] 24.25h [ 87300 ]
            Worklog Id 81469 [ 81469 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 26/Sep/17 12:28 PM
            • Time Spent:
              1h
               

              Discussion

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 24.25h [ 87300 ] 25.25h [ 90900 ]
            Worklog Id 81583 [ 81583 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 25.25h [ 90900 ] 26.25h [ 94500 ]
            Worklog Id 81584 [ 81584 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 26/Sep/17 01:59 PM
            • Time Spent:
              8h
               
              1. Prepared script for Menu actions.
              2. Run script on local for Super Administrator, Partner User, Broker User and Company Administrator.
              3. Made code changes for bind dropdown.
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 26.25h [ 94500 ] 34.25h [ 123300 ]
            Worklog Id 81749 [ 81749 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Worklog Id 81365 [ 81365 ]
            niteen.surwase Niteen Surwase (Inactive) logged work - 26/Sep/17 05:28 PM
            • Time Spent:
              8h
               

              MVC, BL Coding
              Discussion with Sudhir

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 34.25h [ 123300 ] 42.25h [ 152100 ]
            Worklog Id 81818 [ 81818 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Dev Estimates 100
            niteen.surwase Niteen Surwase (Inactive) logged work - 27/Sep/17 05:47 PM
            • Time Spent:
              7.5h
               

              Email Screen Searching, Sorting and Filters
              Discussion with Sudhir.

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Attachment Email-List.JPG [ 62901 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Attachment email list.jpg [ 61744 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 28/Sep/17 05:39 AM
            • Time Spent:
              8h
               

              View changes.
              Made coding changes in controller and models.
              Discussion with Niteen.

            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 42.25h [ 152100 ] 50.25h [ 180900 ]
            Worklog Id 82091 [ 82091 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 50.25h [ 180900 ] 57.75h [ 207900 ]
            Worklog Id 82096 [ 82096 ]
            niteen.surwase Niteen Surwase (Inactive) logged work - 28/Sep/17 09:59 AM
            • Time Spent:
              8h
               

              Email Report : Filtering, Searching, Sorting
              MVC and BL code
              Unit Testing
              Discussion with Sudhir and Swapnil

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 57.75h [ 207900 ] 65.75h [ 236700 ]
            Worklog Id 82191 [ 82191 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 28/Sep/17 01:15 PM - edited
            • Time Spent:
              4h
               
              1. Code changes for filters.
              2. Apply validations to filters on View.
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 03/Oct/17 01:13 PM
            • Time Spent:
              8h
               

              Made View changes and Controller changes.
              Discussion with Niteen.

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Attachment Email_List_Updated.doc [ 63315 ]
            niteen.surwase Niteen Surwase (Inactive) logged work - 03/Oct/17 02:58 PM
            • Time Spent:
              8h
               

              MVC and BL Code
              Filtering - Checkbox filter
              Unit Testing
              Technical Discussion with Sudhir

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 65.75h [ 236700 ] 73.75h [ 265500 ]
            Worklog Id 83050 [ 83050 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Priya Dhamande [ priya.dhamande ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 04/Oct/17 08:50 AM - edited
            • Time Spent:
              8h
               
              1. Code for Export to Excel.
              2. Prepared script for PageLevelAccess for EmailReport.
            niteen.surwase Niteen Surwase (Inactive) logged work - 04/Oct/17 12:53 PM
            • Time Spent:
              8h
               

              Exporting report Implementation
              Searching Filter
              MVC BL changes
              Unit Test
              Technical discussion with Sudhir

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 73.75h [ 265500 ] 81.75h [ 294300 ]
            Worklog Id 83214 [ 83214 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 81.75h [ 294300 ] 89.75h [ 323100 ]
            Worklog Id 83366 [ 83366 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 05/Oct/17 01:03 PM - edited
            • Time Spent:
              4h
               
              1. Code changes for export to excel.
              2. Localization changes.
              3. Remove check boxes from the View.
              4. Unit Testing.
            niteen.surwase Niteen Surwase (Inactive) logged work - 05/Oct/17 04:22 PM
            • Time Spent:
              7h
               

              Excel Implementation and Changes
              View and BL Changes
              Unit Testing

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 89.75h [ 323100 ] 96.75h [ 348300 ]
            Worklog Id 83483 [ 83483 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Link This issue relates to NF-4553 [ NF-4553 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Issue Type Analysis [ 10711 ] Enhancement [ 4 ]
            Status In Analysis [ 10008 ] In Development [ 10007 ]
            Workflow WorkTerra_Analysis_ver 1.0 [ 52336 ] WT_Features [ 54272 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Summary Email list screen Emails list screen - EmailReport
            niteen.surwase Niteen Surwase (Inactive) logged work - 06/Oct/17 10:17 AM
            • Time Spent:
              2h
               

              Unit Testing
              Technical Discussion with Sudhir
              Review Request

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 96.75h [ 348300 ] 98.75h [ 355500 ]
            Worklog Id 83577 [ 83577 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 06/Oct/17 01:02 PM
            • Time Spent:
              3h
               
              1. Code changes.
              2. Unit Testing.
              3. Review Request.
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 98.75h [ 355500 ] 101.75h [ 366300 ]
            Worklog Id 83646 [ 83646 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 101.75h [ 366300 ] 105.75h [ 380700 ]
            Worklog Id 83647 [ 83647 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 105.75h [ 380700 ] 113.75h [ 409500 ]
            Worklog Id 83659 [ 83659 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Worklog Id 83647 [ 83647 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 113.75h [ 409500 ] 117.75h [ 423900 ]
            Worklog Id 83662 [ 83662 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Worklog Id 83662 [ 83662 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Worklog Id 83366 [ 83366 ]
            satyap Satya made changes -
            Labels EmailNotifications
            satyap Satya made changes -
            Labels EmailNotifications Email_Notifications
            Jennifer.Reed Jennifer Reed (Inactive) made changes -
            Labels Email_Notifications Email_Notifications Kindercare
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 17/Oct/17 12:55 PM
            • Time Spent:
              3h
               

              Code review and client call
              Discussion with Satya, Niteen, Sudhir

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 117.75h [ 423900 ] 120.75h [ 434700 ]
            Worklog Id 85448 [ 85448 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Attachment Email Report Lists.png [ 64850 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 23/Oct/17 07:54 AM
            • Time Spent:
              5h
               

              Changed code for Export to Excel.
              Unit tested on local.

            niteen.surwase Niteen Surwase (Inactive) logged work - 24/Oct/17 05:00 PM - edited
            • Time Spent:
              3h
               

              Code Review
              Analysis for answer

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Code Reviewed By Swapnil Pandhare [ 11900 ]
            Company All Clients/Multiple Clients [ 18434 ]
            Developer Niteen Surwase [ niteen.surwase ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 25/Oct/17 08:46 AM
            • Time Spent:
              1h
               

              Discussion with Niteen.
              Check In code for LB.
              Unit testing on LB.

            khandu.kshirsagar Khandu Kshirsagar (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)
            niteen.surwase Niteen Surwase (Inactive) logged work - 25/Oct/17 05:00 PM - edited
            • Time Spent:
              3.5h
               

              Review and Cheking
              Code to Download Excel File LB

            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 120.75h [ 434700 ] 121.75h [ 438300 ]
            Worklog Id 86605 [ 86605 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Time Spent 121.75h [ 438300 ] 126.75h [ 456300 ]
            Worklog Id 87368 [ 87368 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 126.75h [ 456300 ] 129.75h [ 467100 ]
            Worklog Id 87725 [ 87725 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 129.75h [ 467100 ] 130.75h [ 470700 ]
            Worklog Id 87728 [ 87728 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Worklog Id 87725 [ 87725 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 130.75h [ 470700 ] 133.25h [ 479700 ]
            Worklog Id 87728 [ 87728 ]
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching development approval email to work on this ticket: Unable to embed resource: Re Sprint 38 Enhancement Starting from 925 and Ending on 1006.msg of type application/octet-stream
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching development approval email to work on this ticket: Unable to embed resource: Re Sprint 38 Enhancement Starting from 925 and Ending on 1006.msg of type application/octet-stream Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Environment Production [ 18442 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Assignee Niteen Surwase [ niteen.surwase ] Priya Dhamande [ priya.dhamande ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In LB Testing [ 10200 ] Resolution Setting [ 11616 ]
            Transition Time In Source Status Execution Times
            Swapnil Pandhare (Inactive) made transition -
            New Request In Analysis
            6d 23h 39m 1
            Niteen Surwase (Inactive) made transition -
            In Analysis In Development
            17d 19h 23m 1
            Gaurav Sodani (Inactive) made transition -
            In Development In LB Testing
            45d 9h 25m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Resolution Setting
            176d 9h 59m 1

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              gaurav.sodani Gaurav Sodani (Inactive)
              Account Executive:
              Nick (Inactive)
              Developer:
              Niteen Surwase (Inactive)
              QA:
              Priya Dhamande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h Original Estimate - 12h
                  12h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 133.25h
                  133.25h