Unix Timestamp

A quick entry: It’s getting late, and I teach in the morning, then spend two hours in the WC, and after that, a meeting. Plus, I just looked out the window, and it appears that we live in the snowy part of Syracuse, so chances are I’ll have to remember where I last took off my winter boots back when last it snowed in, what, May?

This weekend I stumbled onto a few limitations for Movable Type and Delicious mash-ups I’d been thinking about for some time.

I’d been plotting for a few weeks a plan to export all 1000-some entries from EWM into a standard bookmark format. After the export, I was going to upload the full index (complete with keywords, notes, and timestamps) to Delicious. Easy, yeah? I thought so. But the problem is that I can’t–yet–figure out how to get MT to output a date in epoch form (i.e., as a Unix timestamp). I even posted on the forums, and the question has had several views, but no answers. MT has a gob of other MTEntryDate output options, but no Unix timestamp.

Without getting into the MySQL (and risking a terrible MesSQL), the most obvious workaround is to output the list of entries and such into a simple list that, with some “text to column” magic in Excel would allow me to select and copy the dates from a long string of entries, run them through a batch converter, paste the epoch-formatted numbers back into place, and switch the text into an editor. It might still require a few search and replace actions, but this process would get it close to the standard bookmark format–close enough that Delicious could import the list, anyway. And that’s the point to all of this.

While I was messing around with this, I also learned that Delicious limits the earliest timestamps to 1989 or something. I guess this isn’t all that big of a deal, but it does introduce a problem if, say, we were ever to attempt to use Delicious with some sort of date-stamping method for chronologically ordering bookmarks for a journal archive dating back to the early 1980s.

It’s good to know about these limitations, I suppose, well in advance of experimenting with them on a larger, more consequential project.