Search DominoPower's 11,437 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
ADVANCED DEVELOPMENT TECHNIQUES
Build your own database analysis tool
By Dan Velasco

What Notes databases do you have on your computer? You've got one minute to print out a list, including titles, file names, and the number of forms, agents and views in each. Ready, set…can you do it?

"I rediscovered why I love using LotusScript. Almost any information you want to get or anything that you want to do is possible if you're patient enough."

Don't fret if you couldn't pass this test. You'll be able to after you read this article and implement the agent it describes. And you won't have to spend extra money on a product that analyzes the databases on your system. All you need is a single LotusScript agent, a form to capture the information and a few views to help you analyze at a glance what you have on your system.

You won't even need to worry about searching through all of your subfolders. The agent will provide a report on all databases off of your main Notes data directory, regardless of whether or not they are in subfolders.

Time to do a little housecleaning?
We've all reached a point when we've had to delete some files off of our computer to save space. We even sometimes have to delete (GASP!) Notes/Domino databases. During a recent spring-cleaning frenzy, I went into Windows Explorer, opened up the C:\NOTES\DATA folder and then chose to view the files by size. This is fine when you're starting on a new computer and you only have a few databases on your local machine, which you can identify by the file names. Now that I've been at my current job for over six months, however, I've got a lot of Notes database files on my local machine and I can no longer identify them by file name alone.

You could browse through the databases by selecting them on the Workspace tab, opening them up by looking at all of the elements, and then deciding if you want to delete them or not. Then you could choose Database->Delete from the File menu to actually delete the database from your hard drive. But if you're like me, you have 14 Workspace tabs and it's a pain to have to go through all of the databases one-by-one and decide what to keep and what to delete. It would be much easier to look at all of your databases in a single view and then immediately drill down to more detailed information about selected databases.

What I needed was something to analyze what databases I had on my computer. Then that something would tell me all the pertinent information I needed to know about those databases to help me decide which ones I should keep and which I should scrap. I also wanted something that would help me when doing development. This tool would list the names of all of the forms and views in a database along with their aliases. Since I always develop with an eye to Web functionality, I use aliases on all of my forms and views so I won't have to insert "+" signs to replace spaces in a name when putting it into a URL.


1  ·  2  ·  3  ·  4  ·  5  ·  Next »
Other articles you might like
Home > Internet Technologies > Logging and analysis (8 articles)
   Boost your server performance with HTTrack
   Keeping user credentials in a frameset
   Using probes to monitor your Domino servers
Home > Lotus Technologies > Notes (84 articles)
   A walk down Memory Lane with Lotus Notes
   An application for scanning physical mail and distributing it virtually
   Managing Notes deployments with Teamstudio Build Manager
Home > Lotus Technologies > LotusScript (64 articles)
   When the debugger won't debug hidden code that isn't hidden
   What to do if the LotusScript debugger won't single-step over code
   Little known traps about Lotus Notes fields
Home > Lotus Technologies > Application Development (48 articles)
   An application for scanning physical mail and distributing it virtually
   How hide-whens in Rich Text can ruin your whole day (and what to do about it)
   Little known traps about Lotus Notes fields
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
Application development, William Shatner, and the origin of the universe
Learn Domino Designer 8.5 for free
The (near) future of Sametime, Quickr, Connections, and Symphony
Inside the IBM Innovations lab
Lotusphere 2010: Hot fixes and cool news for Notes, Domino, and LotusLive
Lotusphere 2010: mobility and collaboration
2010: A Lotusphere of change
Latest Lotus Headlines
SNTT : XPages onclick Ghosts in the machine
Ports used by Lotus Sametime 8.5 servers
Exploring a Domino Date Bug
Adding Quick Highlighter support to IBM Lotus Notes Domino Wiki, Weblog, or Webpage
Remember Young Admins...there are 2 files
WebSphere Portal 6.1.0.2 and Lotus Domino 8.5
The CKEditor - with Domino
>> Read all the news
More from the ZATZ journals
Computing Unplugged: The iPad defenders have spoken
David Gewirtz Online: CNN commentary and analysis
OutlookPower: More about disappearing text
-- Advertisement --

Find unused Lotus Notes groups and clean up your address book
Have you ever wanted to get rid of old Lotus Notes groups that were cluttering up your address book, but you weren't sure if they were used? Find Unused Groups can help.

Find Unused Groups will check your ACL, mail, multi purpose and server groups to help you determine if they are used, and who uses them.

Learn how to easily clean up your address book.

-- Advertisement --

Mark your calendar for in-depth Lotus training, May 12-14, Boston
Join experts and peers May 12-14 in Boston for educational and networking events that deliver real-world Lotus training so you can increase productivity and efficiency in your company, advance your skills, and squeeze the most from your current environment. One registration gets you into THE VIEW's Admin2010 and Lotus Developer2010.

Register by April 10 to save $200.
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login