Interested in bringing a class to you? Onsite training
Overview
| Course code | D8530 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 3.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $1,500.00 plus tax | ||
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.
Course outline
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
