From 95f006af3ffbe256ebf095db8be2ebd1321e673e Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 1 Nov 2021 15:21:09 -0300 Subject: Refactor database files Change-Id: I97f41e7a5268ee307e3e0b051abebb35b917ed73 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124565 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/sdatabase/main.xhp | 2 +- source/text/sdatabase/menubar.xhp | 41 +++++++++++ source/text/sdatabase/menuedit.xhp | 83 +++++++++++++++++++++ source/text/sdatabase/menufile.xhp | 51 +++++++++++++ source/text/sdatabase/menufilesave.xhp | 47 ++++++++++++ source/text/sdatabase/menuinsert.xhp | 48 ++++++++++++ source/text/sdatabase/menutools.xhp | 51 +++++++++++++ source/text/sdatabase/menuview.xhp | 74 +++++++++++++++++++ source/text/shared/explorer/database/menubar.xhp | 44 ----------- source/text/shared/explorer/database/menuedit.xhp | 86 ---------------------- source/text/shared/explorer/database/menufile.xhp | 54 -------------- .../text/shared/explorer/database/menufilesave.xhp | 47 ------------ .../text/shared/explorer/database/menuinsert.xhp | 53 ------------- source/text/shared/explorer/database/menutools.xhp | 54 -------------- source/text/shared/explorer/database/menuview.xhp | 77 ------------------- source/text/shared/guide/database_main.xhp | 2 +- 16 files changed, 397 insertions(+), 417 deletions(-) create mode 100644 source/text/sdatabase/menubar.xhp create mode 100644 source/text/sdatabase/menuedit.xhp create mode 100644 source/text/sdatabase/menufile.xhp create mode 100644 source/text/sdatabase/menufilesave.xhp create mode 100644 source/text/sdatabase/menuinsert.xhp create mode 100644 source/text/sdatabase/menutools.xhp create mode 100644 source/text/sdatabase/menuview.xhp delete mode 100644 source/text/shared/explorer/database/menubar.xhp delete mode 100644 source/text/shared/explorer/database/menuedit.xhp delete mode 100644 source/text/shared/explorer/database/menufile.xhp delete mode 100644 source/text/shared/explorer/database/menufilesave.xhp delete mode 100644 source/text/shared/explorer/database/menuinsert.xhp delete mode 100644 source/text/shared/explorer/database/menutools.xhp delete mode 100644 source/text/shared/explorer/database/menuview.xhp (limited to 'source') diff --git a/source/text/sdatabase/main.xhp b/source/text/sdatabase/main.xhp index 806e88419c..f76bead797 100644 --- a/source/text/sdatabase/main.xhp +++ b/source/text/sdatabase/main.xhp @@ -87,7 +87,7 @@ - + diff --git a/source/text/sdatabase/menubar.xhp b/source/text/sdatabase/menubar.xhp new file mode 100644 index 0000000000..7542609dfb --- /dev/null +++ b/source/text/sdatabase/menubar.xhp @@ -0,0 +1,41 @@ + + + + + +Menus +/text/sdatabase/menubar.xhp + + +UFI: Database Document Menu bar + + + + + + + + + + + diff --git a/source/text/sdatabase/menuedit.xhp b/source/text/sdatabase/menuedit.xhp new file mode 100644 index 0000000000..bdb4046a87 --- /dev/null +++ b/source/text/sdatabase/menuedit.xhp @@ -0,0 +1,83 @@ + + + + + +Edit +/text/sdatabase/menuedit.xhp + + +UFI: Edit menu of Database + + + +
+

Edit

+
+The Edit menu of a database window. +

Copy

+Copies the selected object to the clipboard. +

Paste

+Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another. + +

Paste Special

+Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another. +
+ +

Select All

+Selects all entries, including subfolders, in the lower part of the database window. + + +

Edit

+Opens a window where you can edit the selected table, query, form, or report. + + +

Delete

+Deletes the selected table, query, form, or report. +
+ +

Rename

+Renames the selected object. Depending on the database, some names, characters, and name length might be invalid. + +

Open

+Opens the selected object in the last saved state. + +

Create as View

+Converts the selected query to a view. The original query remains in your database file and an additional view is generated on the database server. You must have write permission to add a view to a database. +Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time. + +

Form Wizard

+Starts the Form Wizard for the selected table, query, or view. + +

Report Wizard

+Starts the Report Wizard for the selected table, query, or view. + +

Database

+Opens a submenu. + +

Properties

+Opens the Database Properties dialog. + +

Connection Type

+Opens the Connection Type Wizard.shortened the paragraph, see i58462 + +

Advanced Properties

+Opens the Advanced Properties dialog. + +
diff --git a/source/text/sdatabase/menufile.xhp b/source/text/sdatabase/menufile.xhp new file mode 100644 index 0000000000..cf1f0a533e --- /dev/null +++ b/source/text/sdatabase/menufile.xhp @@ -0,0 +1,51 @@ + + + + + +File +/text/sdatabase/menufile.xhp + + +UFI: File menu for Database + + + +
+

File

+
+The File menu of a database window. Only entries specific to databases are listed. +

Save

+Saves the current database file, query, form or report. For the database file, you see the file save dialog. For the other objects, you see the Save dialog. +

Save As

+Saves the current database file with another name. In the file save dialog, select a path and file name to save. +

Export

+Exports the selected report or form to a text document. A dynamic report is exported as a copy of the database contents at the time of export. +

Send

+Opens a submenu. +

Email Document

+Opens the default email application to send a new email. The current database file is appended as an attachment. You can enter the subject, the recipients and a mail body. + +

Report as Email

+Opens the default email application to send a new email. The selected report is appended as an attachment. You can enter the subject, the recipients and a mail body. A dynamic report is exported as a copy of the database contents at the time of export. + +

Report to Text Document

+Exports the selected report to a text document. A dynamic report is exported as a copy of the database contents at the time of export. + +
diff --git a/source/text/sdatabase/menufilesave.xhp b/source/text/sdatabase/menufilesave.xhp new file mode 100644 index 0000000000..0347c9d43a --- /dev/null +++ b/source/text/sdatabase/menufilesave.xhp @@ -0,0 +1,47 @@ + + + + + + +Save +/text/sdatabase/menufilesave.xhp + + +save dialog in Base + + + + +

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 + +

Create New Directory

+Click to create a new folder within the database file. + +

Up One Level

+Click to go up one level in the folder hierarchy. + +

File name

+Enter the file name for the saved form. + +

Save

+Click to save the form to the database file. + +
diff --git a/source/text/sdatabase/menuinsert.xhp b/source/text/sdatabase/menuinsert.xhp new file mode 100644 index 0000000000..1f9196bc04 --- /dev/null +++ b/source/text/sdatabase/menuinsert.xhp @@ -0,0 +1,48 @@ + + + + + +Insert +/text/sdatabase/menuinsert.xhp + + + +
+

Insert

+
+The Insert menu of a database window. +

Form

+Opens a new text document in form mode. +

Report

+Starts the Report Builder window for the selected table, view, or query. +

Query (Design View)

+Opens a new query in design mode. +

Query (SQL View)

+Opens a new query in SQL mode. +

Table Design

+Opens the table design view. +

View Design

+Opens a new view in design mode. +

View (Simple)

+Opens a new view in SQL mode. +

Folder

+Opens a dialog where you can save a new folder in the database file. + +
diff --git a/source/text/sdatabase/menutools.xhp b/source/text/sdatabase/menutools.xhp new file mode 100644 index 0000000000..f008b6491c --- /dev/null +++ b/source/text/sdatabase/menutools.xhp @@ -0,0 +1,51 @@ + + + + + +Tools +/text/sdatabase/menutools.xhp + + +UFI: Tools menu of Database + + + +
+

Tools

+
+The Tools menu of a database window. + +

Relationships

+Opens the Relation Design view and checks whether the database connection supports relations. + +

User Administration

+Opens the User Administration dialog if the database supports this feature.UFI: where is this specced? + + +

Table Filter

+Opens the Table Filter dialog where you can specify which tables of the database to show or to hide.see text in shared\explorer\database\11090000.xhp +Select the tables that you want to filter in the Filter list. +If you select the topmost table in a hierarchy, all of the tables in the hierarchy are selected. +If you select a table that is at a lower level in the hierarchy, the tables that occur above it in the hierarchy are not selected. + +

SQL

+Opens the SQL dialog where you can enter SQL statements.UFI: may be shared\02\14030000.xhp + +
diff --git a/source/text/sdatabase/menuview.xhp b/source/text/sdatabase/menuview.xhp new file mode 100644 index 0000000000..899b789fa3 --- /dev/null +++ b/source/text/sdatabase/menuview.xhp @@ -0,0 +1,74 @@ + + + + + +View +/text/sdatabase/menuview.xhp + + +UFI: View menu of Database + + + +
+

View

+
+The View menu of a database window. + +

Database Objects

+Opens a submenu. + +

Forms

+Selects the forms container and shows all forms in the detail view. + +

Reports

+Selects the reports container and shows all reports in the detail view. + +

Queries

+Selects the queries container and shows all queries in the detail view. + +

Tables

+Selects the tables container and shows all tables in the detail view. + +

Sort

+Opens a submenu. + +

Ascending

+Sorts the entries in the detail view in ascending order. + +

Descending

+Sorts the entries in the detail view in descending order. + +

Preview

+Opens a submenu. + +

None

+Disables the preview in the database window. + +

Document Information

+The preview window displays the document information of a form or report. + +

Document

+The preview displays the document of a form or report. + +

Refresh Tables

+Refreshes the tables. what happens? cool drinks? Icecream? + +
diff --git a/source/text/shared/explorer/database/menubar.xhp b/source/text/shared/explorer/database/menubar.xhp deleted file mode 100644 index 59919db15a..0000000000 --- a/source/text/shared/explorer/database/menubar.xhp +++ /dev/null @@ -1,44 +0,0 @@ - - - - - - - - -Menus -/text/shared/explorer/database/menubar.xhp - - -UFI: Database Document Menu bar - - - - - - - - - - - diff --git a/source/text/shared/explorer/database/menuedit.xhp b/source/text/shared/explorer/database/menuedit.xhp deleted file mode 100644 index 4fc35cfc5d..0000000000 --- a/source/text/shared/explorer/database/menuedit.xhp +++ /dev/null @@ -1,86 +0,0 @@ - - - - - - - - -Edit -/text/shared/explorer/database/menuedit.xhp - - -UFI: Edit menu of Database - - - -
-Edit -
-The Edit menu of a database window. -Copy -Copies the selected object to the clipboard. -Paste -Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another. - -Paste Special -Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another. -
- -Select All -Selects all entries, including subfolders, in the lower part of the database window. - - -Edit -Opens a window where you can edit the selected table, query, form, or report. - - -Delete -Deletes the selected table, query, form, or report. -
- -Rename -Renames the selected object. Depending on the database, some names, characters, and name length might be invalid. - -Open -Opens the selected object in the last saved state. - -Create as View -Converts the selected query to a view. The original query remains in your database file and an additional view is generated on the database server. You must have write permission to add a view to a database. -Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time. - -Form Wizard -Starts the Form Wizard for the selected table, query, or view. - -Report Wizard -Starts the Report Wizard for the selected table, query, or view. - -Database -Opens a submenu. - -Properties -Opens the Database Properties dialog. - -Connection Type -Opens the Connection Type Wizard.shortened the paragraph, see i58462 - -Advanced Properties -Opens the Advanced Properties dialog. - -
diff --git a/source/text/shared/explorer/database/menufile.xhp b/source/text/shared/explorer/database/menufile.xhp deleted file mode 100644 index 16d5086850..0000000000 --- a/source/text/shared/explorer/database/menufile.xhp +++ /dev/null @@ -1,54 +0,0 @@ - - - - - - - - -File -/text/shared/explorer/database/menufile.xhp - - -UFI: File menu for Database - - - -
-File -
-The File menu of a database window. Only entries specific to databases are listed. -Save -Saves the current database file, query, form or report. For the database file, you see the file save dialog. For the other objects, you see the Save dialog. -Save As -Saves the current database file with another name. In the file save dialog, select a path and file name to save. -Export -Exports the selected report or form to a text document. A dynamic report is exported as a copy of the database contents at the time of export. -Send -Opens a submenu. -Email Document -Opens the default email application to send a new email. The current database file is appended as an attachment. You can enter the subject, the recipients and a mail body. - -Report as Email -Opens the default email application to send a new email. The selected report is appended as an attachment. You can enter the subject, the recipients and a mail body. A dynamic report is exported as a copy of the database contents at the time of export. - -Report to Text Document -Exports the selected report to a text document. A dynamic report is exported as a copy of the database contents at the time of export. - -
diff --git a/source/text/shared/explorer/database/menufilesave.xhp b/source/text/shared/explorer/database/menufilesave.xhp deleted file mode 100644 index 304a40d474..0000000000 --- a/source/text/shared/explorer/database/menufilesave.xhp +++ /dev/null @@ -1,47 +0,0 @@ - - - - - - -Save -/text/shared/explorer/database/menufilesave.xhp - - -save dialog in Base - - - - -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 - -Create New Directory -Click to create a new folder within the database file. - -Up One Level -Click to go up one level in the folder hierarchy. - -File name -Enter the file name for the saved form. - -Save -Click to save the form to the database file. - - diff --git a/source/text/shared/explorer/database/menuinsert.xhp b/source/text/shared/explorer/database/menuinsert.xhp deleted file mode 100644 index 76b40bf504..0000000000 --- a/source/text/shared/explorer/database/menuinsert.xhp +++ /dev/null @@ -1,53 +0,0 @@ - - - - - - - - - - -Insert -/text/shared/explorer/database/menuinsert.xhp - - - -
-Insert -
-The Insert menu of a database window. -Form -Opens a new text document in form mode. -Report -Starts the Report Builder window for the selected table, view, or query. -Query (Design View) -Opens a new query in design mode. -Query (SQL View) -Opens a new query in SQL mode. -Table Design -Opens the table design view. -View Design -Opens a new view in design mode. -View (Simple) -Opens a new view in SQL mode. -Folder -Opens a dialog where you can save a new folder in the database file. - -
diff --git a/source/text/shared/explorer/database/menutools.xhp b/source/text/shared/explorer/database/menutools.xhp deleted file mode 100644 index 2f9cc8efab..0000000000 --- a/source/text/shared/explorer/database/menutools.xhp +++ /dev/null @@ -1,54 +0,0 @@ - - - - - - - - -Tools -/text/shared/explorer/database/menutools.xhp - - -UFI: Tools menu of Database - - - -
-Tools -
-The Tools menu of a database window. - -Relationships -Opens the Relation Design view and checks whether the database connection supports relations. - -User Administration -Opens the User Administration dialog if the database supports this feature.UFI: where is this specced? - - -Table Filter -Opens the Table Filter dialog where you can specify which tables of the database to show or to hide.see text in shared\explorer\database\11090000.xhp -Select the tables that you want to filter in the Filter list. -If you select the topmost table in a hierarchy, all of the tables in the hierarchy are selected. -If you select a table that is at a lower level in the hierarchy, the tables that occur above it in the hierarchy are not selected. - -SQL -Opens the SQL dialog where you can enter SQL statements.UFI: may be shared\02\14030000.xhp - -
diff --git a/source/text/shared/explorer/database/menuview.xhp b/source/text/shared/explorer/database/menuview.xhp deleted file mode 100644 index 3502526adf..0000000000 --- a/source/text/shared/explorer/database/menuview.xhp +++ /dev/null @@ -1,77 +0,0 @@ - - - - - - - - -View -/text/shared/explorer/database/menuview.xhp - - -UFI: View menu of Database - - - -
-View -
-The View menu of a database window. - -Database Objects -Opens a submenu. - -Forms -Selects the forms container and shows all forms in the detail view. - -Reports -Selects the reports container and shows all reports in the detail view. - -Queries -Selects the queries container and shows all queries in the detail view. - -Tables -Selects the tables container and shows all tables in the detail view. - -Sort -Opens a submenu. - -Ascending -Sorts the entries in the detail view in ascending order. - -Descending -Sorts the entries in the detail view in descending order. - -Preview -Opens a submenu. - -None -Disables the preview in the database window. - -Document Information -The preview window displays the document information of a form or report. - -Document -The preview displays the document of a form or report. - -Refresh Tables -Refreshes the tables. what happens? cool drinks? Icecream? - -
diff --git a/source/text/shared/guide/database_main.xhp b/source/text/shared/guide/database_main.xhp index 332255e07a..3ad0d52be8 100644 --- a/source/text/shared/guide/database_main.xhp +++ b/source/text/shared/guide/database_main.xhp @@ -42,7 +42,7 @@

Data Sources

Address book as data source View data source contents -Menu bar of a database file +Menu bar of a database file

Forms and Reports

Create new form document, edit form controls, Form Wizard Entering data versus editing form -- cgit