Bill, If you are talking about parsing Sirsi transaction logs specifically, it's fairly straightforward to do so with regular expressions and a small amount of code. We warehouse data extracted from our logs every night. If you're talking about working with data retrieved from Sirsi's APIs more generally, quite a bit of that can also be done without too much effort. cheers, AC On Thu, Mar 19, 2015 at 9:39 AM, Michelle Suranofsky <[log in to unmask]> wrote: > 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 > [log in to unmask] > > On Wed, Mar 18, 2015 at 5:55 PM, William Denton <[log in to unmask]> 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/ >