incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ksch...@apache.org
Subject svn commit: r1204763 [2/45] - in /incubator/ooo/ooo-site/trunk/content/documentation: HOW_TO/ HOW_TO/data_source/ HOW_TO/data_source/link_tablehtml/ HOW_TO/drawing_graphics/ HOW_TO/files_performances/ HOW_TO/formula/ HOW_TO/img/ HOW_TO/impress/ HOW_TO/...
Date Tue, 22 Nov 2011 00:55:19 GMT

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/SQLite.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/SQLite.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/SQLite.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/SQLite.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/SQLite.sxw?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/SQLite.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.html Tue
Nov 22 00:35:05 2011
@@ -0,0 +1,118 @@
+<html>
+<head>
+<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">
+</head>
+<body>
+<h2 align="center">How to Create a Data Source from Scratch</h2>
+<h5 align="center">provided by</h5>
+<h5 align="center"><i>the OpenOffice.org Documentation Project</i></h5>
+<h3>Table of Contents</h3>
+<ol>
+    <li><a href="#Create"><span style="font-weight: medium">Create the
Data Source</span></a></li>
+    <li><a href="#Add Tables"><span style="font-weight: medium">Adding
Tables to a Data Source</span></a></li>
+    <li><a href="#Editing"><span style="font-weight: medium">Editing Tables
in a Data Source</span></a></li>
+    <li><a href="#Now"><span style="font-weight: medium">What do I do now?</span></a></li>
+</ol>
+<a name="Create"></a>
+<h3>Create the Data Source</h3>
+<p>These steps will run you through setting up a Data Source in the OpenOffice.org
system. &nbsp;A dBase type database will be created for cross platform consistancy.</p>
+<ol>
+    <li>Select the <i>Tools-Data Source menu.</i></li>
+    <li>Click <b>New Data Source</b>.</li>
+    <li>Enter a name for your Data Source. &nbsp;<b>NOTE:</b> &nbsp;I
am going to use TEST as the Data Source name.</li>
+    <li>Press Tab.</li>
+    <li>Select dBase as the Data Source. &nbsp;<b>NOTE:</b> &nbsp;We
are using dBase, because it allows full control over the database on a local system.</li>
+    <li>Press Tab.</li>
+    <li>Enter a directory for the program to store the data files in. &nbsp;Be
sure to enter a directory that DOES NOT exist. &nbsp;The program will automatically create
it for you.</li>
+    <li>Click <b>Apply</b>.</li>
+</ol>
+<a name="Add Tables"></a>
+<h3>Adding Tables in a Data Source</h3>
+<p>In this section, we will go over how to Add tables in a Data Source. &nbsp;This
section assumes that your Data Source allows full access to the database. &nbsp;Currently,
dBase or Spreadsheet are the only types that allow this type of access to files on your computer.
&nbsp;JDBC and ODBC can be used if you already have a Database System setup like MySQL,
SQL Server, or ORACLE.</p>
+<ol>
+    <li>Click on the <b>Tables</b> tab.</li>
+    <li>Click on the New Table icon. <img src="newtable.png"/></li>
+    <li>The Table Design screen will show<br>
+    <img src="tabledesign.png"/></li>
+    <li>Enter Name.</li>
+    <li>Press <b>Tab</b> 3 times.</li>
+    <li>Enter Telephone.</li>
+    <li>Press <b>Tab</b> 3 times.</li>
+    <li>Enter Address.</li>
+    <li>Press <b>Tab</b> 3 times.</li>
+    <li>Enter City.</li>
+    <li>Press <b>Tab</b> 3 times.</li>
+    <li>Enter State.</li>
+    <li>Press <b>Tab</b> 3 times.</li>
+    <li>Enter Zip.</li>
+    <li>Click on File.</li>
+    <li>Click on Save.</li>
+    <li>Select a Name for your table. &nbsp;<b>NOTE:</b> &nbsp;For
this How To, we will use TestTable.</li>
+    <li>Close the Table Design screen.</li>
+    <li>Close the Data Source window.</li>
+</ol>
+<a name="Editing"></a>
+<h3>Edit data in a Data Source</h3>
+<p>This section demonstrates how OpenOffice.org can be used to enter, edit, and remove
values in a Data Source.</p>
+<ol><b>Adding Records</b>
+    <li>Press <b>F4</b>.</li>
+    <li>The Data Explorer window appears.<br>
+    <img src="dataexpl.png"/></li>
+    <li>Click on the <b>Test</b> Data Source.</li>
+    <li>Click on Tables.</li>
+    <li>Click on TestTable</li> 
+    <li>If no records exist in the table, anything you type will automatically start
a new record.  Otherwise, click the New Record button <img src="newrecord.png"/>.</li>
+    <li>Enter the following information pressing tab between fields:
+    <table border=1>
+        <tr>
+            <td>John Doe</td>
+            <td>999-999-9999</td>
+            <td>1234 Anywhere</td>
+            <td>This Town</td>
+            <td>This State</td>
+            <td>12345</td>
+        </tr>
+        <tr>
+            <td>Jane Doe</td>
+            <td>122-122-1222</td>
+            <td>5431 Here Street</td>
+            <td>This Town</td>
+            <td>This State</td>
+            <td>12345</td>
+        <tr>
+    </table></li>
+</ol>
+<ol><b>Editing Records</b>
+    <li>Click in John Doe's Telephone field.</li>
+    <li>Enter 888-888-8888</li>
+    <li>Press the Down Arrow. &nbsp;<b>NOTE:</b> &nbsp;Moving to
a new record saves your changes.</li>
+</ol>
+<ol><b>Deleting Records</b>
+    <li>Click on the Row Selector in front of Jane Doe. &nbsp;Either <img src="recordselect1.png"/>
or <img src="recordselect2.png"/> will select the record.</li>
+    <li>Right click.</li>
+    <li>Select <b>Delete Rows</b>.</li>
+</ol>
+<a name="Now"></a>
+<h3>What to do now?</h3>
+<p>Now that you have seen some of the things that OpenOffice.org can do with Databases,
I would suggest the following:</p> 
+<ol>
+    <li>Play around with the different column types when adding tables.</li>
+    <li>Look into creating SQL statements when in the Data Source screen.</li>
+</ol>
+<p><b>NOTE:</b> &nbsp;You will not hurt anything by playing around
with the database that was created in this How To.</p>
+<div> 
+  <h3><b><a name="5"></a>5. Credits</b></h3>
+  <p><b>Author</b> : Scott Carr</p>
+</div>
+<div> 
+  <p><b>Intgr by</b> : Gianluca Turconi</p>
+</div>
+<div> 
+  <p><b>Last modified</b> : March 2, 2002</p>
+</div>
+<div> 
+  <p><b>Contacts</b> : <span style="font-weight: medium">OpenOffice.org
Documentation 
+    Project </span><a href="http://documentation.openoffice.org/index.html"><span
style="font-weight: medium">http://documentation.openoffice.org/index.html</span></a></p>
+</div>
+</body>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.sxw?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/data1_EN.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/dataexpl.png
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/dataexpl.png?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/dataexpl.png
------------------------------------------------------------------------------
    svn:mime-type = image/png

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/datatable.png
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/datatable.png?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/datatable.png
------------------------------------------------------------------------------
    svn:mime-type = image/png

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/how_to_link_tables_using_named_parameters.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/how_to_link_tables_using_named_parameters.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/how_to_link_tables_using_named_parameters.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/how_to_link_tables_using_named_parameters.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/how_to_link_tables_using_named_parameters.sxw?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/data_source/how_to_link_tables_using_named_parameters.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream



Mime
View raw message