Select Data Source Dialog

OpenOffice 2.0 and StarOffice 8

Document - ID	Specification Owner	Last Change	Status
	Frank Loehmann	23.02.04	Final
Conforms to	StarOffice Specification Workflow v0.1, Aug 2003
Applies to	Calc
Task ID(s)	110350
Category	Bug/Feature

Abstract

The Select Data Source Dialog has been reworked to add the possibility of selecting database files, which are not connected as a data source. Furthermore the login dialog behavior and some strings have been changed to improve usability.

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	Niklas Nebel	Niklas.nebel@sun.com
Quality Assurance	Christoph Lukasiak	Christoph.Lukasiak@sun.com
Documentation	Uwe Fischer	Uwe.fischer@sun.com

Approved for Implementation

	Approved by	Date
User Experience	Frank Loehmann	23.02.04
Development	Ocke Jansen	03.03.04
Quality Assurance	Christoph Lukasiak	23.02.04
Documentation	Uwe Fischer	23.02.04
String Review	Elizabeth Matthis	17.03.04

Document Change History

Rev. Level	Change	Initials	Date
1.0	Work on 1. draft of document	FL	19.02.04
1.1	Finalization	FL	23.02.04
1.2	Work on review feedback from Ocke	FL	03.03.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	Competitive Analyses	1

5.1	Dialogs in OpenOffice.org 1.1	1

6	Detailed Specification	2

6.1	G11n	3

6.2	Error Conditions	3

7	Future Tasks	3

8	Notes	4

9	References	4

Motivation

This only a small bug fix. Please see bug #110350 for details. 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

Competitive Analyses

Dialogs in OpenOffice.org 1.1

The following dialog appears if Data – Data Pilot – Start is chosen.

Illustration 1 Select Source Dialog – OO.org 1.1

Illustration 2 Select Data Source - OO.org 1.1

If the first entry in the data base list box requires a password legitimation, the password dialog appears before the Select Data Source dialog appears. So the user does not know why he has to enter a password.

Illustration 3 Open Type list box: Sheet is misleading -> Table - OO.org 1.1

Detailed Specification

The data source dialog in Calc changes as follows.

String changes:

Item	English	German	Comments
Label	~Data source	~Datenquelle	Previously “Database”
List Box Item	T~able	T~abelle	Previously “Sheet ”
List Box Item	S~election	A~uswahl	Previously “Data source”
Label	Statement	Befehl	Translate in the sense of SQLstatement
Button	~Browse...	~Durchsuchen...	New GUI item

The Password Dialog appears above/after the Select Data Source Dialog, if a password legitimation is needed for a data base/source

Dialog changes for Select Data Source dialog:

Illustration 4 New Select Data Source dialog – Type: Table or Query

The Type list box shows Table (previously “Sheet”) and the unchanged entries Query, SQL and SQL [Native]. The Select list box is enabled if the Table or Query entry is chosen in the Type list box. The Statement edit is only enabled if SQL or SQL [Native] is chosen.

Illustration 5 New Select Data Source dialog – Type: SQL or SQL[native]

The Browse button calls a File Open dialog, where the user can choose and open a data base file. The data source list box then shows the file name of the database in the following format “My private Addresses.sxb (<URL path without filename>)”. The URL path is only shown, if there are two data base files in the Data source list box with an equal file name (from different sources). If the chosen filename is already present, the item gets selected on opening the database file.

If a list box item is too long to be shown within the control completely, a tip help appears on such an entry .

Database files which have been added to the Data source list box will be kept for runtime of OO.org.

Due to the new possibility to choose a database files as data source, the string “Data source registered in %PRODUCTNAME” is changed to “Data Source” as shown below:

Illustration 6 Select Source dialog

Item	English	German	Comments
Option	~Data source	~Datenquelle	Previously “Data source registered in %PRODUCTNAME”

G11n

n/a

Error Conditions

n/a

Future Tasks

n/a

Notes

n/a

References

n/a

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

List box do support those tip helps for cropped text of list items. Please ask Malte Timmermann.

Select Data Source Dialog

Page 5

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

Frank Loehmann

2004-02-19T08:54:13

Matthias Müller-Prove

Elizabeth Matthis