V&M Home Page



AVAILABLE for Consultations or Contracting - I hold passports from Canada and The Netherlands. I would be happy to help you - either in person or working remotely.
Email John



It should be really easy to export a Lotus Notes View to a CSV. Yes and No.
Since the earliest versions of Lotus Note we have be able to export a View to a CSV

This View is the source of random quotations that I include in my signature.
Quips & Quotes 
Conflicts 
Quotes 
Sorted Quotes 
Sources 
New Quotes 
Quote 
Why fit in when you were born to stand out? - Dr. Seuss 
A bird does not sing because it has an answer. It sings because it has a 
song. - Chinese proverb. 
A clear conscience is usually the sign of a bad memory. 
A closed mouth gathers no feet 
A complex system that does not work is invariably found to have evolved 
from a simpler system that worked just fine. -Murphy's Law of Computing 
#138- 
A diplomat is a man who always remembers a woman's birthday but 
never remembers her age. Robert Frost 
2 
3 
4 
5 
6 
456 
228 
14 
169 
29 
Date 
11/09/2015 
07/17/2007 
06/28/99 
03/22/2004 
02/28/2000 
07/13/2008 
Source 
Flbocy 
Bruce Jeffrey GC 
Joke ofthe Day 
Murphy's Law of 
W2K Newsleter

I want to Export these to a spreadsheet.
File 
Quips & Quotes - Sorted Quotes 
Edit View Create Actions 
- 18M Lotus Notes 
Tools Window Help 
ierhoff - Mail John Vanderhoff 
Open 
Save As... 
A utoSave 
Application 
Replication 
Locations 
Import... 
Export... 
Page Setup... 
Print Preview... 
Ctrl+Shift+S 
ew Quotes 
Why fit in when you were born to stand out?- Dr 
bird does notsing because ithas an answer 
ong - Chinese proverb 
clear conscience is usually the sign of a bad 
closed mouth gathers no feet 
complex system that does notwork is invaria 
om a simpler system thatworked iustfina -Mul

Give a location to save the CSV
Export 
Naw folder 
Quick access 
Desktop 
Libraries 
This pc 
File name 
Network 
Save as type 
Date modfied 
No items match your search. 
Type 
Quotas 
Comma Separated Valua

CSV Export 
to Export 
@Al documents 
Export 
@ Default character set 
C) International (LITF-8) 
C) Unicode 
to Irworpor*e 
Include View titles 
Cancel

Open in Excel
2 
3 
4 
5 
6 
7 
Quote 
Why fit in when you were born to stand out? - Dr. Seuss 
A bird does not sing because it has an answer. It sings because it has a song. - Chinese proverb. 
A clear conscience is usually the sign of a bad memory. 
A closed mouth gathers no feet. 
A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine. -Murphy's Law of Computing #138- 
A diplomat is a man who always remembers a woman's birthday but never remembers her age. Robert Frost 
Date 
456 11/09/2015 
228 07/17/2007 
14 06/28/99 
169 03/22/2004 
29 02/28/2000 
260 07/13/2008 
Source 
Flixxy 
Bruce Jeffrey Goldstein 
Joke of the Day 
Murphy's Law of Computin 
W2K Newsletter

Rich Text
You no doubt noticed that the content of the View is all text.
Well, Lotus Notes also allows for the creation of Rich Text Fields. These RTFs cannot be displayed in a View. However, we can extract the text out of a RTF. As you can see bellow, when we extract we are only left with the words. If that doesn't work then we are not going to be able to Export to CSV. We are going to need some programming to populate the spread sheet .
Rich Text Field 
Blue Text 
Ref Text 
Picture > 
Table 
3 
2 
4 
Text Extracted from Rich Text Field 
Blue Text Ref Text Picture > Table Cell 1 Cell 2 Cell 3 Cell 4


Complex Views
Notes is essentially a document based , schemaless, loosely structured database with support for rich content and powerful indexing facilities.

Lotus Notes is a Document Base NOT a database. There really is no structure. At first glance a View looks like a Table. Do not be fooled. There is no way to perform a "join".  Lotus Notes has a pseudo relationship.

Create Child Profile Create Contact Record 
Copy Contact 
Move Contact Record 
IS 26 Feb 2009 *Contact Record* 3 - Damaging But Not Life Threatening Or Dangerous (Status:Closed) 
29 Jun 2009 
IS 24 Mar 2004 *Contact Record* 3 - Damaging But Not Life Threatening Or Dangerous (Status:Closed) 
15 Jun 2005 *Interview* 
21 Jan 2004 *Continuation Sheet* 
IS 3 Nov 2003 *Contact Record* 2 - Dangerous But Not Life Threatening (Status:Closed) 
21 Apr 2004 CARE ORDER- *Report (Microsoft Word)' 
6 Feb 2004 *Collateral Contact* Mr. CE 
28 Jan 2004 CARE ORDER- *Report (Microsoft Word)' 
21 Jan 2004 *Referral Form* 
13 Jan 2004 *Correspondence Folder* 
13 Jan 2004 *Collateral Contact* 
2 Dec 2003 *Collateral Contact* Mr. 
2 Dec 2003 *Collateral Contact* D— 
7 Nov 2003 *Referral Form* 
IS 22 Oct 2003 *Contact Record* 3 - Damaging But Not Life Threatening Or Dangerous (Status:Closed) 
22 Oct 2003 *Referral Form*
In the above sample, the first row contains no data - it is a header under which all of the documents for this one person are collected.

Row 2 contains information included in the Client Profile - we typically refer to this row as the Parent.

Row 3 contains the information about a specific Contact. It is indented below the Parent and we refer to this as the Child document .

To connect the Parent and Child, the Parent has a unique identifier
NT000201 EA 
0N842571 FE DE49485 
0 F714C469A 8 AD484 
DB842574Dg 006FD353
and the Child has a field $REF
— Child Profile 
8 Oct 2015 'Contact Record' HiqJ 
+25 Aug 2015 
18 May2013 
25 Feb 2008 
Apr 2006 
'Contact Record' M 
'Continuation S 
*Contact Record* 
'Contact Record' 3 
'Contact Record* 4 - 
SLIpdatad8y 
Abuse Type 
Abu se TypeOther 
Abuse Where 
Adoptive Lookup DB 
Adoptive Name 
AdootiveStraet 
Rafarance List 
Data Length: 18 bytes 
Seq Num: 2 
Dup iam ID: 
Reid Flags: SUMMARY 
F714C46SA 888A0484- 
NU2571

In this example, 8 Oct 2015 Contact Record and the 25 Aug 2015 are both Children of the Child Profile (Parent Document).

The 10 Jun 10 2013 Continuation Sheet is a Child of  25 Aug  2015 Contact Record.

If we create a View with on Contact Records - then we no longer have the information about the Child Profile. 

Now it gets interesting
We can export a View of  Child Profiles which includes the unique identifier and a View of Contact Records which includes the value in the $REF field. So now we have a link to join the CSV files. It will get more interesting when we connect the the Child document to another Child Document.

Now we have to accommodate the other types of documents: Collateral Contact; CARE ORDER; Referral Form; Correspondence; . . . .

Just for fun, some of the Microsoft Word documents launch specific templates in Word.

Conclusion
While a simple export can be completed in minutes because of the sophistication of Lotus Notes exporting data can also be a major project.


Author's Background
I am a Notes/Consultant with twenty-seven years of experience (almost exclusively with Lotus Notes / Domino). My experience with Notes began when I worked as a Senior Computer Consultant for Price Waterhouse. In 1993, I went to work for Lotus Development Corporation as a Senior Notes / Domino Instructor. I started teaching Application Development and System Administration with Version 3. Helped to develop the course materials for Version 4.x and Release 5.x When LotusScript, Javascript and Java were added to Notes/Domino I started teaching these programming languages.

In 1995, IBM acquired Lotus. For several years we were left alone and the culture did not change. It was a lot of fun to work for Lotus. In 1999 the handwriting was on the wall and I decided it was time for me to leave. So I established V&M to do Lotus Notes/Domino Application Development, System Administration and Training. I've been at it ever since. The life of the consultant is constantly changing. It has given me the chance to travel across Canada and the United States, Scotland, England, Bermuda, Jamaica, Barbados and Hawaii. No travel to the Far East yet. Anyone?

For the last seven years I have been helping companies move their data from Lotus Notes to the Microsoft platform.

Some thoughts on Notes to Exchange Migrations
Migrating from Lotus Notes to Microsoft - Very easy and very hard
Pre- Migration Report that I use
Encrypted Mail Choices
Export a Notes View to CSV
Mail Migrations Using the Cloud
Mail Migrations - Some Lessons Learned
Speeding Some Migrations
Redirecting Mail Migration Traffic
One post migration story
One Approach to Mail Rules
Remove Encryption Button
Microsoft's "Secret" Mail Migration Tool
NME Migrations from a secondary Domino Directory
How to remove encryption from a Notes database
NME and Secondary Address Book
Multi File Selector for Binary Tree CMTe
Problem Mail Files for NME (Notes Migrator for Exchange)
Using a Staging Server for Notes to Exchange migrations
SmartCloud to Office 365
Notes2SharePoint Part 1
Migrating Private Folders
Different roles in an email migrations
What to do with Profile Docs during a Migration

If you would like to see my resume
Click Here


Email John


Copyright 1999-2017, John Vanderhoff. All rights reserved. This document is NOT in the public domain and remains the property of John Vanderhoff. Distribution or modification of this document without the knowledge, review and express permission of John Vanderhoff is strictly prohibited.