Tag: MySQL

ER&L 2012: ERM Workflow and Communications Panel

218/365 - communication problems?
photo by Josh Fassbind

Speakers: Annie Wu & Jeannie Castro

They used a HelpDesk Ticket for new subscriptions to manage the flow of information and tasks through several departments. Sadly, it’s not designed for ejournals management, and not enough information could be included in the ticket, or was inconsistently added. So, they needed to make some changes.

A self-initiated team decided a new workflow using a spreadsheet to keep the info and set up status alerts in SerialsSolutions. The alerts and spreadsheets facilitated the workflow through all departments.

A lengthy description of the process, spreadsheets, action logs, email alerts, and I’ve concluded that my paper checklist is still the best solution for my small library.

Challenges with their system included the use of color to indicate status (one staff is color blind, which is why the also use an action log), there is some overlap of work, and tracking unsolved problems is difficult. Despite that, they feel it is better than the old system. It’s a shared and transparent process, with decent tracking of subscriptions, and it’s easy to integrate additional changes in the process.

Speaker: Kate Montgomery

They initially had Meridian, and while it was great that they followed the ERMI standard, they didn’t need everything, so it was a sea of bits of data with lots of blank fields. Meridian is dead, so they had to look for alternatives. Considered Verde, but sensed that it was to be replaced by Alma. So, they had to decide whether to build their own tool, using an open source product, or purchasing something. They were limited by time, staffing, and money.

Ultimately, they decided to go with CORAL. They didn’t have to learn a lot of new skills (MySQL & PHP) to set it up and get it to work. Rather than looking at this as a whole lot of work, they took the opportunity to make a product that works for them. They reviewed and documented their workflows and set some standards.

CORAL can create workflows that trigger actions for each individual or group, depending on the item or situation. Hopes to use this to create buy-in from library departments and other small libraries around campus.

women in digital librarianship

In the August 2006 issue of Library Journal, Roy Tennant writes about the gender gap in digital librarianship. It’s a concern that I have been pondering on a more personal level for quite some time. I totally geek out over the shiny toys being pumped out by the Library 2.0 geniuses, but when it comes … Continue reading “women in digital librarianship”

In the August 2006 issue of Library Journal, Roy Tennant writes about the gender gap in digital librarianship. It’s a concern that I have been pondering on a more personal level for quite some time. I totally geek out over the shiny toys being pumped out by the Library 2.0 geniuses, but when it comes to creating my own contributions, I falter. Even just writing about them makes me nervous. Who am I to pretend to know something about these things? I’m just the person who pays the bills.

This is not entirely an accurate picture of my work, but a great deal of it does involve managing budgets, as well as staff. Occasionally my Dean will discuss my scholarship direction and interest in library technology, and inevitably the phrase, “but I’m not an expert on that!” will come out of my mouth. He wants me to publish, and I find myself floundering around trying to find something – anything – that I might know more about than the average librarian. The problem is that I am the average librarian.

I’m not Michael Stephens and Jenny Levine, jetting off to here and there to bring the wonders of Library 2.0 to the commoners. I’m not Sarah Houghton with my hands buried up to my elbows in library technology. I’m just a normal person with some HTML skills and an interest in technology. I’ll never be a Mover and Shaker.

This is the mental block that gets thrown up every time I think about my role in digital librarianship. I’m always going to be on the second or third wave of folks implementing new technology in libraries.

What I need are the tools to become more technologically savvy. I’ve looked into some of the options offered at my university, but aside from seeming rather intimidating, I worry that they will be too broad for my needs. What I would really like to see are some training sessions like what Michael and Jenny have been doing, but at a higher level. For example, how about something for folks who already know about RSS feeds but don’t have the skills or tools to use them in more creative ways? That would be very useful. Or maybe a crash course in MySQL databases with PHP interfaces. I can think of a lot of uses for that just in my daily job.

Some of us are lucky enough to live relatively close to Library Science programs. If the iSchool at the University of Washington offered a day or two long continuing education course on MySQL and PHP in the library setting, I would attend.

Maybe that’s something that Tennant and his posse should consider. We can’t wait for a new generation of women to grow up encouraged to be interested in technology. We need to do something for the women who are currently in the profession, as well.

a light at the end of the tunnel

When I returned to work on Monday, I had recovered from the frustration and stress of the previous Friday, so fixing all of the problems I had encountered with SFX was a much more feasible task than it had seemed before the weekend. In fact, with a clear head and a few MySQL passwords, I … Continue reading “a light at the end of the tunnel”

When I returned to work on Monday, I had recovered from the frustration and stress of the previous Friday, so fixing all of the problems I had encountered with SFX was a much more feasible task than it had seemed before the weekend. In fact, with a clear head and a few MySQL passwords, I was able to get most everything done that wasn’t working for me before. As it stands now, pretty much everything is working as it should be. There are still a few more bugs, but I expect those will be cleared up within the next week or two.

Ever since I discovered the joys of keeping up with several weblogs through my RSS aggregator, I have been doing a lot of reading, but not so much writing. Not that I did all that much writing before, but for instance, this week I didn’t write anything at all, and that was mainly because after reading blogs, email, books, and journals, I didn’t have the energy to think of something of my own to say. So, here I am at 1:30am on Saturday, typing away.

css.php