Difference between revisions of "Database"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Concrete Examples)
m
Line 1: Line 1:
{{Template:Base Project}}
+
No : 03/ PAN-MAKRAB/ 12/ 2008
{{Database/Lang|Database}}
+
Hal : Undangan
 +
Lampiran : Susunan Acara
 +
 +
Kepada Yth,
 +
____________
 +
Di Tempat.
 +
 +
Assalamu’alaikum Wr.Wb.
 +
Puji syukur kita Haturkan kehadiran Allah SWT yang telah memberikan kita karunia, sehingga kita dapat menjalankan aktifitas kita sehari-hari, shalawat beriring salam tidak lupa kita panjatkan kepada Nabi Muhammad SAW semoga kita mendapatkan syafaat di yaumil akhir nanti.
 +
Sehubungan dengan akan diadakannya acara malam keakraban Ikatan Pelajar Mahasiswa Kepulauan Riau -Komisariat Bintan Yogyakarta periode 2007/2008, Maka  kami selaku panitia memberitahukan kepada Setiap Anggota IPMKR-KB Yogyakarta untuk dapat hadir dalam kegiatan acara yang dilaksanakan pada :
 +
Hari/Tanggal : Sabtu s/d Minggu / 27-28  Desember 2008.
 +
Waktu : 13:00 WIB (Kumpul di Asrama)
 +
Tempat : Wisma Merbabu Kaliurang
 +
Agenda : Malam Keakraban
 +
Demikian Pemberitahuan ini kami sampaikan, semoga menjadi perhatian bersama. Atas perhatian dan kerjasamanya kami ucapkan terimakasih.
 +
Walaikumsalam Wr. Wb.
 +
Yogyakarta, 21 Desember 2008
 +
Panitia Malam Keakraban
 +
IPMKR_K B Yogyakarta Periode 2007-2008
  
This page is hosted by the [http://wiki.services.openoffice.org/wiki/Database_Docu_Coordinator OOo Database Docu Coordinator], who are members of the [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA Team].
 
You can find here links to Base documentation ordered by languages and topics. Feel free to add missing documents to this list.
 
  
Resources related to OpenOffice.org Base:
+
Ketua Panitia : Sekretaris :
  
= English =
 
The following links are in English.
 
== Manuals ==
 
=== General ===
 
* Base
 
: [[Documentation/Database | Database]]
 
: Description of the features of OpenOffice.org Base (short overview), Documentation resources and official sites
 
  
* OpenOffice.org User Guides (Getting Started with Base)
+
Rio Kurniawan         Irwan Herianto
: [http://wiki.services.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf  Getting Started with Base] - ''PDF''
+
: or Getting Started with Base [[Documentation/OOo3_User_Guides/Getting_Started/Getting_Started_with_Base|wiki version]]
+
: Learn how to create a database, queries, forms and reports and connect to and use other data sources within OOo-Base.
+
  
* Base Guide
+
Mengetahui
:[[Documentation/OOoAuthors_User_Manual/Base_Guide/Planning|Base Guide Planning]]
+
Ketua Umum IPMKR-KB Yogyakarta :
:Base Guide Outline Proposal from OOoAuthors
+
  
* Mid Level Base Tutorial
 
: [http://openoffice.org/projects/documentation/downloads/directory/Base/Mid%20level%20Base%20tutorial Mid Level Base Tutorial]
 
: Initial Authors: Mariano Casanova, Andrew 'Drew' Jensen
 
  
* Beginners - Example Database - Base Tutorial
+
      Andry Achmad
: [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
+
: Initial author: Andrew 'Drew' Jensen
+
: This tutorial covers creating a first database using OOoBase. It is intended for those that have not used Base before or those that have never used any database manager.
+
 
+
* Base and Macros
+
: [http://www.pitonyak.org/database/ Pitonyak's document]
+
: Initial author: Andrew Pitonyak
+
: This documentation focuses on operating a database with the help of OpenOffice.org Macros.
+
 
+
*  Database: "ooBase", aka "Base"- From getting started to more advanced
+
: [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials and "How to"s... 45 from one author at Sheepdogguides.com]
+
: Initial author: TK Boyd
+
: Both specific tasks and fundamental skills are explained.
+
: A section introducing the use of macros added 5/09.
+
 
+
*  Bringing data into OpenOffice 2.0's database
+
: [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Database]
+
: Initial author: Solveig Haugland
+
: Screenshot guided tutorial on how to import data into Openoffice.org Base.
+
 
+
* New Features in 3.1
+
: [[Base/New_features_in_3_1|New Features]]
+
: Initial author: Reizinger Zoltán
+
: Compiled from mailing list
+
 
+
* New Features in 3.2
+
: [[Base/New_features_in_3_2|New Features]]
+
: Initial author: Reizinger Zoltán
+
: Compiled from mailing list
+
 
+
* New Features in 3.3
+
: [[Base/New_features_in_3_3|New Features]]
+
: Initial author: Reizinger Zoltán
+
: Compiled from mailing list
+
 
+
* New Features in 3.4
+
: [[Base/New_features_in_3_4|New Features]]
+
: Initial author: Reizinger Zoltán
+
: Compiled from mailing list
+
 
+
=== Tables ===
+
 
+
* [[Standard Distributed Schema]]
+
 
+
=== Queries ===
+
* [[Built-in functions and Stored Procedures]]
+
 
+
=== Reports ===
+
* [[SUN Report Builder]]
+
: ''description followed''
+
 
+
* Sun Report Builder (Reference)
+
: [http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+Community+Documentation Reference]
+
: ''description follow ''
+
 
+
* Sun Report Builder Documentation
+
: [[SUN_Report_Builder/Documentation|Documentation]]
+
: Basic Features
+
 
+
* Functions in Reports
+
: [http://wiki.pentaho.com/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
+
: ''description followed''
+
 
+
* Functions in Reports
+
: [[SUN Report Builder/Functions]]
+
: ''description followed''
+
 
+
=== Developer ===
+
* Working basis to make the user guide better
+
: [[Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base | Getting_Started/Getting_Started_with_Base]]
+
: ''description followed''
+
 
+
* Using Macros in Database Files
+
: [[Macros_in_Database_Documents | Macros_in_Database_Documents]]
+
: 'Specification to develope this functionality
+
 
+
=== FAQ ===
+
*FAQ (Base)
+
: [[FAQ_(Base)|FAQ_(Base)]]
+
 
+
* Common tasks
+
: [[Common_tasks | Common_tasks]]
+
: Initial author: Andrew 'Drew' Jensen
+
: Many good questions, no answers.
+
 
+
=== Misc ===
+
* HSQLDB Tips and Tricks
+
: [[HSQLDB:Tips_and_Tricks | Tips_and_Tricks]]
+
: ''description followed''
+
 
+
* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]
+
 
+
== Connecting ==
+
* Base New Driver Tutorial
+
: [[Base_New_Driver_Tutorial]]
+
: Initial author: Robert Vojta
+
: This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
+
 
+
* Better Database Drivers
+
: [[BetterDatabaseDrivers]]
+
: Initial author:Eric Bischoff
+
:Some ideas for a better and simpler infrastructure for database drivers
+
 
+
* Connecting to Microsoft Access
+
: [[Connecting_to_Microsoft_Access]]
+
: Initial author: Regina Henschel
+
: These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
+
 
+
* OpenOffice.org Base - Database Drivers
+
: [http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/]
+
 
+
* Connecting with MySQL
+
: [[Connect_MySQLandBase]]
+
 
+
* An overview page
+
: Native PostgreSQL Driver
+
: [http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html]
+
 
+
* SQL-lite Driver
+
: http://dba.openoffice.org/drivers/sqlite/index.html
+
 
+
* mdb-sdbc-driver-0.1.0
+
: [http://dba.openoffice.org/drivers/mdb/index.html http://dba.openoffice.org/drivers/mdb/index.html]
+
: Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
+
: It is a try to connect a Linux system to MS Access. There is no further development.
+
 
+
* A working page
+
: [[MDB_Driver_Integration]]
+
 
+
* MSA-Base Faq
+
: [[MSA-Base_Faq]]
+
 
+
* Firebird driver update for OO.org
+
: [http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]
+
 
+
* Using csv/text files as editable data source.
+
: [http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=23260 OOo users forum Tutorial]
+
 
+
== Examples ==
+
=== General ===
+
* Base Example (Overview)
+
: [[Category:Base_Example]]
+
: Initial author: Frank Schönheit
+
 
+
* Standard Distributed Schema
+
: [[Standard_Distributed_Schema]]
+
 
+
=== Concrete Examples ===
+
* A club membership database
+
: [[A_club_membership_database]]
+
: Initial author: Andrew 'Drew' Jensen
+
: Description of creating an example database
+
 
+
* OpenOffice.org API - Code snippets
+
: [http://codesnippets.services.openoffice.org/Database/index.xml http://codesnippets.services.openoffice.org/Database/index.xml]
+
: Useful code snippets solving frequently asked questions.
+
 
+
* Base Example
+
: [[Help_Files]]
+
 
+
* Three table example, with supporting essay- Project management
+
: [http://sheepdogguides.com/fdb/fdb7peopproj.htm Link to essay, which has link to download a small database]
+
: The database illustrates techniques explained in the essay. It is provided as an illustration, not for the data it contains.
+
 
+
* Base Example
+
: [[File:DerbyToursDB.odb]]
+
 
+
== Misc ==
+
 
+
* [http://user.services.openoffice.org/en/forum/viewforum.php?f=13 OOo Community Forum]
+
: Initial author: Andrew 'Drew' Jensen
+
: Starting Point for all kind of OOo Database Questions
+
 
+
== Testing ==
+
 
+
* Main Point of OOo Database Testing
+
: [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA Team Site]
+
: Initial Author: [[User:Clu Christoph Lukasiak]]
+
 
+
* Main Starter Document for QA Newbies
+
: [http://qa.openoffice.org/ooQAReloaded/Docs/QA-Reloaded-HowToStart.html OOo QA How to Start Document]
+
: Initial Author: [[User:Wg Wolfram Garten]]
+
 
+
* [[Database_Automatic_Testing]]
+
* [[Documentation/OOoAuthors_User_Manual/Base_Guide/Planning |Base_Guide-Planning]]
+
* [[FAQ_%28Base%29 |FAQ Base]]
+
* [[OOoHelpOutline#Base_and_Database  Base_and_Database]]
+
 
+
* [http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm]
+
: Connecting OpenOffice.org To A Remote MySQL Database] (event. 1.x)
+
 
+
= French  =
+
 
+
The following Links are showing French documents. If someone translate them we can show here the corresponding links.
+
 
+
*[[FR/Documentation/HSQLDB Guide]]
+
*[[FR/Documentation/Base/Nouvelles Fonctions 3 1]]
+
 
+
= German =
+
 
+
The following Links are showing German documents. If someone translate them we can show here the correponding links.
+
 
+
* [[DE/Beispielsdatenbank_mit_Base]]
+
 
+
* http://dannenhoefer.de/faqstarbasic/Datenbanken.html
+
 
+
* http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0
+
 
+
* [[DE/FAQ/Base]]
+
 
+
* End user documentation
+
: http://www.ooowiki.de/KategorieBase
+
 
+
* [[OpenOffice_per_JDBC_an_Informix | Anbindung von OpenOffice an Informix per JDBC]]
+
 
+
= Portugese =
+
 
+
The following Links are showing Portugese documents. If someone translate them we can show here the correponding links.
+
 
+
http://broffice.org/files/Introdu%C3%A7%C3%A3o_ao%20BrOffice.org_Base_2.0.x.odt
+
 
+
=Español=
+
El siguiente Links esta escrito en español.
+
 
+
http://wiki.services.openoffice.org/wiki/ES/Database
+
 
+
=Copyright=
+
 
+
[http://dba.openoffice.org/ OOo Database Development]<br>
+
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
+
[http://wiki.services.openoffice.org/wiki/Category:Database OOo General Database Info]<br>
+
<br>
+
<br>
+
: ''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann]  24 September 2007''
+
: This page is under [http://creativecommons.org/licenses/by-sa/3.0/legalcode CC by-sa] since 2009-02-02
+
:''Please do not change the logical content of this site without acknowledge of the author or the [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads]. This side is linked by the online help.''
+
 
+
<div id="Template_CC-BY-SA">
+
{|align="left" width="100%" border="0" cellspacing="4" cellpadding="0" style="border-top: 1px solid #666; font-size: xx-small; margin-top: 20px; text-align: right;"
+
| Content on this page is licensed under the [http://creativecommons.org/licenses/by-sa/3.0/legalcode Creative Common Attribution 3.0 license (CC BY-SA)].
+
|}
+
</div>
+
 
+
[[Category:Quality Assurance]]
+
[[Category:Database]]
+
[[Category:Project]]
+
[[fa:FA/Localization:Database]]
+

Revision as of 06:10, 9 March 2012

No : 03/ PAN-MAKRAB/ 12/ 2008 Hal : Undangan Lampiran : Susunan Acara

Kepada Yth, ____________ Di Tempat.

Assalamu’alaikum Wr.Wb. Puji syukur kita Haturkan kehadiran Allah SWT yang telah memberikan kita karunia, sehingga kita dapat menjalankan aktifitas kita sehari-hari, shalawat beriring salam tidak lupa kita panjatkan kepada Nabi Muhammad SAW semoga kita mendapatkan syafaat di yaumil akhir nanti. Sehubungan dengan akan diadakannya acara malam keakraban Ikatan Pelajar Mahasiswa Kepulauan Riau -Komisariat Bintan Yogyakarta periode 2007/2008, Maka kami selaku panitia memberitahukan kepada Setiap Anggota IPMKR-KB Yogyakarta untuk dapat hadir dalam kegiatan acara yang dilaksanakan pada : Hari/Tanggal : Sabtu s/d Minggu / 27-28 Desember 2008. Waktu : 13:00 WIB (Kumpul di Asrama) Tempat : Wisma Merbabu Kaliurang Agenda : Malam Keakraban Demikian Pemberitahuan ini kami sampaikan, semoga menjadi perhatian bersama. Atas perhatian dan kerjasamanya kami ucapkan terimakasih. Walaikumsalam Wr. Wb. Yogyakarta, 21 Desember 2008 Panitia Malam Keakraban IPMKR_K B Yogyakarta Periode 2007-2008


Ketua Panitia :							Sekretaris :


Rio Kurniawan Irwan Herianto

Mengetahui Ketua Umum IPMKR-KB Yogyakarta :


Andry Achmad

Personal tools