Bursar Export Integration
| Status | DRAFT |
|---|---|
| Primary Author | Rick Dietz, Stanislaus |
| Additional Authors | Ian Chan, San Marcos Lauren Magnuson, San Marcos Brian Moore (Unlicensed), San Diego Eva Sorrell, San Bernardino Suzanna Conrad (Unlicensed), Sacramento Cecilia Huang, Pomona Christian Ward, Sacramento Julie Kowalewski-Ward (Unlicensed), SJSU Troy Compton (Unlicensed), SDSU Aleta Asbury, SFSU |
If your library wishes to export fines and fees to PeopleSoft and close out money owed balances in user records in Alma, the built-in Bursar Export Integration enables this. When fines and fees are exported through this integration, the fine/fee balance is closed out in Alma.
Note that this integration is the 'out-of-the-box' bursar integration provided by Ex Libris, and is distinct from the two-way PeopleSoft Integration being developed at San Marcos. The San Marcos integration is being designed to enable fines to remain active on user records, with payments processed in PeopleSoft to be sent back to Alma. More information on that model is available here.
Considerations
This is the native bursar export provided by Ex Libris. With this option, fines and fees are closed in Alma. This option is best if your library does not intend to restrict library use for balances owed, and does not wish to accept fines in the library. If TOU restrict permissions based on fine balance owed, those restrictions would not take effect, as fine balances are closed out once they are exported to the bursar's office.
Ex Libris Documentation
Bursar Systems (Ex Libris Knowledge Center)
Bursar Fine/Fee Export (Ex Libris Developer Network)
Sample upload file for importing Alma user fine/fee data to PeopleSoft (Bitbucket.org account required. Send your account username and email to Lauren Magnuson (Unlicensed) or Ian Chan (Unlicensed).)
Step-by-step guide
Steps below are dependent on whether all campuses use the same file format for importing data to PeopleSoft SFS accounts.
Alma Integration Profile Setup and Procedures
| Create/Configure a bursar type of integration profile | |
| Location in Alma menu | Administration > General Configuration > Configuration Menu > External Systems > Integration Profiles |
| Ex Libris documentation | https://developers.exlibrisgroup.com/alma/integrations/bursar https://developers.exlibrisgroup.com/alma/integrations/bursar/export |
| notes about configuring integration profile | • scheduling options are preconfigured by Ex Libris staff. Choices: "Every Sunday at 18:00", "Every day at 18:00" and "Not scheduled". |
| Run the Integration Profile | |
| Name of xml file generated | • The "code" you specify in the Integration Profile with be prepended to the name of the xml file generated. • Do not use "/" or other non-alphanumeric characters. |
| What happens to the fine/fee in Alma |
|
Formatting Alma Output for PeopleSoft
- Contact your PeopleSoft administrator and share documentation regarding this integration. You will need to define an S/FTP server location for Alma to export the fines/fees file to for PeopleSoft to pick up.
- Configure and place Alma-to-SFS data conversion script on same server as destination directory for exported bursar data file.
- Utilize automated process to periodically run Alma-to-SFS data conversion script to convert data into appropriate format for file upload to PeopleSoft SFS.
- Place conversion output in directory accessible to PeopleSoft.
- Implemented automated process for PeopleSoft SFS system to upload and process bursar data file.
Related articles