Convert Bento Library to Filemaker Database

I came across this app while looking for alternatives to FileMaker's very limited Bento product: FmPro Migrator 4.36.

It will convert a SQLite Bento Library into a FileMaker database - versions 7-9.

Sounds quite interesting and worth remember ...

Not exactly what I want just yet -- I want to be able to access my OS X PIM data (address book, calendar, tasks) from FileMaker.

Still looking for that solution ...

Windows Search 4 broken by recent update causing MDAC corruption

My XP box index is complete, but Windows Search 4.0 returns nothing. The Event Viewer has no interesting Windows Search Service events; the indexer seems happy, but the search isn’t working. Rebooting didn’t help.

On any search I get "Nothing found in All Locations for query ...".

The only hints I could find wer ea recent post with a Vista problem: SearchIndexer.exe causing problems after Search 4.0 update on Vista Home Premium system. - MSDN Forums and Desktop Search help has no recent advice.

I’ll try doing a windows update, then if that doesn’t work a uninstall/reinstall cycle.

Windows Search was much happier when I was using Office 2003. It hasn’t been the same since I went to 2007.

Update 10/20/08: I miss Lookout for Outlook. Also, Spotlight and all of OS X. Anyway, the Windows Update and reinstall didn't work. This time I'll uninstall, track down my index and trash it, and try again. As before the index is built, everything looks fine, but searches return nothing.

Update 10/20/08: Still not working. I'm running out of ideas. Next step is to uninstall Windows Search 4 and install Google Desktop Search! Instant search works in Outlook, but desktop search doesn't work at all. From a post on MSDN that I wrote:

A few days ago Windows Search 4 stopped working in my corporate XP desktop (all updated). All deskbar searches return "Nothing found in All locations for query ..." regardless of the query. I can't indentify any precipitating event but this is a managed corporate desktop. Anything can happen to it.

Web searches work. Instant searches in Outlook 2007, which use the Windows Search engine, are also working.

The index is fine and it's being maintained correctly.

I've run Office 2007 Diagnostics. I've rebuilt the index. I've uninstalled Windows Search and reinstalled. I've reviewed the Applications event log. I've deleted the index and indexed only a small bit of Outlook 2007. I've relocated my index to a new directory.

Nothing makes any difference. Instant Search works, the indexer works, Windows Search 4 doesn't work.

My corporate desktop is encrypted (SafeBoot), but I've not run into any problems there.

I don't know what to try next. Actually, my next step is to uninstall Windows Search 4 and install Google Desktop Search. I need search to work and I can't go on a lot longer without it.

Later I also reinstalled Office Pro 2007 -- to no effect. I did try Google Desktop Search, but for me it was far too simplistic. It also crashed every day.

Update 10/25/08: The hardest problem I've solved in years. I finally found a 2006 post on an MSDN board about the same problem. Search worked in Outlook 2007, but not from the desktop. It turns out that desktop search uses Microsoft's data query infrastructure (MDAC), and that infrastructure can be broken.

Repair of a broken MDAC stack is occult. Fortunately Paul Nystrom had the answer in 2006

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=901078&SiteID=1

This generally occurs when you have a corruption in your MDAC stack. You can find instructions for repairing your MDAC stack here (note this solution is not officially supported by Microsoft):

http://www.pqsystems.com/kb/activekb/questions/165/

For some additional information:

MDAC stands for Microsoft data access components. These components allow WDS to query it's index for resutls. When MDAC gets corrupted WDS can not retrieve results from the index resulting in empty query results.

Paul Nystrom - MSFT

I followed the repair advice on the referenced page (I have XP SP 3 installed):

How to repair a copy of MDAC 2.8 SP1 on Windows XP with SP2 installed.
----------------------------------------------------------------------

Right-click on C:\Windows\Inf\mdac.inf and choose "Install".

. ..point to the i386 folder in one of these places:

1. C:\Windows\ServicepackFiles\i386 (it may not like this location, if not, go to the next one)

2. The \i386 folder on your XP installation CDROM.

This reinstalls and repairs MDAC 2.8.

I used the servicepack files folder first. When asked for a file that wasn't in there I used the \i386 folder our corporate IT had on my drive.

It worked. Thank you Paul.

Hardest fix in years. Without Windows Live Search and Google I wouldn't have had a chance.

So what happened? My guess is that there's a problem with the sequence I took, moving through Windows Search 4 on Office 2003, then XP SP 3, then Office 2007. Somewhere in that sequence I broke MDAC.

The Wikipedia article on MDAC is informative:

The current version is 2.8 service pack 1, but the product has had many different versions and many of its components have been deprecated and replaced by newer Microsoft technologies. MDAC is now known as Windows DAC in Windows Vista.

XP is starting to remind me of Windows 98.

My Apple AV composite cable no longer works with my 3G iPhone.

If you have an Apple AV cable, you may want to see it if still works with your iPhone after the 2.1 update. I just posted this on Apple's discussion list:

Apple - Support - Discussions - My Apple AV composite cable no longer ...

I purchased an Apple composite AV cable from my local Apple store shortly after I bought my 3G iPhone.

It worked then.

I haven't used it much, but this morning I tried it again.

This time I got a message something like this:

"This accessory was not made to work with the iPhone. Would you like to turn on Airplane mode to reduce interference?"

It works with my older 3rd generation iPod.

This isn't an after-market cable. I bought it (yes, $50) at an Apple store because I knew Apple had shut out non-Apple connectors with the new generation devices.

I've seen various messages about failures of the AV cables after the 2.1 update. Most refer to aftermarket cables, or Apple cables purchased indirectly (may be counterfeit).

Has anyone else run into this?

I suppose I'll have to go back to the Apple Store with the cable and receipt and see what they can do about it.

I'll update this post with what I hear from my Apple store. If it turns out Apple deliberately broke their own cables that worked with iPhone 2.0 ...

Update: I read a post that suggests the connectors are a funny fit with the new iPhone -- that they may not always contact fully and this produces the message. I'll inspect closely and try again.

Update: Yes, it's the cable. If it's not fully seated you get this error. The old iPod connector used a locking connection with a positive click, the AV cable uses a lockless connector that differs from the newer lockless iPhone connector. I suspect the AV cable connector was a transitional design that may have more connectivity issues.

Bento 2: Modest good news, lots of bad news, slow as spit

The good news about Bento 2 is that it gives Leopard users access to their Address Book, Calendar and Tasks. Mail too, I think. That's probably worth $50 for me, especially if the current version FileMaker can't access these stores (I use an old version of FMP, haven't yet seen a good reason to upgrade.)

The bad news is the queries (called smart collections) can't be nested.

So you can define a query, but you can't reference it in a second query.

iTunes allows nested queries, I use them extensively. iPhoto doesn't, I miss 'em.

Some aspects of databases are hard to understand, but iTunes shows that regular users can learn to appreciate nested queries.

So, unfortunate omission.

I'm going to see if I can use Bento to help merge my Gmail and personal address books. If it works for that, I'll buy.

Even without the nested queries.

Update: I watched the videos. You create relationships by drag and dropping records. The 1 many relationship is seen through a "portal" window in a Bento form. Problem is, I don't see how you create a relationship by, say, relating all persons common last names in a single view. Bento would be more interesting if it were integrated with FileMaker, so we could use Bento to access iCal and similar stores but use FM to do more useful operations.

Update: There's no FileMaker Pro integration. The two are completely separate products using unrelated data stores (SQLite for Bento, as in /Users/account name/Application Support/Bento/bento.bentodb/Contents/Resources/Database). You can't link from a FileMaker Pro database into a Bento Library. Yuck. The only way out of this would be if someone figures out a way to use a more powerful SQLite app to manipulate Bento data. I'll watch for that.

This Nov 2007 Daring Fireball post has some more leads for understanding Bento.

Actual Technologies sells a connector that may allow a FMPro app to access SQLite data, may be read-only.

Bento is apple scriptable ...

Update 11/2/2008: Still in my trial period, I tried using Bento to enter several items quickly into my large iCal (several calendars, total 6,300 events). This is a trivial task with Outlook and its multiple views, but it's not supported in iCal.

Opening the Bento database, which includes the iCal tables, took minutes. Adding a single record took a minute. Type lag was severe.

Bento operations were excruciatingly slow on my single-core G5 iMac; manipulating my calendar reliably pegged the CPU. I was surprised how crude the UI was for specifying a calendar in a filtered view; I expected a drop down list but instead had to type the calendar name.

When doing data entry the type lag was gruesome. Yes, in a bloody database app there's type lag. It ain't doing fancy type layout, where the heck is the lag coming from?

When viewing a "collection" you can't create a new record. Lame.

This is an achingly inefficient load of software. It's miserable.

Deleting multiple iPhone camera roll pictures

It's odd that Apple hasn't fixed this bit of missing functionality; on OS X there's no obvious way to mass delete pictures taken with the iPhone camera!

In XP, ironically, it's very simple. XP mounts the camera store as a drive. You can't write to it (I tried of course), but you can select and delete.

In OS X most people recommend using Image Capture to "download and delete".

This tip points out you don't really need to download:

macosxhints.com - Delete multiple photos from the iPhone's Camera Roll

... Launch Image Capture and hit the Download Some button, and you are then free to roam the camera roll, selecting and deleting multiple images...

In case this isn't clear ... Launch Image Capture and click "download some", but you don't need to download any. Select all, then click the "delete" icon in the toolbar. All images are removed.

This is another odd bit of missing iPhone functionality! Of course it's not as critical as the missing calendar API, missing search functionality, the missing cut/copy paste function, the missing tethering tool, ...

iPhoto library sharing - the official Apple method

Apple's kb has an article on Sharing iPhoto libraries among multiple users.

Wild, it's more like what one would read on a geek site.

Turns out it can be done more or less safely. Problem is you need an external drive that ignores permissions -- or you can use a disk image in the shared item folder.

Is this some kind of sign that iLife '09 will support multiple iPhoto Library merges?

Ok, so I'm grasping at straws.

Update 3/9/09: The article was revised 1/12/09. I think they added a disk image option to turn off permission checking. If you go the disk image route remember that the standard disk image is hell on backups. Every time you change one byte in a 40GB Library the whole image has to be backed up. Sparse bundle images mitigate this problem, but Retrospect doesn't back up sparse bundle image backup properly (Time Machine does).

I might try this in a folder where my wife and I both have read/write privileges, though I'm concerned Apple didn't mention this obvious solution. I'll want to verify that this actually happens:

Keep in mind that while one user is viewing this library from iPhoto, another user will not be able to open this library at the same time. Instead, an alert message appears indicating that the library is already in use. You will need to quit iPhoto from the other user account before the next user will be able to view or edit this library.

Update 3/9/09b: Ok, I see the problem. It has to do with the way OS X (BSD Unix) manages permissions and it's a deep problem. Even if I create a shared folder and move my Pictures there, each file inside the "Library" (package) is still mine alone. Even if I change permissions on every file so "Parents" can edit them, newly added images will still get one or the other user's permissions. Yech!!

So to share a Photo library between multiple users you really do need to use something that ignores permissions -- or you need a future version of OS X -- or you need to use the Mac OS X Hints ACL hack.

Update 3/10/09: No changes with iPhoto. As I wrote on this Discussion thread, I think the problem is deeply embedded in the design of OS X (BSD Unix?) file sharing:

I don't think this is something that iPhoto can fix, it's really more of an OS problem. I THINK that the problem goes something like this:

1. OS X assigns new files permissions associated with their owner.
2. OS X allows only one owner per file.

So even if one set all the permissions on thousands of Library files to a multi-user group, the first time someone added new items to the Library there would again be inaccessible files.

Using an external drive or a disk image works because one can then ignore permissions, thereby eliminating a vast amount of security as well!

It's really a fairly deep OS problem. I wonder if Snow Leopard tries an alternative approach. I think XP file sharing doesn't have this particular problem, but I can't say for sure.

Interestingly the Apple kb article seems to imply that images ignore permissions. Thinking about how they're used, I bet that's true. Oddly enough, I can't find good google hits on this.

Alas, I can't go the sparsebundle route because my backup software (Retrospect) needs an update to manage these appropriately.

Update 3/19/09: I'm told Retrospect treats the Sparse Bundle as just another package. I'm doing some testing; after copying an iPhoto Library to the Sparse bundle I have:

Original iPhoto Library: 3.7 GB
Sparse Image Bundle version: 3.8 GB in 488 8MB bands (view package contents)

iPhoto editing in the Sparse bundle library can be hard on backups. I changed a rating on a single image, and five bands were revised (40MB of dat to backup).

Now I need to see how Retrospect behaves.

Incidentally, even though file privileges are ignored on this image, they still exist. So if you let multiple people work on Library, then move it to drive where privileges are NOT ignored, won't the Library be trashed until all privileges are corrected?

This feels like a nasty hack to work around a really bad file system design.

Update 4/9/09: Supposedly Apple has secretly fixed this in iLive '09!

Update 5/6/09: I updated another post with information about Retrospect and sparse bundles based on informed comments. It doesn't look good to me.

Using FrontRow for visually impaired OS X users

Front Row is designed for remote control at a distance. So the UI is pretty good for someone with poor vision, and it's much simpler than iTunes.

On the other hand, the remote is only intuitive to computer geeks. It's also difficult for someone with motor problems to use; the menu button, for example, is flush.

You can improve the menu button by putting fuzzy side velcro tape on it, but an alternative is to use the undocumented Front Row Key commands.

Undocumented, save for a generous blogger who compiled a list. See his site for the full list, here's my annotated version of an excerpt of it. Note that I used Keyboard Preferences to change the activation/quit key to F13. Unfortunately the F13 key doesn't behave exactly like the Menu button -- it starts and quits rather than moves in and out of menus.

rgbdream.com - Front Row Key Commands

Activation

Enter Front Row	F13
Quit Front Row	F13 (actually any key not used by FR will exit)

Menu actions

Up	Up-arrow
Down	Down-arrow
Select	Space
Previous menu	Escape

Playback controls

Play/Pause	Space
Rewind	Left-arrow
Fast-forward	Right-arrow
Previous track	Command + Left-arrow
Next track	Command + Right-arrow

Volume

Volume Up	Command + Up-arrow
Volume Down	Command + Down-arrow

Depending on your context sometimes the arrow keys also navigate menus and control volume.

I'm experimenting to figure out the right balance of use of a modified remote and the keyboard. I think the remove may win overall, but using the arrow and enter keys might be useful. You can use the kb volume keys to change volume.