IBM Lotus Notes and Domino R8.5 Application Developer Professional Training Workshops

Course code: D8510
Skill level: Basic
Duration: 4 days
Delivery type: Classroom (Hands-on labs)

The course provides the information that you need to know to successfully create and modify database applications in IBM Lotus Domino Designer 8. It provides an overview of the Lotus Domino 8 and Domino Designer 8 environments, introduces the elements and skills that are used in creating single-database Domino applications, describes how the formula language can be used to enhance the functionality of a Domino application, and explains how Domino applications can be secured.

Audience

This is basic course for application developers who are new to developing Domino applications and who need to acquire the fundamental skills to develop and modify single database applications in IBM Domino Designer 8.

Prerequisites

The prerequisites for this course include :
Experience using the Lotus Notes client, Web browser or both to access applications.
(Recommended) Experience developing one or more applications using other application development tools.

Skills taught

Exploring Applications in Lotus Domino 8
Exploring the Lotus Domino 8 Design Environment
Creating Databases
Designing Pages
Initiating Forms
Creating Views
Introducing Formulas
Using Formulas in Forms
Using Formulas in Views
Developing Forms
Enhancing Views
Working with Actions
Working with Agents
Securing Applications

Exploring Applications in Lotus Domino 8
Identifying Application Types and Data Sources
Examining the Lotus Domino Architecture
Analyzing Lotus Domino Application Components
Investigating Replication and Application Design Considerations
Extending Lotus Domino Collaboration Capabilities

Exploring the Lotus Domino 8 Design Environment
Exploring the Lotus Domino Designer User Interface
Accessing Design Elements

Creating Databases
Creating a New, Blank Database in Lotus Domino Designer
Designing a Copy of an Existing Database
Initiating a Database from a Template
Organizing the Lotus Domino Designer Environment

Creating Pages
Exploring Page Content, Layout, and Navigation Basics
Creating Pages
Adding Text to Pages
Using Tables to Lay Out Pages
Adding Images to Pages

Creating Forms
Creating Forms
Adding Fields to Forms
Hiding Form Elements

Creating Views
Creating Views
Adding View Columns
Organizing Documents
Formatting Views

Introducing Formulas
Identifying Programming Languages Supported by Lotus Domino
Classifying Formula Components
Identifying Event Triggers
Working with @Functions
Computing and Compare Values
Exploring Formatting and Comments

Using Formulas in Forms
Creating Window Titles
Working with Computed Values
Designing with Field Values
Working with Lists
Prompting Users
Creating Reusable Code
Implementing Error Checking

Using Formulas in Views
Creating Selection Formulas
Concatenating Values in a View Column
Displaying Icons In A View

Enhancing Forms
Working with Layers
Working with Subforms
Creating Shared Fields
Enabling Inheritance in Forms and Documents
Creating Related Forms
Enabling AutoSave
Implementing Lotus Sametime Instant Messaging in Forms

Enhancing Views
Defining Hierarchical Views
Displaying Response Data in Views
Implementing Shared Columns
Enabling Lotus Sametime Instant Messaging in Views
Creating Views for the Web

Working with Actions
Designing Actions
Creating Shared Actions
Controlling the Display of Actions
Establishing Action Hotspots

Working with Agents
Investigating Agents
Creating Agents

Securing Applications
Exploring Database Access
Implementing Roles
Using Readers and Authors Fields
Controlling Access for Anonymous Users
Deploying Applications

Course code: D8530
Skill level: Intermediate
Duration: 2 days
Delivery type: Classroom (Hands-on labs)

This course builds on the skills of Lotus Education’s Fundamentals of IBM Lotus Domino 8 Application Development (D8510) course. Through instructor lecture and student-centered activities and exercises, 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.

Audience

This is an intermediate course for application developers who have experience creating or modifying single database applications with Lotus Domino Designer 8.

Prerequisites

You should have:
Completed Fundamentals of IBM Lotus Domino 8 Application Development course (D8510) or equivalent knowledge, skills, and experience.
Three or more months experience developing Lotus Domino 8 applications.

Skills taught

After completing this course, you 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
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

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
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
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
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

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 (DCRs)
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
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