LDAP Connection

From 17ae85786dd0dc06a23b08cb9e37812824391e48 Mon Sep 17 00:00:00 2001 From: Uwe Fischer Date: Wed, 6 Jan 2010 14:05:10 +0100 Subject: hcshared25: commit before help id changes --- helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'helpcontent2/source/text/shared/explorer/database') diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp index 71321aab36..bbbda9e129 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp @@ -38,10 +38,6 @@ LDAP Connection /text/shared/explorer/database/dabawiz02ldap.xhp - -UFI: Database Wizard LDAP page -YJ: checked - LDAP server; address books (Base) @@ -66,7 +62,9 @@ Use secure connection (SSL) Creates a secure connection to the LDAP server through the Secure Sockets Layer (SSL). By default, an SSL connection uses port 636. A regular connection uses port 389. +

Authentication Database Wizard +

-- cgit From 9d4a39a5654c975a504467407224f34d9806d0f4 Mon Sep 17 00:00:00 2001 From: Uwe Fischer Date: Wed, 13 Jan 2010 16:01:27 +0100 Subject: hcshared25: i 108108 applied --- .../text/shared/explorer/database/02010100.xhp | 4 +-- .../text/shared/explorer/database/05000003.xhp | 8 ++--- .../text/shared/explorer/database/05010100.xhp | 6 ++-- .../text/shared/explorer/database/05020100.xhp | 20 +++++------ .../text/shared/explorer/database/05030100.xhp | 12 +++---- .../text/shared/explorer/database/05030200.xhp | 12 +++---- .../text/shared/explorer/database/05030300.xhp | 6 ++-- .../text/shared/explorer/database/05030400.xhp | 12 +++---- .../text/shared/explorer/database/11020000.xhp | 2 +- .../text/shared/explorer/database/11030000.xhp | 2 +- .../text/shared/explorer/database/11030100.xhp | 14 ++++---- .../text/shared/explorer/database/11080000.xhp | 8 ++--- .../text/shared/explorer/database/11170000.xhp | 12 +++---- .../text/shared/explorer/database/11170100.xhp | 12 +++---- .../text/shared/explorer/database/30100000.xhp | 2 +- .../shared/explorer/database/dabaadvpropdat.xhp | 2 +- .../text/shared/explorer/database/dabapropgen.xhp | 8 ++--- .../text/shared/explorer/database/dabawiz01.xhp | 12 +++---- .../shared/explorer/database/dabawiz02jdbc.xhp | 6 ++-- .../shared/explorer/database/dabawiz02oracle.xhp | 4 +-- .../text/shared/explorer/database/menuedit.xhp | 4 +-- .../text/shared/explorer/database/menufilesave.xhp | 8 ++--- .../shared/explorer/database/migrate_macros.xhp | 4 +-- .../text/shared/explorer/database/password.xhp | 6 ++-- .../text/shared/explorer/database/rep_datetime.xhp | 16 ++++----- .../shared/explorer/database/rep_navigator.xhp | 10 +++--- .../shared/explorer/database/rep_pagenumbers.xhp | 10 +++--- .../text/shared/explorer/database/rep_prop.xhp | 42 +++++++++++----------- .../text/shared/explorer/database/rep_sort.xhp | 18 +++++----- 29 files changed, 141 insertions(+), 141 deletions(-) (limited to 'helpcontent2/source/text/shared/explorer/database') diff --git a/helpcontent2/source/text/shared/explorer/database/02010100.xhp b/helpcontent2/source/text/shared/explorer/database/02010100.xhp index 94808b2a6d..6c3a18001f 100755 --- a/helpcontent2/source/text/shared/explorer/database/02010100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/02010100.xhp @@ -139,9 +139,9 @@ To remove a field name from the query, click the column header of the field and choose the Delete command on the context menu for the column. Save query Use the Save icon on the Standard Bar to save the query. You see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema. -Schema +Schema Enter the name of the schema that is assigned to the query or table view. -Query name or table view name +Query name or table view name Enter the name of the query or table view. Filtering data To filter data for the query, set the desired preferences in the lower area of the Design View. The following lines are available: diff --git a/helpcontent2/source/text/shared/explorer/database/05000003.xhp b/helpcontent2/source/text/shared/explorer/database/05000003.xhp index 1ca01fac10..a6097ceb7b 100755 --- a/helpcontent2/source/text/shared/explorer/database/05000003.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05000003.xhp @@ -47,16 +47,16 @@ Enter / change password Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user's 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. This field is visible when you have started the dialog via Change password. - + Password Enter the new password.UFI: removed help id - + Confirm (password) Enter the new password again. diff --git a/helpcontent2/source/text/shared/explorer/database/05010100.xhp b/helpcontent2/source/text/shared/explorer/database/05010100.xhp index 0286983fd7..93b4469e63 100644 --- a/helpcontent2/source/text/shared/explorer/database/05010100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05010100.xhp @@ -44,7 +44,7 @@

- + Index design The Index Design dialog allows you edit the indexes for the current table.

@@ -66,7 +66,7 @@ Resets the current index to the setting that it had when the dialog was started. Index details As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the Reset Current Index icon. -Unique +Unique Specifies whether the current index allows only unique values. Checking the Unique option prevents duplicate data from being entered in the field and ensures data integrity. Fields The Fields area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list. @@ -74,7 +74,7 @@ Displays a list of the fields in the current table. You can select more than one field.i73718 Sort order Determines the sort order. -Close +Close Closes the dialog. diff --git a/helpcontent2/source/text/shared/explorer/database/05020100.xhp b/helpcontent2/source/text/shared/explorer/database/05020100.xhp index 757510f362..a9185c7066 100644 --- a/helpcontent2/source/text/shared/explorer/database/05020100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05020100.xhp @@ -55,8 +55,8 @@

The update and delete options are only available if they are supported by the database used. - - + + Tables This is where the two related tables are listed.If you create a new relation, you can select one table from each of the combo boxes in the top part of the dialog. If you opened the Relations dialog for an existing relation by double-clicking the connection lines in the Relation window, then the tables involved in the relation cannot be modified. @@ -68,31 +68,31 @@ The names of the tables selected for the link appear here as column names. If you click a field, you can use the arrow buttons to select a field from the table. Each relation is written in a row. Update options Here you can select options that take effect when there are changes to a primary key field. - + No action Specifies that any change made to a primary key does not affect other external key fields. - + Updating cascade Updates all the external key fields if the value of the corresponding primary key has been modified (Cascading Update). - + Set null If the corresponding primary key has been modified, use this option to set the "IS NULL" value to all external key fields. IS NULL means that the field is empty. - + Set default If the corresponding primary key has been modified, use this option to set a default value to all external key fields. During the creation of the corresponding table, the default value of an external key field will be defined when you assign the field properties. Delete options Here you can select options that take effect when a primary key field is deleted. - + No action Specifies that the deletion of a primary key will not have any effect on other external key fields. - + Delete cascade Specifies that all external key fields will be deleted if you delete the corresponding primary key field. When you delete a primary key field with the Delete cascade option, all records from other tables that have this key as their foreign key are also deleted. Use this option with great care; it is possible that a major portion of the database can be deleted. - + Set null If you delete the corresponding primary key, the "IS NULL" value will be assigned to all external key fields. - + Set Default If you delete the corresponding primary key, a set value will be set to all external key fields. diff --git a/helpcontent2/source/text/shared/explorer/database/05030100.xhp b/helpcontent2/source/text/shared/explorer/database/05030100.xhp index e5fdaf3cca..fa6b9c6050 100644 --- a/helpcontent2/source/text/shared/explorer/database/05030100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030100.xhp @@ -50,13 +50,13 @@ Table name Specifies a name for the copy. Some databases only accept names containing eight or fewer characters. Options -Definition and data +Definition and data Creates a 1:1 copy of the database table. The table definition and the complete data are copied. The table definition includes the table structure and format from different data fields, including special field properties. The field contents supply the data. -Definition +Definition Copies only the table definition and not the corresponding data. -As table view +As table view If the database supports Views, you can select this option only when a query is copied in a table container. This option enables you to see and edit a query as a normal table view. The table will be filtered in the view with a "Select" SQL statement. -Append datasee #i63815 +Append datasee #i63815 Appends the data of the table to be copied to an existing table. The table definition must be exactly the same so that data can be copied. Data cannot be copied if a data field in the target table has another format than the data field in the source table. Match the data field names in the Copy Table dialog on the Apply Columns page. @@ -64,9 +64,9 @@ If the fields of the target table have a smaller field length than in the source table when data is being attached, the source data fields will automatically be truncated to match the field lengths in the target table. primary keys; defining -Create primary key +Create primary key Automatically generates a primary key data field and fills it with values. You should always use this field, since a primary key must always be available in order to edit the table. -Name +Name Specifies a name for the primary key generated. This name is optional. Next page diff --git a/helpcontent2/source/text/shared/explorer/database/05030200.xhp b/helpcontent2/source/text/shared/explorer/database/05030200.xhp index c26abc7c60..aa7de0308d 100755 --- a/helpcontent2/source/text/shared/explorer/database/05030200.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030200.xhp @@ -48,14 +48,14 @@ In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Apply columns dialog is the second window of the Copy table dialog. Existing columns -Left list box +Left list box Lists the available data fields that you can include in the copied table. To copy a data field, click its name, and then click the > button. To copy all of the fields, click the >> button. -Right list box +Right list box Lists the fields that you want to include in the copied table. - - - -Buttons + + + +Buttons Adds or removes the selected field (> or < button) or all of the fields (<< or >> button). Next page diff --git a/helpcontent2/source/text/shared/explorer/database/05030300.xhp b/helpcontent2/source/text/shared/explorer/database/05030300.xhp index e2b36b3aca..cba16835f4 100755 --- a/helpcontent2/source/text/shared/explorer/database/05030300.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030300.xhp @@ -49,7 +49,7 @@ Type formatting In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Type formatting dialog is the third window of the Copy table dialog. - + List box Lists the data fields that will be included in to the copied table. Column information @@ -71,10 +71,10 @@ Select the default value for a Yes/No field. Automatic type recognition $[officename] can automatically recognize field contents when you copy database tables by drag and drop. - + (max.) lines Enter the number of lines to use for automatic type recognition. - + Auto Enables automatic type recognition. diff --git a/helpcontent2/source/text/shared/explorer/database/05030400.xhp b/helpcontent2/source/text/shared/explorer/database/05030400.xhp index 1d8c29a159..3f5c7492bd 100755 --- a/helpcontent2/source/text/shared/explorer/database/05030400.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030400.xhp @@ -55,18 +55,18 @@ Destination table Lists the possible data fields in the destination table. Only the data fields that are selected in the source table list will be included the destination table. - - + + up Moves the selected entry up one position in the list. - - + + down Moves the selected entry down one position in the list. - + all Selects all of the data fields in the list. - + none Clears all of the check boxes in the list. diff --git a/helpcontent2/source/text/shared/explorer/database/11020000.xhp b/helpcontent2/source/text/shared/explorer/database/11020000.xhp index f314718e31..a7514852fd 100644 --- a/helpcontent2/source/text/shared/explorer/database/11020000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11020000.xhp @@ -60,7 +60,7 @@ Use this text field to enter additional optional driver settings if this is necessary.

-Character Set +Character Set Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database. Choose "System" to use the default character set of your operating 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.

diff --git a/helpcontent2/source/text/shared/explorer/database/11030000.xhp b/helpcontent2/source/text/shared/explorer/database/11030000.xhp index 069f855c6b..685dd80e96 100644 --- a/helpcontent2/source/text/shared/explorer/database/11030000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11030000.xhp @@ -55,7 +55,7 @@ In dBASE format, deleted records remain in the file. To view any changes that you make to the database, close the connection to the database, and then reconnect the database. UFI: deleted note about case sensitivity. Should be not other than for all other files. - + Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.

diff --git a/helpcontent2/source/text/shared/explorer/database/11030100.xhp b/helpcontent2/source/text/shared/explorer/database/11030100.xhp index 57108aa806..c126feeb74 100755 --- a/helpcontent2/source/text/shared/explorer/database/11030100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11030100.xhp @@ -48,19 +48,19 @@

-Table +Table Select the database table that you want to index. -Table Indexes +Table Indexes Lists the current indexes for the selected database table. To remove an index from the list, click the index, and then click the right arrow. -Free Indexes +Free Indexes Lists the available indexes that you can assign to a table. To assign an index to a selected table, click the left arrow icon. The left double arrow assigns all available indexes. -< +< Moves the selected index to the Table Indexes list. -<< +<< Moves all of the free indexes to the Table Indexes list. -> +> Moves the selected table indexes to the Free Indexes list. ->> +>> Moves all of the table indexes to the Free Indexes list. diff --git a/helpcontent2/source/text/shared/explorer/database/11080000.xhp b/helpcontent2/source/text/shared/explorer/database/11080000.xhp index 35b5a848a5..81f72e308b 100644 --- a/helpcontent2/source/text/shared/explorer/database/11080000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11080000.xhp @@ -55,16 +55,16 @@

You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here. To run an SQL query for filtering data in the database, use the Query Design View. -Command to execute +Command to execute Enter the SQL administration command that you want to run. For example, for a "Bibliography" data source, you can enter the following SQL command: SELECT "Address" FROM "biblio" "biblio" For more information on SQL commands, please consult the documentation that came with the database. -Previous commands +Previous commands Lists the previously executed SQL commands. To run a command again, click the command, and then click Run. -Status +Status Displays the results, including errors, of the SQL command that you ran. -Run +Run Runs the command that you entered in the Command to execute box.

diff --git a/helpcontent2/source/text/shared/explorer/database/11170000.xhp b/helpcontent2/source/text/shared/explorer/database/11170000.xhp index 2e360806db..b40b169138 100755 --- a/helpcontent2/source/text/shared/explorer/database/11170000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11170000.xhp @@ -47,17 +47,17 @@ Adabas D Statistics Specifies the access options for the Adabas database.

-Data Buffer Size +Data Buffer Size Enter the size of the data buffer for the database. The setting takes effect after you restart the database. -Increment size +Increment size Enter the size by which you want to automatically increment the database. The maximum increment size is 100 MB. The setting takes effect after you restart the database. -Control User Name +Control User Name Enter the name of a user that you want to give limited control to modify some parameters of the database. -Control Password +Control Password Enter the password of the Control User. -Shut down the service when closing $[officename] +Shut down the service when closing $[officename] Exits the Adabas database server when you exit $[officename]. This option is only available if you start the database server from $[officename] with a control user and password. -Extended +Extended Opens the Database Statistics dialog, where you can view statistics about the Adabas database. diff --git a/helpcontent2/source/text/shared/explorer/database/11170100.xhp b/helpcontent2/source/text/shared/explorer/database/11170100.xhp index e129b6e10c..75b5013b47 100755 --- a/helpcontent2/source/text/shared/explorer/database/11170100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11170100.xhp @@ -46,18 +46,18 @@ Database Statistics Displays statistics about the Adabas database. Database files -SYSDEVSPACE +SYSDEVSPACE Displays the path and the name of the SYSDEVSPACE file. -TRANSACTIONLOG +TRANSACTIONLOG Displays the path and the name of the TRANSACTIONLOG file. -DATADEVSPACE +DATADEVSPACE Displays the path and the name of the DATADEVSPACE file. Database sizes -Size (MB) +Size (MB) Displays the full size (in megabytes) of the database. -Free space (MB) +Free space (MB) Displays the amount of free space (in megabytes) that is available in the database. -Memory utilization (in %) +Memory utilization (in %) Displays the amount of used space in the database as a percentage. diff --git a/helpcontent2/source/text/shared/explorer/database/30100000.xhp b/helpcontent2/source/text/shared/explorer/database/30100000.xhp index 61ec25a288..140b88ddbc 100644 --- a/helpcontent2/source/text/shared/explorer/database/30100000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/30100000.xhp @@ -49,7 +49,7 @@ Database name Type the name of the database. The name is added to the Data source URL field. User settings - + Administrator Enter the name of the database administrator. The administrator name and password is assigned when you create an Adabas database. Apart from the administrator, two more users can access the Adabas database. Control User diff --git a/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp b/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp index 2350ad4e7b..cb22c59611 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp @@ -91,7 +91,7 @@ The control box is available for all data source types which support write access to their data. The control box does not exist for spreadsheets, text, csv, and the various read-only address books. Ignore currency field information Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded. - + Use ODBC conformant date/time literals Check to use ODBC conformant date/time literals. diff --git a/helpcontent2/source/text/shared/explorer/database/dabapropgen.xhp b/helpcontent2/source/text/shared/explorer/database/dabapropgen.xhp index b16b97effd..902b88da40 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabapropgen.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabapropgen.xhp @@ -56,7 +56,7 @@ 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 +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. @@ -66,7 +66,7 @@ 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 +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. @@ -81,10 +81,10 @@ Data source URL Enter the location of the JDBC data source as a URL. -JDBC driver class +JDBC driver class Enter the name of the JDBC driver class that connects to the data source. -Test ClassUFI: found for JDBC +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/helpcontent2/source/text/shared/explorer/database/dabawiz01.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz01.xhp index f291ee3af7..afe6f8f5a9 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz01.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz01.xhp @@ -51,16 +51,16 @@ Create a new database Select to create a new database. This option uses the HSQL database engine with default settings. The final page of the wizard appears next. External web page about HSQL. - - + + Open an existing database file Select to open a database file from a list of recently used files or from a file selection dialog. - - + + Recently used Select a database file to open from the list of recently used files. Click Finish to open the file immediately and to exit the wizard. - - + + Open Opens a file selection dialog where you can select a database file. Click Open or OK in the file selection dialog to open the file immediately and to exit the wizard. diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp index 62dc482ef6..b6f7451997 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp @@ -92,14 +92,14 @@ Data source URL Enter the URL for the database. For example, for the MySQL JDBC driver, enter "jdbc:mysql://<Servername>/<name of the database>". For more information on the JDBC driver, consult the documentation that came with the driver. - -JDBC Driver Class + +JDBC Driver Class Enter the name of the JDBC driver.

Before you can use a JDBC driver, you need to add its class path. Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - Java, and click the Class Path button. After you add the path information, restart %PRODUCTNAME.

-Test ClassUFI: may be Test Connection - both strings are in spec +Test ClassUFI: may be Test Connection - both strings are in spec Tests the connection with the current settings. Authentication Database Wizard diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02oracle.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02oracle.xhp index 5b44a023c6..faf4b11765 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02oracle.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02oracle.xhp @@ -80,10 +80,10 @@ Port number Enter the port number for the database server. - + Oracle JDBC Driver Class Enter the name of the JDBC driver. - + Test Class Tests the connection with the current settings. Authentication diff --git a/helpcontent2/source/text/shared/explorer/database/menuedit.xhp b/helpcontent2/source/text/shared/explorer/database/menuedit.xhp index b1359b82d5..089e6c861f 100755 --- a/helpcontent2/source/text/shared/explorer/database/menuedit.xhp +++ b/helpcontent2/source/text/shared/explorer/database/menuedit.xhp @@ -57,12 +57,12 @@ Inserts an item from the clipboard. If you want, you can insert forms and reports, including subfolders, from one database file to another.

- + Edit Opens a window where you can edit the selected table, query, form, or report. - + Delete Deletes the selected table, query, form, or report. diff --git a/helpcontent2/source/text/shared/explorer/database/menufilesave.xhp b/helpcontent2/source/text/shared/explorer/database/menufilesave.xhp index 5676db7ac1..50fb37ca36 100644 --- a/helpcontent2/source/text/shared/explorer/database/menufilesave.xhp +++ b/helpcontent2/source/text/shared/explorer/database/menufilesave.xhp @@ -47,16 +47,16 @@ 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 verify that 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/helpcontent2/source/text/shared/explorer/database/migrate_macros.xhp b/helpcontent2/source/text/shared/explorer/database/migrate_macros.xhp index b90fc54ea4..fab1b29264 100755 --- a/helpcontent2/source/text/shared/explorer/database/migrate_macros.xhp +++ b/helpcontent2/source/text/shared/explorer/database/migrate_macros.xhp @@ -51,9 +51,9 @@ The Database Document Macro Migration Wizard moves existing macros from sub-documents of an old Base file into the new Base file's macro storage area.

- + Choose a location and file name to save the new database file. By default, the new file gets the same name as the old file, while the old file gets renamed with the string "backup" in the name. - + The list shows all changes that were applied to the database file. Previously, macros have been allowed to reside only in the text sub-documents of forms and reports. Starting with OpenOffice.org 3.1 or StarOffice 9.1, macros can also be stored in the Base file itself. This means that macros in Base files can be called now from any of its sub-components: forms, reports, table design, query design, relation design, table data view. However, it is technically not possible to store macros both in a Base file and in its sub-documents at the same time. So, if you want to attach some new macros to the Base file, while retaining any existing old macros that were stored in the sub-documents, you must move the existing old macros up to the Base file's macro storage area. diff --git a/helpcontent2/source/text/shared/explorer/database/password.xhp b/helpcontent2/source/text/shared/explorer/database/password.xhp index 7329f0c2b1..a125c8bfa4 100644 --- a/helpcontent2/source/text/shared/explorer/database/password.xhp +++ b/helpcontent2/source/text/shared/explorer/database/password.xhp @@ -44,13 +44,13 @@ User Name and Password Required - + User name Enter the user name to connect to the data source. - + Password Enter the password to connect to the data source. - + Remember password till end of session Select to use the same user name and password without further dialog, when you connect again to the same data source in the current %PRODUCTNAME session. diff --git a/helpcontent2/source/text/shared/explorer/database/rep_datetime.xhp b/helpcontent2/source/text/shared/explorer/database/rep_datetime.xhp index c997db7bff..cbcc5c83d1 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_datetime.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_datetime.xhp @@ -47,14 +47,14 @@ You can open the Date and Time dialog of the Report Builder by choosing Insert - Date and Time. Press Shift-F1 and point with the mouse at an input box to see a help text for this input box. -Enable Include Date to insert a date field into the active area of the report. The date field displays the current date when the report is executed. - - -Select a format to display the date. -Enable Include Time to insert a time field into the active area of the report. The time field displays the current time when the report is executed. - - -Select a format to display the time. +Enable Include Date to insert a date field into the active area of the report. The date field displays the current date when the report is executed. + + +Select a format to display the date. +Enable Include Time to insert a time field into the active area of the report. The time field displays the current time when the report is executed. + + +Select a format to display the time. Click OK to insert the field. You can click the date or time field and drag to another position within the same area, or edit the properties in the Properties window. diff --git a/helpcontent2/source/text/shared/explorer/database/rep_navigator.xhp b/helpcontent2/source/text/shared/explorer/database/rep_navigator.xhp index add37e669a..5ad87a6b10 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_navigator.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_navigator.xhp @@ -51,7 +51,7 @@ You can open the Report Navigator window of the Report Builder by choosing View - Report Navigator. The Report Navigator reveals the structure of the report. You can use the Report Navigator to insert functions into the report. -Click an entry in the Report Navigator. The corresponding object or area is selected in the Report Builder view. Right-click an entry to open the context menu. +Click an entry in the Report Navigator. The corresponding object or area is selected in the Report Builder view. Right-click an entry to open the context menu. To enter functions to the report In the context menu of the Report Navigator, you see the same commands as in the Report Builder view, plus additional commands to create new functions or to delete them. Functions can be entered using a syntax as specified by the OpenFormula proposal. @@ -82,9 +82,9 @@ Maybe you have to set the initial value to the value of the field like [field].these 3 paras copied from another mail by Ocke in users@dba.o.o If there are blank fields in the cost column, use the following formula to replace the blank fields' content with zero: [SumCost] + IF(ISBLANK([field]);0;[field])need some real working examples. See i81874Formula -Enter the formula that defines the function. Use OpenFormula syntax.Initial value -Enter the initial value for the evaluation of the formula. Often this is set to 0 or to 1.Deep traversing -If Deep traversing is enabled, functions are evaluated considering all lower levels of hierarchy. This would be used for instance for line numbering. If Deep traversing is not enabled, only the first level of hierarchy is evaluated.Pre evaluation -If Pre evaluation is enabled, functions are evaluated only when the report is finished. +Enter the formula that defines the function. Use OpenFormula syntax.Initial value +Enter the initial value for the evaluation of the formula. Often this is set to 0 or to 1.Deep traversing +If Deep traversing is enabled, functions are evaluated considering all lower levels of hierarchy. This would be used for instance for line numbering. If Deep traversing is not enabled, only the first level of hierarchy is evaluated.Pre evaluation +If Pre evaluation is enabled, functions are evaluated only when the report is finished. diff --git a/helpcontent2/source/text/shared/explorer/database/rep_pagenumbers.xhp b/helpcontent2/source/text/shared/explorer/database/rep_pagenumbers.xhp index 171b5bbc21..9da583ac44 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_pagenumbers.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_pagenumbers.xhp @@ -47,11 +47,11 @@ You can open the Page Numbers dialog of the Report Builder by choosing Insert - Page Numbers. Press Shift-F1 and point with the mouse at an input box to see a help text for this input box. -Page N -Page N of M -Top of Page (Header) -Bottom of Page (Footer) -AlignmentShow Number On First Page - not in UIShow Number on First Page +Page N +Page N of M +Top of Page (Header) +Bottom of Page (Footer) +AlignmentShow Number On First Page - not in UIShow Number on First Page Select the format for the page numbers, either "Page N" or "Page N of M", where N stands for the current page number, and M for the total number of pages in the report. diff --git a/helpcontent2/source/text/shared/explorer/database/rep_prop.xhp b/helpcontent2/source/text/shared/explorer/database/rep_prop.xhp index 1e22300e1d..bebbaf020c 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_prop.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_prop.xhp @@ -49,35 +49,35 @@ Press Shift-F1 and point with the mouse at an input box to see a help text for this input box. On first start of the Report Builder, the Properties window shows the Data tab page for the whole report. Select a table from the Contents list, then press Tab or click outside the input box to leave the input box. -The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose View - Add Field. +The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose View - Add Field. The General tab page can be used to change the name of the report, and to disable the Page Header or Page Footer areas, among others. To display the Data or General tab page for the whole report, choose Edit - Select Report.Group keep together -Groups are kept together by page or by column (default). You must enable Keep Together also.Page header -Specifies in which context the page header will be printed: on all pages, or not on pages with a report header or footer.Page footer -Specifies in which context the page footer will be printed: on all pages, or not on pages with a report header or footerPrint repeated values -Specifies to print repeated values. +Groups are kept together by page or by column (default). You must enable Keep Together also.Page header +Specifies in which context the page header will be printed: on all pages, or not on pages with a report header or footer.Page footer +Specifies in which context the page footer will be printed: on all pages, or not on pages with a report header or footerPrint repeated values +Specifies to print repeated values. If you click the Page Header or Page Footer area without selecting any object, you see the General tab page for that area. You can edit some visual properties for the area.screen only or also in report?Background color -Sets the background color for the selected object, both on screen and for printing.Visible -An invisible object is not shown in the executed report. It is still visible in the Report Builder view.Height -Defines the height of the selected object.Conditional Print Expression -If the Conditional Print Expression evaluates to TRUE, the selected object will be printed.id="par_id2386852" l10n="NEW"Conditions use the following form:Background transparent -Specifies whether the background of the selected object is transparent or opaque.just guessing +Sets the background color for the selected object, both on screen and for printing.Visible +An invisible object is not shown in the executed report. It is still visible in the Report Builder view.Height +Defines the height of the selected object.Conditional Print Expression +If the Conditional Print Expression evaluates to TRUE, the selected object will be printed.id="par_id2386852" l10n="NEW"Conditions use the following form:Background transparent +Specifies whether the background of the selected object is transparent or opaque.just guessing If you click the Detail area without selecting any object, you see the General tab page for that area. You can specify some properties to fine-tune the way the records are printed.Force New Page -Force New Page specifies whether the current section and/or the next section is printed on a new page.New Row Or Column -New Row Or Column specifies, for a multi-column design, whether the current section and/or the next section will be printed on a new row or column.Keep together -Keep Together specifies to print the current object starting on top of a new page if it doesn't fit on the current page. +Force New Page specifies whether the current section and/or the next section is printed on a new page.New Row Or Column +New Row Or Column specifies, for a multi-column design, whether the current section and/or the next section will be printed on a new row or column.Keep together +Keep Together specifies to print the current object starting on top of a new page if it doesn't fit on the current page. Insert some data fields into the Detail area, or insert other control fields into any area. When you select an inserted field, you can set the properties in the Properties window. For a Label field, you can change the displayed text in the Label input box. -For a picture, you can specify to either insert the picture as a link to a file or only as an embedded object in the Base file. The embedded option increases the size of the Base file, while the link option is not as portable to other computers.Position x -Set the X Position for the selected objectx in pixel or twips? or current measurement units? from origin as on ruler? from elsewhere?Position y -Set the Y Position for the selected objectWidth -Sets the width of the selected object.Font -Select the font for the selected text object.Print when group change -Print when group changeVert. Alignment -Vert. Alignment +For a picture, you can specify to either insert the picture as a link to a file or only as an embedded object in the Base file. The embedded option increases the size of the Base file, while the link option is not as portable to other computers.Position x +Set the X Position for the selected objectx in pixel or twips? or current measurement units? from origin as on ruler? from elsewhere?Position y +Set the Y Position for the selected objectWidth +Sets the width of the selected object.Font +Select the font for the selected text object.Print when group change +Print when group changeVert. Alignment +Vert. Alignment On the General tab page of a data field, you can set the Formatting properties, among others. -On the Data tab page, you can change the data contents to be shown. +On the Data tab page, you can change the data contents to be shown. diff --git a/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp b/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp index 8dde7a43e9..8a0b3bb5c9 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp @@ -49,23 +49,23 @@ The Groups box shows the fields in an order from top to bottom. You can select any field, then click the Move Up or Move Down button to move this field up or down in the list. The sorting and grouping will be applied in the order of the list from top to bottom. - + Lists the fields that will be used for sorting or grouping. The field at the top has the highest priority, the second field has the second priority, and so on. - + Click to open a list from which you can select a field. - + Moves the selected field up in the list. - + Moves the selected field down in the list. - + Select the sorting order. - + Select to show or hide the Group Header. - + Select to show or hide the Group Footer. - + Select to create a new group on each changed value, or on other properties. Removes the selected field from the list. @@ -81,7 +81,7 @@ For fields of type AutoNumber, Currency, or Number, you specify an interval.how? - + Enter the group interval value that records are grouped by. Select the level of detail by which a group is kept together on the same page. -- cgit From ced3a4d3aaac5c79e6e859a3cecf24dc5a6d95a2 Mon Sep 17 00:00:00 2001 From: Uwe Fischer Date: Fri, 23 Apr 2010 09:47:01 +0200 Subject: hcshared25: before rebase --- .../text/shared/explorer/database/rep_main.xhp | 34 +++++++++++----------- 1 file changed, 17 insertions(+), 17 deletions(-) (limited to 'helpcontent2/source/text/shared/explorer/database') diff --git a/helpcontent2/source/text/shared/explorer/database/rep_main.xhp b/helpcontent2/source/text/shared/explorer/database/rep_main.xhp index c221910ad0..6db770f8e8 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_main.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_main.xhp @@ -1,11 +1,11 @@ - + - - + + Report Builder @@ -50,13 +50,13 @@ Choose Tools - Extension Manager to open the Extension Manager. - Click the link "Get more extensions here". This opens your web browser at the address http://extensions.services.openoffice.org and shows a list of available extensions. + If you see the Report Builder in the Extension Manager list, then you do not need to install the extension. Else click the link "Get more extensions here". This opens your web browser at the address http://extensions.services.openoffice.org and shows a list of available extensions. - Find the Sun Report Builder extension. Click at the icon or the "click here" text link. This opens the download page for the extension. + Find the Report Builder extension. Click at the icon or the "click here" text link. This opens the download page for the extension. - Click the "Get it!" icon. The file "sun-report-builder.oxt" will be downloaded to your computer. + Click the "Get it!" icon. The extension file will be downloaded to your computer. Switch back from your web browser to the %PRODUCTNAME window. The Extension Manager should still be visible. @@ -65,8 +65,8 @@ In the Extension Manager, click Add to open the Add extensions dialog. - Select the "sun-report-builder.oxt" file that you downloaded. Click Open. - This starts the installation of the Sun Report Builder extension. + Select the extension file that you downloaded. Click Open. + This starts the installation of the Report Builder extension. Read the license. If you accept the license, click Accept to continue the installation. @@ -149,7 +149,7 @@ It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted. - You can also insert text that should be the same on every page of the report. Click the Label Field icon + You can also insert text that should be the same on every page of the report. Click the Label Field icon

Icon , then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want. @@ -184,7 +184,7 @@ To execute a report - Click the Execute Report icon + Click the Execute Report icon

Icon on the toolbar. @@ -193,12 +193,12 @@ If the database contents did change, execute the report again to update the result report.automatic? message? To edit a report First decide if you want to edit the generated report, which is a static Writer document, or if you want to edit the Report Builder view and then generate a new report based on the new design. - The Writer document is opened read-only. To edit the Writer document, click Edit File + The Writer document is opened read-only. To edit the Writer document, click Edit File

Icon on the Standard toolbar.saved automatically with the Base file? If you want to edit the Report Builder view, you can change some of its properties. Click in the Details area. Then in the Properties window, change some properties, for example the background color. - After finishing, click the Execute Report icon + After finishing, click the Execute Report icon

Icon to create a new report. If you close the Report Builder, you will be asked if the report should be saved. Click Yes, give the report a name, and click OK.report part of Base file? @@ -206,7 +206,7 @@ Without sorting or grouping, the records will be inserted into the report in the order in which they are retrieved from the database. - Open the Report Builder view and click the Sorting and Grouping icon + Open the Report Builder view and click the Sorting and Grouping icon

Icon on the toolbar. You see the Sorting and Grouping dialog. @@ -220,7 +220,7 @@ Grouping - Open the Report Builder view and click the Sorting and Grouping icon + Open the Report Builder view and click the Sorting and Grouping icon

Icon on the toolbar. You see the Sorting and Grouping dialog. @@ -228,7 +228,7 @@ In the Groups box, open the Group Header list box and select to show a group header. - Click the Add Field icon + Click the Add Field icon

Icon to open the Add Field window. @@ -242,7 +242,7 @@ If you like to sort and group, open the Report Builder view, then open the Sorting and Grouping dialog. Select to show a Group Header for the fields that you want to group, and select to hide the Group Header for the fields that you want to be sorted. Close the Sorting and Grouping window and execute the report. Updating and printing your data When you insert some new data or edit data in the table, a new report will show the updated data. - Click the Reports icon + Click the Reports icon

Icon and double-click your last saved report. A new Writer document will be created which shows the new data. To print a report, choose File - Print from the Writer document. -- cgit