1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabasedabapropaddxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Additional Settings</title>
<filename>/text/sdatabase/dabapropadd.xhp</filename>
</topic>
</meta>
<body>
<section id="dabapropadd">
<h1 id="par_idN1054D"><link href="text/sdatabase/dabapropadd.xhp">Additional Settings</link></h1>
<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US"><ahelp hid=".">Specifies additional options for a data source.</ahelp></paragraph>
</section>
<section id="howtoget">
<paragraph role="paragraph" id="par_id4641865" xml-lang="en-US">In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Additional Settings</emph> tab</paragraph>
</section>
<paragraph role="paragraph" id="par_idN10572" xml-lang="en-US">The availability of the following controls depends on the type of database:</paragraph>
<h2 id="par_idN10575">Host name</h2>
<paragraph role="paragraph" id="par_idN105D7" xml-lang="en-US"><ahelp hid=".">Enter the host name of the server that contains the database, for example ldap.server.com.</ahelp><comment>used for multiple database formats</comment></paragraph>
<h2 id="par_idN10579">Port number</h2>
<paragraph role="paragraph" id="par_idN105F6" xml-lang="en-US"><ahelp hid=".">Enter the port number for the server that hosts the database.</ahelp><comment>UFI: used for LDAP and MySQL, different default values</comment></paragraph>
<h2 id="par_idN1057D">MySQL JDBC driver class</h2>
<paragraph role="paragraph" id="par_idN10615" xml-lang="en-US"><ahelp hid=".">Enter the name of the JDBC driver for the MySQL database.</ahelp><comment>UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??)</comment></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_CHARSET" id="bm_id9317606" localize="false"/><h2 id="par_idN10581">Character set<comment>UFI: seen for dBase</comment><comment>and for text file folder</comment></h2>
<paragraph role="paragraph" id="par_idN10634" xml-lang="en-US"><ahelp hid=".">Select the character set that you want to use to view the database in $[officename].</ahelp> This setting does not affect the database. To use the default character set of your operating system, select "System".</paragraph>
<note id="par_idN10651">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.<comment>UFI. copied from shared\explorer\database\11020000.xhp</comment></note>
<h2 id="par_idN10585">Oracle JDBC driver class</h2>
<paragraph role="paragraph" id="par_idN10653" xml-lang="en-US"><ahelp hid=".">Enter the name of the JDBC driver for the Oracle database.</ahelp><comment>UFI: copied from shared\explorer\database\11110000.xhp but that was changed before (??)</comment></paragraph>
<h2 id="par_idN10589">Driver settings</h2>
<paragraph role="paragraph" id="par_idN10672" xml-lang="en-US"><ahelp hid=".">Specify additional driver options.</ahelp><comment>UFI. copied from shared\explorer\database\11020000.xhp</comment></paragraph>
<h2 id="par_idN1058D">Use catalog for file-based databases</h2>
<paragraph role="paragraph" id="par_idN10691" xml-lang="en-US"><ahelp hid=".">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.</ahelp><comment>UFI. copied from shared\explorer\database\11020000.xhp</comment></paragraph>
<h2 id="par_idN10591">Base DN</h2>
<paragraph role="paragraph" id="par_idN106B0" xml-lang="en-US"><ahelp hid=".">Enter the starting point to search the LDAP database, for example, dc=com.</ahelp><comment>copied from shared\explorer\database\11190000.xhp</comment></paragraph>
<h2 id="par_idN10595">Maximum number of records</h2>
<paragraph role="paragraph" id="par_idN106F3" xml-lang="en-US"><ahelp hid=".">Enter the maximum number of records that you want to load when you access the LDAP server.</ahelp></paragraph>
<h2 id="par_idN10599">Display deleted records as well<comment>UFI: seen for dBase, but Help ID is somewhere else</comment></h2>
<paragraph role="paragraph" id="par_idN10700" xml-lang="en-US"><ahelp hid=".">Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.</ahelp><comment>copied from shared\explorer\database\11030000.xhp</comment></paragraph>
<note id="par_idN10715">In dBASE format, deleted records remain in the file.</note>
<tip id="par_idN10718">To view changes that you make to the database, close the connection to the database, and then reconnect to the database.</tip>
<h2 id="par_idN1059D">Indexes<comment>UFI: seen for dBase</comment></h2>
<paragraph role="paragraph" id="par_idN10725" xml-lang="en-US"><ahelp hid=".">Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database.</ahelp><comment>UFI: removed link from extended help text</comment></paragraph>
<h2 id="par_idN105B9">Text contains headers<comment>UFI: the following found for a text file folder, but HELP Ids are somewhere else</comment></h2>
<paragraph role="paragraph" id="par_idN107B0" xml-lang="en-US"><ahelp hid=".">Select this check box if the first line of the text file contains field names.</ahelp><comment>copied from shared\explorer\database\11040000.xhp</comment></paragraph>
<h2 id="par_idN105BD">Field separator</h2>
<paragraph role="paragraph" id="par_idN107CF" xml-lang="en-US"><ahelp hid=".">Enter or select the character that separates data fields in the text file.</ahelp></paragraph>
<h2 id="par_idN105C1">Text separator</h2>
<paragraph role="paragraph" id="par_idN107DC" xml-lang="en-US"><ahelp hid=".">Enter or select the character that identifies a text field in the text file. You cannot use the same character as the field separator.</ahelp></paragraph>
<h2 id="par_idN105C5">Decimal separator</h2>
<paragraph role="paragraph" id="par_idN107E9" xml-lang="en-US"><ahelp hid=".">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).</ahelp></paragraph>
<h2 id="par_idN105C9">Thousands separator</h2>
<paragraph role="paragraph" id="par_idN107F6" xml-lang="en-US"><ahelp hid=".">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).</ahelp></paragraph>
<h2 id="par_idN105CD">File extension</h2>
<paragraph role="paragraph" id="par_idN10803" xml-lang="en-US"><ahelp hid=".">Select the format for the text file.</ahelp> The extension that you select affects some of the default settings in this dialog. </paragraph>
</body>
</helpdocument>
|
