Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    How to upload a list of Fund allocations from a file to Alma?

    • Product: Alma
    •  

    Question

    How to upload allocations to Funds through a file?

    Answer

    1. Prepare an input file. Here is an example of an Excel file:
    FUND_EXTERNAL_ID FISCAL_PERIOD_ID AMOUNT TRANSACTION_REFERENCE_NUMBER TRANSACTION_NOTE
    ART 5 50    

    Fill in:

    • FUND_EXTERNAL_ID
    • The FISCAL_PERIOD_ID is found in: Configuration > Acquisitions > General > Fund and Ledger Fiscal Period
    • AMOUNT
    • TRANSACTION_REFERENCE_NUMBER 
    • TRANSACTION_NOTE
    1. Verify that you have access to an FTP server, as set-up in: Configuration > General > Integration Profiles > Integration Type: Finance > for example: "ERP"
    2. In the above integration profile > "Actions" tab > find the section "FUNDS ALLOCATION LOADER"
    3. Note the subdirectory (you may need to change it, as long as it exists in the FTP server as configured in step #2)
    4. Modify the input file - keep it small at least in the beginning when you test
    5. Load the file to the FTP server as configured above
    6. Open again the Integration Profile > Actions > Find the section "FUNDS ALLOCATION LOADER" > make sure that the Loader section is "Active", and "Run"

    Additional Information

    Read here about "Financial Systems" Integration Profiles

    And more about the "Funds Allocation Loader – Fund Allocation Loader (called Update Fund Tx Job in the list of scheduled jobs)"

     

     

     

     


    • Article last edited: 22-JUN-2022
    • Was this article helpful?