Course Description
Abstract: This course builds on the skills of Lotus Education's Fundamentals of IBM Lotus Domino Application
Development (D8510) course. This is an instructor lecture with student-centered activities used to teach students to use IBM Lotus Domino Designer 8 to develop multi-database applications. This course explores advanced formula techniques and methods to develop interactions within applications.
Keywords
Basic, IBM, Lotus Domino Applications, Lotus Domino 8, intermediate skills
Overview
This course builds on the skills the IBM Lotus Domino 8 Application Development course. Through instructor lecture and student-centered activities and exercises, students learn to use IBM Lotus Domino Designer 8 to develop multi-database applications.
The course explores advanced formula techniques including looping and user interaction with the application. The course explains different methods for accessing data sources outside the current Domino database including other
Domino databases and relational databases. Other topics include adding workflow functionality to route documents and notify users that a document requires their attention, and security issues such as encrypting data.
This course also examines navigation elements such as links, outlines, and framesets that bind the components of the application together and allow users to locate information quickly and easily.
Target Student
The target audience for this course is application developers who have experience creating or modifying single database applications with Lotus Domino Designer 6, 7, or 8.
:: Course D8530 ::
Prerequisites
Students taking this course should have experience using the IBM® Lotus Notes® client to access applications and possess the equivalent knowledge, skills, and experience developing Lotus Domino 6, 7, or 8 applications.
Students should have completed the Fundamentals of Lotus Domino 8 Application Development or Developing
Lotus Domino 6/6.5 Applications Foundation Skills course.
Delivery Method
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Course Materials
Student Guide, Instructor Guide.
Hardware Requirements
Primary Classroom Server:
At least 1GB of RAM per CPU. However, for optimal performance, you might need to use 2 GB or more.
A Pentium class (or higher) processor and compatibles. A Pentium 4, 2.6 GHz, processor is recommended.
An SVGA (or better) video card and monitor. Support for 256 colors, 800 x 600 resolution.
At least 2 GB (per partition) of free hard disk space. 40 GB of free disk space is recommended.
For disk swap space, at least twice the amount of installed RAM.
A mouse or other pointing device.
A CD-ROM drive or access to a network file server for installation.
Instructor and Student Clients:
At least 1 GB of RAM, 1.5 GB is recommended.
A Pentium class processor.
An SVGA (or better) video card and monitor. Support for 256 colors, 800 x 600 resolution.
At least 1.5 GB of free hard disk space, 3 GB is recommended.
A mouse or other pointing device.
A CD-ROM drive or access to a network file server for installation.
Synchronize system time with all classroom machines.
:: Course D8530 ::
Software Requirements:
Microsoft Windows Server 2003 (Standard or Enterprise Edition) (the latest Service Pack is recommended, but not required) or Microsoft; Windows 2000 Server (or Advanced Server) with Service Pack 4.
IBM Lotus Domino 8.
DB2 Universal Database Enterprise Server Edition 8.2 with FixPak 12.
Performance-Based Objectives
After completing this course, students should be able to:
Use formula language to inspect and manipulate text values and lists, and use iterative statement functions.
Implement functions that interact with users through different types of dialog boxes using the @Prompt and
@DialogBox functions.
Implement advanced view design features to enhance how Lotus Notes displays documents.
Examine and use several IBM® Lotus® Domino® design elements as navigation structures, including links and imagemaps.
Create and embed an outline.
Work with framesets and frames.
Access data in Lotus® Domino® databases by using formula language and profile documents.
Use the formula language to access data sources using the Microsoft® Open Database Connectivity (ODBC) interface.
Examine Domino Enterprise Connection Services (DECS) and implement real-time data mapping between an
IBM® Lotus® Domino® application and a relational database.
Implement workflow in Lotus Domino applications.
Secure Lotus Domino application data by controlling access and encrypting data.
Lesson 1: Working with Strings, Lists, and Loops
Topic 1A: Writing Formulas to Manipulate Text Values
Useful Functions for Inspecting and Searching Text
Inspecting and Searching Strings
Useful Functions for Parsing a String
Examples of Parsing a String
Topic 1B: Working with Lists
Creating Lists
List Operations
Using the List Subscript Operator
Useful Functions for Inspecting Lists
Useful Functions for Modifying Lists
Useful Functions for Converting Lists
:: Course D8530 ::
Topic 1C: Creating Iterative Formulas
Iterative Statement Functions
Using a For Loop
Using a While Loop
Using a DoWhile Loop
Lesson 2: Writing Formulas to Interact with the User
Topic 2A: Using the @Prompt Function
Introducing The @Prompt Function
Examples of User Prompts
The @Prompt Function
@Prompt Styles
Topic 2B: Working with the @DialogBox Function
The @DialogBox Function
Using the @DialogBox Function
Creating a Form for @DialogBox
Topic 2C: Using Layout Regions
Layout Regions
Creating a Layout Region
Adding Elements to a Layout Region
Lesson 3: Advanced View Design
Topic 3A: Using a Background Image in a View
Background Images
Background Image Formatting Options
Adding a Background Image to a View
Topic 3B: Hiding a View Column
Hiding Columns
Using a Formula to Hide a Column
Topic 3C: Modifying View Elements
Highlighting View Documents
Programmatically Setting Colors in a View
Creating a View Column to set the Colors of a Row
Using Values to Specify the View Text Color
Using Values to Specify the View Background Color and Text Color
Hiding the Color Column
Expanding a Column to Use the Available Width
Topic 3D: Working with Embedded Elements
Adding an Embedded Editor to the Form
Preventing a Document from Being Saved
Combining Embedded Elements
Embedded Schedulers
:: Course D8530 ::
Lesson 4: Adding Navigational Elements Using Links and Imagemaps
Topic 4A: Linking to Other Documents and Pages
Types of Links
Creating a Link Hotspot on a Page or Form
The Hotspot Resource Link Properties
Named Element Links
Creating a Named Element Link in the Properties Box
URL Links
Creating a URL Link
Topic 4B: Creating Imagemaps
Imagemaps
Describing Hotspots on an Image
Creating a Hotspot on an Image
Lesson 5: Working with Outlines
Topic 5A: Creating an Outline
The Outline Design Element
Process of Creating an Outline
Create an Outline
Default Outlines
Creating a Default Outline
Topic 5B: Adding Outline Entries
Outline Entries
Creating a Hierarchical Outline
Creating an Outline Entry
Topic 5C: Modifying Outline Entries
Setting Outline Entry Properties
Indenting and Outdenting Outline Entries
Topic 5D: Embedding an Outline
Embedding Outlines
Embedded Outline Properties
Formatting an Embedded Outline
Lesson 6: Creating a Frameset
Topic 6A: Adding a Frameset to an Application
What are Frames?
What are Framesets?
Structuring a Frameset
Guidelines for Designing Framesets
Creating a Frameset
Topic 6B: Adding Content to a Frame
Specifying Frame Information
Specifying a Content Source
Using a Target Frame
Specifying the Default Target Frame
Target Frame Precedence
Placing a Page in a Frame
:: Course D8530 ::
Topic 6C: Launching an Application Frameset
Setting Database Properties to Launch a Frameset
Topic 6D: Adjusting Framesets
Adding New Frames to a Frameset
Launching Individual Elements in a Specific Frame
Opening Documents in a Frame
Setting a Target Frame
Lesson 7: Accessing Data in IBM® Lotus® Domino® Databases
Topic 7A: Accessing Data from a View
Common Arguments for @Db Functions
Options for Caching the Results of a Lookup
Guidelines for Caching the Results of a Lookup
Specifying a Database for Lookups
How Lotus Notes® Searches for a Replica
Using @DbColumn
Using @DbLookup
Optional Keywords for @DbLookup
Topic 7B: Using @PickList
Advantages of @PickList
Styles of PickLists
Displaying a View with @PickList
Displaying a Domino Directory View with @PickList
Topic 7C: Working with Profile Documents
Introducing Profile Documents
Characteristics of Profile Documents
Guidelines for Using Profile Documents
Designing a Form for Creating Profile Documents
Creating a Profile Document with Formulas
Reading Data in Profile Documents
Updating Data in Profile Documents
Lesson 8: Accessing Non-Domino Data
Topic 8A: Introducing Microsoft Open Database Connectivity
Using ODBC
Working with ODBC Drivers
ODBC Driver Configuration
Example dBase Table
Topic 8B: Using @Db Functions to Access an ODBC Data Source
Accessing Relational Data from IBM® Lotus® Domino® with ODBC
Comparing the @Db Functions that use ODBC
Using @DbColumn
Using @DbLookup
Using @DbCommand
:: Course D8530 ::
Lesson 9: Mapping Data Between IBM® Lotus® Domino® and Relational Databases
Topic 9A: Introducing IBM® Lotus® Domino® Enterprise Connection Services
Data Mapping
Data Mapping in Lotus® Domino®
Using DECS
How DECS Communicates with the External Data Source
Capabilities of DECS
Topic 9B: Working with DECS
The DECS Server Task
Working with the DECS Administrator Database
Topic 9C: Using Data Connection Resources
Working with DCRs
The DECS Administrator Database and DCRs
Using DCRs
Creating a Data Source Resource for ODBC Access
Creating a DCR
Basic Properties of a DCR
Optional Properties of a DCR
Associate a Form with a DCR
Mapping Fields to External Table Fields
Importing External Data
Enabling a Lotus® Domino® Database to Use DCRs
Lesson 10: Adding Workflow to IBM® Lotus® Domino® Applications
Topic 10A: Defining Workflow
Benefits of Automating the Process
Elements of Workflow
Using a Workflow Diagram
Example of an Expense Reimbursement Workflow Diagram
Workflow Elements of the Expense Reimbursement Process
Topic 10B: Routing Workflow Objects in IBM® Lotus® Domino®
The Routing Process
Ways to Route Documents
Making a Mail Database Known to the Router
Making an Application Database Known to the Router
Topic 10C: Designing Workflow
Triggering Workflow
Identifying the Recipient
Identifying the Data to Send
Sending the Data
Topic 10D: Notifying Users
Sending a Doclink Using @MailSend
Topic 10E: Routing Entire Documents
Examples of Routing Entire Documents
Configuring the Application to Route Documents
Enabling Recipients to Read Documents
Using a Form Formula in a View
:: Course D8530 ::
Topic 10F: Sending the Current Document
Defining the SendTo Field
Creating a SendTo Field
Using @MailSend Without Parameters
Using the Present Send Mail Dialog Property
Using the MailSend @command
Using the Send Document Simple Action
Using the MailOptions Field
Forcing a Document to Route Using a MailOptions Field
Topic 10G: Tracking Documents
Collecting Information on the State of a Document
Useful @functions for Creating a History Log
Adding a Tracking Field to a Form
Creating a Tracking View
Lesson 11: Securing IBM® Lotus® Domino® Application Data
Topic 11A: Limiting Who Can Read and Edit Sections
Using Access-Controlled Sections
Creating an Access-Controlled Section
Limiting Who Can Edit a Section
Topic 11B: Signing Documents and Mail
Enabling Signing Documents and Mail Messages
Creating a Sign-Enabled Field
Signing an Access-Controlled Section
Topic 11C: Encrypting Domino Data
Determining What to Encrypt
Types of Encryption Keys
Using Public and Private Keys
Using Secret Keys
Topic 11D: Creating and Distributing Secret Keys
Creating a New Secret Encryption Key
Distributing Encryption Keys with E-mail
Exporting a Secret Encryption Key to a File
Merging an Encryption Key Received by E-Mail
Importing an Encryption Key Received as a File
Topic 11E: Encrypting Fields
Enabling Encryption for a Field
Applying Encryption
Applying Encryption Automatically
Providing a List of Secret Encryption Keys in a Field
Appendix A: Activity Solutions
Appendix B: Create an ODBC Data Source Resource
Appendix C: Course Scenario
Appendix D: Certification and Exam Competencies
Appendix E: Instructor Preparatio
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.