Nice, very nice.
-----Original Message----- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: 12 January 2005 14:28 To: CF-Talk Subject: Re: WOT: Someone who still believes Rob Did you notice the part where he was using OS X Tiger Spotlight to instantly search both content & metadata? For a web site, this could be a total replacement for Verity (or whatever). You could just place a Mac somewhere on the network & move all your web content to it. When files are placed on this Mac they are automatically cataloged both content & metadata. (includes text, .doc. mp3, jpg, pdf. xls, htm, cfm.) etc. You never need to create a collection (it's automatic), and it is always up to date. And, a metadata/content search server is always running Then, you can use this Mac as a search server from CF. You use cfexecute to issue a mdfind command-- something like: <cfset searchTerm = "'Ray Charles'" /> <cfexecute name="mdfind" arguments="searchTerm" variable="searchResults" timeout="200"> </cfexecute> <cfoutput> <pre> #searchResults# </pre> </cfoutput> Returns all the paths to files referencing "Ray Charles" * * * /Volumes/My_iPod/iTunes/Ray Charles/VH1 8 Track Flashback - The On/In The Summertime.mp3 /Volumes/My_iPod/iTunes/Ray Charles & Blues Brothers /Volumes/My_iPod/iTunes/Ray Charles & Blues Brothers/Unknown Album/Shake Your Tail Feather.mp3 /Volumes/My_iPod/iTunes/Ray Charles & Charles Aznavour /Volumes/My_iPod/iTunes/Ray Charles & Charles Aznavour/Unknown Album/For Mamma.mp3 /Volumes/My_iPod/iTunes/Ray Charles & Hank Williams Jr /Volumes/My_iPod/iTunes/Ray Charles & Hank Williams Jr/Complete C&W Recordings 59/09 Two Old Cats Like Us.mp3 /Volumes/My_iPod/iTunes/Ray Charles & Van Morrison /Volumes/My_iPod/iTunes/Ray Charles & Van Morrison/Unknown Album/Tura-Lura-Lural (That's An Irish Lullaby).mp3 * * * Then, if you want to see the metadata associated with an mp3 file we use (cfexecute) the mdls command: mdls '/Volumes/My_iPod/iTunes/Ray Charles & Blues Brothers/Unknown Album/Shake Your Tail Feather.mp3' /Volumes/My_iPod/iTunes/Ray Charles & Blues Brothers/Unknown Album/Shake Your Tail Feather.mp3 ------------- kMDItemAttributeChangeDate = 2005-01-12 05:38:36 -0800 kMDItemAudioBitRate = 128 kMDItemAudioChannelCount = 2 kMDItemAudioSampleRate = 44100 kMDItemAuthors = ("Ray Charles & Blues Brothers") kMDItemContentType = "public.mp3" kMDItemContentTypeTree = ( "public.mp3", "public.audio", "public.audiovisual-content", "public.data", "public.item", "public.content" ) kMDItemDisplayName = "Shake Your Tail Feather" kMDItemDurationSeconds = 168 kMDItemFSContentChangeDate = 2004-12-20 16:48:47 -0800 kMDItemFSCreationDate = 2004-06-10 17:23:08 -0700 kMDItemFSCreatorCode = 0 kMDItemFSFinderFlags = 0 kMDItemFSInvisible = 0 kMDItemFSLabel = 0 kMDItemFSName = "Shake Your Tail Feather.mp3" kMDItemFSNodeCount = 0 kMDItemFSOwnerGroupID = 99 kMDItemFSOwnerUserID = 501 kMDItemFSSize = 2697344 kMDItemFSTypeCode = 0 kMDItemID = 42327 kMDItemKind = "MP3 Audio File" kMDItemLastUsedDate = 2004-12-20 16:48:47 -0800 kMDItemTitle = "Shake Your Tail Feather" kMDItemTotalBitRate = 128 kMDItemUsedDates = (2004-12-20 16:48:47 -0800) The above will work if CF is running on the Mac -- a little more involved to setup the Mac as a separate server. Anyway, "we gonna' mdfind Ray Charles" wherever he is-- even in a file named MyCD1.mp3 (and even in this email or the .cfm above.) The search server and datastore is built into OS X and is based on SQLite rdbms. The indexing scheme uses normalized, generic fields to describe metadata elements so that the Author(s) of a word doc are equivalent to the Artist(s) on a song. You use a search notation similar to SQL Select syntax. When OS X Tiger ships (sometime before July 2005) I suspect that there will be custom tags to do the search (I'll write one if necessary). This is really cool & fast! I bought a Sponge Mac Square Bob (Mac mini) that I plan to dedicate as a search server for just this purpose Dick P.S. 'lo to K On Jan 11, 2005, at 11:55 PM, Rob wrote: > That was a great keynote thanks for posting it Dick - I've got my copy > of iWork on the way :-D > > On Tue, 11 Jan 2005 19:43:40 -0800, Dick Applebaum > <[EMAIL PROTECTED]> wrote: >> I've been around micro/desktop computers since 1978. >> >> Here is someone who still believes: >> >> http://stream.apple.akadns.net/ >> >> Dick > > -- > ~Blog~ > http://www.robrohan.com > ~The cfml plug-in for eclipse~ > http://cfeclipse.tigris.org > ~open source xslt IDE~ > http://treebeard.sourceforge.net > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190081 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54