Skip to content

Into Battle!

December 5, 2014

As a librarian, I do battle.

I would gladly charge into the field to defend intellectual freedom, the rights of all to use public library resources, the importance of teaching technology skills, and generally rally to the cause any number of the arguably obvious librarian-waged wars.

But my personal battles are with code, programs, and general “getting the computer to do the thing.”

Today, I am working with Evanced.

I really like Evanced’s product. I’m especially happy that we’re making the transition from their older products to SignUp and Spaces. But it means that  I have 2,600 lines of Excel data that need to have some sense made of them, since we can’t import the old events into the new product. Which makes sense – I’m not upset about this. In fact, I enjoy battles like this. Wrestling with things like Excel are incredibly fulfilling – when I win.

What I want to do shouldn’t be that difficult. I need to separate the events out by date range (our physical year runs from June to May), then total them, then pull the total attendance. Easy peasy, right?

Except Excel is starting to be a headache for this. I’m thinking Access. Which means refreshing my knowledge of queries.

HERE WE GO.

Advertisements
2 Comments leave one →
  1. December 5, 2014 7:39 pm

    Hmm, I have no idea without using Google, what Evanced is and what it does.

    But the thought of dealing with that many lines of Excel data…is it pure static data or are there scripts embedded?

    Ex-special librarian now knowledge management specialist for enterprise wise e-document management system. My job requires I spend time on clients’ business needs, process analysis, group training, etc. I leave the Excel imports to pure IT folks. They won’t allow anyone else to do it. So 47,000 drawings were migrated along with Excel metadata into the e-document management system.

    Then we had to migrate 25,000 more. Then there’s going to be probably a set of 500 or so later. I’ve done bulk data exports and imports in previous jobs..

    • December 8, 2014 9:06 am

      My apologies! Evanced is a SaaS vendor that provides calendar, event, and room reservation software to libraries.

      I ended up manipulating the data in Excel as opposed to Access. The main trouble is the inconsistency that has occurred (on the staff side) when entering attendance data. With out consistent input, our stats are going to be off. Which means to fix them, I have to slug through old monthly reports and manually enter stuff. Fun times!

      We don’t have any IT folks in the building, and I consider my ability to manipulate data and create worksheets/documents that will make statistic gathering and reporting much easier a great asset. And importing data from a CSV or text file into Excel is a breeze! Even importing Excel into Access isn’t difficult – the program’s wizard walks you through it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: