Uploaded image for project: 'UX Product'
  1. UX Product
  2. UXPROD-199

The ability to import fund updates via csv file in order to bulk edit funds

    XMLWordPrintable

Details

    • Large < 10 days
    • Low
    • XL < 15 days
    • Hide
      If users need the system to actually create budgets and make allocation this must be done as a new feature and estimates might change.

      If we can assume the budgets will already exist this could be handle as a bulk edit feature. export list of budgets, make changes in excel, import them back in.
      Show
      If users need the system to actually create budgets and make allocation this must be done as a new feature and estimates might change. If we can assume the budgets will already exist this could be handle as a bulk edit feature. export list of budgets, make changes in excel, import them back in.
    • Thunderjet
    • 83
    • R5
    • R1
    • R3
    • R3
    • R4
    • R5
    • R1
    • R4
    • R1
    • R2
    • R4
    • R5
    • R4
    • R1
    • R4
    • R4

    Description

      Note: this was split into two stories one for export (UXPROD-3620) and this one for Import.

      Purpose: Users need to be able to export and import their ledgers in order to bulk edit Fund and Budget details easily

      Use cases:

      • Librarian administrator logs into folio after finishing fiscal year rollover. The librarian needs to allocate money to all budgets in the new fiscal year. User downloads all budgets and updates numbers in spreadsheet. Uploads all numbers to update values in Finances
      • Library may want to upload budget numbers for planned budgets for the coming year. This would require us to have the ability to choose what fiscal year we are adding the budget information to.
      • Mid fiscal year it is sometimes necessary to make updates to budget allocations. TO do this we would export budgets and make changes to the necessary budgets. Uploading these changes would result in increases or decreases in allocation for the budget that were changed.

      High-Level Requirements:

      These requirements needed to be updated to accommodate the new element Expense class. It could also makes sense to split this feature into separate requirements for import and export. https://wiki.folio.org/x/v8K8B

      Note changing the Fund information and budget information at the same time may be confusing. Could be helpful to separate these into separate actions.

      Additional information: https://wiki.folio.org/display/DD/Finance+Data+Model

      Approach:

      https://wiki.folio.org/display/DD/Data+export+by+using+Spring+Batch

      Out of scope:

      • Creating any type of transfer, payment or credit using this process.
      • Creating new Funds during this process

      Grooming

      Export to CSV

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                dennisbridges Dennis Bridges
                dennisbridges Dennis Bridges
                Dennis Bridges Dennis Bridges
                Dennis Bridges Dennis Bridges
                Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                  Created:
                  Updated:

                  TestRail: Runs

                    TestRail: Cases