110 likes | 256 Views
Digital Memories Software. Jim Gemmell Digital Memories (Memex) Workshop 7/19/2006. What’s in the kit. SenseCam SenseCam software: upload wizard, (non-database) viewer inc. movie creation. sc-qa@microsoft.com for support. Digital Memories Software
E N D
Digital Memories Software Jim Gemmell Digital Memories (Memex) Workshop 7/19/2006
What’s in the kit SenseCam SenseCam software: upload wizard, (non-database) viewer inc. movie creation. sc-qa@microsoft.com for support Digital Memories Software Includes a (database-based) SenseCam viewer
Connect Site • Latest version of Digital Memories software. • Updated version of SenseCam upload/viewer. • SenseCam demo data (photos, sensor date + GPS). • Sample code for extending the Digital Memories software. • Tips, e.g. upgrade problems: • Uninstall a previous release • Remove any Digital Memories services
Running in the background • NTFS file system promotion service (fswatch.exe) • Local Web Service" (mlbwww.exe) • PersonalVibe (in startup group) • Outlook toolbar watching your email, contacts etc. • IE toolbar capturing web pages
NTFS Sync Controller • Don’t need to run SenseCam import if you are watching the folder tree
DEMO: did you know you can…? • IE: common pages, next/prev in history • Outlook: click for log, pause button, launch shell • SenseCam Viewer • Trip Replay • Shell: drag & drop photos onto map, sort web pages by time spent
Creating new item types • Award for first new item type goes to Michael Shoffner from UNC: “Inserted context items show up in the shell and work with full text search!” -- SQL to add a new type to Digital Memories for context snapshots from CAF -- These items are inserted by a trigger on the _Items table whenever a modification or creation of an item occurs. -- Create a table to hold context data create table Context_Snapshots (item_id uniqueidentifier NOT NULL, Snapshot varchar(max)) GO -- add a primary key constraint ALTER TABLE [dbo].[Context_Snapshots] ADD CONSTRAINT [PK_Context_Snapshots] PRIMARY KEY NONCLUSTERED ([item_id]) GO -- add a foreign key reference to enforce that no Snapshot can exist without a corresponding _Item ALTER TABLE [dbo].[Context_Snapshots] ADD CONSTRAINT [FK_ContextSnapshot_Items] FOREIGN KEY ([item_id]) REFERENCES [dbo].[_Items] ([item_id]) GO exec _Init_CreateSubType 'CEC5651C-AE0E-494E-9959-97B6654C9441', 'Context_Snapshots' GO -- sp to delete a context item create procedure Context_Snapshots_DeleteProcedure @item_id uniqueidentifier AS delete from Context_Snapshots where item_id = @item_id …
My questions for you • Is anyone planning on extending the shell with a new visualization? • We want to hold a workshop for the final results of your workshop: • When should it be? • How long should it be? (is one day enough?) • What is the most important feature missing from the software right now?