Bug 148495 - Connect to an existing database drop-down list in Database Wizard should be alphabetically sorted
Summary: Connect to an existing database drop-down list in Database Wizard should be a...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevAdvice
Depends on:
Blocks: Database-Wizard
  Show dependency treegraph
 
Reported: 2022-04-10 15:35 UTC by Roman Kuznetsov
Modified: 2022-04-13 10:06 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2022-04-10 15:35:57 UTC
Description:
Connect to an existing database drop-down list should be alphabeticcaly sorted

Today it looks so:

JDBC
Oracle JDBC
ADO
Microsoft Access
Microsoft Access 2007
Spreadsheet
dBase
Firebird External
Text
MySQL/MariaDB
ODBC
PostgreSQL
Writer Document

But should looks like:

ADO
dBase
Firebird External
JDBC
Microsoft Access
Microsoft Access 2007
MySQL/MariaDB
ODBC
Oracle JDBC
PostgreSQL
Spreadsheet
Text
Writer Document



Steps to Reproduce:
1. Open LibreOffice
2. Select File->New->Database (it opens the Database wizard)
3. Select Connect to an existing database radiobutton
4. Select the drop-down list below and look at it (see Description above)

Actual Results:
Connect to an existing database drop-down list in Database Wizard isn't alphabeticcaly sorted

Expected Results:
Connect to an existing database drop-down list in Database Wizard is alphabeticcaly sorted


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: ccb78b98e0618cce365562fe326d018892b8104a
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL Jumbo
Comment 1 Heiko Tietze 2022-04-11 10:06:44 UTC
Looks like some kind of sorting is done here. Wonder what difference is between JDBC vs. Oracle JDBC, the various MSO formats, what exactly Spreadshseet means (if LibreOffice Calc we should label it so and Writer as well).

So before sorting, which is not a bad idea, we have to clarify the options. 

=> needsDevAdvice
Comment 2 Lionel Elie Mamane 2022-04-11 10:31:16 UTC
(In reply to Heiko Tietze from comment #1)
> Wonder what difference is between JDBC vs. Oracle JDBC,

"Oracle JDBC" is probably just Libreoffice's SDBC-JDBC driver with some (all?) settings hardcoded to what is know to be working/correct with Oracles' JDBC driver. Which is also what the "MySQL/MariaDB JDBC" option is (which you get after choosing MySQL/MariaDB and clicking next, you get a new choice between native, JDBC and ODBC).

> the various MSO formats

Probably ".mdb" and ".accdb", respectively. Similarly, those are thin wrappers around the ADO support, IIRC.

> what exactly Spreadshseet means

Probably "any file format supported by LibreOffice Calc". That includes "Text", but would be using the "Text" file through LibreOffice Calc, instead of through native Base/SDBC support.
Comment 3 Alex Thurgood 2022-04-13 09:43:09 UTC
FWIW, there is/was also an ongoing discussion about how to reorganise (or not) the MySQL/MariaDB entry, i.e. whether or not to put everything into the main, first dialog, or leave it as present in a secondary dialog which only appears if MySQL/MariaDB is selected in the first window.

See, for example :

bug 128950

But also see the related discussions around what to put in the first dialog:

bug 127665
bug 148192
Comment 4 Alex Thurgood 2022-04-13 09:49:29 UTC
If anyone is going to tackle this, please make sure that it is consistent throughout - there are multiple entry points for displaying the list of possible database connection types.
Comment 5 Alex Thurgood 2022-04-13 09:54:04 UTC
(In reply to Heiko Tietze from comment #1)

> 
> So before sorting, which is not a bad idea, we have to clarify the options. 
> 
> => needsDevAdvice

@Heike : I believe you already started looking at the Spreadsheet page in bug 148499 ?
Comment 6 Heiko Tietze 2022-04-13 10:06:57 UTC
(In reply to Alex Thurgood from comment #5)
> @Heike : I believe you already started looking at the Spreadsheet page in
> bug 148499 ?

Not beyond adding the code pointer