Difference between revisions of "Published tools"

From GnuCash
Jump to: navigation, search
m (Tools - Fix link to BackupGnuCashWin)
(Tools: Ledger-CLI; minor formatting)
Line 6: Line 6:
  
 
== Tools ==
 
== Tools ==
 +
;Command line interfaces: [[Ledger-CLI]]
 +
;mixed:
 
* Different [http://sourceforge.net/search/?q=gnucash SourceForge] projects in conjunction to GnuCash.
 
* Different [http://sourceforge.net/search/?q=gnucash SourceForge] projects in conjunction to GnuCash.
 
* Different [https://github.com/search?utf8=%E2%9C%93&q=gnucash&type= GitHub] projects in conjunction to GnuCash.
 
* Different [https://github.com/search?utf8=%E2%9C%93&q=gnucash&type= GitHub] projects in conjunction to GnuCash.
Line 11: Line 13:
 
* [http://bokeep.org/ Bo-Keep] a Desktop application, which uses GnuCash as backend by the Python interface.  
 
* [http://bokeep.org/ Bo-Keep] a Desktop application, which uses GnuCash as backend by the Python interface.  
 
* Email with [https://lists.gnucash.org/pipermail/gnucash-de/2010-March/007310.html csv2qif.py - csv to qif converter] by Nils Andresen.
 
* Email with [https://lists.gnucash.org/pipermail/gnucash-de/2010-March/007310.html csv2qif.py - csv to qif converter] by Nils Andresen.
 
 
* [http://gnucashtoqif.sourceforge.net gnucashtoqif] Java Export to QIF files by [http://slawrance.users.sourceforge.net/ Steven Lawrance]
 
* [http://gnucashtoqif.sourceforge.net gnucashtoqif] Java Export to QIF files by [http://slawrance.users.sourceforge.net/ Steven Lawrance]
 
 
* [http://apps.sourceforge.net/mediawiki/jgnucashlib/index.php?title=Main_Page jgnucashlib] Java access on GnuCash XML files by M. Wolschon
 
* [http://apps.sourceforge.net/mediawiki/jgnucashlib/index.php?title=Main_Page jgnucashlib] Java access on GnuCash XML files by M. Wolschon
 
: [https://lists.gnucash.org/pipermail/gnucash-devel/2005-October/014163.html Comment by C. Stimming] about it.
 
: [https://lists.gnucash.org/pipermail/gnucash-devel/2005-October/014163.html Comment by C. Stimming] about it.
Line 23: Line 23:
 
* [http://bramblesoft.com/gnucashreporting.html GnuCash-Reporting] - Report charts for your GnuCash data. Simple question based UI. Reads from SQL. Java, JavaFX, Linux and Windows.
 
* [http://bramblesoft.com/gnucashreporting.html GnuCash-Reporting] - Report charts for your GnuCash data. Simple question based UI. Reads from SQL. Java, JavaFX, Linux and Windows.
  
Spreadsheet to GnuCash (XLSX, CSV to QIF) tools:
+
;Spreadsheet to GnuCash (XLSX, CSV to QIF) tools:
 
* [https://github.com/OneClickToQif/OneClickToQif OneClickToQif] - a set of templates and macros, which are used to export data from your spreadsheets to QIF format, as used by GnuCash. You can use the templates as provided, or adapt your own spreadsheet, so your data is automatically exported to QIF with a single click
 
* [https://github.com/OneClickToQif/OneClickToQif OneClickToQif] - a set of templates and macros, which are used to export data from your spreadsheets to QIF format, as used by GnuCash. You can use the templates as provided, or adapt your own spreadsheet, so your data is automatically exported to QIF with a single click
 
* [http://gnucash.1415818.n4.nabble.com/Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680333.html XLSM2QIF] [http://gnucash.1415818.n4.nabble.com/Re-XLSM2QIF-Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680402.html XLSM2QIF-Link2] is a application for make conversions between 64-bit Excel spreadsheets and Quicken QIF data and GnuCash Android QIF data and GnuCash Desktop QIF and XML data.
 
* [http://gnucash.1415818.n4.nabble.com/Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680333.html XLSM2QIF] [http://gnucash.1415818.n4.nabble.com/Re-XLSM2QIF-Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680402.html XLSM2QIF-Link2] is a application for make conversions between 64-bit Excel spreadsheets and Quicken QIF data and GnuCash Android QIF data and GnuCash Desktop QIF and XML data.
 
* [http://llg.cubic.org/csv2iif/ csv2iif suite], offers perl programs to download PayPal business account transactions via the PayPal API and convert the transactions into IIF, OFX or QIF files. For GnuCash you can use the paypal2qif.pl program from their software suite.
 
* [http://llg.cubic.org/csv2iif/ csv2iif suite], offers perl programs to download PayPal business account transactions via the PayPal API and convert the transactions into IIF, OFX or QIF files. For GnuCash you can use the paypal2qif.pl program from their software suite.
  
Python based (As of 2015 our MacOSX and Windows builds are without Python):
+
;Python based (As of 2015 our MacOSX and Windows builds are without Python):
 
 
 
* [http://piecash.readthedocs.org/en/latest/doc/doc.html PieCash] a simple and pythonic interface to GnuCash files stored in SQL
 
* [http://piecash.readthedocs.org/en/latest/doc/doc.html PieCash] a simple and pythonic interface to GnuCash files stored in SQL
 
* [https://github.com/niknow/BankCSVtoQif BankCSVtoQif] converts csv from banks to qif and automatically replaces descriptions and accounts of transactions according to predefined customizable rules along the way.
 
* [https://github.com/niknow/BankCSVtoQif BankCSVtoQif] converts csv from banks to qif and automatically replaces descriptions and accounts of transactions according to predefined customizable rules along the way.
 
* [https://gitlab.com/m8ram/vikingcsv2qif vikingcsv2qif] converts csv from [https://mobilevikings.be/en/ Mobile Vikings] to qif with customizable accounts and category
 
* [https://gitlab.com/m8ram/vikingcsv2qif vikingcsv2qif] converts csv from [https://mobilevikings.be/en/ Mobile Vikings] to qif with customizable accounts and category
  
Export invoices:
+
;Export invoices:
 
 
 
* [http://stefans.datenbruch.de/gnucash/gc2latex.shtml gc2latex] - Gnucash invoices with LaTeX and Perl
 
* [http://stefans.datenbruch.de/gnucash/gc2latex.shtml gc2latex] - Gnucash invoices with LaTeX and Perl
 
 
* [https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025615.html Announcement GIP: GnuCash Invoice Printer]
 
* [https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025615.html Announcement GIP: GnuCash Invoice Printer]
 
 
* https://bitbucket.org/smoerz/gcinvoice can create invoices from arbitrary user provided templates, not only for LaTeX.
 
* https://bitbucket.org/smoerz/gcinvoice can create invoices from arbitrary user provided templates, not only for LaTeX.
  
Modified Invoice forms:
+
;Modified Invoice forms:
 
 
 
* [http://web.archive.org/web/http://clusterconsult.thtesche.com/download/gnucash_2_2_7_invoice_de.tgz von thtesche (cluster:Systems) für Version 2.2.7]
 
* [http://web.archive.org/web/http://clusterconsult.thtesche.com/download/gnucash_2_2_7_invoice_de.tgz von thtesche (cluster:Systems) für Version 2.2.7]
  

Revision as of 14:11, 18 May 2020

Several users published their tools to work with GnuCash. Here is a reference list:

Disclaimer

  • The GnuCash team is in no way responsible for the tools linked here.
  • In particular the access to your Gnucash database should only take place by the GnuCash Engine in the library libgncmod-engine.so. The interface is described here in the developer documentation.

Ask the publisher, if they use it or if your data are endangered.

Tools

Command line interfaces
Ledger-CLI
mixed
  • Different SourceForge projects in conjunction to GnuCash.
  • Different GitHub projects in conjunction to GnuCash.
Comment by C. Stimming about it.
  • jPortfolioView - Announcement
  • Lars Eggert offers e.g. Lufthansa Miles&More-Import, updated F::Q-Modul cominvest.pm.
  • Bayes A PERL script to prune the import map of Bayes to get rid of obsolete or unwanted accounts and to remove insignificant entries.
  • BackupGnuCash - Easily create offsite encrypted backups of GnuCash data files by Chris Good. Java, GNU/Linux and Windows.
  • IngAusOfxFix - Fix problems with OFX files from ING before importing into GnuCash by Chris Good. Java, GNU/Linux and Windows.
  • GnuCash-Reporting - Report charts for your GnuCash data. Simple question based UI. Reads from SQL. Java, JavaFX, Linux and Windows.
Spreadsheet to GnuCash (XLSX, CSV to QIF) tools
  • OneClickToQif - a set of templates and macros, which are used to export data from your spreadsheets to QIF format, as used by GnuCash. You can use the templates as provided, or adapt your own spreadsheet, so your data is automatically exported to QIF with a single click
  • XLSM2QIF XLSM2QIF-Link2 is a application for make conversions between 64-bit Excel spreadsheets and Quicken QIF data and GnuCash Android QIF data and GnuCash Desktop QIF and XML data.
  • csv2iif suite, offers perl programs to download PayPal business account transactions via the PayPal API and convert the transactions into IIF, OFX or QIF files. For GnuCash you can use the paypal2qif.pl program from their software suite.
Python based (As of 2015 our MacOSX and Windows builds are without Python)
  • PieCash a simple and pythonic interface to GnuCash files stored in SQL
  • BankCSVtoQif converts csv from banks to qif and automatically replaces descriptions and accounts of transactions according to predefined customizable rules along the way.
  • vikingcsv2qif converts csv from Mobile Vikings to qif with customizable accounts and category
Export invoices
Modified Invoice forms

Mobile Apps

There is a separate page for GnuCash and Mobile Devices

Fonts

Some translations use scripts which are missing in most popular fonts. So here is a list:

mni
Meithei (Manipuri) can be written either in Meitei Mayek or Bengali. While Bengali is in many fonts, Meitei Mayek has been forbiddden over a century and is very rare:
http://tabish.freeshell.org/eeyek/download.html GPL2+
http://e-pao.net/epPageExtractor.asp?src=MeiteiMayek.meetei_mayek_keys.html.. Page with download link and mapping