Installation | Usage | Configuration | ChangeLog
A tool to export The Evergreen State College Offering catalogue from Banner, via Adminweb.
This project came about due to Lab Management Software (LMS) migration for the Science Support Center. The SSC ran a custom Drupal application called Merci and migrated to using Gigatrak. GigaTrak has many imports, one of which is for members/patrons. Offerings/Programs are used to check equipment out to. It would be helpful to import Science Offerings into Gigatrak so that Offerings/Programs don't have to be manually entered. There's an XML feed from Banner through Adminweb interface, which requires being on the office VLAN.
The XML Offerings feed needs to be parsed (and filtered), and I chose to use XMLSTARTLET for that since the Offerings tool is written for Windows Command shell. The documentation for XMLStartlet is sparse and it took much digging + trial and error to get things working. This is to say that this project would be helpful for learning XMLStartlet. I've tried to document most of the work in my XMLStartlet notes.
Download the latest version from GitHub Release; this will provide an archive compressed .zip file that can be extracted to a directory of your choosing -- hopefully you are following Filesystem Hierarchy Standard, and just like *NIX, Windows has a Directory structure Standard as well. Once extracted, lets say to %SYSTEMDRIVE%\Users\Public\Tools the path wil then be: C:\Users\Public\Tools\Offerings-0.0.0\Offerings-0.0.0; I recommend moving the contents to the top folder: C:\Users\Public\Tools\Offerings-0.4.0
To run the program, run Offerings.cmd. I haven't figured out yet how to path the release, so that it's not redundant.
XMLStartlet -- the [xml] executable must be in the \bin directory.
not all folders will be present with installation, but will be created on first run.
\bin -- contains the XMLStartlet executable.
\cache -- contains working cache, mostly in txt files.
\config -- contains offering configuration for quarters.
\data -- Output for Offerings as txt files that are data structured, using either "|" or TAB as delimiters.
\data\index -- contains the index files by quarters.
\data\xml -- contains the offering XML feed file.
\Docs -- contains documentation, such as XMLStartlet Notes.
\lib -- contains libraries for munging data.
For most users, there's no need to change any variables
Some global variables can be changed in the Offerings.cmd Declare Global Variables section:
:: Log file
SET $LOG_FILE=Offerings.log
:: Adminweb Web URI to fetch export
SET "$URI_ADMINWEB=https://adminweb.evergreen.edu/banner/public/offerings/export"
:: Adminweb xml export file
SET $ADMINWEB_OFFERINGS_EXPORT_FILE=adminweb_Offering_export.xml
:: PATH to xml exe
SET $PATH_XML=.\bin
Free Software (as in, Software Freedom)