The following are Mac ONLY applescripts that I have written that I think would be useful to others. They are issued as donationware, meaning that if you like them, I would appreciate you sending a buck or two via paypal to silverst@orthonj.com.

Renumber Scans: Click here to get the text of the script. Copy the text and paste it into the script editor. You can then save it as an application, put it in a dock, etc. You can also click here to download the script directly.

Description: This script is for those of us who have scanners with a document feeder, but the document feeder can only scan 1 side of a double sided page at a time. This script will set the names of scanned files to the correct order after scanning side one of a packet, then side two of a packet. Script by Bob Silverstein - silverst@orthonj.com. This is provided as donation-ware. If you find it useful, please donate what you think it is worth to my paypal account using the above email address.

Put the document packet to be scanned in the document feeder and scan it (first page on top). Remove the packet from the output bin and put it back into the document feeder with the last page on top. (You will now be scanning the last page first, and the first page of the document will be face down on the bottom of the pile. If the last page is blank or you don't want whatever is on the last page to be part of the document, remove this page from the top of the pile and don't scan it). After scanning is complete, move the files to be renumbered into an empty folder (nothing else is in that folder besides the files to be renumbered). Then open the window of this folder and make sure it is the front-most window. Make sure the list is sorted by name in ascending order. Then launch this script. The list of files can now be dragged and dropped onto Acrobat's icon (note that this is the application that can create PDFs, not the reader) and made into a single document in the correct page order. Note that if you want acrobat to combine all of the pages into a single document and the documents are all PDFs, this drag and drop method will not work; Acrobat will just open all of the documents rather than combining them. If you want acrobat to be able to combine them, set your scanner software to save the files as TIFFs or JPEGs.


 

Convert qif to iif (Quicken to Quickbooks): Click here to get the text of the script. Copy the text and paste it into the script editor. You can then save it as an application, put it in a dock, etc or just run it from AppleScirpt Editor like I do. You can also click here to download the script directly. Please note that I am just making this available out of the kindness of my heart. I am not a programmer; I am a full time practicing orthodontist, and probably don't have time to troubleshoot problems for you (especially when I am not earning any money on this). This is provided as an applescript and not a Mac application, and you need to have a basic understanding of Applescript in order for this to make sense to you.

Description:

As of January, 2001, there are only 2 proported options to convert qif files that you would download from your bank or credit card company's web site into iif files (Quickbooks file format): SimplyConvert IIF Converter, which I have never been able to get to work successfully (Quickbooks 2010 for the Mac can see the iif file to import it, but when the file is selected for importing, nothing gets imported), and add-ons for Excel (like this one or this one) which only work in Excel 2004. I was using the one from Big Red Consulting for years, and I was hopeful that with the return of macros in Office 2011, that I could finally delete Office 2004 from my computer to save some space. No such luck. Although Microsoft supposedly re-enabled macros, they changed enough of the syntax that the add-ons do not create files that Quickbooks can successfully import. A rep at Big Red Consulting told me that there are enough problems with the Office 2011 macro implementation that they were going to wait until Microsoft fixed these. Rather than continue to keep Excel 2004, I figured out how to do the conversion myself via applescript. Instructions on how to use the script itself and modify it to fit your situation are commented out in the code (the gray text after you compile the script by clicking the "Compile" icon in the upper left of AppleScript Editor. Once you download the script, unzip it, and double click on it, it will open AppleScript Editor.

Notes: