table of contents
other versions
- wheezy 0.1.9-2
GPE-EXPENSES(1) | GPE-EXPENSES | GPE-EXPENSES(1) |
NAME¶
gpe-expenses - Expense records for GPE using QOF (Query Object Framework).EMBEDDED PLATFORMS¶
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 --gui operation. 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 sqlite: access method (in a similar manner to specifying a particular protocol in the URL of other applications). See Examples.¶
SYNOPSIS¶
gpe-expenses
{[[--gui]]} [[[--debug]]]
gpe-expenses
{[[--explain]]}
gpe-expenses
{[[-l] | [--list]]}
gpe-expenses
{[[--version]]}
gpe-expenses
{[[-?] | [--help]]}
gpe-expenses
[[[--usage]]]
gpe-expenses
{[[-i] | [--input-file]] filename}
[[[-c] | [--category]] string]
[[[-t] | [--date]] string]
[[[-s] | [--sql]] string]
[[[-f] | [--sql-file]] filename]
[[[-w] | [--write]] filename] [[[--debug]]]
DESCRIPTION¶
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 'QSF', suitable for use with XSL and other tools.COMMANDS¶
--guiLoad the Gtk graphic interface. Options
-w, -s, -f, -t and -c are ignored.
-i, --input-file filename
Load the QSF XML file:filename or SQLite
database sqlite:filename.
file: access requires libxml2 support and the QSF XML backend. To access
data in a gpe-expenses SQLite database, specify the sqlite: access
method. See under EXAMPLES.
-l, --list
Lists all available databases and exit.
--explain
List the fields within the gpe_expenses
database and exit. Only the one database is currently supported in
gpe-expenses.
OPTIONS¶
gpe-expenses options¶
-c, --category stringShorthand to only query objects that are set
to the specified category.
(Ignored by --gui).
-t, --date string
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.
(Ignored by --gui).
-w, --write filename
Write the results of any query to a SQLite
database or (if libxml2 is supported) a QSF XML file.
Remember to specify the sqlite: access method if libxml2 is not
supported.
(Ignored by --gui).
-s, --sql string
Specify a SQL query on the command line.
(Ignored by --gui).
-f, --sql-file filename
Specify one or more SQL queries contained in a
file.
(Ignored by --gui).
--debug
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.
help options¶
-h, --helpDisplay the help synopsis for
gpe-expenses.
--usage
Display a brief usage message and exit without
connecting.
-v, --version
Display version of gpe-expenses.
EXAMPLES¶
Start the GPE-EXPENSES graphic interface with debug output sent to /tmp/gpe-expenses.traceAUTHOR¶
gpe-expenses was written by Neil Williams linux@codehelp.co.uk. This manual page was written by Neil Williams linux@codehelp.co.ukREPORTING BUGS¶
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. http://lists.sourceforge.net/lists/listinfo/qof-develCOPYRIGHT¶
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. 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. 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.SEE ALSO¶
COPYRIGHT¶
Mon Dec 24 12:08:31 GMT 2007 | GPE-EXPENSES 1 |