'\" t
.\"     Title: gpe-expenses
.\"    Author: [see the "Author" section]
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
.\"      Date: Mon Dec 24 12:08:31 GMT 2007
.\"    Manual: GPE-EXPENSES
.\"    Source: GPE-EXPENSES 1
.\"  Language: English
.\"
.TH "GPE\-EXPENSES" "1" "Mon Dec 24 12:08:31 GMT 2007" "GPE-EXPENSES 1" "GPE-EXPENSES"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
gpe-expenses \- Expense records for GPE using QOF (Query Object Framework)\&.
.SH "EMBEDDED PLATFORMS"
.PP
Embedded platforms can choose not to include the libxml2 backend which means that QOF cannot provide the QOF XML backend (called QSF XML)\&. Other platforms are free to use any available QOF backend\&. All platforms support the SQLite backend, command\-line and
\fB\-\-gui\fR
operation\&.
.PP
SQLite databases written on embedded platforms without libxml2 can be copied to the host PC for further processing and conversion of data to or from QSF XML and other formats\&. SQLite databases can also be queried directly, either using the
sqlite
application or at the
gpe\-expenses
command line\&. Without libxml2 support, the output needs to be written to a new SQLite database but this can be used, e\&.g\&. to export certain categories of expenses, expenses within a particular time period or expenses that match other similar criteria to a new SQLite database\&. When accessing a SQLite database on the
gpe\-expenses
command line, you need to specify the
\fBsqlite:\fR
access method (in a similar manner to specifying a particular protocol in the URL of other applications)\&.
.PP
See
\fIExamples\fR\&.
.SH ""
.SH "SYNOPSIS"
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR {[[\-\-gui]]} [[[\-\-debug]]]
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR {[[\-\-explain]]}
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR {[[\-l]\ |\ [\-\-list]]}
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR {[[\-\-version]]}
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR {[[\-?]\ |\ [\-\-help]]}
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR [[[\-\-usage]]]
.HP \w'\fBgpe\-expenses\fR\ 'u
\fBgpe\-expenses\fR {[[\-i]\ |\ [\-\-input\-file]]\ \fIfilename\fR} [[[\-c]\ |\ [\-\-category]]\ \fIstring\fR] [[[\-t]\ |\ [\-\-date]]\ \fIstring\fR] [[[\-s]\ |\ [\-\-sql]]\ \fIstring\fR] [[[\-f]\ |\ [\-\-sql\-file]]\ \fIfilename\fR] [[[\-w]\ |\ [\-\-write]]\ \fIfilename\fR] [[[\-\-debug]]]
.SH "DESCRIPTION"
.PP
GPE Equivalent for Expenses on the Palm\&. Supports payment types, categories, expense types (mileage, meals, parking, etc\&.), notes and currency selection via a Gtk interface\&. Where available, SQLite data can be easily converted to XML using a QOF format called \*(AqQSF\*(Aq, suitable for use with XSL and other tools\&.
.SH "COMMANDS"
.PP
\fB\-\-gui\fR
.RS 4
Load the Gtk graphic interface\&. Options
\fB\-w\fR,
\fB\-s\fR,
\fB\-f\fR,
\fB\-t\fR
and
\fB\-c\fR
are ignored\&.
.RE
.PP
\fB\-i\fR, \fB\-\-input\-file\fR filename
.RS 4
Load the QSF XML
file:filename
or SQLite database
sqlite:filename\&.
.sp
\fBfile:\fR
access requires libxml2 support and the QSF XML backend\&. To access data in a
gpe\-expenses
SQLite database, specify the
\fBsqlite:\fR
access method\&. See under EXAMPLES\&.
.RE
.PP
\fB\-l\fR, \fB\-\-list\fR
.RS 4
Lists all available databases and exit\&.
.RE
.PP
\fB\-\-explain\fR
.RS 4
List the fields within the gpe_expenses database and exit\&. Only the one database is currently supported in gpe\-expenses\&.
.RE
.SH "OPTIONS"
.SS "gpe\-expenses options"
.PP
\fB\-c\fR, \fB\-\-category\fR \fBstring\fR
.RS 4
Shorthand to only query objects that are set to the specified category\&.
.sp
(Ignored by
\fB\-\-gui\fR)\&.
.RE
.PP
\fB\-t\fR, \fB\-\-date\fR \fBstring\fR
.RS 4
Shorthand to only query objects that contain the specified date\&. Specify dates using YY\-MM\-DD, YY\-MM or just YY\&. Single digits can omit the leading zero, e\&.g\&. 04\-12\-1, 1st December 2004 \- years less than 100 are assumed to be in the 21st century\&. Years prior to 2000 can be specified as YYYY\-MM\-DD etc\&. This value is taken as a range, 05\-03\-01 includes all times between Tue Mar 1 00:00:00 UTC 2005 and Tue Mar 1 23:59:59 UTC 2005\&. 05\-03 includes all dates and times between Tue Mar 1 00:00:00 UTC 2005 and Thu Mar 31 23:59:59 UTC 2005\&. 05 includes all dates and times in 2005\&.
.sp
(Ignored by
\fB\-\-gui\fR)\&.
.RE
.PP
\fB\-w\fR, \fB\-\-write\fR \fBfilename\fR
.RS 4
Write the results of any query to a SQLite database or (if libxml2 is supported) a QSF XML file\&.
.sp
Remember to specify the
\fBsqlite:\fR
access method if libxml2 is not supported\&.
.sp
(Ignored by
\fB\-\-gui\fR)\&.
.RE
.PP
\fB\-s\fR, \fB\-\-sql\fR \fBstring\fR
.RS 4
Specify a SQL query on the command line\&.
.sp
(Ignored by
\fB\-\-gui\fR)\&.
.RE
.PP
\fB\-f\fR, \fB\-\-sql\-file\fR \fBfilename\fR
.RS 4
Specify one or more SQL queries contained in a file\&.
.sp
(Ignored by
\fB\-\-gui\fR)\&.
.RE
.PP
\fB\-\-debug\fR
.RS 4
Enable debug output using
/tmp/gpe\-expenses\&.trace
which will be created if it does not exist and overwritten if it does\&. If this fails, tries to create a temporary trace file in
/tmp
or uses
stderr\&.
.RE
.SS "help options"
.PP
\fB\-h\fR, \fB\-\-help\fR
.RS 4
Display the help synopsis for
\fIgpe\-expenses\fR\&.
.RE
.PP
\fB\-\-usage\fR
.RS 4
Display a brief usage message and exit without connecting\&.
.RE
.PP
\fB\-v\fR, \fB\-\-version\fR
.RS 4
Display version of
\fIgpe\-expenses\fR\&.
.RE
.SH "EXAMPLES"
.PP
Start the GPE\-EXPENSES graphic interface with debug output sent to
/tmp/gpe\-expenses\&.trace
.PP

\fIgpe\-expenses\fR
\fB\-\-gui\fR
\fB\-\-debug\fR
.PP
List all currently supported databases\&.
.PP

\fIgpe\-expenses\fR
\fB\-l\fR
.PP
Copy all expenses in 2005 to a backup SQLite database\&.
.PP

\fIgpe\-expenses\fR
\fB\-i\fR
\fBsqlite:/home/user/\&.gpe\-expenses/expenses\fR
\fB\-w\fR
\fBsqlite:business\&.sqlite\fR
\fB\-t\fR
\fB2005\fR
.PP
Export all expenses that have the category
\fBBusiness\fR
using libxml2 and the QSF XML backend to STDOUT\&. Note that
\fBfile:\fR
is the default access method and can be omitted only if libxml2 support is available\&. (SQLite is unable to output to STDOUT, always use
\fB\-w\fR
with SQLite\&.)
.PP

\fIgpe\-expenses\fR
\fB\-i\fR
\fBexpenses\&.xml\fR
\fB\-c\fR
\fB"Business"\fR
.PP
Command line SQL query of SQLite storage\&.
.PP

\fIgpe\-expenses\fR
\fB\-i\fR
\fBsqlite:business\&.sqlite\fR
\fB\-s\fR
"SELECT * from gpe_expenses where expense_city = \*(AqLondon\*(Aq;"
.SH "AUTHOR"
.PP
\fIgpe\-expenses\fR
was written by Neil Williams
linux@codehelp\&.co\&.uk\&.
.PP
This manual page was written by Neil Williams
linux@codehelp\&.co\&.uk
.SH "REPORTING BUGS"
.PP
Please do NOT report bugs in gpe\-expenses to GPE\&. Report bugs via the QOF\-devel mailing list or use the
reportbug
tool in Debian\&.
.PP
\fIhttp://lists\&.sourceforge\&.net/lists/listinfo/qof\-devel\fR
.SH "COPYRIGHT"
.PP
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version\&.
.PP
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE\&. See the GNU General Public License for more details\&.
.PP
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc\&., 51 Franklin Street, Fifth Floor, Boston, MA 02110\-1301, USA\&.
.SH "SEE ALSO"
.PP

\m[blue]\fBhttp://gpe\-expenses\&.sourceforge\&.net/\fR\m[]
.PP

\m[blue]\fBhttp://sourceforge\&.net/projects/gpe\-expenses/\fR\m[]
.SH "COPYRIGHT"
.br