From 0703d0cacd74d084009d7f8436fa833c77b56c1f Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 11 Jan 2021 10:27:00 -0300 Subject: Refactor and fix links in database Help Change-Id: Id6a6eabd496ca6c49979e6766081d78274217c4e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109096 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- AllLangHelp_sdatabase.mk | 3 + AllLangHelp_shared.mk | 3 - source/text/sdatabase/05000000.xhp | 42 ++++++++++ source/text/sdatabase/05000001.xhp | 44 ++++++++++ source/text/sdatabase/05000003.xhp | 45 +++++++++++ source/text/shared/01/05340400.xhp | 97 +++++++++++------------ source/text/shared/explorer/database/05000000.xhp | 47 ----------- source/text/shared/explorer/database/05000001.xhp | 49 ------------ source/text/shared/explorer/database/05000003.xhp | 48 ----------- 9 files changed, 180 insertions(+), 198 deletions(-) create mode 100644 source/text/sdatabase/05000000.xhp create mode 100644 source/text/sdatabase/05000001.xhp create mode 100644 source/text/sdatabase/05000003.xhp delete mode 100644 source/text/shared/explorer/database/05000000.xhp delete mode 100644 source/text/shared/explorer/database/05000001.xhp delete mode 100644 source/text/shared/explorer/database/05000003.xhp diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index 05c6b48a9c..591591974b 100644 --- a/AllLangHelp_sdatabase.mk +++ b/AllLangHelp_sdatabase.mk @@ -23,6 +23,9 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\ helpcontent2/source/text/sdatabase/02010101 \ helpcontent2/source/text/sdatabase/04000000 \ helpcontent2/source/text/sdatabase/04030000 \ + helpcontent2/source/text/sdatabase/05000000 \ + helpcontent2/source/text/sdatabase/05000001 \ + helpcontent2/source/text/sdatabase/05000003 \ helpcontent2/source/text/sdatabase/toolbars \ )) diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk index 7f9a707524..5cf886e060 100644 --- a/AllLangHelp_shared.mk +++ b/AllLangHelp_shared.mk @@ -861,9 +861,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ )) $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ - helpcontent2/source/text/shared/explorer/database/05000000 \ - helpcontent2/source/text/shared/explorer/database/05000001 \ - helpcontent2/source/text/shared/explorer/database/05000003 \ helpcontent2/source/text/shared/explorer/database/05010000 \ helpcontent2/source/text/shared/explorer/database/05010100 \ helpcontent2/source/text/shared/explorer/database/05020000 \ diff --git a/source/text/sdatabase/05000000.xhp b/source/text/sdatabase/05000000.xhp new file mode 100644 index 0000000000..694dd0d92a --- /dev/null +++ b/source/text/sdatabase/05000000.xhp @@ -0,0 +1,42 @@ + + + + + +Tables +/text/sdatabase/05000000.xhp + + +Sun Microsystems, Inc. + + + +
+

Tables

+Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records. +
+In the $[officename] Help, you will find further information on the following subjects: +

Create new or edit table design

+ + +

Sort and Filter Data

+

Relations, Primary and External Key

+ + +
diff --git a/source/text/sdatabase/05000001.xhp b/source/text/sdatabase/05000001.xhp new file mode 100644 index 0000000000..6855b58153 --- /dev/null +++ b/source/text/sdatabase/05000001.xhp @@ -0,0 +1,44 @@ + + + + + +Table Context Menus +/text/sdatabase/05000001.xhp + + +Sun Microsystems, Inc. + + + +
+

Table Context Menus

+The context menu of the table container offers various functions that apply to all database tables. To edit a particular table within the database, select the corresponding table and open its context menu. +
+
+ +
+Depending on the context, it is possible that not all the functions for your current database will be listed in the context menus. For example, the Relationships command for defining relationships between various tables is only available with relational databases. +Depending on the database system used, you will find the following entries on the context menus: + +If a table is open, there are several functions available to edit the data. + + + +
diff --git a/source/text/sdatabase/05000003.xhp b/source/text/sdatabase/05000003.xhp new file mode 100644 index 0000000000..8d41b96c09 --- /dev/null +++ b/source/text/sdatabase/05000003.xhp @@ -0,0 +1,45 @@ + + + + + +Enter / change password +/text/sdatabase/05000003.xhp + + +Sun Microsystems, Inc. + + + +

Enter / change password

+Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user name in this dialog. + +

User

+Specifies the name of the new user. This field is only visible if you have defined a new user. + +

Old password

+Enter the old password here. This field is visible when you have opened the dialog via Change password. + +

Password

+Enter the new password.UFI: removed help id + +

Confirm (password)

+Enter the new password again. + +
diff --git a/source/text/shared/01/05340400.xhp b/source/text/shared/01/05340400.xhp index 68e722231f..3bb1dee26f 100644 --- a/source/text/shared/01/05340400.xhp +++ b/source/text/shared/01/05340400.xhp @@ -1,7 +1,4 @@ - - - - - - + Data Sources @@ -35,174 +30,174 @@ databases; editing tables editing; database tables and queries queries; editing in data source view -mw deleted "database tables," and changed "tables in databases;" -Data Sources +mw deleted "database tables," and changed "tables in databases;" +

Data Sources

This section contains information on browsing and editing database tables. -You cannot use the data source browser on a database table that is open in Design view. -Data source browser +You cannot use the data source browser on a database table that is open in Design view. +

Data source browser

The commands for the data source browser are found on the Table Data bar and in context menus. -Selecting records +

Selecting records

To select a record in a database table, click the row header, or click a row header, and then use the Up or Down arrow keys. Select database records. Drag-and-drop rows or cells to the document to insert contents. Drag-and-drop column headers to insert fields. The following table describes how to select individual elements in the data source browser: - + Selection - + Action - + Record - + Click the row header - + Several records or removing a selection - + Hold down CommandCtrl and click the row header - + Column - + Click the column header - + Data field - + Click in the data field - + Entire table - + Click the row header of the column headings
-Table Data toolbar (editing table data) +

Table Data toolbar (editing table data)

- + Icon - + Allows you to edit, add, or delete records from the database table.removed 3 ancient paras
-Cutting, copying and pasting data +

Cutting, copying and pasting data

You can cut, copy, and paste records in Data Source view. The Data Source browser also supports the dragging and dropping of records, or text and numbers from other $[officename] files. You cannot drag and drop to Yes/No, binary, image, or counting table fields. -Drag and drop only works in Edit mode. +Drag and drop only works in Edit mode. -Navigating in the Data Source Browser +

Navigating in the Data Source Browser

Use the Form Navigation bar at the bottom of the Data Source view to navigate between different records. -First record +

First record

- + Icon - + Go to the first record in the table.
-Previous record +

Previous record

- + Icon - + Go to the previous record in the table.
-Record number +

Record number

Type the number of the record that you want to display, and then press Enter. -Next record +

Next record

- + Icon - + Go to the next record in the table.
-Last record +

Last record

- + Icon - + Go to the last record in the table.
-New record +

New record

- + Icon - + Inserts a new record into the current table. To create a record, click the asterisk (*) button at the bottom of the table view. An empty row is added at the end of the table.
-Number of records +

Number of records

Displays the number of records. For example, "Record 7 of 9(2)" indicates that two records (2) are selected in a table containing 9 records, and that the cursor is in record number 7. -Organizing tables +

Organizing tables

To access the commands for formatting the table, right-click a column header, or a row header. -Table Format +

Table Format

-Row Height +

Row Height

-Column Format +

Column Format

-Column Width +

Column Width

diff --git a/source/text/shared/explorer/database/05000000.xhp b/source/text/shared/explorer/database/05000000.xhp deleted file mode 100644 index 990465d2c7..0000000000 --- a/source/text/shared/explorer/database/05000000.xhp +++ /dev/null @@ -1,47 +0,0 @@ - - - - - - - - - - -Tables -/text/shared/explorer/database/05000000.xhp - - -Sun Microsystems, Inc. - - - -
-Tables -Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records. -
-In the $[officename] Help, you will find further information on the following subjects: -Create new or edit table design - - -Sort and Filter Data -Relations, Primary and External Key - - -
diff --git a/source/text/shared/explorer/database/05000001.xhp b/source/text/shared/explorer/database/05000001.xhp deleted file mode 100644 index 74cb325489..0000000000 --- a/source/text/shared/explorer/database/05000001.xhp +++ /dev/null @@ -1,49 +0,0 @@ - - - - - - - - - - -Table Context Menus -/text/shared/explorer/database/05000001.xhp - - -Sun Microsystems, Inc. - - - -
-Table Context Menus -The context menu of the table container offers various functions that apply to all database tables. To edit a particular table within the database, select the corresponding table and open its context menu. -
-
- -
-Depending on the context, it is possible that not all the functions for your current database will be listed in the context menus. For example, the Relationships command for defining relationships between various tables is only available with relational databases. -Depending on the database system used, you will find the following entries on the context menus: - -If a table is open, there are several functions available to edit the data. - - - -
diff --git a/source/text/shared/explorer/database/05000003.xhp b/source/text/shared/explorer/database/05000003.xhp deleted file mode 100644 index 56227495a9..0000000000 --- a/source/text/shared/explorer/database/05000003.xhp +++ /dev/null @@ -1,48 +0,0 @@ - - - - - - - - -Enter / change password -/text/shared/explorer/database/05000003.xhp - - -Sun Microsystems, Inc. - - - -Enter / change password -Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user name in this dialog. - -User -Specifies the name of the new user. This field is only visible if you have defined a new user. - -Old password -Enter the old password here. This field is visible when you have opened the dialog via Change password. - -Password -Enter the new password.UFI: removed help id - -Confirm (password) -Enter the new password again. - - -- cgit