Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-921

Item Maintenance - Provide a means to export all Item Maintenance data as a csv

    Details

    • Sprint:
      CFAMX 2019R1 Sprint 4, CFAMX 2019R1 Sprint 5, CFAMX 2019R1 Sprint 6
    • Story Points:
      3
    • SOW (Time Tracking) Project:
      44890
    • Work Type Classification:
      Sustaining

      Description

      As a user of the item maintenance page I want the ability to export all data from the page so that I can view it in a spreadsheet application

      Notes:

      • In order to calculate SS and UPT values operators are looking for a mechanism to get Item Details from InFORM into a spreadsheet application
      • This can be a simple csv export that is generated within the browser, it does not need to use reporting services
      • The button to trigger the download will be controlled by a configuration option
      • If the config is set to display the button, it should display for all views of the page
      • Mockup:

      Acceptance Criteria:

      1. Confirm that there is an option to Download a csv
      2. Confirm that there is a new configuration option that controls the visibility of the download button
        • Operations > Setup > Configuration Manager > Mobile > Administration
        • Allow Access To Download csv of Item Maintenance
        • Allow Access To the Download CSV button on the Item Maintenance page in MxConnect
        • By Default the configuration should be off
      3. Confirm that restaurants that are not configured to see the button do not have access to the button
      4. Confirm that if a restaurant has access to the button and clicks on the button a csv file is generated
      5. Confirm the file name of the file generated includes details that identify its content, for example:
        • Item Details
        • Restaurant Number
        • Date
        • This assumes that it is possible to control the filename
      6. Confirm that a csv file is generated and contains the correct data
        • Usage Restaurant:
          • Description
          • Inventory Item Cost
          • Inventory Unit
          • On Hand
          • Suggested Item
          • Build To
          • UPT Quantity
          • UPT Auto Calc
          • User Default Quantity (Assuming that the restaurant is configured to "Allow Default Order Quantity")
            • If the field is not displayed in the browser it should not be included in the csv
        • Suggested Ordering Restaurant:
          • Description
          • Inventory Item Cost
          • Inventory Unit
          • On Hand
          • Suggested Item
          • Build To This field should NOT be included for Suggested Ordering restaurants
          • UPT Quantity
          • UPT Auto Calc
          • Safety Stock Number
          • Safety Stock Auto Calc
          • Safety Stock Unit
          • User Default Quantity (Assuming that the restaurant is configured to "Allow Default Order Quantity")
            • If the field is not displayed in the browser it should not be included in the csv
      7. Confirm that the csv file is downloaded by the browser

        Attachments

        1. usage.txt
          30 kB
        2. suggested.txt
          37 kB
        3. IMG_0026.PNG
          IMG_0026.PNG
          259 kB
        4. image-2018-10-27-14-51-57-296.png
          image-2018-10-27-14-51-57-296.png
          57 kB

          Issue Links

            Activity

              People

              • Assignee:
                staten.putnal Staten Putnal (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 27h Original Estimate - 27h
                  27h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 28.5h
                  28.5h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.