summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2021-03-22 17:22:56 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-03-23 16:51:42 +0100
commitab806360c69c9f59c7782535d4e8a95bd939276e (patch)
tree329ac38f509f2ad376005924ae6d5fe326759d4c
parentrelated to: tdf#140601 add "howtoget" and improve explanation (diff)
downloadhelp-ab806360c69c9f59c7782535d4e8a95bd939276e.tar.gz
help-ab806360c69c9f59c7782535d4e8a95bd939276e.zip
Refatctor database help files
put them in /sdatabase/ Change-Id: I80bcd63dacf36f36e189dfe93e6a4f7ab5d865e5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/112940 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--AllLangHelp_sdatabase.mk5
-rw-r--r--AllLangHelp_shared.mk5
-rw-r--r--source/text/sdatabase/05030000.xhp (renamed from source/text/shared/explorer/database/05030000.xhp)13
-rw-r--r--source/text/sdatabase/05030100.xhp (renamed from source/text/shared/explorer/database/05030100.xhp)33
-rw-r--r--source/text/sdatabase/05030200.xhp (renamed from source/text/shared/explorer/database/05030200.xhp)21
-rw-r--r--source/text/sdatabase/05030300.xhp (renamed from source/text/shared/explorer/database/05030300.xhp)29
-rw-r--r--source/text/sdatabase/05030400.xhp (renamed from source/text/shared/explorer/database/05030400.xhp)21
7 files changed, 52 insertions, 75 deletions
diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk
index f6a005f86d..b9cd52e672 100644
--- a/AllLangHelp_sdatabase.mk
+++ b/AllLangHelp_sdatabase.mk
@@ -30,6 +30,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\
helpcontent2/source/text/sdatabase/05010100 \
helpcontent2/source/text/sdatabase/05020000 \
helpcontent2/source/text/sdatabase/05020100 \
+ helpcontent2/source/text/sdatabase/05030000 \
+ helpcontent2/source/text/sdatabase/05030100 \
+ helpcontent2/source/text/sdatabase/05030200 \
+ helpcontent2/source/text/sdatabase/05030300 \
+ helpcontent2/source/text/sdatabase/05030400 \
helpcontent2/source/text/sdatabase/toolbars \
))
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index d81d87cd5e..97c1a0a161 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -861,11 +861,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
))
$(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
- helpcontent2/source/text/shared/explorer/database/05030000 \
- helpcontent2/source/text/shared/explorer/database/05030100 \
- helpcontent2/source/text/shared/explorer/database/05030200 \
- helpcontent2/source/text/shared/explorer/database/05030300 \
- helpcontent2/source/text/shared/explorer/database/05030400 \
helpcontent2/source/text/shared/explorer/database/05040000 \
helpcontent2/source/text/shared/explorer/database/05040100 \
helpcontent2/source/text/shared/explorer/database/05040200 \
diff --git a/source/text/shared/explorer/database/05030000.xhp b/source/text/sdatabase/05030000.xhp
index 8f6da339c8..ca3b9a1885 100644
--- a/source/text/shared/explorer/database/05030000.xhp
+++ b/source/text/sdatabase/05030000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,19 +16,18 @@
* 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="textsharedexplorerdatabase05030000xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Copy a Table by Drag-and-Drop</title>
-<filename>/text/shared/explorer/database/05030000.xhp</filename>
+<filename>/text/sdatabase/05030000.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
</history>
</meta>
<body>
-<paragraph role="heading" id="hd_id3154894" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05030000.xhp" name="Copy Query or Table by Drag-and-Drop">Copy Query or Table by Drag-and-Drop</link></paragraph>
+<h1 id="hd_id3154894"><link href="text/sdatabase/05030000.xhp" name="Copy Query or Table by Drag-and-Drop">Copy Query or Table by Drag-and-Drop</link></h1>
<bookmark xml-lang="en-US" branch="index" id="bm_id3155535"><bookmark_value>queries; copying (Base)</bookmark_value>
<bookmark_value>tables in databases; copying database tables (Base)</bookmark_value>
</bookmark><comment>mw deleted "database tables;"</comment>
@@ -48,8 +45,8 @@
</listitem>
</list>
<paragraph role="paragraph" id="par_id3155628" xml-lang="en-US">You can copy within the same database or between different databases.</paragraph>
-<embed href="text/shared/explorer/database/05030100.xhp#tablecopy"/>
-<embed href="text/shared/explorer/database/05030200.xhp#tablecopy2"/>
-<embed href="text/shared/explorer/database/05030300.xhp#tablecopy3"/>
+<embed href="text/sdatabase/05030100.xhp#tablecopy"/>
+<embed href="text/sdatabase/05030200.xhp#tablecopy2"/>
+<embed href="text/sdatabase/05030300.xhp#tablecopy3"/>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/05030100.xhp b/source/text/sdatabase/05030100.xhp
index 23d5f08b23..7151193e63 100644
--- a/source/text/shared/explorer/database/05030100.xhp
+++ b/source/text/sdatabase/05030100.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,42 +16,40 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase05030100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Copy Table</title>
-<filename>/text/shared/explorer/database/05030100.xhp</filename>
+<filename>/text/sdatabase/05030100.xhp</filename>
</topic>
</meta>
<body>
<section id="tablecopy">
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/CopyTablePage" id="bm_id3154841" localize="false"/>
-<paragraph role="heading" id="hd_id3085157" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05030100.xhp" name="Copy Table">Copy Table</link></paragraph>
+<h1 id="hd_id3085157"><link href="text/sdatabase/05030100.xhp" name="Copy Table">Copy Table</link></h1>
<paragraph role="paragraph" id="par_id3149264" xml-lang="en-US">You can copy a table by dragging and dropping the table onto the table area of a database file window. The <emph>Copy table </emph>dialog appears.</paragraph>
</section>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/name" id="bm_id3154840" localize="false"/><paragraph role="heading" id="hd_id3154926" xml-lang="en-US" level="2">Table name</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/name" id="bm_id3154840" localize="false"/><h2 id="hd_id3154926">Table name</h2>
<paragraph role="paragraph" id="par_id3144740" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/name">Specifies a name for the copy.</ahelp> Some databases only accept names containing eight or fewer characters.</paragraph>
-<paragraph role="heading" id="hd_id3154228" xml-lang="en-US" level="2">Options</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/defdata" id="bm_id3147576" localize="false"/><paragraph role="heading" id="hd_id3157898" xml-lang="en-US" level="3">Definition and data</paragraph>
+<h2 id="hd_id3154228">Options</h2>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/defdata" id="bm_id3147576" localize="false"/><h3 id="hd_id3157898">Definition and data</h3>
<paragraph role="paragraph" id="par_id3150178" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/defdata">Creates a 1:1 copy of the database table.</ahelp> 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.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/def" id="bm_id3147226" localize="false"/><paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="3">Definition</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/def" id="bm_id3147226" localize="false"/><h3 id="hd_id3149346">Definition</h3>
<paragraph role="paragraph" id="par_id3156426" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/def">Copies only the table definition and not the corresponding data.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/view" id="bm_id3149096" localize="false"/><paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="3">As table view</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/view" id="bm_id3149096" localize="false"/><h3 id="hd_id3143267">As table view</h3>
<paragraph role="paragraph" id="par_id3153311" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/view">If the database supports Views and you selected this option, a query will be created in the table container as a table. This option allows you to view the query results as a normal table view.</ahelp> The table will be filtered in the view with a "Select" SQL statement.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/data" id="bm_id3156347" localize="false"/><paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="3">Append data<comment>see #i63815</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/data" id="bm_id3156347" localize="false"/><h3 id="hd_id3155535">Append data<comment>see #i63815</comment></h3>
<paragraph role="paragraph" id="par_id3166410" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/data">Appends the data of the table to be copied to an existing table.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3147275" xml-lang="en-US">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.</paragraph>
-<paragraph role="paragraph" id="par_id3156117" xml-lang="en-US">Match the data field names in the<emph> Copy Table</emph> dialog on the <link href="text/shared/explorer/database/05030400.xhp" name="Apply Columns">Apply Columns</link> page.</paragraph>
+<paragraph role="paragraph" id="par_id3156117" xml-lang="en-US">Match the data field names in the<emph> Copy Table</emph> dialog on the <link href="text/sdatabase/05030400.xhp" name="Apply Columns">Apply Columns</link> page.</paragraph>
<paragraph role="paragraph" id="par_id3153252" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/data">If the data cannot be attached, you will see a list of fields in the <emph>Column Info</emph> dialog whose data cannot be copied.</ahelp> If you confirm this dialog with OK, only the data that does not appear in the list will be attached.</paragraph>
-<paragraph role="note" id="par_id3158430" xml-lang="en-US">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.</paragraph>
+<note id="par_id3158430">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.</note>
<bookmark xml-lang="en-US" branch="index" id="bm_id3149164"><bookmark_value>primary keys; defining</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/primarykey" id="bm_id3148564" localize="false"/><paragraph role="heading" id="hd_id3149164" xml-lang="en-US" level="3">Create primary key</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/primarykey" id="bm_id3148564" localize="false"/><h3 id="hd_id3149164">Create primary key</h3>
<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/primarykey">Automatically generates a primary key data field and fills it with values.</ahelp> You should always use this field, since a primary key must always be available in order to edit the table.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/keyname" id="bm_id3147303" localize="false"/><paragraph role="heading" id="hd_id3146794" xml-lang="en-US" level="3">Name</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/copytablepage/keyname" id="bm_id3147303" localize="false"/><h3 id="hd_id3146794">Name</h3>
<paragraph role="paragraph" id="par_id3156343" xml-lang="en-US"><ahelp hid="dbaccess/ui/copytablepage/keyname">Specifies a name for the primary key generated. This name is optional.</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3151056" xml-lang="en-US"><link href="text/shared/explorer/database/05030200.xhp" name="Next page">Next page</link></paragraph>
+<paragraph role="paragraph" id="par_id3151056" xml-lang="en-US"><link href="text/sdatabase/05030200.xhp" name="Next page">Next page</link></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/05030200.xhp b/source/text/sdatabase/05030200.xhp
index cbcf36a685..d26f815241 100644
--- a/source/text/shared/explorer/database/05030200.xhp
+++ b/source/text/sdatabase/05030200.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,31 +16,29 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase05030200xml" indexer="exclude" status="PUBLISH">
<title id="tit" xml-lang="en-US">Apply columns</title>
-<filename>/text/shared/explorer/database/05030200.xhp</filename>
+<filename>/text/sdatabase/05030200.xhp</filename>
</topic>
</meta>
<body>
<section id="tablecopy2">
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/ApplyColPage" id="bm_id3155806" localize="false"/>
-<paragraph role="heading" id="hd_id3150445" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05030200.xhp" name="Apply columns">Apply columns</link></paragraph>
+<h1 id="hd_id3150445"><link href="text/sdatabase/05030200.xhp" name="Apply columns">Apply columns</link></h1>
<paragraph role="paragraph" id="par_id3147143" xml-lang="en-US">In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The <emph>Apply columns </emph>dialog is the second window of the <emph>Copy table</emph> dialog.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3155552" xml-lang="en-US" level="2">Existing columns</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/from" id="bm_id3155805" localize="false"/><paragraph role="heading" id="hd_id3154751" xml-lang="en-US" level="3">Left list box</paragraph>
+<h2 id="hd_id3155552">Existing columns</h2>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/from" id="bm_id3155805" localize="false"/><h3 id="hd_id3154751">Left list box</h3>
<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US"><ahelp hid="dbaccess/ui/applycolpage/from">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 &gt; button. To copy all of the fields, click the <emph>&gt;&gt;</emph> button.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/to" id="bm_id3149827" localize="false"/><paragraph role="heading" id="hd_id3154823" xml-lang="en-US" level="3">Right list box</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/to" id="bm_id3149827" localize="false"/><h3 id="hd_id3154823">Right list box</h3>
<paragraph role="paragraph" id="par_id3156426" xml-lang="en-US"><ahelp hid="dbaccess/ui/applycolpage/to">Lists the fields that you want to include in the copied table.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colrh" id="bm_id3152781" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colsrh" id="bm_id3147653" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/collh" id="bm_id3151110" localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colslh" id="bm_id3152996" localize="false"/><paragraph role="heading" id="hd_id3147242" xml-lang="en-US" level="3">Buttons</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colslh" id="bm_id3152996" localize="false"/><h3 id="hd_id3147242">Buttons</h3>
<paragraph role="paragraph" id="par_id3146797" xml-lang="en-US"><ahelp hid=".">Adds or removes the selected field (&gt; or &lt; button) or all of the fields (&lt;&lt; or &gt;&gt; button).</ahelp></paragraph>
-<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US"><link href="text/shared/explorer/database/05030300.xhp" name="Next page">Next page</link></paragraph>
+<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US"><link href="text/sdatabase/05030300.xhp" name="Next page">Next page</link></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/05030300.xhp b/source/text/sdatabase/05030300.xhp
index 0833ecad04..812cc215fa 100644
--- a/source/text/shared/explorer/database/05030300.xhp
+++ b/source/text/sdatabase/05030300.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,14 +16,11 @@
* 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="textsharedexplorerdatabase05030300xml" indexer="exclude" status="PUBLISH">
<title id="tit" xml-lang="en-US">Type formatting</title>
-<filename>/text/shared/explorer/database/05030300.xhp</filename>
+<filename>/text/sdatabase/05030300.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
@@ -33,36 +28,36 @@
</meta>
<body>
<section id="tablecopy3">
-<paragraph role="heading" id="hd_id3163829" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05030300.xhp" name="Type formatting">Type formatting</link></paragraph>
+<h1 id="hd_id3163829"><link href="text/sdatabase/05030300.xhp" name="Type formatting">Type formatting</link></h1>
<paragraph role="paragraph" id="par_id3150247" xml-lang="en-US">In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The<emph> Type formatting </emph>dialog is the third window of the <emph>Copy table</emph> dialog.</paragraph>
</section>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/typeselectpage/columnnames" id="bm_id3147291" localize="false"/>
-<paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="2">List box</paragraph>
+<h2 id="hd_id3152801">List box</h2>
<paragraph role="paragraph" id="par_id3145313" xml-lang="en-US"><ahelp hid="dbaccess/ui/typeselectpage/columnnames">Lists the data fields that will be included in to the copied table.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="2">Column information</paragraph>
+<h2 id="hd_id3155535">Column information</h2>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_COLUMNNAME" id="bm_id3153311" localize="false"/>
-<paragraph role="heading" id="hd_id3156426" xml-lang="en-US" level="3">Field name</paragraph>
+<h3 id="hd_id3156426">Field name</h3>
<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US"><ahelp hid=".">Displays the name of the selected data field. If you want, you can enter a new name.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_TYPE" id="bm_id3154749" localize="false"/>
-<paragraph role="heading" id="hd_id3156113" xml-lang="en-US" level="3">Field type</paragraph>
+<h3 id="hd_id3156113">Field type</h3>
<paragraph role="paragraph" id="par_id3149811" xml-lang="en-US"><ahelp hid=".">Select a field type.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_TEXT_LEN" id="bm_id3149795" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_LEN" id="bm_id3149516" localize="false"/>
-<paragraph role="heading" id="hd_id3149763" xml-lang="en-US" level="3">Length</paragraph>
+<h3 id="hd_id3149763">Length</h3>
<paragraph role="paragraph" id="par_id3155449" xml-lang="en-US"><ahelp hid=".">Enter the number of characters for the data field.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_SCALE" id="bm_id3154285" localize="false"/>
-<paragraph role="heading" id="hd_id3159176" xml-lang="en-US" level="3">Decimal places</paragraph>
+<h3 id="hd_id3159176">Decimal places</h3>
<paragraph role="paragraph" id="par_id3153666" xml-lang="en-US"><ahelp hid=".">Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_BOOL_DEFAULT" id="bm_id3156155" localize="false"/>
-<paragraph role="heading" id="hd_id3150276" xml-lang="en-US" level="3">Default value</paragraph>
+<h3 id="hd_id3150276">Default value</h3>
<paragraph role="paragraph" id="par_id3147620" xml-lang="en-US"><ahelp hid=".">Select the default value for a Yes/No field.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="2">Automatic type recognition</paragraph>
+<h2 id="hd_id3153087">Automatic type recognition</h2>
<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US">$[officename] can automatically recognize field contents when you copy database tables by drag and drop.</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/typeselectpage/auto" id="bm_id3153061" localize="false"/>
-<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="3">(max.) lines</paragraph>
+<h3 id="hd_id3156023">(max.) lines</h3>
<paragraph role="paragraph" id="par_id3155923" xml-lang="en-US"><ahelp hid="dbaccess/ui/typeselectpage/auto">Enter the number of lines to use for automatic type recognition.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/typeselectpage/autobutton" id="bm_id3148946" localize="false"/>
-<paragraph role="heading" id="hd_id3154347" xml-lang="en-US" level="3">Auto</paragraph>
+<h3 id="hd_id3154347">Auto</h3>
<paragraph role="paragraph" id="par_id3152361" xml-lang="en-US"><ahelp hid="dbaccess/ui/typeselectpage/autobutton">Enables automatic type recognition.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/05030400.xhp b/source/text/sdatabase/05030400.xhp
index feb9c11a27..b3e6039f41 100644
--- a/source/text/shared/explorer/database/05030400.xhp
+++ b/source/text/sdatabase/05030400.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,14 +16,11 @@
* 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="textsharedexplorerdatabase05030400xml" indexer="exclude" status="PUBLISH">
<title id="tit" xml-lang="en-US">Assign columns</title>
-<filename>/text/shared/explorer/database/05030400.xhp</filename>
+<filename>/text/sdatabase/05030400.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
@@ -33,28 +28,28 @@
</meta>
<body>
<section id="tablecopy2a">
-<paragraph role="heading" id="hd_id3151100" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05030400.xhp" name="Assign columns">Assign columns</link></paragraph>
+<h1 id="hd_id3151100"><link href="text/sdatabase/05030400.xhp" name="Assign columns">Assign columns</link></h1>
<paragraph role="paragraph" id="par_id3156027" xml-lang="en-US">In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. If you select the <emph>Attach data </emph>check box on the first page of the <emph>Copy table </emph>dialog, the <emph>Assign columns </emph>dialog opens as the second window. You can use this dialog to map the contents of a data field in the source table to a different data field in the destination table.</paragraph>
</section>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/left" id="bm_id3153527" localize="false"/>
-<paragraph role="heading" id="hd_id3157958" xml-lang="en-US" level="2">Source table</paragraph>
+<h2 id="hd_id3157958">Source table</h2>
<paragraph role="paragraph" id="par_id3145071" xml-lang="en-US"><ahelp hid="dbaccess/ui/namematchingpage/left">Lists the data fields in the source table. To include a data field from the source table in the destination table, select the check box in front of the data field name. To map the contents of a data field in the source table to a different data field in the destination table, click the data field in the source table list, and then click the up or down arrow.</ahelp> To include all of the source data fields in the destination table, click <emph>All</emph>.</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/right" id="bm_id3147242" localize="false"/>
-<paragraph role="heading" id="hd_id3166410" xml-lang="en-US" level="2">Destination table</paragraph>
+<h2 id="hd_id3166410">Destination table</h2>
<paragraph role="paragraph" id="par_id3154749" xml-lang="en-US"><ahelp hid="dbaccess/ui/namematchingpage/right">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.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/up" id="bm_id3149516" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/up_right" id="bm_id3155342" localize="false"/>
-<paragraph role="heading" id="hd_id3150670" xml-lang="en-US" level="2">up</paragraph>
+<h2 id="hd_id3150670">up</h2>
<paragraph role="paragraph" id="par_id3155628" xml-lang="en-US"><ahelp hid=".">Moves the selected entry up one position in the list.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/down" id="bm_id3154307" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/down_right" id="bm_id3153716" localize="false"/>
-<paragraph role="heading" id="hd_id3149580" xml-lang="en-US" level="2">down</paragraph>
+<h2 id="hd_id3149580">down</h2>
<paragraph role="paragraph" id="par_id3150984" xml-lang="en-US"><ahelp hid=".">Moves the selected entry down one position in the list.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/all" id="bm_id3147619" localize="false"/>
-<paragraph role="heading" id="hd_id3156156" xml-lang="en-US" level="2">all</paragraph>
+<h2 id="hd_id3156156">all</h2>
<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US"><ahelp hid="dbaccess/ui/namematchingpage/all">Selects all of the data fields in the list.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/namematchingpage/none" id="bm_id3155341" localize="false"/>
-<paragraph role="heading" id="hd_id3153541" xml-lang="en-US" level="2">none</paragraph>
+<h2 id="hd_id3153541">none</h2>
<paragraph role="paragraph" id="par_id3148563" xml-lang="en-US"><ahelp hid="dbaccess/ui/namematchingpage/none">Clears all of the check boxes in the list.</ahelp></paragraph>
</body>
</helpdocument>