Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I am using Mountain Lion (OS X 10.8). I have a lot of stickies, but have been unable to find a simple way to export all the stickies at once as either text or HTML.

Have I overlooked something obvious? What is the right way to export all stickies in bulk into a more open file format?

share|improve this question
1  
All stickies are stored in ~/Library/Preferences/widget-com.apple.widget.stickies.plist and could be extracted from there. –  patrix Aug 5 '12 at 15:13
    
@patrix They are in a database format; there is no obvious way to extract the stickies to text and/or HTML from the native format of the stickies database. –  CodeGnome Aug 5 '12 at 15:27
    
Err, I just realized that there are different apps for Stickies. One is a Dashboard widget, the other one a "real" application. Which one are you talking about? –  patrix Aug 6 '12 at 17:10
add comment

2 Answers

Export stickies created by Stickies.app

  1. Install Notational Velocity (NV) and start the application
  2. In Finder open your Library folder and locate StickiesDatabase
  3. Drag StickiesDatabase into the 'Filtered Note List' in the NV main window (see here for reference)
  4. In NV select any number of notes and choose Export from the menu

If you prefer to write your own code, have a look at Learning Cocoa with Objective-C which explains how to reverse-engineer the StickiesDatabase format.

Export Dashboard stickies

Run this in Terminal.app

plutil -convert json -r -o - ~/Library/Preferences/widget-com.apple.widget.stickies.plist |
    awk '$1 ~ /-data/ { start=index($0, ":")+3
                        end=length($0)-2
                        sticky=substr($0, start, end-start+1)
                        gsub(/<.?.?div>/, "", sticky)
                        gsub(/<br>/, "\n", sticky)
                        print sticky
                        print "---" }' > ~/all-my-stickies.txt
share|improve this answer
    
This program worked great in Mountain Lion. Now I have to figure out how to import the files into Notes. Thanks, Jim –  user58687 Oct 3 '13 at 18:21
add comment

Below is a modified version of this script. It exports your stickies into separate txt files.

osascript <<'APPLESCRIPT'

set theName to ""
set i to 0
set n to {}
set L to {}

# prompt for output dir
set destFldr to (choose folder with prompt "Choose a destination folder:") as text
# hardcode output dir
#set destFldr to "/path/to/export/to/" as text
set mydestFldr to POSIX path of destFldr

tell application "Stickies"
    activate
    tell application "System Events"
        tell application process "Stickies"
            set L to name of every window
            try
                repeat with awindow in L
                    set m to value of text area 1 of scroll area 1 of window awindow
                    set i to i + 1
                    set theName to "stickies" & "_" & i & ".txt" as string
                    set theFile to mydestFldr & theName
                    do shell script "/bin/echo " & quoted form of m & " > " & quoted form of theFile
                end repeat
            end try
        end tell
    end tell
    # display dialog "done"
    tell application "Finder"
        activate
        open destFldr
    end tell
end tell
APPLESCRIPT

Note that this will only grab all the stickies from the current Mac 'Space'.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.