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

EDI Dashboard - Requirement Specification

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Development - In Progress
    • Issue Importance:
      Must have Additional
    • Sprint:
      WT Sprint 26

      Description

      EDI Bulk ultility tasks - Scheduled feeds widget

        Attachments

          Issue Links

            Activity

            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to ST-125 [ ST-125 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Priority High [ 2 ] Medium [ 3 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Issue Importance Can Wait [ 11801 ] Good To Have [ 11802 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Component/s BenAdmin [ 10100 ]
            Key ST-156 WT-3092
            Project Project Simple [ 10400 ] WORKTERRA [ 10000 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Issue Importance Good To Have [ 11802 ] Must have Additional [ 12201 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint Must have Enhancements-Add [ 15 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked lower
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint Must have Enhancements-Add [ 15 ] Must have Add-Backlog [ 22 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint Must have Add-Backlog [ 22 ] Must Have Enhancements [ 10 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked lower
            satyap Satya made changes -
            Sprint Must Have Oct-Dec [ 10 ] Enhancements: March-June 2017 [ 48 ]
            satyap Satya made changes -
            Link This issue relates to WT-8896 [ WT-8896 ]
            satyap Satya made changes -
            Sprint Enhancements: March-June 2017 [ 48 ] WT Sprint 26 [ 49 ]
            satyap Satya made changes -
            Summary EDI Bulk ultility tasks - Scheduled feeds widget EDI Dashboard - Requirement Specification
            satyap Satya made changes -
            Assignee Samir [ samir ] Lalit Kumar [ lalit.kumar ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 30/Mar/17 12:41 PM
            • Time Spent:
              1h
               

              EDI dashboard meeting

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 34847 [ 34847 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Dev Due Date 04/Apr/2017
            Original Estimate 0h [ 0 ]
            rohan.khandave Rohan J Khandave (Inactive) logged work - 30/Mar/17 03:29 PM
            • Time Spent:
              1h
               

              Discussion

            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Time Spent 1h [ 3600 ] 2h [ 7200 ]
            Worklog Id 35039 [ 35039 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 30/Mar/17 05:58 PM
            • Time Spent:
              1h
               

              EDI Dashboard discussion

            prasanna Prasanna Karlekar (Inactive) logged work - 30/Mar/17 09:15 PM
            • Time Spent:
              1h
               

              EDI Dashboard discussion

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 2h [ 7200 ] 3h [ 10800 ]
            Worklog Id 35305 [ 35305 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 3h [ 10800 ] 4h [ 14400 ]
            Worklog Id 35366 [ 35366 ]
            lalit.kumar Lalit Kumar (Inactive) logged work - 03/Apr/17 04:54 PM
            • Time Spent:
              1h
               

              Requirement documentation of EDI dashboard

            rohan.khandave Rohan J Khandave (Inactive) logged work - 04/Apr/17 07:55 AM
            • Time Spent:
              1.5h
               

              Discussion with Vinayak , Ganesh & Team

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 04/Apr/17 10:10 AM
            • Time Spent:
              0.75h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Time Spent 4h [ 14400 ] 4.75h [ 17100 ]
            Worklog Id 35910 [ 35910 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Progress(10206)
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            lalit.kumar Lalit Kumar (Inactive) logged work - 04/Apr/17 03:55 PM - edited
            • Time Spent:
              2h
               

              Requirement documentation of EDI dashboard + minor discussion with EDI team

            lalit.kumar Lalit Kumar (Inactive) logged work - 04/Apr/17 04:47 PM
            • Time Spent:
              0.75h
               

              Discussion with Amit and EDI team on requirements regarding EDI dashboard

            lalit.kumar Lalit Kumar (Inactive) logged work - 05/Apr/17 03:56 PM - edited
            • Time Spent:
              3h
               

              Making changes to requirement document after discussion with Amit

            rohan.khandave Rohan J Khandave (Inactive) logged work - 06/Apr/17 08:00 AM
            • Time Spent:
              1h
               

              Discussion with EDI Team

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 06/Apr/17 12:01 PM
            • Time Spent:
              1.5h
               

              Discussion

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Time Spent 4.75h [ 17100 ] 6.25h [ 22500 ]
            Worklog Id 36553 [ 36553 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 06/Apr/17 01:35 PM
            • Time Spent:
              0.5h
               

              meeting

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 6.25h [ 22500 ] 6.75h [ 24300 ]
            Worklog Id 36656 [ 36656 ]
            lalit.kumar Lalit Kumar (Inactive) logged work - 06/Apr/17 04:48 PM
            • Time Spent:
              1h
               

              Discussion with import and export team to implement scenarios discussed with Amit

            lalit.kumar Lalit Kumar (Inactive) logged work - 06/Apr/17 04:58 PM - edited
            • Time Spent:
              2h
               

              Minor changes to document (EDI dashboard requirements)

            lalit.kumar Lalit Kumar (Inactive) made changes -
            Attachment EDI-Dashboard.docx [ 44754 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Status In Development [ 10007 ] Mockup Approval [ 10010 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Status Mockup Approved [ 10012 ] In Development [ 10007 ]
            Hide
            satyap Satya added a comment -

            First Draft of the document has been created & attached with JIRA ticket:
            EDI-Dashboard.docx

            Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - First Draft of the document has been created & attached with JIRA ticket: EDI-Dashboard.docx Regards, Satya Prakash
            satyap Satya made changes -
            Status In Development [ 10007 ] Mockup Approval [ 10010 ]
            lalit.kumar Lalit Kumar (Inactive) logged work - 07/Apr/17 05:33 PM
            • Time Spent:
              1.5h
               

              Reviewed EDI requirement spec before sharing

            satyap Satya made changes -
            Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
            satyap Satya made changes -
            Status Mockup Approved [ 10012 ] In Development [ 10007 ]
            satyap Satya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            satyap Satya made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            satyap Satya made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            satyap Satya made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            satyap Satya made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            satyap Satya made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            satyap Satya made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            satyap Satya made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            satyap Satya made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Hide
            satyap Satya added a comment -

            Document shared with Amit, Dave, Abhay & Nick. Will modify this according to feedback received from them.

            For development linked ticket is: WT-8896.

            Show
            satyap Satya added a comment - Document shared with Amit, Dave, Abhay & Nick. Will modify this according to feedback received from them. For development linked ticket is: WT-8896 .
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Time Spent 6.75h [ 24300 ] 8.25h [ 29700 ]
            Worklog Id 37087 [ 37087 ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Time Spent 8.25h [ 29700 ] 9.25h [ 33300 ]
            Worklog Id 37093 [ 37093 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            To be added to the requirements:

            Need the system to provide reason of failure under Import/Export > Manual Import/Export page. Currently it just states “Import Failed.” Normally, a JIRA ticket needs to be opened for development to troubleshoot the error.

            For both scheduled as well manual import/export, as an immediate measure, we can have the back-end “error log” exposed to the user via error message. As this will be a run-time error, it will have limited use – but it will be better than the current error message. In most cases it would tell the user which macro caused the error. Sharing this message with development will save investigation time as well.

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - To be added to the requirements: Need the system to provide reason of failure under Import/Export > Manual Import/Export page. Currently it just states “Import Failed.” Normally, a JIRA ticket needs to be opened for development to troubleshoot the error. For both scheduled as well manual import/export, as an immediate measure, we can have the back-end “error log” exposed to the user via error message. As this will be a run-time error, it will have limited use – but it will be better than the current error message. In most cases it would tell the user which macro caused the error. Sharing this message with development will save investigation time as well.
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 9.25h [ 33300 ] 10h [ 36000 ]
            Worklog Id 39130 [ 39130 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 10h [ 36000 ] 11h [ 39600 ]
            Worklog Id 39131 [ 39131 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 11h [ 39600 ] 12h [ 43200 ]
            Worklog Id 39133 [ 39133 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 12h [ 43200 ] 14h [ 50400 ]
            Worklog Id 39134 [ 39134 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Worklog Id 39134 [ 39134 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 14h [ 50400 ] 16h [ 57600 ]
            Worklog Id 39136 [ 39136 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 16h [ 57600 ] 17h [ 61200 ]
            Worklog Id 39138 [ 39138 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 17h [ 61200 ] 18h [ 64800 ]
            Worklog Id 39136 [ 39136 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 18h [ 64800 ] 19.5h [ 70200 ]
            Worklog Id 39188 [ 39188 ]
            lalit.kumar Lalit Kumar (Inactive) made changes -
            Time Spent 19.5h [ 70200 ] 20.5h [ 73800 ]
            Worklog Id 39138 [ 39138 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            Lalit Kumar and Rakesh Roy - EDI Team had a meeting with Samir and Amit Thorve where we added the following requirement. CC Cindy Wibbing

            • When a developer fixes the issue for a failure (like making space on the server, opening a port or a code fix), they should add a note about that against the feed failure. In other words whenever the reason of failure is not trivial (i.e. the file typically gets uploaded when refired, or after updating the credentials) - there should be a comment that states reason of the failure and gives some details of the fix that resulted in succesful file generation/ upload.
            • The dashboard should be able to export a simple report that gives information about the failed feeds, just like the report currently mailed by Mandar - with additional information like cause of failure (noted by development or the EDI person), number of attempts and when did it run successfully.
            • We need documentation that maps the error message and issues that cause those errors.
            Show
            abhay.patil Abhay Patil (Inactive) added a comment - Lalit Kumar and Rakesh Roy - EDI Team had a meeting with Samir and Amit Thorve where we added the following requirement. CC Cindy Wibbing When a developer fixes the issue for a failure (like making space on the server, opening a port or a code fix), they should add a note about that against the feed failure. In other words whenever the reason of failure is not trivial (i.e. the file typically gets uploaded when refired, or after updating the credentials) - there should be a comment that states reason of the failure and gives some details of the fix that resulted in succesful file generation/ upload. The dashboard should be able to export a simple report that gives information about the failed feeds, just like the report currently mailed by Mandar - with additional information like cause of failure (noted by development or the EDI person), number of attempts and when did it run successfully. We need documentation that maps the error message and issues that cause those errors.
            abhay.patil Abhay Patil (Inactive) made changes -
            Attachment Description of Import Errors.docx [ 46041 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment - - edited
            Show
            abhay.patil Abhay Patil (Inactive) added a comment - - edited Added a file that has mapping of import errors compiled by Monika Demla .
            satyap Satya made changes -
            Link This issue is cloned by WT-13665 [ WT-13665 ]
            chaitali.acharya Chaitali Acharya (Inactive) made changes -
            Link This issue relates to DEV-10272 [ DEV-10272 ]
            Transition Time In Source Status Execution Times
            Lalit Kumar (Inactive) made transition -
            New Request Pending for Approval
            326d 3h 45m 1
            Lalit Kumar (Inactive) made transition -
            Pending for Approval Approved for Development
            4s 1
            Lalit Kumar (Inactive) made transition -
            Approved for Development In Development
            5s 1
            Satya made transition -
            In Development Mockup Approval
            3d 31m 2
            Satya made transition -
            Mockup Approval Mockup Approved
            2d 17h 20m 2
            Satya made transition -
            Mockup Approved In Development
            8s 2
            Satya made transition -
            In Development In LB Testing
            3s 1
            Satya made transition -
            In LB Testing Pending for Stage Approval
            3s 1
            Satya made transition -
            Pending for Stage Approval Approved for Stage
            2s 1
            Satya made transition -
            Approved for Stage Stage Testing
            2s 1
            Satya made transition -
            Stage Testing Pending for Production Approval
            2s 1
            Satya made transition -
            Pending for Production Approval Approved for production
            2s 1
            Satya made transition -
            Approved for production In Production Testing
            2s 1
            Satya made transition -
            In Production Testing Production Complete
            9s 1
            Satya made transition -
            Production Complete Closed
            3s 1

              People

              Assignee:
              lalit.kumar Lalit Kumar (Inactive)
              Reporter:
              rakeshr Rakesh Roy (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 - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20.5h
                  20.5h