Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
89 lines (46 sloc) 1.7 KB

#django-bankdownloads

  • django app to import and standardise bank transaction downloads

  • imports ofx (open financial exchange format) via the ofxparse library

  • imports csv using regex to match data columns

  • bankid and accountid taken from original file if possible, otherwise from a filename in the format

    --YYYYMMDD.

  • creates a standardised data dictionary with headers:

    date transid value currency memo payee accountid bankid fxcurrency fxrate fxamount

  • outputs data in ofx format

##Requirements

  • working django site

##Install

  1. Get the code

    git clone git://github.com/evandavey/django-bankdownloads.git django-bankdownloads

  2. Install via pip

    pip install django-bankdownloads

  3. Add 'bankdownloads' to INSTALLED_APPS

  4. Add BANKDOWNLOADS_IMPORT_PATH,BANKDOWNLOADS_OUTPUT_PATH,BANKDOWNLOADS_EMAILS and BANKDOWNLOADS_NOTIFIER_EXCLUDES to settings

##Use

  • provides a 'BankDownload' class that can be reused in other applications

    mydownload = BankDownload()

    mydownload.original_file=[file]

    mydownload.save()

  • access standardised data via the 'data' property

    data = mydownload.data

    ofx = mydownload.export_ofx()

  • use management command bankdownloads_notifier to email if data is missing for a given month

  • use management command bankdownloads_processor to batch import bank downloads and output standardised ofx

##Authors

Evan Davey evan.davey@cochranedavey.com

##Licenses

CC-SA-NC

Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.