Transfering Google-synced iPad Notes between accounts

The short path to transferring iPad Notes between Google accounts:

  1. Create a Notes label in your new Gmail
  2. Connect the old and new Gmail to a mail client that allows multiple accounts and transferring messages between them
  3. Transfer all messages in the old Gmail’s Notes folder to the new Gmail’s Notes folder (Gmail labels are manifested as folders in Evolution)
  4. Turn off Notes sync with the old Google account on the iPad
  5. Turn on Notes sync with the new Google account

The longer tale

The iPad Notes application has the ability to sync your notes to Google, Yahoo and other accounts, along with iCloud. While dealing with the ramifications of changing to a new primary Google account, I needed to get all my notes moved over. During this process, I learned some interesting things about Notes and Gmail in particular.

Line-wise diffs only

When you sync your iPad notes with a Google account, notes appear as email messages with a newly created label applied called “Notes”. While the view on the iPad is a continuous document, modifications to notes actually show up as new messages in the same conversation under the Notes label. This provides the perk of a primitive diff view for your notes since the changes are shown in a different color.

Update: After some additional testing, I cannot discern the pattern of how these notes are updated as messages in Gmail. I have several that definitely show diffs and threaded conversations as evidenced by the image above (purple text was the first form; black was the most recent update). But this next test shows no such markup or evidence of what were definitely multiple messages:

Test synced note showing no signs of diffs or multiple messages despite the disparate update times...

Nice-to-have optional features aside, seeing as these notes are nothing more than emails with an intuitive label, transferring them to a new Google account got pretty simple. First though, I was unhappily reminded that Gmail does not allow you to forward more than one message at a time. To get around this, I set up both Gmail accounts within the desktop Evolution client. Then it was simply a matter of going to the old Notes folder, selecting all, Copy to Folder, navigate to the new account’s Notes folder, done. Be aware that you should first create a Notes label in the new Gmail account since it won’t exist before you sync notes from an iPad with the account. (And while we are on that topic, be aware that you have to quit and restart Evolution for it to pick up new folders.)

Posted in Apple, Desktop, Google, Linux, Mobile | Leave a comment

Handy Excel Tip: Open workbook in new instance

I’ve written before about using Excel for some remote data collection and analysis tasks. One thing that often annoyed me in such situations was the inability to utilize multiple monitors. Whenever I wanted to break out a sheet, or especially when opening a new workbook, I found there is no way in default Excel to open the item in a new instance. It would always open in the same window, severely limiting potentially useful layout arrangements.

As is unfortunately common with Windows improvements… there’s a registry modification to solve it. All credit goes to OnlineTechTips: this article got me fixed up quickly.

Basically you just download a zip file, extract the contents, and rename the file whose title indicates the behavior you’d like in place. After this you just double click to run the file. This is a very convenient way to provide a fix, much easier than following descriptions of where in the registry tree to find what entries and what values to set them as. One of them even adds the option to open in a new Excel window to the right click context menu.

Posted in Desktop, Office | Tagged , , , , | 1 Comment

Charlie Sheen is a long way from philosophy– but the journey is winning

After reading about an interesting phenomenon witnessed in a cartoon by Randall xkcd I decided to see how true it was that you could get to Philosophy from most any Wikipedia term via a reasonable number of clicks (here the devil waits, no doubt). The principle:

If you take any article, click on the first link in the article text not in parentheses or italics, and then repeat, you will eventually end up at “Philosophy”.

Being a good citizen of the Internet I started my search with the article on Charlie Sheen, hopeful that I was a mere two or three hops from my beloved Ivory Tower description. The truth, it turns out, is far more amusing. Follow the clicktrain:

  • Step 1: Charlie sheen -> Martin sheen -> Stage name -> Pseudonym -> Name ->
  • Step 6: Noun -> Linguistics -> Human -> Taxonomically -> Science ->
  • Step 11: Knowledge -> Facts -> Information -> Finite -> Mathematics ->
  • Step 16: Quantity -> Property -> Modern philosophy ->
  • Step 19. Philosophy

Now of course I have to write a script to facilitate exploring distances between terms in Wikipedia. After more important projects…

Posted in Amusing, Web Applications | Tagged , | Leave a comment

Show all available documents to new Google Apps – Docs users

At my job we use Google Docs (via Google Apps) for internal collaborative documents and archives. One big issue with this platform is that when new folks are hired/given accounts and they go to view “All documents”– lo, and behold! it is empty. That’s right, if you go to “All items” and select Visibility -> YOURCOMPANY under More options as the filter, you will still only get “No items matched your selections”. This despite there potentially being thousands of documents that should fit your criterion.
Continue reading

Posted in Web Applications | Tagged , , | Leave a comment

Bag of useful Bash aliases and functions

Here are a number of assorted aliases and functions for Bash that I’ve made in the last few months and found to be useful. Enjoy!
Continue reading

Posted in CLI | Tagged , , , | 7 Comments