OpenNTF.org - eleMental
    Advanced
   Application Catalog
Edit Document By Date > Document
About This Document
Rating:
Not Rated Yet 
Title:
eleMental 
Version:
0.1 
Release date:
07/20/2006 
Author:
Andrew Barker 
 
Category:
Developer Tools 
Type:
Open Source (see project for licensing information) 
Supported Notes Version:
R5.x, R6.x, R7.x 
 
Document Release:
07/20/2006 
Contributor:
Andrew Barker 
Last Modified:
20 Jul 2006 
Notification:
Notify me when comments are added 
 
Download location:
OpenNTF.org 
Download URL:
http://www.openntf.org/projects/lnfreewarecatalog.nsf/ByDate/31A70C834979FB34862571B1005DD9D4/$file/eleMental.nsf

All of the program code and information presented in the OpenNTF.org Freeware Catalog are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Freeware Catalog, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.
Description
Viewing Design Elements as documents in a view is useful. (Views with their $FormulaClass tweaked.)


This db contains reusable views (and code) for exposing a database's design.

As a reference*, it started with $Flags, but I realized many other design settings could be viewed from these views. (There are too many to list here, you'll just have to see for yourself.)

Also, since your design is now exposed as documents, it is more easily manipulated. Including writing to custom $Fields (See #2 and #4 below.).

For example, I have included various views here which allow you to (all code works on selected docs/elements):

1. Set / Clear the "Prohibit Design refresh..."
2. Set / Clear element level Inheritance ( or Backup if you need to temporarily disable)
3. Export and Import design elements between databases
4. Group designs and documents together as Design Packages
- There is a stand alone agent which can set regular documents to be included into your Design Package, for instance, config or lookup docs.
5. Read / Edit the $Comments
6. View
- All elements. This is the one to use if you want to see all the settings.
- by Design Package
- by Template Inheritance
- by Security (design elements which have Who Can Read or View settings)
- by Subforms used (by which forms)

* I have exposed most of the values and what they do in the "All Objects" view. There are, however, many that I have not yet sussed out. I'd love some help figuring out other $Field values / meanings. Leave them here or here (http://www.andrewbarker.com/home/htmDocs/Elemental) as comments and I'll add them into the next release.


Thanks to:
1. Johan Kanngard (http://dev.kanngard.net/Permalinks/ID_20021012152907.html)
2. Julian R. (http://www.nsftools.com/tips/NotesTips.htm#formulaclass) and
3. Dan Velasco
for good starting points.

Screenshots
eleMental.nsf (1576 Kbytes)


 Comments
Posted by Kevin Pettitt on 06/26/2007 08:23:41 PMAndrew, you really need to make this a proper project...
Hi Andrew,
I've been working on some things that are starting to overlap with eleMental and would like to help. I've found some great reference materials from Andre Guirard and Rocky Oliver, and sample code in the Sandbox. In particular I've been working on the same sort of $Flag deciphering you've done here.
The bigger problem with eleMental though is that it is practically invisible on the OpenNTF site. It only shows up under "Application Catalog" when most folks would be looking in the Projects. You should really create a project for this so people can find it. I'm going to include some bits in SuperNTF and would love to hook up with you to share ideas on how the two projects can benefit from each other.
Kevin
www.lotusguru.com
 Add your comment!
Subject:


Comment:


     Notify me when comments are added