--- name: "dfxml-homebank" section: "1" platform: "linux" package: "datafreedom-perl" version: "0.2.2-1" release: "Debian 6.0 (Squeeze)" platforms: ["linux"] url: "https://new.carta.tech/dfxml-homebank" --- # dfxml-homebank(1) parse a QSF XML file and prepare a CSV invoice for homebank ## NAME dfxml-homebank - parse a QSF XML file and prepare a CSV invoice for homebank ## 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. \ \ \ ## AUTHOR Neil Williams, `""` ## BUGS Please report bugs via the pilot-qof package, either in the Debian BTS or via SourceForge trackers. ## 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 . ```