Importing bookmarks: timedate conversion problem

Users asking other users for import filters.
Post Reply
jeremydouglass
Posts: 33
Joined: Wed Feb 15, 2006 10:06 am

Importing bookmarks: timedate conversion problem

Post by jeremydouglass »

I recently converted the ~700 or so bookmark citations I was keeping in Del.icio.us (the online bookmarking service) to a Bookends Tab Delimited file - I'm trying to figure out how to convert the viewed dates.

Del.icio.us outputs a file designed for import by web browsers such as Firefox or Safari. An example entry looks like this:

<DT><A href="http://ludology.org/article.php?story=2004022508012250" add_date="1142366006" last_modified="1142366006" tags="IF news researcher">What Ever Happened to Mary Ann Buckles? (Gonzalo Frasca. Ludology.org. 2004-02-25)</A>
</DT><DD>A call for and response from Mary Ann Buckles, coming out after years apart from her dissertation ...
(tags: IF news researcher)
</DD>

Once I was done massaging the data, this left me with an Access Date (User3) column, part of which looks like this:

1142366006
1130012018
1129975254
1129867887
1119528805
1090894441

I believe that these are time in seconds, however I'm not sure and I can't find a function in Excel to convert it. I tried importing it as-is but it got copied in raw. Anyone have any suggestions?
Post Reply