r22086 - gnucash/trunk - Bug #672161: New CSV account and transaction importer

Christian Stimming cstim at code.gnucash.org
Fri Mar 16 16:26:24 EDT 2012


Author: cstim
Date: 2012-03-16 16:26:22 -0400 (Fri, 16 Mar 2012)
New Revision: 22086
Trac: http://svn.gnucash.org/trac/changeset/22086

Added:
   gnucash/trunk/src/import-export/csv-import/
   gnucash/trunk/src/import-export/csv-import/Makefile.am
   gnucash/trunk/src/import-export/csv-import/assistant-csv-account-import.c
   gnucash/trunk/src/import-export/csv-import/assistant-csv-account-import.glade
   gnucash/trunk/src/import-export/csv-import/assistant-csv-account-import.h
   gnucash/trunk/src/import-export/csv-import/assistant-csv-trans-import.c
   gnucash/trunk/src/import-export/csv-import/assistant-csv-trans-import.glade
   gnucash/trunk/src/import-export/csv-import/assistant-csv-trans-import.h
   gnucash/trunk/src/import-export/csv-import/csv-account-import.c
   gnucash/trunk/src/import-export/csv-import/csv-account-import.h
   gnucash/trunk/src/import-export/csv-import/gnc-csv-gnumeric-popup.c
   gnucash/trunk/src/import-export/csv-import/gnc-csv-gnumeric-popup.h
   gnucash/trunk/src/import-export/csv-import/gnc-csv-import.c
   gnucash/trunk/src/import-export/csv-import/gnc-csv-import.glade
   gnucash/trunk/src/import-export/csv-import/gnc-csv-import.h
   gnucash/trunk/src/import-export/csv-import/gnc-csv-model.c
   gnucash/trunk/src/import-export/csv-import/gnc-csv-model.h
   gnucash/trunk/src/import-export/csv-import/gnc-plugin-csv-import-ui.xml
   gnucash/trunk/src/import-export/csv-import/gnc-plugin-csv-import.c
   gnucash/trunk/src/import-export/csv-import/gnc-plugin-csv-import.h
   gnucash/trunk/src/import-export/csv-import/gncmod-csv-import.c
   gnucash/trunk/src/import-export/csv-import/schemas/
   gnucash/trunk/src/import-export/csv-import/schemas/Makefile.am
   gnucash/trunk/src/import-export/csv-import/schemas/apps_gnucash_dialog_import_csv.schemas.in
Removed:
   gnucash/trunk/src/import-export/csv/Makefile.am
   gnucash/trunk/src/import-export/csv/gnc-csv-gnumeric-popup.c
   gnucash/trunk/src/import-export/csv/gnc-csv-gnumeric-popup.h
   gnucash/trunk/src/import-export/csv/gnc-csv-import.c
   gnucash/trunk/src/import-export/csv/gnc-csv-import.glade
   gnucash/trunk/src/import-export/csv/gnc-csv-import.h
   gnucash/trunk/src/import-export/csv/gnc-csv-model.c
   gnucash/trunk/src/import-export/csv/gnc-csv-model.h
   gnucash/trunk/src/import-export/csv/gnc-plugin-csv-ui.xml
   gnucash/trunk/src/import-export/csv/gnc-plugin-csv.c
   gnucash/trunk/src/import-export/csv/gnc-plugin-csv.h
   gnucash/trunk/src/import-export/csv/gncmod-csv-import.c
Modified:
   gnucash/trunk/configure.ac
   gnucash/trunk/po/POTFILES.in
   gnucash/trunk/src/bin/gnucash-bin.c
   gnucash/trunk/src/import-export/Makefile.am
   gnucash/trunk/src/import-export/dialog-import.glade
   gnucash/trunk/src/import-export/import-account-matcher.c
   gnucash/trunk/src/import-export/import-account-matcher.h
   gnucash/trunk/src/import-export/import-main-matcher.c
   gnucash/trunk/src/import-export/import-main-matcher.h
Log:
Bug #672161: New CSV account and transaction importer

Patch by Robert Fewell:

Firstly, this patch allows for the creating and updating accounts based on the CSV file
being imported. New accounts are created if the commodity required exists and
existing accounts are updated for the four fields: code, description, notes and
colour. This can be used for doing bulk updates of these fields and also for
importing the account structure from another file.

The second part is the change of the existing CSV importer to use an assistant
to guide you through the import. Additional features added is the ability to
specify the start and end row to be imported allowing you to jump over a header
or footer or just import a few rows. A currency format option was added which
was requested in another bug to overcome a problem they were having with the
downloaded format from there bank. You can also associate the account name to a
GnuCash account using the 'online_id' kvp, not sure if this is Ok or whether it
should be a different one.

To achieve the above, I split the dialogs used in import_account_matcher and
import_main_matcher into the dialog and the content so I could load the content
into the assistant saving on duplication, hope this makes sense.



More information about the gnucash-patches mailing list