From 2271ad00c7e0312071b78706da40a778171bfb9a Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 16 Jul 2021 18:14:55 -0300 Subject: Refactor database files Change-Id: I10909197c08cec40819658d2d0951800133409da Reviewed-on: https://gerrit.libreoffice.org/c/help/+/119099 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- AllLangHelp_sdatabase.mk | 5 ++ AllLangHelp_shared.mk | 5 -- source/text/sdatabase/dabadoc.xhp | 38 +++++++++++ source/text/sdatabase/dabaprop.xhp | 41 ++++++++++++ source/text/sdatabase/dabapropadd.xhp | 73 ++++++++++++++++++++ source/text/sdatabase/dabapropcon.xhp | 46 +++++++++++++ source/text/sdatabase/dabapropgen.xhp | 73 ++++++++++++++++++++ source/text/shared/01/01010000.xhp | 2 +- source/text/shared/explorer/database/dabadoc.xhp | 38 ----------- source/text/shared/explorer/database/dabaprop.xhp | 44 ------------ .../text/shared/explorer/database/dabapropadd.xhp | 78 ---------------------- .../text/shared/explorer/database/dabapropcon.xhp | 49 -------------- .../text/shared/explorer/database/dabapropgen.xhp | 78 ---------------------- source/text/shared/explorer/database/dabawiz00.xhp | 2 +- .../text/shared/explorer/database/menufilesave.xhp | 2 +- source/text/shared/guide/data_register.xhp | 2 +- source/text/shared/guide/data_view.xhp | 2 +- 17 files changed, 281 insertions(+), 297 deletions(-) create mode 100644 source/text/sdatabase/dabadoc.xhp create mode 100644 source/text/sdatabase/dabaprop.xhp create mode 100644 source/text/sdatabase/dabapropadd.xhp create mode 100644 source/text/sdatabase/dabapropcon.xhp create mode 100644 source/text/sdatabase/dabapropgen.xhp delete mode 100644 source/text/shared/explorer/database/dabadoc.xhp delete mode 100644 source/text/shared/explorer/database/dabaprop.xhp delete mode 100644 source/text/shared/explorer/database/dabapropadd.xhp delete mode 100644 source/text/shared/explorer/database/dabapropcon.xhp delete mode 100644 source/text/shared/explorer/database/dabapropgen.xhp diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index 337313b72e..23346f8c9d 100644 --- a/AllLangHelp_sdatabase.mk +++ b/AllLangHelp_sdatabase.mk @@ -48,6 +48,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\ helpcontent2/source/text/sdatabase/dabaadvpropdat \ helpcontent2/source/text/sdatabase/dabaadvpropgen \ helpcontent2/source/text/sdatabase/dabaadvprop \ + helpcontent2/source/text/sdatabase/dabadoc \ + helpcontent2/source/text/sdatabase/dabaprop \ + helpcontent2/source/text/sdatabase/dabapropadd \ + helpcontent2/source/text/sdatabase/dabapropcon \ + helpcontent2/source/text/sdatabase/dabapropgen \ )) # vim: set noet sw=4 ts=4: diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk index ef4b88e0b5..107c8b1a52 100644 --- a/AllLangHelp_shared.mk +++ b/AllLangHelp_shared.mk @@ -865,11 +865,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ )) $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ - helpcontent2/source/text/shared/explorer/database/dabadoc \ - helpcontent2/source/text/shared/explorer/database/dabaprop \ - helpcontent2/source/text/shared/explorer/database/dabapropadd \ - helpcontent2/source/text/shared/explorer/database/dabapropcon \ - helpcontent2/source/text/shared/explorer/database/dabapropgen \ helpcontent2/source/text/shared/explorer/database/dabawiz00 \ helpcontent2/source/text/shared/explorer/database/dabawiz01 \ helpcontent2/source/text/shared/explorer/database/dabawiz02 \ diff --git a/source/text/sdatabase/dabadoc.xhp b/source/text/sdatabase/dabadoc.xhp new file mode 100644 index 0000000000..4ed6c6b95b --- /dev/null +++ b/source/text/sdatabase/dabadoc.xhp @@ -0,0 +1,38 @@ + + + + + + + + + Database File + /text/sdatabase/dabadoc.xhp + + + +
+

Database File

+ The database file window organizes the tables, views, queries, and reports of a database in %PRODUCTNAME. +
+
+ Working with databases in %PRODUCTNAME +
+ +
diff --git a/source/text/sdatabase/dabaprop.xhp b/source/text/sdatabase/dabaprop.xhp new file mode 100644 index 0000000000..8539d3008a --- /dev/null +++ b/source/text/sdatabase/dabaprop.xhp @@ -0,0 +1,41 @@ + + + + + +Database Properties +/text/sdatabase/dabaprop.xhp + + +UFI: Database Properties dialog + + + +
+

Database Properties

+Specifies the properties of a database. +
+
+In a database window, choose Edit - Database - Properties + +
+ + + +
diff --git a/source/text/sdatabase/dabapropadd.xhp b/source/text/sdatabase/dabapropadd.xhp new file mode 100644 index 0000000000..677f14a7bb --- /dev/null +++ b/source/text/sdatabase/dabapropadd.xhp @@ -0,0 +1,73 @@ + + + + + +Additional Settings +/text/sdatabase/dabapropadd.xhp + + + +
+

Additional Settings

+Specifies additional options for a data source. +
+
+In a database window, choose Edit - Database - Properties, click Additional Settings tab +
+The availability of the following controls depends on the type of database: +

Host name

+Enter the host name of the server that contains the database, for example ldap.server.com.used for multiple database formats +

Port number

+Enter the port number for the server that hosts the database.UFI: used for LDAP and MySQL, different default values +

MySQL JDBC driver class

+Enter the name of the JDBC driver for the MySQL database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??) +

Character setUFI: seen for dBaseand for text file folder

+Select the character set that you want to use to view the database in $[officename]. This setting does not affect the database. To use the default character set of your operating system, select "System". +Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.UFI. copied from shared\explorer\database\11020000.xhp +

Oracle JDBC driver class

+Enter the name of the JDBC driver for the Oracle database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??) +

Driver settings

+Specify additional driver options.UFI. copied from shared\explorer\database\11020000.xhp +

Use catalog for file-based databases

+Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.UFI. copied from shared\explorer\database\11020000.xhp +

Base DN

+Enter the starting point to search the LDAP database, for example, dc=com.copied from shared\explorer\database\11190000.xhp +

Maximum number of records

+Enter the maximum number of records that you want to load when you access the LDAP server. +

Display deleted records as wellUFI: seen for dBase, but Help ID is somewhere else

+Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.copied from shared\explorer\database\11030000.xhp +In dBASE format, deleted records remain in the file. +To view changes that you make to the database, close the connection to the database, and then reconnect to the database. +

IndexesUFI: seen for dBase

+Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database.UFI: removed link from extended help text +

Text contains headersUFI: the following found for a text file folder, but HELP Ids are somewhere else

+Select this check box if the first line of the text file contains field names.copied from shared\explorer\database\11040000.xhp +

Field separator

+Enter or select the character that separates data fields in the text file. +

Text separator

+Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator. +

Decimal separator

+Enter or select the character that is used as a decimal separator in the text file, for example, a period (0.5) or a comma (0,5). +

Thousands separator

+Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a period (1.000). +

File extension

+Select the format for the text file. The extension that you select affects some of the default settings in this dialog. + +
diff --git a/source/text/sdatabase/dabapropcon.xhp b/source/text/sdatabase/dabapropcon.xhp new file mode 100644 index 0000000000..14a79b016a --- /dev/null +++ b/source/text/sdatabase/dabapropcon.xhp @@ -0,0 +1,46 @@ + + + + + +Connection Type Wizard +/text/sdatabase/dabapropcon.xhp + + +Connection Type Wizard + + + +
+

Connection Type Wizard

+Changes the type of connection for the current database. +
+
+In a database window, choose Edit - Database - Connection Type + +
+The Connection Type Wizard consists of three pages. You cannot transfer all settings from one database type to another.UFI: what does this para mean? Who writes such &/()? +For example, you can use the wizard to open a database file that is in a format that is usually not recognized by an installed database.UFI: what does this para mean? Who writes such &/()? + +

Database type

+Select the type of database that you want to connect to. + + + +
diff --git a/source/text/sdatabase/dabapropgen.xhp b/source/text/sdatabase/dabapropgen.xhp new file mode 100644 index 0000000000..c1f1f398d8 --- /dev/null +++ b/source/text/sdatabase/dabapropgen.xhp @@ -0,0 +1,73 @@ + + + + + +Advanced Properties +/text/sdatabase/dabapropgen.xhp + + + +
+

Advanced Properties

+Specifies some options for a database. +
+
+In a database window, choose Edit - Database - Properties, click Advanced Properties tab +
+The availability of the following controls depends on the type of database: +

Path to dBASE filesUFI: found for dBase

+Enter the path to the directory that contains the dBASE files. +Ensure that the *.dbf file name extension of the dBASE files is lowercase.moved from shared\explorer\database\11030000.xhp +

BrowseUFI: found for dBase

+Opens a dialog where you can select a file or a directory.which one? or depends? +

Test ConnectionUFI: found for dBaseand for Calc doc

+Tests the database connection with the current settings. +

Path to the text filesUFI: found for text file folder

+Enter the path to the folder of the text files. +

Path to the spreadsheet documentUFI: found for a Calc doc

+Enter the path to the spreadsheet document that you want to use as a database. +

Name of the ODBC data source on your system

+Enter the name of the ODBC data source. +

User name

+Enter the user name that is required to access the database. +

Password requiredUFI: found for Calc doc

+If checked, the user will be asked to enter the password that is required to access the database. +

Name of the databaseUFI: found for JDBC

+Enter the name of the database. +

Name of the MySQL database

+Enter the name of the MySQL database that you want to use as a data source. +

Name of the Oracle database

+Enter the name of the Oracle database that you want to use as a data source. +

Microsoft Access database file

+Enter the name of the Microsoft Access database file that you want to use as a data source. +

Host name

+Enter the host name for the LDAP data source. +

Data source URL

+Enter the location of the JDBC data source as a URL. + +

JDBC driver class

+Enter the name of the JDBC driver class that connects to the data source. + +

Test ClassUFI: found for JDBC

+Tests the database connection through the JDBC driver class. +

Choose a database

+Select a database from the list or click Create to create a new database. + +
diff --git a/source/text/shared/01/01010000.xhp b/source/text/shared/01/01010000.xhp index f70edac47c..fb357cdd54 100644 --- a/source/text/shared/01/01010000.xhp +++ b/source/text/shared/01/01010000.xhp @@ -105,7 +105,7 @@ Database - Opens the Database Wizard to create a database file. + Opens the Database Wizard to create a database file. diff --git a/source/text/shared/explorer/database/dabadoc.xhp b/source/text/shared/explorer/database/dabadoc.xhp deleted file mode 100644 index d3d785f4a0..0000000000 --- a/source/text/shared/explorer/database/dabadoc.xhp +++ /dev/null @@ -1,38 +0,0 @@ - - - - - - - - - Database File - /text/shared/explorer/database/dabadoc.xhp - - - -
- Database File - The database file window organizes the tables, views, queries, and reports of a database in %PRODUCTNAME. -
-
- Working with databases in %PRODUCTNAME -
- -
\ No newline at end of file diff --git a/source/text/shared/explorer/database/dabaprop.xhp b/source/text/shared/explorer/database/dabaprop.xhp deleted file mode 100644 index 6e85496cce..0000000000 --- a/source/text/shared/explorer/database/dabaprop.xhp +++ /dev/null @@ -1,44 +0,0 @@ - - - - - - - - -Database Properties -/text/shared/explorer/database/dabaprop.xhp - - -UFI: Database Properties dialog - - - -
-Database Properties -Specifies the properties of a database. -
-
-In a database window, choose Edit - Database - Properties - -
- - - -
diff --git a/source/text/shared/explorer/database/dabapropadd.xhp b/source/text/shared/explorer/database/dabapropadd.xhp deleted file mode 100644 index 1c603813d6..0000000000 --- a/source/text/shared/explorer/database/dabapropadd.xhp +++ /dev/null @@ -1,78 +0,0 @@ - - - - - - - - - - -Additional Settings -/text/shared/explorer/database/dabapropadd.xhp - - - -
-Additional Settings -Specifies additional options for a data source. -
-
-In a database window, choose Edit - Database - Properties, click Additional Settings tab -
-The availability of the following controls depends on the type of database: -Host name -Enter the host name of the server that contains the database, for example ldap.server.com.used for multiple database formats -Port number -Enter the port number for the server that hosts the database.UFI: used for LDAP and MySQL, different default values -MySQL JDBC driver class -Enter the name of the JDBC driver for the MySQL database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??) -Character setUFI: seen for dBaseand for text file folder -Select the character set that you want to use to view the database in $[officename]. This setting does not affect the database. To use the default character set of your operating system, select "System". -Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.UFI. copied from shared\explorer\database\11020000.xhp -Oracle JDBC driver class -Enter the name of the JDBC driver for the Oracle database.UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??) -Driver settings -Specify additional driver options.UFI. copied from shared\explorer\database\11020000.xhp -Use catalog for file-based databases -Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.UFI. copied from shared\explorer\database\11020000.xhp -Base DN -Enter the starting point to search the LDAP database, for example, dc=com.copied from shared\explorer\database\11190000.xhp -Maximum number of records -Enter the maximum number of records that you want to load when you access the LDAP server. -Display deleted records as wellUFI: seen for dBase, but Help ID is somewhere else -Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.copied from shared\explorer\database\11030000.xhp -In dBASE format, deleted records remain in the file. -To view changes that you make to the database, close the connection to the database, and then reconnect to the database. -IndexesUFI: seen for dBase -Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database.UFI: removed link from extended help text -Text contains headersUFI: the following found for a text file folder, but HELP Ids are somewhere else -Select this check box if the first line of the text file contains field names.copied from shared\explorer\database\11040000.xhp -Field separator -Enter or select the character that separates data fields in the text file. -Text separator -Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator. -Decimal separator -Enter or select the character that is used as a decimal separator in the text file, for example, a period (0.5) or a comma (0,5). -Thousands separator -Enter or select the character that is used as a thousands separator in the text file, for example a comma (1,000), or a period (1.000). -File extension -Select the format for the text file. The extension that you select affects some of the default settings in this dialog. - -
diff --git a/source/text/shared/explorer/database/dabapropcon.xhp b/source/text/shared/explorer/database/dabapropcon.xhp deleted file mode 100644 index 87b7f9a5f8..0000000000 --- a/source/text/shared/explorer/database/dabapropcon.xhp +++ /dev/null @@ -1,49 +0,0 @@ - - - - - - - - -Connection Type Wizard -/text/shared/explorer/database/dabapropcon.xhp - - -Connection Type Wizard - - - -
-Connection Type Wizard -Changes the type of connection for the current database. -
-
-In a database window, choose Edit - Database - Connection Type - -
-The Connection Type Wizard consists of three pages. You cannot transfer all settings from one database type to another.UFI: what does this para mean? Who writes such &/()? -For example, you can use the wizard to open a database file that is in a format that is usually not recognized by an installed database.UFI: what does this para mean? Who writes such &/()? - -Database type -Select the type of database that you want to connect to. - - - -
diff --git a/source/text/shared/explorer/database/dabapropgen.xhp b/source/text/shared/explorer/database/dabapropgen.xhp deleted file mode 100644 index a23d46edca..0000000000 --- a/source/text/shared/explorer/database/dabapropgen.xhp +++ /dev/null @@ -1,78 +0,0 @@ - - - - - - - - - - -Advanced Properties -/text/shared/explorer/database/dabapropgen.xhp - - - -
-Advanced Properties -Specifies some options for a database. -
-
-In a database window, choose Edit - Database - Properties, click Advanced Properties tab -
-The availability of the following controls depends on the type of database: -Path to dBASE filesUFI: found for dBase -Enter the path to the directory that contains the dBASE files. -Ensure that the *.dbf file name extension of the dBASE files is lowercase.moved from shared\explorer\database\11030000.xhp -BrowseUFI: found for dBase -Opens a dialog where you can select a file or a directory.which one? or depends? -Test ConnectionUFI: found for dBaseand for Calc doc -Tests the database connection with the current settings. -Path to the text filesUFI: found for text file folder -Enter the path to the folder of the text files. -Path to the spreadsheet documentUFI: found for a Calc doc -Enter the path to the spreadsheet document that you want to use as a database. -Name of the ODBC data source on your system -Enter the name of the ODBC data source. -User name -Enter the user name that is required to access the database. -Password requiredUFI: found for Calc doc -If checked, the user will be asked to enter the password that is required to access the database. -Name of the databaseUFI: found for JDBC -Enter the name of the database. -Name of the MySQL database -Enter the name of the MySQL database that you want to use as a data source. -Name of the Oracle database -Enter the name of the Oracle database that you want to use as a data source. -Microsoft Access database file -Enter the name of the Microsoft Access database file that you want to use as a data source. -Host name -Enter the host name for the LDAP data source. -Data source URL -Enter the location of the JDBC data source as a URL. - -JDBC driver class -Enter the name of the JDBC driver class that connects to the data source. - -Test ClassUFI: found for JDBC -Tests the database connection through the JDBC driver class. -Choose a database -Select a database from the list or click Create to create a new database. - -
diff --git a/source/text/shared/explorer/database/dabawiz00.xhp b/source/text/shared/explorer/database/dabawiz00.xhp index 1bc61f46e0..bb1cb6d646 100644 --- a/source/text/shared/explorer/database/dabawiz00.xhp +++ b/source/text/shared/explorer/database/dabawiz00.xhp @@ -39,7 +39,7 @@

Database Wizard

The Database Wizard creates a database file that contains information about a database.UFI: extended help text must no longer contain switches or links -The Database Wizard creates a database file that contains information about a database. +The Database Wizard creates a database file that contains information about a database. Depending on the type of operation and the type of database, the Database Wizard consists of a varying number of steps. diff --git a/source/text/shared/explorer/database/menufilesave.xhp b/source/text/shared/explorer/database/menufilesave.xhp index 4cec435100..304a40d474 100644 --- a/source/text/shared/explorer/database/menufilesave.xhp +++ b/source/text/shared/explorer/database/menufilesave.xhp @@ -30,7 +30,7 @@ Save -In this dialog, you can specify the position and name of a form UFI: spec says also for report, but reports can be created only by Wizard and are autosaved thereUFI: spec says also for query, cannot verifythat you save within a database file. The dialog opens automatically when you save a form the first time.UFI: no chance to open the dialog a second time +In this dialog, you can specify the position and name of a form UFI: spec says also for report, but reports can be created only by Wizard and are autosaved thereUFI: spec says also for query, cannot verifythat you save within a database file. The dialog opens automatically when you save a form the first time.UFI: no chance to open the dialog a second time Create New Directory Click to create a new folder within the database file. diff --git a/source/text/shared/guide/data_register.xhp b/source/text/shared/guide/data_register.xhp index 62f72b4aac..cbeaf9cb81 100644 --- a/source/text/shared/guide/data_register.xhp +++ b/source/text/shared/guide/data_register.xhp @@ -35,7 +35,7 @@ lists;registered databases (Base) mw deleted "removing;...". New entry "lists;" from shared/optionen/01160200.xhpRegistering and Deleting a Database -Data from any database file can be registered to the installed instance of %PRODUCTNAME. To register means to tell %PRODUCTNAME where the data is located, how it is organized, how to get that data, and more. Once the database is registered, you can use the menu command View - Data source to access the data records from your text documents and spreadsheets. +Data from any database file can be registered to the installed instance of %PRODUCTNAME. To register means to tell %PRODUCTNAME where the data is located, how it is organized, how to get that data, and more. Once the database is registered, you can use the menu command View - Data source to access the data records from your text documents and spreadsheets. To register an existing database file: diff --git a/source/text/shared/guide/data_view.xhp b/source/text/shared/guide/data_view.xhp index 64d6532eca..3572ac9f12 100644 --- a/source/text/shared/guide/data_view.xhp +++ b/source/text/shared/guide/data_view.xhp @@ -41,7 +41,7 @@ Choose File - Open to open the database file. -The database file gives you full access to tables, queries, reports, and forms. You can edit the structure of your tables and change the contents of the data records. +The database file gives you full access to tables, queries, reports, and forms. You can edit the structure of your tables and change the contents of the data records. Choose View - Data source to view the registered databases. -- cgit