Palm to iPod (iPhone) Memo Migration: Notes+


The Palm “Memo” app is much better than the built-in iPhone “Notes” app, except for the small matter of PalmOS being discontinued. My requirements for the iPhone “Memo” app replacement:

  • Categories – or “folders”, or “tags”, or whatever. Single-tags is sufficient, multiple tags per memo is not required.
  • Per-note password protection. The Palm “Memo” app allows for individual notes to be password-protected so that one doesn’t have to password-lock the entire iPhone.
  • No cloud-service requirement. The existence of personal data in the Palm Memos makes synchronizing with a cloud service a deal-breaker. Notably, this excludes Google Docs (popular with many apps) and the apparently-popular EverNote, Notespark, and Appigo/Toodledo.com apps.
  • Data Portability. I need to import 400+ memos from my Palm.

The app I settled on is called Notes+, which at $1.99 on iTunes is very reasonably priced compared to other apps. Aside from meeting all of the above requirements, it features a freely-downloadable companion desktop application (a super-stripped-down Palm Desktop “Memo” application) which can synchronize with the iPhone, and, most importantly, stores its data in a very developer-friendly SQLite3 database.

Palm Memo notes can be exported by Palm Desktop 6.2 as a CSV file.

I wrote memo2notes.py to read this CSV file and put its contents into the Notes+ SQLite3 database. Finally, I synchronized the desktop app contents into the iPhone.

The Notes+ app itself is fine; I only have a few small complaints:

  • Category navigation is not as good as in the Palm app. It has the same “category” button at the top of the screen. On the Palm, tapping this button yielded a dropdown for category selection (either to change the browsed category, or for changing the category of the viewed memo). However, in Notes+, clicking this button brings up a category chooser at the bottom of the screen, requiring that the finger move from the top of the screen to the bottom of the screen.
  • The index of notes doesn’t use screen real estate as efficiently as in the Palm. In the Palm, the index view uses a single row of text per note. In Notes+, each note in the index takes up two rows: the subject (just like in Palm), and a second row for the note’s category. This is somewhat understandable because having only a single row would make things difficult to hit with a finger (since iPhone users don’t typically uses styluses). But it would have been nice to have a single-row option.
  • Starting up the app is delayed with a splash screen. It looks nice, but it gets in the way, and is seems gratuitous. The app is already paid for, it’s not like this is a free app trying to upsell you to a paid app, or showing some advertising.
  • On Windows, the desktop app doesn’t minimize into the system tray; it takes up Taskbar space. It is nice that you can leave this app running so that the iPhone can back up its data without having to be plugged into iTunes. Unfortunately for Linux geeks like me, there is no “headless” non-GUI version of this app.

Other Palm refugees will hopefully find this tool helpful.

Donate

(I am not affiliated in any way with SEPV Corporation, just a satisfied customer.)

  1. #1 by Jerry Freilich on Tue Jul 27, 2010 - 9:43 pm

    Your pathway here is more elegant than 100 others posted on the web. But does Notes+ have any way to take in vCards in the absence of your neato Linux script? I’m a Mac user. Is there a way I can make this work?

  2. #2 by Todd on Tue Aug 3, 2010 - 7:31 pm

    I am very interested in importing Palm memo’s into Notes+.
    The Palm Desktop only allows exporting in Tab & Return format.
    I my Palm Desktop version too old?
    I am using a Mac, and do not know how to use your script.
    I only have about 100 memo’s to import, so copy & paste would not be too bad, if necessary.
    Any help would be appreciated.

    Thanks,

    Todd

  3. #3 by jr on Fri May 27, 2011 - 5:49 am

    Thanks v much for your well-documented solution.

    I tried applying it to converting from my PalmV to my iPhone 3GS and the python script crashes.

    I think it is because of differences in format of the csv file between Palm Desktop 6.2 as documented and the version I had to install: Palm Desktop 4.1.4.

    I had to use 4.1.4 to be comnpatible with my Palm V.
    I tried Palm Desktop 6.2 and it couldn’t see any of the contents of my Palm V.

    I would be very grateful if you could provide a version of your python script that worked with the format of the csv file exported from Palm Desktop 4.1.4

    Thanks a lot,
    jr

  4. #4 by jr on Fri May 27, 2011 - 6:00 am

    In regards to my previous post, this is the error produced when running the pythin script:

    Traceback (most recent call last):
    File “./memo2notes.py”, line 241, in
    sys.exit(main())
    File “./memo2notes.py”, line 228, in main
    rc = convert(inputf, cursor, options)
    File “./memo2notes.py”, line 172, in convert
    categories = getCategories(cursor)
    File “./memo2notes.py”, line 65, in getCategories
    ”’)
    sqlite3.OperationalError: no such table: categories

    Thanks again,
    jr

  5. #5 by jr on Fri May 27, 2011 - 6:24 am

    In regards to my previous post, the version of python is 2.6.5 under cygwin

  6. #6 by DL on Sun Nov 20, 2011 - 12:25 pm

    One caveat: Notes+ supports a maximum of 4096 notes. When I tried to import 4400+ notes, the import failed with an error instructing the user to delete “some” notes. Unfortunately, the error does not disclose the maximum supported number of notes. Therefore, I hope my experimentation and subsequent success helps others looking to import large numbers of memos into iOS.

    Thanks for your fantastic legwork and python script. I had to tweak the python script, after which I was able to import successfully from Palm Desktop 6.2.2 by ACCESS. Aside from the 4096-note limit and tweaking, this worked fantastically. Very helpful!!

  7. #7 by DL on Sun Nov 20, 2011 - 12:31 pm

    DL :
    When I tried to import 4400+ notes, the import failed with an error instructing the user to delete “some” notes. Unfortunately, the error does not disclose the maximum supported number of notes. Therefore, I hope my experimentation and subsequent success helps others looking to import large numbers of memos into iOS.

    Sorry, this comment should have said that the SYNCHRONIZATION (from Notes+ on the computer to the Notes+ app on iOS) failed. The IMPORT (using the python script) worked great (after manually tweaking the script).

(will not be published)