OpenOffice.org Mozilla/Thunderbird Address Book Access Enhance

Database

Document - ID	Specification Owner	Last Change	Status
	Wind Li	02/02/05	Draft 1.0
Conforms to	
Applies to	Database Application
Task ID(s)	I20088,i20081
Category	Feature

Abstract

Feature to add Thunderbird AddressBook support and multiple Mozilla profiles support to OpenOffice.org . Users can select a profile from a list and use it access to Mozilla or Thunderbird address books.

i-Team Members (The specification owner is part of the i-Team)

	Name	E-mail Address
User Experience	Christian Jansen	cj@openoffice.org
Development	Wind Li	windly@openoffice.org
Quality Assurance	Marc Neumann	msc@openoffice.org
Documentation	Uwe Fischer	ufi@openoffice.org

Approved for Implementation

	Approved by	Date
User Experience	Christian Jansen	02/02/05
Development	Wind Li	02/02/05
Quality Assurance	Marc Neumann	01/31/05
Documentation	Uwe Fischer	01/31/05
String Review	Elizabeth Matthis	02/01/05

Document Change History

Rev. Level	Change	Initials	Date
0.1	First draft 0.1	windly	01/31/05
0.2		windly	01/31/05
0.3	Change StarOffice to OpenOffice.org	windly	01/31/05
0.4	Many Changes suggested by Franks	windly	02/01/05
1.0	Approved by i-team	windly	02/02/05

Contents

1.Glossary	1

2.Motivation	1

3.User Scenarios	1

4.Goals	1

5.Requirements and Dependencies	1

6.Competitive Analyses	1

7.Detailed Specification	1

8.Database Types Added	2

9.The properties dialog changed	2

10.Thunderbird Address Book Behavior	4

11.References	5

1.Glossary

Term	Description
Thunderbird	Product Name. Mozilla's next generation e-mail client.
Mozilla Profile Name	The names of Mozilla profiles. Mozilla can have multiple profiles, but each profile must have an unique name.
Thunderbird Profile Name	The names of Thunderbird profiles. Thunderbird can have multiple profiles, but each profile must have an unique name.

2.Motivation

Thunderbird 1.0 has been released. It is supposed to be the next major email client. So we should support read and write Thunderbird address books in OpenOffice.org . We should support switch Mozilla profiles at runtime too.

3.User Scenarios

A user has Mozilla or Thunderbird installed. She uses different profiles to access different mails. She has a profile named Business and another one named Personal. She needs OpenOffice.org to print envelops for both his friends listed in the Personal address books and his partners listed in Business profile.

4.Goals

Support accessing Thunderbird address books in OpenOffice.org . Support accessing more then one Mozilla/Thunderbird profiles at the same time in OpenOffice.org .

5.Requirements and Dependencies

No.

6.Competitive Analyses

Currently we can access Mozilla address books in OpenOffice.org, but we cannot access Thunderbird address books. And we cannot switch Mozilla profiles at runtime.

7.Detailed Specification

This Specification is base on Data Source Property dialog.

8.Database Types Added

In Data Source Property dialog. Section 4.1, there definds a lots of database format. To support Thunderbird address books, we need add this one to the list:

Thunderbird Address Book

9.The properties dialog changed

As defineded in Data Source Property dialog Section 4.2.1, Mozilla Address Book does not not need additional information to connect to the database, the “General” page must only state a text that there is no more information needed. But now, it not the case. We need Mozilla Profile Name now. The “General” page should look like this:

The “General” page of the Mozilla Address Book connection settings

Illustration 1:Mozilla Address Book Database properties dialog

When the Browse button pressed we will popup a:

Mozilla Profiles Selecting Dialog.

All the Mozilla profiles of this user will be list in the list box. If users does not given a profile name in the “General” page or there isn't a profile has the given name, the default profile will be selected in the list box. Illustration 2: Mozilla Profiles Selecting Dialog

Thunderbird is derived from Mozilla, it supports multiple profiles too.

The “General” page of the Thunderbird Address Book connection settings page

Illustration 3: Thunderbird Address Book Database properties dialog

Like Mozilla, we popup a profiles selecting dialog when the browse button pressed.

Thunderbird Profiles Selecting Dialog.

Illustration 4: Thunderbird Profile Selecting Dialog

The 'Additional Settings' page

Mozilla and Thunderbird Address Book both don't have the 'Additional Settings' page.

File|New|Database wizard

We do not nclide the profile selection in the File|New|Database wizard. We will leave the profile name null and the driver will then use the default profile to access Mozilla/Thunderbird address books. The benifit of this behavior is that we can share the created database documents between two users who give the Mozilla profiles diffrent names. If users want to use a none default profile, he/she must use Edit|Database|Properties to choose one.

<String Lists>

String list

Item	English	German	Comments
FixedText	~Mozilla profile name	Name des ~Mozilla Benutzerprofils	
FixedText	~Thunderbird profile name	Name des ~Thunderbird Benutzerprofils	
ListBox entry	Thunderbird address book	Thunderbird Adressbuch	

10.Thunderbird Address Book Behavior

In background we use the same driver to handle Mozilla address books and Thunderbird address books, so they will have the same behavior.

The table struct is read only. You cannot change a table's define or create a new table.

An unlocked profile is writable. If you are not using Thunderbird with the same profile, you can modify/insert/delete address entries in the profile.

An lock profile is read only.

LDAP directories are always readonly.

All lists in the address books will be showed as database views.

You can get more information from http://dba.openoffice.org/specifications/Write_Access_To_AddressBooks.sxw .

11.References

TaskID:i20088,i20081

CWS: mozab05

New Data Source Property dialog: http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw

Write Access To Mozilla AddressBooks:

http://dba.openoffice.org/specifications/Write_Access_To_AddressBooks.sxw

OpenOffice.org Mozilla/Thunderbird Address Book Access Enhance

Page 3

http://dba.openoffice.org/specifications/Thunderbird_ab.sxw

Elizabeth Matthis

2004-12-06T17:40:14