Archive for the 'Technology and software' Category

Google TV

Posted in Technology and software on July 29th, 2011

The first couple of Google TV products emerged in early 2011—Logitech’s Revue set-top box and a Sony Blu-ray player with Google TV built in. A fairly long writeup in the February 2011 Home Theater is interesting—including an odd little slap at both devices for requiring wall-wart power supplies, which—for devices that are always plugged in—“always screams cheap, off-the-shelf design to me.” The main conclusions: Google TV isn’t there yet, partly because none of the three main networks will allow streaming of their shows, partly because in the process of passing your other TV signals through the Google box, you lose surround-sound capabilities. We do get a sideswipe from a writer who’s clearly an Apple fancier—as made clear in this passage: “If you’re one of those staunch opponents of all things Apple, you probably don’t know what I’m talking about, and you’ll forever be subjected to complex hierarchies and poorly integrated UIs…” Wow. Nobody but Apple is capable of producing good UIs!

For an amusing contrast, there’s “Kill Your Cable, If You Dare” by Jeff Bertolucci in the December 2010 PC World. Bertolucci was spending $85/month on his cable service, and of course the only solution was to get rid of cable entirely. (Since, you know, moving to limited-basic is clearly out of the question.) He concludes that “Google TV…is the best way to find content online.” He also discusses lots of other options…and admits that, well, “if you live in an area where the over-the-air broadcast channels are difficult to receive through antenna,” maybe you shouldn’t cut the cable. What I notice consistently throughout the article: There is never any discussion of video quality. None. (At the very end, he does mention limited-basic cable.) So on one hand, Google TV is the way to go; on the other, it’s not ready for prime time.

For the rest of the story (21 other products & ideas)… or read Interesting & Peculiar Products as part of Cites & Insights 11:6

Trends & Quick Takes

Posted in Technology and software on July 27th, 2011

Time for another Random Roundup, part of an ongoing effort to offer quick notes on interesting things. When I did a catch-up edition of T&QT in October 2009, I noted that—with my switch in March 2009 from printing leadsheets for interesting source material to tagging items in Delicious—I was up to 50 items in September 2009 tagged “tqt” (the tag for this section) out of 643 items altogether, far more items than I ever had “on hand” prior to Delicious.

If you’ve been keeping track, you’ll be aware that I gave up on Delicious after Yahoo! basically issued its death warrant and, after asking for advice and doing some exploring, switched to Diigo, taking my Delicious-tagged items with me (evaluating many of them along the way). I’m not thrilled with one specific aspect of Diigo (the alphabetic list of all tags is clumsy to use because it’s not a list), but otherwise it’s just fine—but boy, do I have a lot of stuff tagged, even after wiping out a hundred items in one recent essay.

The count as of April 21, 2011: 1,294 items in all. Take away GBS (Google Book Settlement, which I may scrap entirely) with 230, and you still have more than a thousand, including 106 tagged tqt. So, well, this roundup in an issue full of roundups is another attempt to do a little catching up, five thousand (or so) words at a time.

For the rest of the story… or read as part of Cites & Insights 11:6

Sometimes it’s the little things…

Posted in Technology and software on April 21st, 2011

I’m holding off on a downbeat post that I’ve been thinking about for a week or more, because, you know, I’m really an upbeat kind of guy, and…well, anyway. Instead, here are three reasons, all of them small in some ways, why I’m pretty happy with Windows7 and Office2010:

  1. I have Windows AutoUpdate on–I can’t imagine not having it on, frankly. In Vista and, I believe, XP, that meant that, once an update had hit my machine, any attempt to do a temporary partial shutdown (sleep or hibernate) would turn into a forced shutdown to allow the updates to be installed. You got the exclamation-point warning, but still… In Windows7, you still get the exclamation-point warning, but you can still go to Sleep or Hibernate without the update-and-shutdown taking precedence. There are times when I really want to leave some applications in “loaded” state while the machine’s on standby or powered down; this is a really nice, perhaps small, change.
  2. This becomes much more relevant if my proposed project on (mostly public) libraries as publishers/facilitators of low-cost, short-run publishing becomes a reality: Office2010 includes direct PDF support on Windows7 (that is, you don’t need to buy Acrobat or a competitor), but my sense was that it wouldn’t produce Lulu-compatible output because Arial wouldn’t get embedded (and some document templates will still have apparent Arial text even if there’s none that you can find–as a footnote separator, for example). BUT: I’ve just noticed that the PDF options include an ISO 9005-1-compliant option, that is, PDF/A (the standard, archival, PDF option. PDF/A embeds all typefaces in a document. It should be Lulu-compatible, albeit slightly larger. So, unless you need special capabilities (combining multiple PDFs, restricting accessibility, etc.), this should mean that Office2010 by itself is all you need.
  3. Windows7 made a generally-sensible change to the taskbar, combining multiple instances and windows of a given program into a single button that yields multiple views when you mouseover–good for many people in that it cleans up the taskbar. But for some people, including my wife (who, for certain projects, will have two or three Notepad windows and an IE window or two open) and, actually, me (frequently two Word windows), it’s a damn nuisance. And, as it turns out, an entirely optional one: Right-click on the taskbar, choose Properties, and on the Taskbar tab there’s “Toolbar buttons:” and a pull-down that defaults to the snazzy, clean & lean “Always combine, hide labels” option. Change that to “Never combine” and you’re back to multiple Word or Notepad or whatever elements that self-identify.

So there’s my upbeat Friday post.

LibreOffice Notes, 1

Posted in Technology and software on April 11th, 2011

For a project I hope to be taking on (for a real publisher, none of this “do all the work and see whether anybody wants it” stuff), I downloaded OpenOffice 3.3. Then, after being alerted to its existence and thinking about it, I got rid of that and downloaded LibreOffice 3.3 instead (version 3.3.2 at the moment)–all of the open source goodness, less of Larry Ellison (directly or indirectly), and presumably a more-or-less identical code base at the moment.

The idea was not to quit using Microsoft Office, especially since I’ve upgraded to Office2010 within the last three weeks. (Which, so far, I find a little cleaner than Office2007, and I was happy with that, so… A number of advantages, especially in the new “File” page, and so far only one minor annoyance.)

The idea was to offer an alternative, for book-level preparation, for those who couldn’t afford Word. I don’t think there’s much doubt that LibreOffice/OpenOffice is a reasonable alternative for most everyday Word uses and for most everyday Excel uses–but it doesn’t take all that much to move beyond “everyday.”

Heck, I even read a book on OpenOffice–after my attempts to open or import Access databases were, shall we say, less than optimal (yes, the tables opened…but with all table-to-table links gone, with all reports gone, and, in one case, with a fully-editable database turned read-only). That wasn’t helpful as regards the Database portion: I would up converting the databases into Excel spreadsheets, substituting page-to-page links for table-to-table links. But that’s a different matter…

Some Compatibility Testing

First, I tried LibreOffice as a truly compatible system, since it now claims to handle the “…x” formats (Office2007 native) as well as the old .doc and .xls and .ppt formats.

To wit, what would happen when I opened an existing document?

Trial 1: Current Cites & Insights

Yes, it opened. Yes, the typefaces were right. But…

  • The running footer disappeared entirely.
  • The issue was now 46 pages long rather than 44. Why? Because…
  • LibreOffice Writer turned off hyphenation. If you try to turn it back on, it hyphenates everything, including headings and subheadings. In other words, it’s simply ignoring style-level control of hyphenation.
  • LibreOffice Writer also lost all of the tightening I’d done, cases where I compressed a paragraph by 0.1 or 0.2 pts to pull a final word back up to the previous line. Oh, you can do that compression, but it’s much more laborious than in Word (partly because the default up/down step for compression is an absurd 1.0 points, not 0.1 points, yielding unreadable text)…and, of course, I’d have to go through and redo all of it.
  • Bizarrely, the Heading2 and Heading3 styles now assumed that all lines but the first should be indented 1.5 picas. This yields Heading2 (centered) that, if they run past one line, look absurd: Centered but with the second line offset enough to the right that it looks as though you simply don’t know what you’re doing. Similarly for Heading3.

On the other hand, kerning was fine and it seemed to retain bolding and italics. So it was ignoring some aspects of the original document–enough that it would have taken me at least 3-4 hours to get back to what I wanted.

Trial 2: Body Type Sampler

I put this document together to determine which serif typefaces on my system came with normal Microsoft software, so I’d have a set of possible alternatives to suggest (I have a couple of hundred typefaces that I’ve acquired in other entirely legal manners)…and how well each of them worked in terms of looks, kerning, etc.

I was using my default template, a very simple one, and using primarily four styles (but with typeface overrides on most paragraphs): Title, Heading3, First (first paragraph under any heading level, using 11-point type) and Quote (indented paragraph using 10-point type).

The good news: LibreOffice Writer picked up all the typeface and style overrides (each sampler paragraph includes normal, italic and boldface), and kerning was done as well as (I’d say identically to) Word2010.

The bad news:

  • Once again, the running footers were gone.
  • While the First paragraphs were still 11 point type, the Quote paragraphs–while properly indented–were now 12 points, which is bizarre.

Trial 3: Book with very little formatting

While disContent: The Complete Collection is no longer available as a book, I still have the .docx and .pdf files. This is a simple book, with the same running page headers throughout, but it does have a few typical book complexities–e.g., page numbering starts at the first chapter, there are lots of forced page breaks,

Let’s see…

  • Hyphenation disappeared.
  • So did running headers–to be replaced, on all pages, by a running footer that was only supposed to appear on the first page of the Preface, nowhere else.
  • The table of contents was a complete mess, as some lines were justified in a manner that made them unreadable (they shouldn’t have been justified at all).
  • The book was significantly shorter–because, as it turned out, Writer had dropped the gutter margin, so that the body text was now 4.7 inches rather than 4.4 inches.

Trial 4: Early C&I, using .doc (Word2000)

Just for fun, I opened Volume 2 Issue 1, which used .doc but also used drop caps at the start of each new story.

LibreOffice Writer did considerably better with this document–retaining the running footer, handling the drop caps, but still changing formatting in ways that made the whole text run a little longer.

Overall Conclusion

LibreOffice Writer is “compatible” with Word, where “compatible” is in scare quotes–because you have no way of knowing which aspects of a document Writer will choose to ignore and which it will handle correctly.

For the book-length projects I’m thinking of, I’m reluctant to consider it as an alternative, because it looks to be fairly cumbersome at pagefitting and at handling special aspects of a book. But, of course, 99.9% of documents prepared in Word aren’t books (I made that number up, of course)…and LibreOffice may be just fine for those and especially when you’re creating new documents.

I might give it a little more trial, using it to create new things, to see whether I can figure out how to have a Style palette display, whether its templates are robust, and other things that matter to me but maybe not to others.

And then there’s LibreOffice Calc…

Just as a side note, “Writer” and “Calc” are the program names–but if you open LibreOffice itself, they’ll appear as “Text Document” and “Spreadsheet.” Not sure whether that’s an advantage or a disadvantage. Also, LibreOffice uses Office2003-style menus and toolbars (no ribbon), which some people will find to be an advantage. Oh, and because LibreOffice will produce PDF/A, it’s a little better for cases where the PDF must embed all typefaces–I still don’t see how to do that in Office2010’s PDF save-as option. (Unfortunately, I can’t get rid of an Arial stub that doesn’t appear to actually be in my documents, but still registers as an unembedded typeface.)

I tried opening two mildly complex Excel2010 spreadsheets (or Excel2007–I’m not sure I’ve turned off Compatibility in either case). One is the Liblog2009 master spreadsheet, a biggie with thousands of page-to-page links and formulas. The other is simpler but uses a Vlookup to another page as a key element.

My first impression is that Calc is doing just fine with both of these, although it took a while to open the Liblog2009 one (it felt like more than a minute, but that might not be true). All the page-to-page references seem to be OK; all the formulas seem to be fine.

Will there be a ,2?

Unsure. I might experiment some more; I might not. I probably won’t play with Impress, because I so rarely use PowerPoint that I can’t really judge.

Overall? LibreOffice is one heck of a bargain, and it may be the only Office suite most people need (especially if you do more spreadsheets than template-based documents). But as a fully compatible Word equivalent…well, maybe that’s asking a lot, but the sheer unpredictability of what would and would not import correctly bothers me. A lot.

And if open source advocates say, “But that’s not it’s primary purpose!”…I’d agree. Note the first two sentences of the previous paragraph.

Fun with typography and Office2010

Posted in Technology and software on April 5th, 2011

Nothing earthshaking here, but a little fun for those who care about typefaces and typography and who don’t automatically sneer at me because I use Word instead of a Proper Desktop Publishing Program…

I knew Office2010 offered more sophisticated typographical options. At first, it seemed as though most of them (in Word2010) weren’t really available in any typeface I had; turns out I just needed to convert the documents from Word2007-compatible to native Word2010 (same .docx format, but more options). And, to be sure, needed appropriate typefaces.

For purposes that may eventually become obvious, I’ve been going through my collection of typefaces and identifying those that (a) are serif text faces that might be suitable for body text, (b) are likely to be on most computers with Windows7/Office2010 (and, for most of these, earlier Office and Windows versions as well). I determined (a) by inspection in the Word typeface (ok, sigh, “font”) pulldown and (b) by going to the Microsoft Typography site and seeing whether the typeface was in the list. (I still have a bunch of typefaces that came with Corel’s Bitstream-supplied 500-typeface CD, and the licensed copy of Berkeley that I paid for.)

I found 22 in all. Without arguing aesthetics (is Times New Roman too familiar? Are Georgia and Lucida Bright and Cambria too ‘screen-oriented’?), I divided them into five groups:

  1. Nine typeface families with good kerning (checking such pairs as To, Wa, Vo–“Vo” as in “Vortext” seems to be problematic in lots of cases) and complete families supplied (or at least Roman, Italic and Bold–you can bold an italic without too much damage, but slanting Roman is always strange).
  2. Two typeface families with somewhat inadequate kerning.
  3. Six typeface families with either no kerning or very inadequate kerning.
  4. Three singletons with good kerning.
  5. Two singletons with inadequate kerning or no kerning.

As I was preparing samples of each typeface, I decided to turn on many, if not all, of the advanced typography features, specifically all ligatures.

Wowser.

Oh, not most of the time–most of the typefaces didn’t show any ligatures in the sample I prepared.

But then there was Palatino Linotype (which, unfortunately, has incomplete kerning: specifically, the “Vo” combination in Roman and Bold has an awkwardly wide space, and the “To” isn’t great either).

But the ligatures…well, more than I’d really use in modern text (the Word Font/Advanced dialog box includes five choices for ligature usage, and “standard” is probably what you’d normally use, not “all”), but, well… And, for that matter, old-style numbers are available, although the default is lining numbers (unlike Constantia’s default old-style).

Here’s the paragraph I used. See what you get with your system. Apparently, Prof. Zapf had some fun when preparing this version. Now, if only the kerning was more complete…

The Quick Brown Fox Jumped Over the Lazy Dog. 1&2#3$4%5 6?7 “89”. Kerning: Wasted Torpid Florid florid offensive Vortex. The Quick Brown Fox Jumped Over the Lazy Dog. 1&2#3$4%5 6?7 “89”. Kerning: Wasted Torpid Florid Vortex. The Quick Brown Fox Jumped Over the Lazy Dog. 1&2#3$4%5 6?7 “89”. Kerning: Wasted Torpid Florid Vortex. Ours is a noble old house, and stretches a long way back into antiquity. The earliest ancestor the Twains have any record of was a friend of the family by the name of Higgins. [Mark Twain’s (Burlesque) Auto-Biography via Project Gutenberg]

 


Added at 2:05 p.m. April 5, 2011: Just for fun, I opened the same paragraph in LibreOffice (OpenOffice, basically) in Palatino Linotype. As anticipated, the ligatures are all gone–LibreOffice Text doesn’t have any of those advanced typographical features. On the other hand, the most egregious kerning problem (Vo) seems to be at least partly fixed, that is, it’s at least reasonably kerned. I find that very strange…mysterious, even.

Only amateurs…

Posted in Technology and software on March 30th, 2011

…use a spreadsheet for a database.

As I recall, that was a pretty popular opinion among the digerati a while back (maybe a LONG while back), regarding those who built databases with spreadsheets with the same derision you’d use for someone who uses word processing software to do calculations.

I keep track of Cites & Insights general themes–how recently they’ve appeared–and current segments (how long, status, etc.) with a one-page Word table, which includes a bottom-of-page running total of current wordcount. Why Word, not Excel? Because it’s convenient and it works. And, y’know, I don’t have to leave the program to update an item; just open the document.

Are there still people who believe this–that any proper database is built and maintained using a database program, that only amateurs and other idiots use Excel for databases?

I wonder. If so, they can just call me another technophobic idiot.

I’ve used a number of different databases over the years at home (and, of course, at work–SPIRES was/is one damn powerful database management system, easy to build new databases and with nearly unlimited power for old ones: I was sorry when we made the, I suppose, inevitable switch to a Proper Relational Database.). Hell, I’ve written database management systems using high-level programming tools…

And, well, today I just shut down the last database I was using at home, converting it to an Excel spreadsheet. Partly because I couldn’t seem to do the data validation in the LibreOffice version of the Access database that I wanted (and it was truly trivial to recreate the same validation in Excel–two minutes work at most), partly because, after fighting with LibreOffice’s report writer long enough to get a semi-workable report, I realized that the equivalent report would take, oh, 30 seconds to create in Excel (it’s just a pivot table with a heading).

And, now that it’s in Excel, I don’t have the field length limitations I had in Access (once you’ve defined a field length, that’s pretty much it). Or other limitations.

Oh, sure, at some point I could exceed the limitations of a single spreadsheet. But after my experiences with the massively complex spreadsheets for my liblog projects, I don’t see that point happening any time soon.

This is just a musing, I suppose, having to do with how times change. Yes, there are almost certainly home databases that Excel just can’t handle–but for lots of databases, it now strikes me as the preferable tool. I’m guessing the same is true for LibreOffice Spreadsheet.

This is another random musing of no lasting significance…

Two steps forward, one step sideways?

Posted in Stuff, Technology and software on March 29th, 2011

I rely on computers. I used to make my living from computers–as a systems analyst/designer/programmer. I still rely on computers for whatever little earned income I do have: Sure, I could write with a pen and notepad, but I wouldn’t even be able to read some of what I’d written, much less make it readily available to others.

That said…

It’s been a more interesting week than I’d really hoped for; I hope it’s settling down. These are all trivial little upsets and very much firstworldissues, but hey, this is a random blog.

Scene 1: The Toshiba comes unhinged

My wife has a Toshiba notebook that’s about 3.5 years old. She likes it just fine. Even when the case stopped closing fully, she lived with it. Until last Thursday, when the left hinge broke–that is, the screen section came out of the hinge. No way to get it back in.

The notebook still worked (and works), but that was clearly not a good sign, and from what little we could figure out, a fix would cost a little more than a new notebook.

So, after a little checking, off we went to Office Depot–not nearly as convenient as OfficeMax, but after my experience with the local OM not living up to its own promises, I’m not shopping there–so my wife could try out various notebooks, keyboard feel & touchpad characteristics being very important to her. Oh, and since the old notebook had a 14″ 4×3 screen, she probably needed a 17″ screen to get the same vertical resolution (since nearly all contemporary notebooks have 16×9 screens).

She found a unit that was to her liking–another Toshiba, as it happens, on sale at a really excellent price. That solved one outstanding issue: When she’d move from Vista to Windows 7. And, since I’d been ready to move to Office2010 soon anyway, it made sense to get Office2010 for both of us at the same time–there’s a new-machine discount, and OD offered to load her copy as a free extra.

Scene 2: I decide to upgrade to Office2010

My wife still hasn’t actually moved to the new notebook–she spends a lot of time on her primary online interest (Unclaimed Persons, a closed volunteer group currently using Facebook that assists coroners in locating next of kin for those who die without someone to claim the body: a great pursuit for a retired librarian!), and the weekend had various other issues. Maybe today; maybe tomorrow.

Meanwhile, I upgraded to Office2010. Which brought me up short on one thing. I was using Office2007, but still using Access2003, since I didn’t lay out the big bucks for the full Professional version of Office2007. (Remember when Office Pro was bundled with computers?) And, unlike Office2007, Office2010 just won’t install when it sees what it considers a damaged version of an earlier Office.

So…

Scene 3: Undoing Access and Finishing the Upgrade

I was really only using Access for two fairly simple little databases and one slightly more complex one–one for a summary budget of household expenses by major categories, one for a list of books & authors to use when getting books at the local PL (so I didn’t get the same title twice), and one–the slightly more complex one–a summary database of wines, helpful when shopping for new vintages.

None of these could possibly justify laying out the money for Access.

I exported the primary tables (two for Books, two for Expenses, three for Wines) as Excel spreadsheets, figuring I could work with those if necessary. And I thought OpenOffice–which I won’t use instead of Word, but which I had–might provide an acceptable substitute.

Then I deleted what was left of Office2003 and installed Office2010. (Unlike earlier versions, there’s no “upgrade version”–and, at some point, I think that’s sensible. When you’re upgrading from an upgraded version of an upgraded version…well, sooner or later, you’re not going to be able to prove you ever owned the original. I think my original was either Office2000 or OfficeXP.)

The install went fine. I haven’t explored the nuances of Word2010 and Excel2010 much yet; I do like the new File/Backstage replacement for the frankly failed “hide print & file options under an Office icon” button, and I’m aware that there are some interesting typographical options in Word if I actually had any OpenType typefaces with suitable extensions. (Oh, and having the Styles list display as a simple list instead of attempting to show the formatting: What a sensible step back!)

All in all, I think I’ll like it just fine. Later this week, maybe, I’ll explore a bit more to see what typefaces besides CalifornianFB have been added, whether I want to use them, and what else is new and interesting. (I accepted a default installation. I’m never sure whether that’s the right choice…)

Step 4: Trying to use OO Base as a Replacement for Access

Actually, that’s not quite right. I did do an initial attempt–creating .ODB files that link to the MSOffice .MDB files–and verified (a) that I could open all three databases, (b) that the reports had either disappeared or turned into tables, (c) that cross-table linkages had disappeared in the process.

Before attempting to resolve those issues, it was suggested that I switch from OpenOffice to LibreOffice. After discussing the reasoning, I concluded that just having less to do with Larry Ellison was reason enough, so I downloaded LibreOffice 3.3, deleted OpenOffice, and tried again.

Yesterday, despite some frustrations, I managed to build a report for the Expenses database that provides the same summary by category and grand total that’s the whole reason for having the database. It’s not as pretty and it was clunky to build, but it works. What I cannot get to work, so far at least: having the “category” column within the Expenses table limited to, and prompted by, values within the Expense Category table, a linkage that was in the Access database. Maybe it’s because this particular Base database is really acting as a connector to the .MDB database, but there seems to be no way to do this, at least within existing tables.

I can live with that, at least for this table.

Before lunch today, I made a typical every-three-weeks library run to take back three books and get three more–as usual, one non-genre fiction, one genre fiction (mystery this time, since it was SF/fantasy last), one nonfiction. For nonfiction, I’m cheating: the library had a book on OpenOffice 3. Aha! Maybe that will help.

Then came home and, after lunch, sat down to work on this. When I’d gone to put the computer in Sleep mode before running the errands and having lunch, I got a Windows Update, which meant shutting it down entirely. That’s OK.

Step 5: Something goes very wrong–fortunately, temporarily

Turned the computer back on. The background came up, as did all five items in the tray (W7 is much better than Vista in this regard), all six icons on the toolbar (some standard, some I’ve added), all 29 shortcuts and icons on the desktop (which I really should trim some day, but I guess 29 isn’t terrible).

Clicked on FireFox. The little circle spun for a couple of seconds. Then nothing. Did same for Windows2010. Same non-result. Well, let’s open TaskManager…whoops, same result.

Restarted the system. No luck.

Powered down. If it had come up one more time with the same results, I would have hit F10 during startup and gone to the previous restore point. Fortunately, the third time was the charm. Slowly, at first, programs came to life. Everything seems back to normal now. (Well, I haven’t tried *everything*–but if non-MS programs, MS contemporary programs, and 15-year old programs all work, chances are it’s good.)

So, then, taking the book in hand and trying to modify tables to use links…

No luck. Maybe I’m dense, maybe I’ll try again later, but so far, it looks as though compatibility with MSAccess databases is limited. That’s no great surprise.

In one case–the most complex database, probably not for very good reasons–it turned out to be most sensible to combine the exported Excel tables into a new and simpler Excel database, which–among other things–allows me to use typefaces I like while entering and updating data (I can’t see how to change LO Base’s table typography; again, maybe I’m missing something). In the case of the expense database, losing the category prompt list is a nuisance but not fatal. In the case of the books database–well, it never really amounted to anything anyway.

So there’s an afternoon pretty much shot, with no real progress…but hey, I could afford to waste an afternoon.

Step 6: Profit!

I know, that’s supposed to be Step 3 or Step 4, and in this case it’s nonsense–almost. If one proposed project is approved, I’ll need OpenOffice or LibreOffice, and I’m pleased to see that its import of Word files is a whole lot better than it used to be (last time I tried this, OO threw away major portions of style-based formatting).

Otherwise? Back to writing, browsing, being grumpy on FriendFeed, virtual slot poker, all that good stuff. And maybe reading the OO book in more detail and seeing what I’m missing. Which is probably that I can only *add* a new field that’s based on a set of values from another table, not *restore* a table linkage lost in the so-so “compatibility.”

Hmm. My Gateway notebook–my only computer, used as a two-screen setup with my old-but-beautiful Sony 19″ 4×3 LCD display–is probably 2.5 or 3 years old. Hope it holds up a little longer…

National Day of Unplugging: Count me out

Posted in Technology and software on March 4th, 2011

Today’s San Francisco Chronicle has a story on the National Day of Unplugging, which is from sundown today to sundown tomorrow (Saturday).

It’s in the Business section, with a big picture of Anne Wojcicki, cofounder of 23andme Inc. and Sergey Brin’s wife. Wojcicki “sometimes carries four cell phones, sleeps with a BlackBerry on her pillow and finds herself instant messaging people sitting next to her.”

The reporter seems to think that everyone is as addicted as she seems to be: “Consider how increasingly rare it is to get through a conversation or a meal without someone glancing at their phone.” Really? We took my brother & sister-in-law out to dinner last night (at a casual Italian place), the place was nearly full, and I don’t believe I saw one cell phone in use at any table in our vicinity–certainly not ours. Yes, I do see some people at some lunch places making a point of placing their phones on the table so they’re always in touch. I wouldn’t voluntarily dine or converse with these folks.

Wojcicki “hopes to institute the tradition weekly around the household” and says “It’s really about achieving balance and spending some time where you’re really just connected with the environment and the people around you.”

So during Sabbath (yes, the NDU was created by a group “focused on updating Jewish traditions to make them more relevant to modern life”) you’ll take 24 precious hours away from Your Precious in all its connecting glory. And think you’ve achieved balance?

I’m not having it. Oh, it’s quite likely that I won’t be on a cell phone between sundown tonight and sundown Saturday: That’s true most days. But I’ll almost certainly use email and FriendFeed and look at other online sources as appropriate. Never during a meal, to be sure, and never during a conversation, and not while we’re out enjoying the real world, and not when we’re watching TV, and not when I’m reading.

That’s called balance: making an appropriate place for interruptive technology and keeping it in its place. Period. Except for emergencies–and, you know, you’d be surprised how few true emergencies there are in most people’s lives.

Hey, if declaring a National Day gets that Blackberry off your pillow for one night, I guess that’s progress. But don’t tell me it’s balance, and don’t confuse taking an occasional timeout with achieving some form of sensible balance.

Real data on library use of social networks?

Posted in Libraries, Technology and software on January 18th, 2011

Here’s an honest question that may reflect my lack of intimate current knowledge of the formal library literature:

Has anyone studied the actual use of social networks by public libraries other than those with high-profile spokespeople/advocates? Better yet, has anyone done so on a scale broad enough to be anything more than anecdata?

I’m asking not because I assume the results would be “not much of any use” but, actually, the opposite: I’m beginning to suspect there’s a lot of real-world l0w-key adoption that we don’t hear about.

Why? Anecdata, of course. I was reducing the 16,000 words of Cites & Insights 11:2 to a 2,000-word Online column and found myself adding new material—and wondering what I’d find locally.

Just for fun, I thought I’d see what elements of 2.0 technologies I could locate at three well-used local public libraries—the one I use now and the two I used previously. None of these have high profiles nationally; all are reasonably but not lavishly funded; all are in a region where use of social networking and other “2.0” tools should be predictably high. All three communities are roughly the same size (70,000-75,000 population).

The library I use now, Livermore Public Library, has had the same director for more than two decades. She has a blog—but doesn’t use it all that often, with nine posts in the three years since it began. (One post speaks to the nonsense you hear sometimes from doomcryers about most people not wanting or using public library services: In a local survey, 81% of respondents reported using LPL—and they rated service quality at 79 on a 100-point scale, a very high result.) There’s also a teen blog—but it’s only had three posts in its one-year life. LPL also has a Facebook page with a fairly steady stream of updates on LPL programs (seven updates in the last two weeks) “liked” by 550 people and a Twitter feed with 172 followers, with 905 tweets to date. How many of those 172 followers are actual Livermore residents interested in library issues? That’s a tougher question. There’s also a mobile catalog, a version of LPL’s catalog stripped down to a bare all-text minimum. All in all, a reasonable showing for a library with high usage and budgetary problems that stem entirely from city budgetary problems.

Mountain View Public Library devotes most of a straightforward home page to a catalog search box and set of current events—but there’s also a “Social Networking” icon that leads to a surprising wealth of items, some oddly identified (e.g., the library’s blog is identified as Blogspot rather than by its name). The library blog appears to serve as the source of the home page’s center strip; it’s entirely official announcements and book reviews and has ten posts in the past 3.5 months. A Teen Blog began in April 2010 and had 45 posts during 2010. There’s also a Delicious page with the library’s bookmarks (189 in all), a Facebook page with 285 people Liking it and 15 items in the past month—and another TeenZone Facebook page with 37 people liking it, clear evidence of teen patron involvement but relatively few recent updates; a Flickr photostream with 93 photos; two Twitter streams, a general one having 311 followers (and itself following 169 other streams!) and a fairly steady stream of tweets and a much smaller teen stream (33 followers, 88 tweets); and—unusually—a Yelp link, where you’ll find 89 reviews for the library. (Based on those reviews, MVPL is doing quite a few things right!) All in all, an impressive showing.

Like Livermore, Redwood City Public Library has a slideshow current-even element on its home page which can be either great or annoying. The front page doesn’t link directly to any blogs—but does have Facebook and Twitter icons. The Facebook page has 295 people Liking it and four updates in the last two weeks; the Twitter stream has 124 followers and 123 tweets—four of them within the last two weeks. In fact, RCPL had one of the earliest public library blogs, Liblog, beginning in 2002—but its URL now links directly to the library’s home page.

Conclusion? All of these libraries are using social networks with varying effectiveness. None of them makes a big deal of their usage. That may be as it should be.

A little anecdote to close the year

Posted in Technology and software on December 31st, 2010

The story you are about to read is true. The names are not changed, since nobody here is guilty. This is a story about resourcefulness, panic and the little things the web really is good for–and that mean “death of the web” (as in “no searching, just destinations”) predictions are stupid.

The setup

As I’ve noted previously, when we bought our new/old house back in May 2009, we agreed to take the Samsung refrigerator that was already there and leave our not-very-old refrigerator in our old house, because the Samsung looked like it would meet our needs better and all three parties in the two transactions would win from this agreement.

The previous owners passed on most installation and user handbooks on most of the add-ons in the new house. The refrigerator was an exception: no manual.

The refrigerator–a bottom-freezer non-French-door unit–is reasonably basic: No water dispenser in the door, and if there is/was an icemaker, it’s not plumbed and doesn’t operate. That’s what we wanted. One high-tech feature: A panel on the freezer door that shows the temperature in the freezer and refrigerator and has some controls. We didn’t necessarily want that, but it couldn’t hurt. We left the settings at 2F freezer, 38F refrigerator.

One feature we didn’t realize at the time: The refrigerator was shallow by today’s standards, only about 27″ deep.

The panic

A couple of weeks ago, my wife heard a beeping from the refrigerator (two beeps, repeated every couple of minutes). I heard it too. She thought the refrigerator door might have been slightly ajar; we made sure it was fully closed.

The beeps continued. And there was no light when we opened the door.

Then we noticed that the refrigerator temperature was creeping up, to 39, then to 40, then to 41…

Arggh. We’d just bought $20 worth of organic chicken breasts, there was $35 worth of salmon in the freezer, plus all the usual refrigerated and frozen foods…

We called the local appliance store that we’ve already learned to trust. They said “Samsung? We don’t repair Samsung: It’s impossible to get parts.” They also gave us the 1-800 number for a national agency that does repair Samsung refrigerators. Called that number; they said it would be $75 to come out and provide an estimate, plus the actual cost of repair, and the earliest they could send somebody out was the following afternoon. We didn’t schedule an appointment…

Called my brother (who’s lived in our new hometown for 50+ years) to see whether he might have a dorm refrigerator he could lend us, which would let us keep the most vital stuff chilled while we worked out a replacement. Otherwise, we thought, we might have to go buy one… We thought the old one was about 8 years old, in which case a newer one might use less power…although the old one did have an EnergyStar mark, those standards change over time.

Turned out he actually had a brand-new 10cf. refrigerator/freezer, purchased for the expansion to his house that’s going on (which includes a kitchenette). He was able to bring it over (with help from a friend); we found a place for it and plugged it in to start chilling. By now, the refrigerator was up to 45 or higher (but the freezer was still at 2F, which told us *something*–namely, that the compressor was working, but the fan to distribute cold air to the refrigerator wasn’t).

We moved food into the smaller unit (after it was cold enough to do so) and went over to the appliance store to see what a new refrigerator/freezer would cost and how soon we could get one delivered. (We’d also seen the mfr. plate on the Samsung and realized it was six years old, not eight years–so it should have another 8-10 years ahead of it.) After some discussion (with great people at the store, who don’t work on commission), we found:

  • We’d have trouble buying a new unit that would fit: The unit’s in an open area that’s about 30″ deep–and with any of the regular new units, that would result in the door handle being at least 5″-8″ out from the framed area, so far out that it would impede traffic into the kitchen and look really terrible. We could go for a “cabinet unit,” but those cost a fortune ($2,500 and up), you’re pretty much obliged to get a side-by-side with the door icemaker/water dispenser we really don’t want, and the vegetable bins are relatively small–significant because my wife gets a large quantity of vegetables once a week at the farmer’s market.
  • The salesperson suggested unplugging the unit, letting it sit for 15-20 minutes, and plugging it back in, on the possibility that something in the electronics might be off and would reset itself.

The process

We went home and tried that. It didn’t work.

But my wife, the expert reference librarian (and former library director–unlike me, she does have an MLS), did some careful searching online, while I did some clumsy searching. I managed to find the manual for the Samsung (online), and found that the only alarm was an open-door alarm. Aha! Apparently the refrigerator was convinced that the refrigerator door was open–and possibly had stopped supplying cold air because, you know, what’s the point?

My wife found a chat room where, it turned out, a number of other people had had a similar problem–and one of them had found a possible solution. Namely, that the problem was the door sensor, one of two plunger switches on a little panel next to the hinges (one plunger for the refrigerator door, one for the freezer). This person also said how you could remove the panel–and that, with the switches unplugged, the Samsung would default to “doors are closed” instead of the “door is open” it was reading.

What could it hurt?

Before we called the national agency back, we tried it. A flathead screwdriver did pop off the little panel, and–with some strain–we could remove the little harness that plugged into the back of the panel. We did so, closed the doors again, plugged in the refrigerator, and…

It worked. Oh, no lights, to be sure, since those are turned on and off by the same door sensor, but the refrigerator started cooling back down.

The follow-up

OK, so we had it working, sort of…but it made sense to replace the door sensors, sooner or later. Would we have to pay $75+ to do that?

More searching…

Samsung doesn’t offer parts on its website, at least not the public-facing part. But there was another site, Samsungparts.com….

The part was $11.95. Including shipping and handling, it was about $21 total (the company has a physical presence in California, so 9.75% sales tax was part of the deal).

I ordered the part.

About a week later, I realized that I didn’t really know much about Samsungparts.com. Oh, sure, the ordering process was over an https:// secure link, and they had credit-card authorization, but how much does that really tell you? We’d had one credit card replaced last year due to fraud (caught by the credit-card company), and changing the numbers on autopay setups is always a hassle…

I checked the credit card account online: Not only wasn’t there some big unexpected charge, the $21 or so hadn’t even been charged yet.

Perhaps another week later, I got email: The part had been backordered, but had now shipped. The email included a tracking number (USPS Priority Mail). The source address also included a parent company I thought I’d heard of (but I was probably wrong: it’s a very small company). The credit card charge showed up the next day: the company didn’t charge until the part was shipped. Score one.

Three-four days later, the box arrived. We rolled out the refrigerator, unplugged it, fished out the wiring harness, plugged it in to the new switch/sensor panel (which could only be done one way, fortunately), pushed the new panel into place, closed the door, waited 15 minutes, plugged it in…

And we once again have lights when the doors are open, along with proper refrigeration. For a total repair cost of $21, not, say, $95 or so…

The morals

  1. The web is a great place to find missing owner’s manuals. We already knew that.
  2. With a lot of luck and some skillful searching, the web can be a good place to diagnose and repair odd problems–although it can also be a dangerous place to do so. (In this case, there were enough people who’d had the same problem and found the same solution, or took the advice, that we were reasonably confident.)
  3. The web allows small companies to have big presences, and for third parties to step in when a manufacturer’s not willing to deal directly with consumers. (Samsung doesn’t appear to sell parts to individuals. The third-party company appears to be a tiny three-person operation, a true small business–but they’re a national supplier with a solid web presence.)
  4. On the other hand: If the refrigerator wasn’t too smart for its own good, we would have had a soft failure: Failure of a door sensor wouldn’t cause the refrigerator to stop operating. Funny thing: If your car’s “check for malfunction” light comes on, the engine doesn’t stop operating.
  5. On the other hand: There is no way in hell that a refrigerator door sensor should fail after six years. It’s a push-down switch, a trivially simple part, and given that the design makes it critical to the operation of the refrigerator…

Objectively, you could look at this and say “Why didn’t you find out about the problem before you went to all the trouble of finding a temporary refrigerator, two people having to bring it over, two people having to take it back…?”

Because the thought of spoiling food (did I mention that this happened within two hours after grocery shopping?) tends to push one towards immediate action, not screwing around on the web for a couple of hours.

Happy New Year’s, and may your refrigerator door sensors all work well.


This blog is protected by dr Dave\\\\\\\'s Spam Karma 2: 105174 Spams eaten and counting...