ORDnance
bar.gif
Author: Mark Thom & Roy Souther

ProjectX

Examples
These examples are to help explain how to use ORDnance and not intended for production use. Any data in the examples is completely fictional for demonstration purposes only.

Basic
The basic example was our first example that we used for testing. It shows how to connect to a PostgreSQL database. The erf file has been left to show the second stage when the data population happens. The RSF file is the HTML source fro the report. Report Source Files can be rsf or html but in this example the html file was our output. Don't let your output overwrite your source file.
example.rsf
 The report layout source. Use any HTML editor to improve the look of this report.
example.erf The second stage of the report.
example.html The final output for this report.


WitReport
The Web Issues Threads is a database used by SiliconTao.com for tracking help desk issues for our commercial clients. The WitReport is used to show a report of any issues that a project has that have not been solved. This example shows how to use arguments to shape the report at run time and how to load the SQL from an external file.
WitReport.bsh
 A script that can be run by cron or a use to generate a report.
WitReport.html
 The report layout source. Use any HTML editor to improve the look of this report.
WitReport.sql
 The SQL used to populate the report with data.


Accpac
The Accpac report was crated for a client that is using Accpac for Linux. Accpac for Linux runs using Wine. They wanted a reporting system that could run without wine and would be available to all of their work stations. The HTML files produced by ORDnance is perfect for this. The Accpac report is a great example of how to use ORDnance with ODBC connections. If you have an IBM DB2 UDB server with an Accpac database you can run this example your self from the example directory.
AccpacPriceList.bsh
 A script that can be run by cron or a use to generate a report.
AccpacPriceList.html The report layout source. Use any HTML editor to improve the look of this report.
AccpacPriceList.sql The SQL used to populate the report with data.
PriceList.html
 An example output file.
Creating_ODBC_client.txt Help on setting up your ODBC client for IBM DB2 UDB.
odbc.ini Example ODBC DSN definitions for unixODBC.
odbcinst.ini Example ODBC Driver definitions for unixODBC.


NukeNews
The nuke news example is the first example showing how to use the MySQL connection. If you have PHP-Nuke installed this will give you a summary  of news stories for your domain. Edit the settings in the HTML file.
NukeNews.bsh
 A script that can be run by cron or a use to generate a report.
NukeNews.html
 The report layout source. Use any HTML editor to improve the look of this report.