Category Archives: Apple

SQL For Fun: Parsing the iTunes XML

What happens if one part of your personality is data-parsing nerd and another part is music lover nerd? You end up trying to answer questions like, “Which songs did I have rated with 4 stars last year that are lower … Continue reading

Posted in Apple, iTunes, MS SQL, Transact SQL | Leave a comment

Take Control of Mac File Paths

Since I added a Mac to my repertoire of workstations, I’m getting better and better about finding quick and easy ways to get around. Sooner or later, I’ll be just as efficient on my Mac as I am on my … Continue reading

Posted in Apple, OS X | Tagged , , , , , | Leave a comment

Applescript Calling Shellscript to run Software that Calls Other Software – A Path Odessey

Since my previous adventure with Applescript, I made a few tweaks, and then I got hung up on a bigger problem. I did a lot of googling, and while I found cases of my problem, I never found an answer … Continue reading

Posted in Apple, Applescript | Tagged , , , , , , , , | Leave a comment

My First Applescript: Intelligent Photo Renaming

Before a week ago, the most time I’d spent on a mac was just playing around in the Apple store, while waiting for a Genius Bar kid to confirm that my salt-water soaked phone was indeed ready for the electronics … Continue reading

Posted in Apple, Applescript | Tagged , , , , , , | Leave a comment