Re: Extracting Patron Information From Banner

[Alma Garcia <almag at mills dot edu>]

We have been using Banner for well over 10 years.  Before III we were 
loading student information from our Banner system into our old Dynix 
system.  When we migrated to III, the process was updated and library 
staff if given authority to run the report whenever we need to load the 
information.  At the beginning of each semester we are now loading 
information for students as well as from payroll for faculty and staff.

We are also using the same information to load update a couple of other 
systems on campus that need student information as well.

Alma

Steve Sowder wrote:
> We do something simular but with a slight twist.  Our ITS people got 
> tired of me asking for the patron data so they set up a web page for me. 
> On the web page I fill out a form indicating which semester and which 
> group. (We have basically three groups. The  University, a Physical 
> Therapy school which is on it's own semester system, and a high school 
> and grade school). The web page form results in an email with  the 
> results of the Banner search sent to me. I save it to a file and then 
> update a local database with a perl script. It selects out only the CHANGES 
> from the previous update and sends only the changes to the Innovative 
> system to reduce the workload on the server.
>
> I can optionally tell the perl script to send everything to the server 
> that was in the load from Banner.
>
> While it's not waiting for me when I come in I can run the entire 
> process from offsite. Even while at IUG.
>
> Steve 
> sowder at andrews dot edu
>
>
> On Mon, 4 Apr 2005, Casey Bisson wrote:
>
>
> > We've been getting our patrons from Banner for a while now, but it 
> > required the Banner folks to create a table (used by a number of 
> > departments) of currently active students, faculty, and staff. I don't 
> > believe this table is a standard part of banner, but we found it 
> > necessary to make sure there was an authoritative list of 
> > benefitted/privileged persons.
> >
> > We now copy that table to a MySQL table where I can read it with less 
> > fuss, but for a while I read the Oracle table directly and created our 
> > patron load lists from there.
> >
> > In both cases I use a PHP script to select the entire table, then 
> > iterate through each record to format a III punch card-style patron 
> > record for import. I use information in the Banner record to set patron 
> > type, but it's fairly straightforward from there. The record formatting 
> > is the easy part, establishing the relationship with the MIS folks, 
> > identifying who should have privileges, and ensuring ease of access to 
> > the data while maintaining security are a lot more complex.
> >
> > I've now automated things so that there's a new patron load file 
> > waiting on our Innopac each day, a member of the circ staff manually 
> > does the load from there. Some would probably make an Expect script to 
> > handle that last part, and with appropriate error checking it could be 
> > a fully automated solution.
> >
> > Casey Bisson
> > __________________________________________
> >
> > Library Information Technologist
> > Plymouth State University
> > Plymouth, New Hampshire
> > http://oz.plymouth.edu/~cbisson/
> > ph: 603-535-2256
> >
> >
> >
> >
> > On Apr 4, 2005, at 9:39 AM, Pfohl, Dan wrote:
> >
> >
> > > The universities in the NC Coastal Carolina Consortium are working at
> > > upgrading HRS and SIS Plus systems to Banner.  Our IT folks have asked
> > > if there are any Banner sites out there that would be willing to share
> > > scripts for extracting faculty and student information from Banner and
> > > reformatting it for importing into Innopac/Millennium.
> > >
> > > Thanks in advance for any help you can provide.
> > >
> > > Daniel M. Pfohl
> > > Associate University Librarian for Computing Services
> > > William Madison Randall Library
> > > UNC-Wilmington
> > > 601 South College Road
> > > Wilmington, NC 28403-5616
> > >
> > > pfohld at uncw dot edu
> > > Phone: 910-962-7641
> > > Fax: 910-962-3078
> >
> > --
> > This message was distributed through the Innovative Users Group INNOPAC list
> > Public replies:  INNOPAC at innopacusers dot org
> > Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac
> >
> >
> > BEGIN-ANTISPAM-VOTING-LINKS
> > ------------------------------------------------------
> > Teach CanIt if this mail (ID 2160564) is spam:
> > Spam:        http://www.andrews.edu/spam/canit/b.php?c=s&i=2160564&m=587813f3a674
> > Not spam:    http://www.andrews.edu/spam/canit/b.php?c=n&i=2160564&m=587813f3a674
> > Forget vote: http://www.andrews.edu/spam/canit/b.php?c=f&i=2160564&m=587813f3a674
> > ------------------------------------------------------
> > END-ANTISPAM-VOTING-LINKS
>
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac

--
Alma García			Library Systems Administrator
Mills College Library		510-430-2021	
5000 MacArthur Blvd.		510-430-3155 fax
Oakland, CA  94613