Introduction
We have chosen to use OpenOffice Base to make reports of the Schoolsplay progress.
The reasons are obvious: OpenOffice is also open-source, it runs on all platforms and has good support. You can download it at www.openoffice.org.
A very good support forum for OpenOffice can be found at www.oooforum.org/.
I will be explaining the procedure here for Windows based systems, for GNU/Linux based systems see Howto open the database GNU/Linux.
Installing SQLite ODBC driver
To be able to access the SQLite database that Schoolsplay for now uses, you need to install a driver for it, this can be found at www.ch-werner.de/sqliteodbc/
Download the package appropriate for your platform and install it.
Making an OpenOffice Base document that point to sp.db
Step1
Start OpenOffice Base, it will start with the Database Wizard.
Choose "Connect to an exisiting database" and select ODBC.
Click Next »
Step2
Click Browse and select "SQLite3 Datasource"
Click Organize…
Step3
Now you are in the ODBC Data Source Administrator, you can start this also btw on Windows by running ODBCAD32.exe.
Click Add…
Step4
Choose as driver "SQLite3 ODBC Driver" and click Finish
Step5
Fill the options
Data Source Name = Schoolsplay (you may change this whatever you like)
Database Name = Enter or browse to the path of the schoolsplay database
Lock Timeout = 100000
Sync Mode = NORMAL
Click OK
And click OK once again in the ODBC Data Source Adminstrator
Step6
Now select the Schoolsplay datasource and click OK.
Click Next to advance to the user authentication step
Step7
Here, click Test Connection, this should return positive.
Step8
Click Finish and save the database
Step9
Navigate to the Tables icon and you'll see the tables in use in Schoolsplay.
Great! Now you can open the Schoolsplay database in OpenOffice Base.
In the future, we will try to provide you with a Base document that contains some commonly used Queries, Forms and Reports.
For now, you can must your own, but please send them back to us.
