@
Distoration Ik heb een db-backup container draaien die voor de backup zorgt.
Mijn hele firefly keten zit in 1 compose-file, met daarin dit blokje voor de backup:
code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
| db-backup:
container_name: firefly-db-backup
image: ghcr.io/tiredofit/docker-db-backup:latest
volumes:
- /dbbackup:/backup
#- ./post-script.sh:/assets/custom-scripts/post-script.sh
environment:
#- PUID=1000
#- PGID=1000
- TIMEZONE=Europe/Amsterdam
#- CONTAINER_NAME=example-db-backup
- CONTAINER_ENABLE_MONITORING=FALSE
- LOG_PATH=/backup/logs
# - DEBUG_MODE=TRUE
- BACKUP_JOB_CONCURRENCY=1 # Only run one job at a time
- DEFAULT_CHECKSUM=NONE # Don't create checksums
- DEFAULT_COMPRESSION=ZSTD # Compress all with ZSTD
- DEFAULT_BACKUP_INTERVAL=1440 # Backup every 1440 minutes
- DEFAULT_BACKUP_BEGIN=2359 # Start backing up at xx:xx
- DEFAULT_CLEANUP_TIME=8640 # Cleanup backups after a week
- DB01_TYPE=mariadb
- DB01_HOST=fireflyiiidb
- DB01_NAME=firefly
- DB01_USER=abc
- DB01_PASS=xyz
- DB01_BACKUP_INTERVAL=480 # (override) Backup every x minutes
#- DB01_BACKUP_BEGIN=+1 # (override) Backup starts immediately
#- DB01_CLEANUP_TIME=180 # (override) Cleanup backups they are older than 180 minutes
- DB01_CHECKSUM=SHA1 # (override) Create a SHA1 checksum
- DB01_COMPRESSION=GZ # (override) Compress with GZIP
depends_on:
db:
condition: service_healthy
restart: unless-stopped |
Verder koppel ik tijdens de import al, dmv een import_config.json allerlei account aan elkaar.
Mijn json:
{
"version": 3,
"source": "ff3-importer-1.5.6",
"created_at": "2025-01-14T14:09:31+01:00",
"date": "Ymd",
"default_account": 1,
"delimiter": "semicolon",
"headers": true,
"rules": true,
"skip_form": true,
"add_import_tag": true,
"roles": [
"date_transaction",
"opposing-name",
"account-iban",
"opposing-iban",
"_ignore",
"ing-debit-credit",
"amount",
"tags-comma",
"description",
"_ignore",
"_ignore"
],
"do_mapping": [
true,
true,
true,
false,
false,
false,
false,
false,
false,
false,
false
],
"mapping": {
"1": {
"Albert Heijn 1234 Lutjebroek": 29,
"Albert Heijn 5678 Amsterdam": 29
},
"2": {
"NL00INGB1234567890": 1
}
},
"duplicate_detection_method": "classic",
"ignore_duplicate_lines": true,
"unique_column_index": 0,
"unique_column_type": "internal_reference",
"flow": "file",
"content_type": "csv",
"custom_tag": "",
"identifier": "0",
"connection": "0",
"ignore_spectre_categories": false,
"grouped_transaction_handling": "single",
"use_entire_opposing_address": false,
"map_all_data": true,
"accounts": [],
"date_range": "",
"date_range_number": 30,
"date_range_unit": "d",
"date_not_before": "",
"date_not_after": "",
"nordigen_country": "",
"nordigen_bank": "",
"nordigen_requisitions": [],
"nordigen_max_days": "90",
"conversion": false,
"ignore_duplicate_transactions": true
}
Ik heb 1 Albert Heijn crediteur, zonder IBAN. Die crediteur heeft in de db id 29, en alle transacties die Albert Heijn 1234 of Albert Heijn 5678 als opposing name hebben worden omgehangen naar die ene Albert Heijn crediteur.
in mijn hoofd klinkt deze uitleg logisch, hopelijk komt het ook zodanig over. zo niet, vraag gerust verduidelijking
:strip_icc():strip_exif()/u/8817/DSC05697_70x70-2.jpg?f=community)
:strip_icc():strip_exif()/u/178794/Iron_Maiden_klein.jpg?f=community)
:strip_exif()/u/47273/goticon.gif?f=community)
:strip_icc():strip_exif()/u/28238/dommel.jpg?f=community)
?
. 
:strip_icc():strip_exif()/u/6081/Apogee_Avatar_60x60.jpg?f=community){kind=avatar}
Registry verwijderen en weer toevoegen werkt alles wel 
:strip_exif()/u/28955/leipie.gif?f=community)
:no_upscale():strip_icc():strip_exif()/f/image/iB9fpGmvqsDEiYnlIBQQEE1V.jpg?f=user_large)
:strip_exif()/f/image/pV2Oyg2Bakmu7OLCpcT8q18y.png?f=user_large)