Extracting specific info from Design Synopsis?

HCL Domino Domino Forum
1

I’ve inherited a database (developed about a version or two ago) that’s in serious need of trimming. It’s taken me nearly week to slog through the overloaded design to realize that over one hundred views are virtually identical except for minor differences in view selection. Two days of that time were spent proving that twenty of those views could be replaced by ONE categorized view set up to display Single Category.

Dealing with the rest of the overabundant views (with cryptic names, feh) would be a relative snap, or so I hope, if there were a way to quickly extract 1) View Name and 2) View Selection Formula to help figure out the tiny differences and where they lie. I’ve so far been unable to find anything in Sandbox to help, and so I’m been resorting to Design Synopsis. But stripping out all the information between Name: and Selection Formula: is not exactly ‘quick’, not with well over 100 views to deal with.

Am I doomed to this method, or is anyone aware of a an API or a Sandbox db I might have missed or even a native script function I might have missed that would allow me to extract just the View Name and View Selection Formula from every view element? Something I could then paste into a spreadsheet and identify the subtle selection differences that would aid me in consolidating the unneccessarily abundant views in this ugly, ugly database?

2

Subject: Extracting specific info from Design Synopsis?

you could do it quite simply with a script agent, dump that in an email or something…

Dim session As New NotesSession

Dim db As NotesDatabase



Set db = session.CurrentDatabase



Forall vues In db.Views

	

	Msgbox vues.Name

	

	Forall valeur In vues.Aliases

		Msgbox valeur

	End Forall

	

	Msgbox vues.SelectionFormula

	

End Forall

hope that helps

Alain

p.s. small change in the sample code, forgot that the alias is an array…

3

Subject: RE: Extracting specific info from Design Synopsis?

Fantastic! Merci beaucoup!!! You’ve saved me a lot of tedious work (and revamping this database is tedious enough for this lifetime as it is). And you’ve given me the direction I need to look if I need any other single values in these voluminous views, for which I’m also excessively grateful.

4

Subject: RE: Extracting specific info from Design Synopsis?

You are most welcome mon ami, have fun, and bon courage with the revamping…