Program Title:	Automating user information Creation, Updating and Deleting across systems	
Presentation Type:	Lightning Round	
Track:	System Administration	
ILS:	Sierra	
Program Description:	We have created an ETL (Extract, TRansform, Load) process at UNCW that allow us to take a file provided by a campus department on a daily basis and import patron information (UPDATE, ADD, DELETE) to Sierra using the Patron API. Additionally we have created an application that uses the same Sierra information to modify users in ILLIAD. (UPDATE status, Clear/ Disavow users). These 2 processes have reduced the amount of time we spend to manually import users and has improved the quality of the data in the ILLiad system.
Presenter Information: 	Jason	Fleming	flemingj@uncw.edu	
Institution:	University of North Carolina Wilmington
automatinguser.pptx (1.4 MB)