Skip to content

Georgs Blog

  • Home
  • github
  • PGP-Keys
  • Cheat sheets

Category: office

Find orphaned sidecar files

Some software like digital image processing tools work with sidecar files which are placed next to the original file. E.g. darktable uses .xmp as file extension, rawtherapee .pp3.

When you sort out / delete original files outside of the software, you end up with orphaned sidecar files.

Continue reading “Find orphaned sidecar files”
Author georgPosted on 2021-06-062021-06-06Categories code, officeTags darktable, photography, python, rawtherapee, sidecar

Import paypal CSV to homebank

paypal2homebank.py converts the CSV export of paypal to the CSV import format of homebank.

Example:

$ paypal2homebank.py ~/bin/Download.CSV ~/out.csv
Processing line 1
Processing line 2
Skipping type Memo in line 3

Author georgPosted on 2020-04-182020-06-27Categories code, officeTags banking, paypal

Import Volksbank CSV to homebank

fiducia2homebank.py converts the CSV export of fiducia based banking websites (e.g. Volksbank ) to the CSV import format of homebank.

Example:

$ fiducia2homebank.py Umsaetze_DExxxxxxxxxxxxxx_2020.01.01.csv ~/out.csv
Found header in line 9
Data section ends in line 42

Author georgPosted on 2020-04-132020-06-27Categories code, officeTags banking, csv, homebank

Get a list of gnucash accounts in python

For use in scripts it might be helpful to get a flat list of accounts from a given gnucash file. Fortunately gnucash has an extensive python binding. See the script gnucash_accounts.py for an example on how to use it:

Continue reading “Get a list of gnucash accounts in python”
Author georgPosted on 2018-01-282020-06-14Categories code, officeTags gnucash, python

Yet another gnucash import script

gnucash_import parses a CSV file and directly imports it into gnucash.

Example usage:

gnucash_import.py csv_file myfile.gnucash "Aktiva:Barvermögen:Girokonto"
Continue reading “Yet another gnucash import script”
Author georgPosted on 2017-12-292020-06-27Categories code, officeTags banking, csv, gnucash

Posts navigation

Page 1 Page 2 … Page 8 Next page

Categories

  • backup (14)
  • code (75)
  • database (10)
  • email (37)
  • geo (9)
  • hardware (15)
  • network (27)
  • office (37)
  • security (20)
  • unix (89)
  • windows (35)
  • www (37)

Archives

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tags

  • banking
  • borgbackup
  • ci
  • courier
  • csv
  • darktable
  • dell
  • docker
  • dotfiles
  • encryption
  • firefox
  • git
  • gnucash
  • gpg
  • homeassistant
  • homebank
  • imap
  • jenkins
  • laptop
  • letsencrypt
  • mqtt
  • offlineimap
  • owncloud
  • paypal
  • photography
  • proxy
  • python
  • rawtherapee
  • screensharing
  • sendmail
  • sidecar
  • smarthome
  • ssh
  • subversion
  • syncthing
  • tests
  • traefik
  • ubuntu
  • video
  • virtualbox
  • Home
  • github
  • PGP-Keys
  • Cheat sheets
Georgs Blog Proudly powered by WordPress