https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&action=history&feed=atom
Configuring and Using Databases - Revision history
2024-03-28T14:42:23Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=11189&oldid=prev
Sardisson: Lorinda moved everything interesting to NeoBase; redirect people there from other old links
2007-07-24T01:50:39Z
<p>Lorinda moved everything interesting to <a href="/index.php/NeoBase" title="NeoBase">NeoBase</a>; redirect people there from other old links</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:50, 24 July 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{handbook sidebar|DatabaseTOC}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">redirect </ins>[[<ins style="color: red; font-weight: bold; text-decoration: none;">NeoBase</ins>]]</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{fixme}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">While NeoOffice 1.2.x, NeoOffice/J 1.1 and [[OpenOffice.org Mac OS X (X11)|OpenOffice.org/X11 1.1.x]] do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports. NeoOffice 2.0 includes a new database component, “Baseâ€, but you can still connect to various external databases and manipulate data from NeoOffice.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">If you do not have a MySQL or hsqldb database, you can also [[Creating_a_Database|create a simple database]] in NeoOffice or OpenOffice.org/X11—or even [[Using a Calc spreadsheet as a data source|use a Calc table]] if your needs are very simple.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">The various pages of this article contain information on installing, configuring, and using a these databases with NeoOffice or OpenOffice.org/X11.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">''Maybe insert a screenshot here to balance the length of the page vs. the length of the TOC--the TOC will get shorter when the articles are done, but storing comments there now until we decide on page names, etc.''</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">''Include a reference to the [[Importing_Data_from_Address_Book|Address Book]] article somewhere, though it's not part of this article''</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">===dbf import tip===</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">The table structure of the dbf file for all the fields</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">containing leading apostrophes say they are characters. This can easily seen if</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">you import the DBF file and look at the first row. All columns have a header</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">defining it. C is for characters (text), N would be numeric.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">So Calc imports the values correctly as Characters. As the number format for the</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">default template is set to numeric, a apostrophe is placed in front of the</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">value to make it a text.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">To change such text values to real numeric values, you have two choices.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">1.) Change the field setting in the DBF from C to N and re-import the file or</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">2.) use the Search and replace functionality. Open the search and replace dialog</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">and enter '.*' (without the quotes) into the search field. Type '&' (also</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">without quotes) into the replace field. Now press on the More Button and tag the</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">option Regular expression. Click on replace all and all the apostrophes should</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">be gone.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">===MS Access-related tips===</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. </del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. It is a commercial one, but it works. The [http://www.mysql.com/products/tools/migration-toolkit/ MySQL Migration Toolkit] for the Mac can be found in the [http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle] and can be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with). Other options are discussed on the [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436</del>#<del style="color: red; font-weight: bold; text-decoration: none;">23436 Trinity forum].</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">==Related External Links==</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">[http://hsqldb.org/web/hsqlDocsFrame.html HSQL Documentation]</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">:useful site for documentation on the underlying HSQL used by OpenOffice, including SQL syntax that can be used in working with databases.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">[[Category:Tips and Hints]][[Category:NeoOffice]]</del>[[<del style="color: red; font-weight: bold; text-decoration: none;">Category:OpenOffice.org</del>]]</td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=10835&oldid=prev
Lorinda: /* Related External Links */ fix link
2007-05-24T16:40:03Z
<p><span class="autocomment">Related External Links -</span> fix link</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:40, 24 May 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 37:</strong></td>
<td colspan="2" align="left"><strong>Line 37:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Related External Links==</td><td> </td><td style="background: #eee; font-size: smaller;">==Related External Links==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">[http://hsqldb.org/web/hsqlDocsFrame.html<del style="color: red; font-weight: bold; text-decoration: none;">|</del>HSQL Documentation]</td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://hsqldb.org/web/hsqlDocsFrame.html HSQL Documentation]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:useful site for documentation on the underlying HSQL used by OpenOffice, including SQL syntax that can be used in working with databases.</td><td> </td><td style="background: #eee; font-size: smaller;">:useful site for documentation on the underlying HSQL used by OpenOffice, including SQL syntax that can be used in working with databases.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=10834&oldid=prev
Lorinda: /* MS Access-related tips */ add link
2007-05-24T16:39:29Z
<p><span class="autocomment">MS Access-related tips -</span> add link</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:39, 24 May 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 35:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. It is a commercial one, but it works. The [http://www.mysql.com/products/tools/migration-toolkit/ MySQL Migration Toolkit] for the Mac can be found in the [http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle] and can be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with). Other options are discussed on the [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436 Trinity forum].</td><td> </td><td style="background: #eee; font-size: smaller;">An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. It is a commercial one, but it works. The [http://www.mysql.com/products/tools/migration-toolkit/ MySQL Migration Toolkit] for the Mac can be found in the [http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle] and can be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with). Other options are discussed on the [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436 Trinity forum].</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">==Related External Links==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://hsqldb.org/web/hsqlDocsFrame.html|HSQL Documentation]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">:useful site for documentation on the underlying HSQL used by OpenOffice, including SQL syntax that can be used in working with databases.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=9189&oldid=prev
Ovvldc: /* MS Access-related tips */ added link to Mac version of migration toolkit
2007-02-14T22:07:17Z
<p><span class="autocomment">MS Access-related tips -</span> added link to Mac version of migration toolkit</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 22:07, 14 February 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 34:</strong></td>
<td colspan="2" align="left"><strong>Line 34:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. </td><td> </td><td style="background: #eee; font-size: smaller;">Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. a commercial one, but it works.</td><td>+</td><td style="background: #cfc; font-size: smaller;">An ODBC driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. <ins style="color: red; font-weight: bold; text-decoration: none;">It is </ins>a commercial one, but it works. <ins style="color: red; font-weight: bold; text-decoration: none;">The </ins>[http://www.mysql.com/products/tools/migration-toolkit/ <ins style="color: red; font-weight: bold; text-decoration: none;">MySQL </ins>Migration Toolkit] for the Mac <ins style="color: red; font-weight: bold; text-decoration: none;">can be found in </ins>the <ins style="color: red; font-weight: bold; text-decoration: none;">[http://dev</ins>.<ins style="color: red; font-weight: bold; text-decoration: none;">mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle] and can </ins>be <ins style="color: red; font-weight: bold; text-decoration: none;">used to move data from an MS Access database to </ins>a <ins style="color: red; font-weight: bold; text-decoration: none;">MySQL one (which NeoOffice will happily deal with). Other options are discussed on the </ins>[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436 <ins style="color: red; font-weight: bold; text-decoration: none;">Trinity forum</ins>]<ins style="color: red; font-weight: bold; text-decoration: none;">.</ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">hopefully the </del>[http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac <del style="color: red; font-weight: bold; text-decoration: none;">will come out soon. </del>the <del style="color: red; font-weight: bold; text-decoration: none;">windows version does the job</del>. <del style="color: red; font-weight: bold; text-decoration: none;">perhaps we have to </del>be a <del style="color: red; font-weight: bold; text-decoration: none;">little patience</del>[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]] [[It:Configurare_ed_Usare_i_Database|Italiano]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
</table>
Ovvldc
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=8335&oldid=prev
Valterb: botlangbar -> IT
2007-01-15T22:37:02Z
<p>botlangbar -> IT</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 22:37, 15 January 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 37:</strong></td>
<td colspan="2" align="left"><strong>Line 37:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]]}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français<ins style="color: red; font-weight: bold; text-decoration: none;">]] [[It:Configurare_ed_Usare_i_Database|Italiano</ins>]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
</table>
Valterb
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=7353&oldid=prev
Jgd: fix typo
2006-12-03T14:12:30Z
<p>fix typo</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:12, 3 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 34:</strong></td>
<td colspan="2" align="left"><strong>Line 34:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. </td><td> </td><td style="background: #eee; font-size: smaller;">Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">An <del style="color: red; font-weight: bold; text-decoration: none;">ODCB </del>driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. a commercial one, but it works.</td><td>+</td><td style="background: #cfc; font-size: smaller;">An <ins style="color: red; font-weight: bold; text-decoration: none;">ODBC </ins>driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. a commercial one, but it works.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
</table>
Jgd
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=7350&oldid=prev
Jgd: botlangbar -> FR
2006-12-03T14:00:38Z
<p>botlangbar -> FR</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:00, 3 December 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 37:</strong></td>
<td colspan="2" align="left"><strong>Line 37:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Configurer_et_Utiliser_des_Bases_de_Données|Français]]}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
</table>
Jgd
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=6694&oldid=prev
Sardisson: {{fixme}}
2006-09-02T04:28:02Z
<p>{{fixme}}</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 04:28, 2 September 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{handbook sidebar|DatabaseTOC}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{handbook sidebar|DatabaseTOC}}</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">{{fixme}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">While NeoOffice 1.2.x, NeoOffice/J 1.1 and [[OpenOffice.org Mac OS X (X11)|OpenOffice.org/X11 1.1.x]] do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports. NeoOffice 2.0 includes a new database component, “Baseâ€, but you can still connect to various external databases and manipulate data from NeoOffice.</td><td> </td><td style="background: #eee; font-size: smaller;">While NeoOffice 1.2.x, NeoOffice/J 1.1 and [[OpenOffice.org Mac OS X (X11)|OpenOffice.org/X11 1.1.x]] do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports. NeoOffice 2.0 includes a new database component, “Baseâ€, but you can still connect to various external databases and manipulate data from NeoOffice.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td colspan="2" align="left"><strong>Line 36:</strong></td>
<td colspan="2" align="left"><strong>Line 37:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td><td> </td><td style="background: #eee; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org<del style="color: red; font-weight: bold; text-decoration: none;">]][[Category:Fixme</del>]]</td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=6645&oldid=prev
Sardisson: this page really shouldn't be a dumping-ground for other db tips, but it is for now ;)
2006-08-29T19:48:43Z
<p>this page really shouldn't be a dumping-ground for other db tips, but it is for now ;)</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 19:48, 29 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 29:</strong></td>
<td colspan="2" align="left"><strong>Line 29:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">option Regular expression. Click on replace all and all the apostrophes should</td><td> </td><td style="background: #eee; font-size: smaller;">option Regular expression. Click on replace all and all the apostrophes should</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">be gone.</td><td> </td><td style="background: #eee; font-size: smaller;">be gone.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">===MS Access-related tips===</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files. </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">An ODCB driver that works with MS Access on a Mac is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. a commercial one, but it works.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">hopefully the [http://www.mysql.com/products/tools/migration-toolkit/ Migration Toolkit] for the Mac will come out soon. the windows version does the job. perhaps we have to be a little patience[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]][[Category:Fixme]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]][[Category:Fixme]]</td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Configuring_and_Using_Databases&diff=6568&oldid=prev
Sardisson: fix space
2006-08-27T05:35:10Z
<p>fix space</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:35, 27 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{handbook sidebar|DatabaseTOC}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{handbook sidebar|DatabaseTOC}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">While NeoOffice 1.2.x, NeoOffice/J 1.1 and [[OpenOffice.org Mac OS X (X11)|OpenOffice.org/X11 1.1.x]] do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports. NeoOffice 2.0 includes a new database component, “Baseâ€, but you can still connect to various external databases and manipulate data from NeoOffice.</td><td> </td><td style="background: #eee; font-size: smaller;">While NeoOffice 1.2.x, NeoOffice/J 1.1 and [[OpenOffice.org Mac OS X (X11)|OpenOffice.org/X11 1.1.x]] do not include a separate database component like Microsoft Access, it is possible to use all of these programs to connect to existing MySQL or hsqldb databases and enter or manipulate data, including creating detailed forms and reports. NeoOffice 2.0 includes a new database component, “Baseâ€, but you can still connect to various external databases and manipulate data from NeoOffice.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>
Sardisson