DATAFREEDOM

These scripts developed from the 'pilot-qof' package but now include support for other packages and formats and will continue to be extended along the lines of http://www.data-freedom.org/ - liberating user data from the application. Therefore, the datafreedom scripts use a 'df' prefix.

The scripts continue to be developed within the pilot-qof CVS until such time as the scripts are sufficiently cohesive to form a new source package.

Please feel free to contribute any of your own scripts, under the provisions of the GNU General Public Licence v3 or later, via the QOF-devel mailing list. http://lists.sourceforge.net/lists/listinfo/qof-devel

VERSION

Version 0.0.1

SYNOPSIS

dfxml-homebank FILENAME
dfxml-homebank -h|--help|--version

DESCRIPTION

dfxml-homebank parses a QSF XML file output by pilot-qof and prepares a CSV invoice suitable for import into homebank, based on rates specified in ~/.datafreedom/currency which will be created for you.

Specify '-' as the filename to parse STDIN.

e.g.
 pilot-qof -x data.xml --invoice-city -t 2006-11-09 | dfxml-homebank -

The CSV output is intended to be compatible with homebank:
 DATE;TRANS_TYPE;EXP_TYPE;CUSTOMER;DESC;AMOUNT;ACCOUNT

e.g.
 13/08/2007;5;;ACustomer;Payment;-610.5;Income
 30/08/2007;4;Parking;BCustomer;JobTitle;2.75;Expenses

Homebank uses digits for transaction types:
 5 = internal transfer
 4 = bank transfer

Homebank CSV import can take a few steps (in common with a lot of other CSV processes, this is due to inherent weaknesses in the CSV format) so dfxml-homebank is best used with the '>>' redirect to append to an existing CSV file so that all relevant invoices can be imported into Homebank in a single import - each run of dfxml-homebank only adds a few CSV lines, homebank is suprisingly efficient at CSV import.

dfxml-homebank, like pilot-qof, is designed to be used in pipes like this. It is intended to provide support for your own scripts where details like the date can be set as an option:

 #!/bin/bash
 DATE=$1
 
 if [ ! $DATE ]; then
        echo "$0: please specify the date of the invoice you want to view."
        exit
 fi
 pilot-qof -x data.xml --invoice-city -t $DATE | dfxml-homebank -

Or, a full zenity version which allows the date to be selected in a calendar widget:

 #!/bin/bash
 set -e
 MSG="Select the date of the invoice to view"
 DATE=`zenity --calendar --text="$MSG" --date-format="%Y-%m-%d"`
 TIME=`date -d"$DATE" +"%A, %B %e %Y"`
 
 if [ ! $DATE ]; then
        echo "$0: please specify the date of the invoice you want to view."
        exit
 fi
 
 pilot-qof -x /opt/data/pilot-qof/offline.xml --invoice-city -t $DATE \
  | dfxml-homebank -

OBJECTS

pilot_expenses is part of pilot-qof. Can also be used with gpe-expenses - compatibility with the default SQLite gpe-expenses backend is pending.

<http://qof.sourceforge.net/>

<http://pilot-qof.sourceforge.net/>

<http://gpe-expenses.sourceforge.net/>

AUTHOR

Neil Williams, "<codehelp at debian.org>"

COPYRIGHT & LICENSE

  Copyright 2008 Neil Williams.
  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 3 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, see <http://www.gnu.org/licenses/>.