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. image-2018-10-27-14-51-57-296.png
          image-2018-10-27-14-51-57-296.png
          57 kB
        2. IMG_0026.PNG
          IMG_0026.PNG
          259 kB
        3. suggested.txt
          37 kB
        4. usage.txt
          30 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.