scriblio

Happy New Scriblio!

The most recently released, stable version of Scriblio is marked 2.9-r1 and was last updated in June 2010. You can be forgiven for thinking development had ceased in the interim. Today, however, I’m proud to introduce a completely new Scriblio, re-written from the ground up to take advantage of the latest features of WordPress and eliminate the mistakes […] » about 600 words

Cleaning Up Category Relationships In A WordPress Scriblio Site

A few lines of SQL I used to clean up a Scriblio site. It’s probably useless to anybody but me. I’m not suggesting anybody else use this code, as it will result in changed or deleted data.

Update the post author for catalog records (identified because they have a specific post meta entry):

UPDATE wp_8_postmeta
JOIN wp_8_posts ON wp_8_posts.ID = wp_8_postmeta.post_id
SET post_author = 15
WHERE meta_key = 'scrib_meditor_content'

Get the categories attached to every catalog record (except the “catalog” category):

SELECT tr.object_id , tr.term_taxonomy_id
FROM wp_8_term_relationships tr
JOIN wp_8_posts p ON p.ID = tr.object_id
WHERE tr.term_taxonomy_id IN (
	SELECT term_taxonomy_id
	FROM wp_8_term_taxonomy
	WHERE taxonomy = "category"
	AND term_id != 30
)
AND post_author = 15
ORDER BY tr.object_id , tr.term_taxonomy_id

Using the above list of object ids and term taxonomy ids, build a series of queries like the following to delete them:

DELETE FROM wp_8_term_relationships WHERE object_id = 12275 AND term_taxonomy_id = 271872 ;

Insert a catalog category relationship for all catalog records:

INSERT INTO wp_8_term_relationships
SELECT p.ID , '271871' , '0'
FROM wp_8_posts p
LEFT JOIN wp_8_term_relationships tr ON p.ID = tr.object_id AND tr.term_taxonomy_id = 271871
WHERE post_author = 15
AND tr.term_taxonomy_id IS NULL

Scriblio Theater

Flickr Video Flickr Video

I should have done screencasts like the above long ago. It’s not that they’re great, but they are a wonderful excuse to use the canned lounge music I’ve got. Those videos are now on the front page of the official Scriblio site, and I did five more to demo the installation and configuration. Big thanks go to Collingswood NJ Public Library Director Brett Bonfield who let me use his library like this.

Scriblio 2.7 Released

My slides for my presentation yesterday at code4lib are available both as a 2.7MB QuickTime and a 7.8 MB PDF, while the gist of talk went something like this: Scriblio is an open source WordPress plugin that adds the ability to search, browse, and create structured data to the the popular blog/content management platform. And […] » about 500 words

My DevCamp Lightning Talk

Hi, I’m Casey. I developed Scriblio, which is really just a faceted search and browse plugin for WordPress that allows you to use it as a library catalog or digital library system (or both). I’m not the only one to misuse WordPress that way. Viddler is a cool YouTube competitor built atop WordPress that allows […] » about 400 words

Scriblio Integrates Google Book Search Links

(crossposted at Scriblio.net) Using the newly released book viewability API in Google Book Search, Plymouth State University’s Lamson Library and Learning Commons is one of the first libraries to move beyond simply listing their books online and open them up to reading and searching via the web. Take a look at how this works with […] » about 200 words

Scriblio Feature: Text This To Me

Take note of the “New Feature: Text this to your cellphone” line above. Adam Brin of Tricollege Libraries explained that the “text this to me” feature he built to send location information about items in the library catalog as text messages to a user’s cell phone is being used as many as 60 times a […] » about 100 words

OLA Superconference Presentation: Scriblio

I’m honored to be invited to the Ontario Library Association Superconference to present my work on Scriblio today (session #1329). A PDF of my slides is online. Scriblio has had about a year of use in production at each of three sites, and the lessons suggest that Web 2.0 technologies really do work for libraries. […] » about 200 words

Scriblio 2.3 v4 Released

Scriblio 2.3 v4 is out. See it. Download it. Install it. Join the mail list. What’s new? Lots of small bug fixes. Implemented wp_cache support. Revamped SQL query logic for better memory efficiency. New widget options. Search suggest/autocomplete support (implemented in the new theme). New theme. New Theme! By Jon Link. » about 100 words

People Make Scriblio Better

It’s way cool to see Lichen‘s Scriblio installation instructions translated to Hungarian. Even cooler to have Sarah the tagging librarian take hard look at it and give us some criticism (and praise!). But I’m positively ecstatic to see Robin Hastings’ post on installing Scriblio (it’s not easy on Windows, apparently).

Part of it is pride in seeing something that I’ve been working on for so long finally get out into the world, but Scriblio really does get better with every comment or criticism. And it takes giant leaps forward every time somebody installs it and reports on how it went. Way cool. Thank you.

Internet Librarian 2007 Presentation: Building Web 2.0 Native Library Services

The conference program says I’m speaking about designing an OPAC for Web 2.0, and I guess I am, but the approach this time is what have we learned so far? And though it’s the sort of thing only a fool would do, I’m also planning to demonstrate how to install Scriblio, a web 2.0 platform […] » about 100 words

Presentation: Faceted Searching and Browsing in Scriblio

I was honored to be a panelist at the LITA/ALCTS CCS Authority Control in the Online Environment Interest Group presentation of “Authority Control Meets Faceted Browse.” What is faceting? Why is it (re)emerging in use? Where can I see it in action? This program is intended to introduce the audience to facet theory, showcase implementations […] » about 500 words

An Almost-Manifesto Masquerading as a Presentation…

Context: Below is the text of my virtual presentation to the LITA BIGWIG (it stands for blogs, wikis, interest group, and stuff) Social Software Showcase. The presentation is virtual, but the round table discussion is going on today, June 23rd, from 1:30-2:30 p.m. in the Renaissance Mayflower Cabinet Room. I won’t be there, though. My […] » about 600 words

Books I Now Want To Read…

The problem with working on Scriblio is that I end up running into so many interesting looking books. Just this morning I discovered a number of recent acquisitions in the 19th Century and 20th Century subject feeds in my development instance (also available via RSS). All of this is under active development, so those links […] » about 100 words

Presentation: Faceted Searching And Our Cataloging Norms

ALA Midwinter 2007, ALCTS Cataloging Norms Discussion Group presentation: Metadata and faceted searching: an implementation report based on WPopac. (slides: QuickTime & PDF.) Faceted searching such as that made possible by WPopac (look for the new name soon) improves the usability of our systems and findability of our materials, but also puts new demands on […] » about 400 words

Let The Silence Roar

Okay, before anybody inquires if I’ve gone into boat sales or brings up the BisonBoom story again, I need to ask for your understanding. It’s not that I’ve been spending my days trying to pick out just the right shade of red for my new Corvette (really I’m not, it’s the Lotus I like), or […] » about 300 words

WordPress 2.1 + WPopac

I’ve been following WP2.1 development, but Aaron Brazell’s post in the development blog wrapped up a lot of questions all at once.

The short story is that 2.1 is going to bring some really good changes that will allow more flexibility and better optimization of WPopac. Of the four changes Brazell names, the last two, the addition of the post_type column and a change in usage of the post_status column, are where the money is.

I’m awaiting the final release of 2.1 before building the necessary changes into WPopac, but the benefits will be worth it.

Woot! Woot!

The press release: Making Libraries Relevant in an Internet-Based Society PSU’s Casey Bisson wins Mellon Award for innovative search software for libraries PLYMOUTH, N.H. — You can’t trip over what’s not there. Every day millions of Internet users search online for information about millions of topics. And none of their search results include resources from […] » about 600 words

Presentation: Designing an OPAC for Web 2.0

MAIUG 2006 Philadelphia: Designing an OPAC for Web 2.0 (interactive QuickTime with links or static PDF) Web 2.0 and other “2.0” monikers have become loaded terms. But as we look back at the world wide web of 1996, there can be little doubt that today’s web is better and more useful. Indeed, that seems to […] » about 400 words

Catching Bugs Before They Catch You

I got itchy about magic quotes the other day because it’s the cause (through a fairly long cascade of errors) of some performance problems and runaways I’ve been seeing lately (pictured above). But I deserve most of the blame for allowing a query like this to run at all: SELECT type, data, count(*) AS hits […] » about 300 words