Over the years I’ve accumulated more than 1,000 links in http://delicious.com/smithjd.   Delicious (in its various versions) was my preferred tool  for storing,  retrieving, and sharing bookmarks.  Far better than bookmarking things in a browser.  But I’ve gotten impatient with the delicious browser widget in Chrome (and the website was just too much overhead) so I decided to move all my links to Evernote.  The Evernote web clipper widget is easier to use, it pick up chunks of text and images, and it puts them in the same searchable place as bibliographic citations, written notes of all kinds, etc.   Perhaps most importantly, Evernote is available on my desktop, on a laptop machine I use when traveling, on a tablet and on my phone. And the search function is great.

But how to move those 1,000 links I’ve accumulated over the years?  Should I just forget and start over?  Delicious does provide an easy way to put all the links and the comments that go with them in one big file that you can copy-paste into an Evernote note. Unfortunately, the tags would all be lost!  I spent a lot of time looking around for ways to import individual notes with their tags, including various attempts to use DR.PALANIRAJA’s blog posting Import Delicious bookmarks to Evernote including tags and an attempt to create an Evernote XML backup file.  I couldn’t get anything to work and it looked like Evernote had abandoned an import method that was supported at one time. After some mucking around, I ended up downloading an XML file, processed it in OpenRefine, and sent  each link to Evernote in an individual email from a Google Spread-sheet.  I thought I’d share the details of how I ended up doing it.

To do this, you start by inserting your username and password into this URL:

• https://USERNAME:PASSWORD@api.del.icio.us/v1/posts/all

That gives you something like this:

Here is one post:

<post description=”Manufacturing Miracles”
extended=”By Horace Dediu, Asymco, Are wars the only means to motivate a society to boost manufacturing? Uxing Pixxa Perspective player on the iPad — an interesting statistical display machine.”
hash=”cd330643d37cbc870b9e4ac9cbe341e7″  href=”http://pixxa.com/pub/asymco/story/e8h9XtEr.html”
private=”no”
shared=”yes”
tag=”free ipad statistics”
time=”2013-02-07T05:53:52Z”/>

One thousand of those is a bit daunting, but OpenRefine, one of my favorite tools for wrangling data, has no trouble creating a project by opening an XML file. You end up with columns in your refine project containing the following information:

• time-date
• hash (discard this)
• href – the URL
• shared & private (which are the inverse of each other and which I discarded)
• description (basically the title of a post)
• tag (the guts of the whole thing)
• extended (more information on the post)

Use Refine to clean things up so that eventually you end up with a Google spread-sheet with columns that contain columns labeled href, description, tag, and an extended description:

Consulting Evernote’s blog on the format for the emailed notes set me up to write a Google Script that would send one email for each row:

function sendEmails() {
// building off tutorial code at https://developers.google.com/apps-script/articles/sending_emails
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 189; // Number of rows to process
// Fetch the range of cells A2:B3
var dataRange = sheet.getRange(startRow, 1, numRows, 4)
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (i in data) {
var row = data[i];
var emailAddress = "your-evernote-address@m.evernote.com";
var subject = row[1] + " @ test" + row[2];
var message = row[0] + 'n n' + row[3];
MailApp.sendEmail(emailAddress, subject, message);
}
}
You can’t send all 1,000 emails at once, as I found out.  After trying to do so, I got an email message back from Evernote saying that most of them had been rejected, although some worked very nicely.  I figured there must be a limit on the number of emails, and indeed Evernote’s helpful folks responded with:

So I send 250 mail messages a day for a few days.  The notes with information from Delicious aren’t all as beautiful as I’d like, but they have all the information I want.  I’m finding that Evernote makes it really easy to consolidate and clean up my my tags, which now apply to URLs as well as everything else!