Select Data Source Dialog

OpenOffice 2.0 and StarOffice 8

Document - ID	Specification Owner	Last Change	Status
	Frank Loehmann	03.05.04	Final
Conforms to	
Applies to	Writer
Task ID(s)	http://www.openoffice.org/issues/show_bug.cgi?id=26301
Category	Bug/Feature

Abstract

The Fields-Database dialog has been reworked to add the possibility of selecting database files, which are not connected as a data source.

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

	Name	E-mail Address
User Experience	Frank Loehmann (FL)	Frank.loehmann@sun.com
Development	Ocke Jansen / (GUI) Oliver Specht	ocke.jansen@sun.com
Quality Assurance	Marc Neumann	marc.neumann@sun.com
Documentation	Uwe Fischer	Uwe.fischer@sun.com

Approved for Implementation

	Approved by	Date
User Experience	Frank Loehmann	12.03.04
Development	Oliver Specht	03.05.04
Quality Assurance	Marc Neumann	30.04.04
Documentation	Uwe Fischer	12.03.04
String Review	Elizabeth Matthis	18.05.04

Document Change History

Rev. Level	Change	Initials	Date
1.0	Work on 1. draft of document	FL	11.03.04
1.1	Work on comments from OS	FL	15.03.04
1.2	Define Browse Button behavior	FL	28.04.04
1.3	Work on comments from FS	FL	28.04.04
1.4	Update link to mail merge spec	FL	29.04.04
1.5	Add i-Team Oks	FL	03.05.04
1.6	Rework dialog after translation has been finished	FL	19.05.04

Contents

1	Motivation	1

2	User Scenarios	1

3	Goals	1

4	Requirements and Dependencies	1

4.1	Requirements	1

4.2	Technical Dependencies	1

5	Detailed Specification	1

5.1	Fields-- Database dialog	1

5.2	Exchange Database Dialog	2

5.3	Browse Button Behavior	3

5.3.1	Add Data Source	3

5.4	G11n	4

5.5	Error Conditions	4

6	Future Tasks	4

7	Notes	4

8	References	4

Motivation

This only a small bug fix. Please also see bug #26301 . A small new feature has been added to be able to connect to database files in the file system additionally to the current data source concept.

User Scenarios

n/a

Goals

n/a

Requirements and Dependencies

Requirements

n/a

Technical Dependencies

n/a

Detailed Specification

The following dialogs are changed:

Fields-- Database dialog

The Database tab page of the fields dialog offers a new browse button to open a database from file.

Illustration 1 Database tab page of Fields dialog

Note: The Browse button behavior is defined in chapter 5.3 on page 3 below.

Strings:

Item	English	German	Comments
Label	Add database file	~Datenbankdatei hinzufügen	
Label	Browse...	~Durchsuchen...	

The Browser button calls a file picker dialog, were a database file can be chosen. The chosen database source will be registered as new data source. The file name is the new database name (without the extension) shown in the dialog shown in Illustration 1 Database tab page of Fields dialog. A tip help shows the path and filename on mouse over.

Exchange Database Dialog

The Exchange Database Dialog offers a new Browse... Dialog to open a database from file.

Illustration 2 Exchange Database dialog in Writer

Note: The Browse button behavior is defined in chapter 5.3 on page 3 below.

Strings:

Item	English	German	Comments
Label	Use the browse button to select a database file.	Benutzen Sie die Durchsuchen Schaltfläche, um eine Datenbankdatei auszuwählen.	

Browse Button Behavior

If the Browse button is pressed in the Exchange Database or in the Fields-Database dialog, a file Open dialog is shown where a database file can be selected. If the database file contains more than one table, the tree control used the dialog Exchange Database Dialog in chapter 5.2 allows to choose a single table.

The following yellow marked sections are taken from the mail merge specification were this behavior has already been described:

Please note that the “<Address Lists>” entries are not valid for this specification and the following strings are different:

String changes:

Item	English	German	Comments
Open dialog title	Select Database	Datenbank auswählen	

Add Data Source

Users can add a data source by clicking 'Add...' button. A file picker appears pointing by default to the My Documents folder. The file type list shall provide the following filter patterns:

<Address Lists>	(& extension list of the file formats listed below )
<Address Lists>	(*.sxb; *.csv; *.sxc; *.xls; *.txt; *.dbf)
<All Files>	(*.*)
%Productname Base [ ]	*.sxb
%Productname Calc	*.sxc
dBase	*.dbf
Microsoft Excel	*.xls
Plain Text	*.txt
Text Comma Separated	*.csv

In the case OpenOffice.org could not open the file a warning shall appear informing the user that this file could not be opened.

String list

Item	English	German	Comments
Title Bar	%PRODUCTNAME %PRODUCTVERSION	%PRODUCTNAME %PRODUCTVERSION	
Text Field	Could not open “C:\xxxx.ttt” because it is not the right kind of format.	„C:\xxxx.ttt“ kann nicht geöfnet werden. Die Datei hat nicht das richtige Format.	
	OK	OK	

The added database files are then registered data sources and are kept until they are getting deleted in the Tools-Option-Database dialog tab.

G11n

n/a

Error Conditions

n/a

Future Tasks

n/a

Notes

n/a

References

Please also see the following specs:

Related issue in Calc.http://specs.openoffice.org/calc/ease-of-use/select_data_source_dialog.sxw

Database application spec.: http://dba.openoffice.org/specifications/Database_application.sxw

http://specs.openoffice.org/calc/ease-of-use/select_data_source_dialog.sxw

If the name is already in use, a number in brackets is added to the name “<Filename without extension> (2)”

http://specs.openoffice.org/writer/mail_merge/mailmerge_specification.sxw#Datasource

OpenOffice.org Base is the working name for the OpenOffice.org Database module introduced with OpenOffice.org 2.0

Select Data Source Dialog

Page 4

http://specs.openoffice.org/writer/database/database_field_dialog.sxw

Frank Loehmann

2004-02-19T08:54:13