Comparing text in Excel

I know I'll probably forget this, but maybe I'll remember that I put it on my blog. :)  

To help me check Tiffany's work, I'm pasting the data from FM and the data that was given to her  into one Excel spreadsheet.  To verify that all is good, I put them in the same order and then put something like this formula in another cell:

=exact(A2,D2)

That leaves a True or False in the field, so I can just search for false. :)

Hiding the menubar on Safari

Safari lost it's "hide menubar" preference, so I had to add it again. I have to do this so I can minimize windows when I remote desktop to my work computer through Citrix.

I added this (in alphabetical order, after LSUManagement...) to the info.plist file (without the quotes and spaces):
"< "key" >LSUIPresentationMode< /key >
< "integer" >4< /integer >"

To get to the info.plist, I right-clicked on the Safari app, clicked on "Show Package Contents" and then found the info.plist file.

Gallery, etc...

I finally got around to figuring out Gallery 2. I reloaded it on my webspace, since I didn't remember what I had done or hadn't done.

The reason I did this is because I'm taking a lot of daylily pictures now, and when I email them to my mom, not only is it slow for her to get them, but there's some weird setting in her Outlook that makes the pictures take up about 4 screens worth of real estate. So she sees like one petal at a time. So I set up Gallery at blairbrown.org, and everything is good except for the massive file sizes that my camera puts out. Anything over 1M doesn't work, and really, it doesn't need to be larger than that anyway, since I don't want to fill EPB's server with pictures. So I found a nifty tip here to create an AppleScript to resize files that I drag to the program, which I called ResizePhotos. When it's done, there are files in whichever folder the files originally came from that are prepended with "scaled." So I can sort and drag them to Fetch, and then "Upload from Server" in Gallery and they're all there! Of course, then I have to give them pretty names, but it's way better than not being able to upload them!

Currently, I've got the resize program's target_width set to 800, which makes the files just over 100k!

parent paths

When I moved servicesystems, I got this error on one of their ASP pages:
Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/shop/Default.asp, line 17

The Include file '../includes/setup.asp' cannot contain '..' to indicate the parent directory.


The solution is to enable parent paths per
http://support.microsoft.com/kb/226474