Hi Bill, I have been working on parsing our logs so we can migrate all of our historical circ transactions into OLE. I was recently able to use the data pulled out of the logs to provide circ counts to our acq department for a vendor provided spreadsheet of items/isbns (that we had purchased).
After using the Sirsi api to pull all of the charges and renewals out of the logs I’ve been using java to parse through these text files and insert the information into a sqlite database (as a ‘staging’ database). From there the transactions can be queried (and for me...prepped to migrate). I would be happy to share my code/process with you. Michelle mis...@lehigh.edu On Wed, Mar 18, 2015 at 5:55 PM, William Denton <w...@pobox.com> wrote: > I'm going to analyze a whack of transaction logs from our Symphony ILS so > that we can dig into collection usage. Any of you out there done this? > Because the system is so closed and proprietary I understand it's not easy > (perhaps impossible?) to share code (publicly?), but if you've dug into it > I'd be curious to know, not just about how you parsed the logs but then > what you did with it, whether you loaded bits of data into a database, etc. > > Looking around, I see a few examples of people using the system's API, but > that's it. > > Bill > -- > William Denton ↔ Toronto, Canada ↔ https://www.miskatonic.org/
