Also in this section:
Web Development: Applescript
10/13/2004 Applescript: Harry N. Abrams, Inc.

Harry N. Abrams, Inc. has moved to a new way of tracking its data internally, and the Filemaker Pro database they're now using on their network outputs files that are rather different from Excel, which they had used. As these files are the source of the website's data, I've had to make sure that they play well with the Web--special characters are translated, invisible characters deleted or translated as necessary, etc. The best way to clean this up is to clean it before it leaves their environment, and the technology of choice there is good old Applescript. I coded up a droplet for this, so now all they have to do is drop the export file on it, and a few seconds later, the file is ready for upload. It was nice to work in Applescript again.