nNYAB import - key not found

[iffy]

[2021-11-05 21:57:03.662] [info] (core) INFO [ynab] Attempting nYNAB import with decimal=. thousands=, dateformat=MM/dd/yyyy
[2021-11-05 21:57:03.666] [info] (core) DEBUG [ynab] Zip opened
[2021-11-05 21:57:03.666] [info] (core) DEBUG [ynab] found budget.csv
[2021-11-05 21:57:03.667] [info] (core) DEBUG [ynab] found register.csv
[2021-11-05 21:57:03.667] [info] (core) DEBUG [ynab] processing Budget file...
[2021-11-05 21:57:12.600] [info] (core) DEBUG Breathing for 1000
[2021-11-05 21:57:22.616] [info] (core) DEBUG [ynab] processing Register file...
[2021-11-05 21:57:22.670] [info] (core) tables.nim(262)          []
[2021-11-05 21:57:22.670] [info] (core) Error: unhandled exception: key not found:  [KeyError]

[cmeury]

Happened to me as well in v0.63.0.

I also tried it with two different currency and date formats, it failed both times. Not sure if it is relevant to the bug, but since I tried I thought I'd include it, in case it helps isolate the cause.

US Settings

Buckets setting: decimal=. thousands=, dateformat=yyyy/MM/dd

YNAB CSV Example Line: "Bargeld","","2016/12/31","Migros","Essen: Lebensmittel & Haushalt","Essen","Lebensmittel & Haushalt","",$3.00,$0.00,"Reconciled"

Localized Settings

Buckets setting: decimal=. thousands=' dateformat=dd'.'MM'.'yyyy

YNAB CSV Example Line: "Bargeld","","31.12.2016","Migros","Essen: Lebensmittel & Haushalt","Essen","Lebensmittel & Haushalt","",CHF 3.00,CHF 0.00,"Reconciled"

Log

...
[2021-11-06 12:17:24.538] [info] (core) DEBUG [ynab] skipping future transaction: 2021/11/08
[2021-11-06 12:17:25.365] [info] (core) tables.nim(262)          []
[2021-11-06 12:17:25.366] [info] (core) Error: unhandled exception: key not found:  [KeyError]
[2021-11-06 12:17:25.374] [error] (main) uncaughtException Error: write EPIPE
    at WriteWrap.onWriteComplete [as oncomplete] (internal/stream_base_commons.js:83:16)

[iffy]

Thank you for this! A few questions:

1. Can you send me the first line of both the CSV files in your export?
2. What does Essen translate to in English? I'm trying German on Google Translate and getting Eat. Is that Income?

[cmeury]

1. Register: "Account","Flag","Date","Payee","Category Group/Category","Category Group","Category","Memo","Outflow","Inflow","Cleared"
   Budget: "Month","Category Group/Category","Category Group","Category","Budgeted","Activity","Available"
2. "Essen" means "Food", and it's the Category Group. It's not income, it's an expense (in the "Outflow" column).

I've put together a minimal example: ynab-buckets614-minimal.zip

The single transaction is a reconciliation in an off-budget account (==no category). So, there's no corresponding budget statement.

[iffy]

Included in v0.63.1 release (AUTOMATED COMMENT)

[cmeury]

Confirming import now again works for me in v0.63.1 beta. Thanks!

[stefer09]

Mine is still crashing on v0.63.1 beta ,
[2021-11-07 10:59:10.031] [info] (core) ERROR [ynab] Failed to parse Date '2022-04-21' w/ format yyyy/MM/dd: Failed to parse '2022-04-21' with format 'yyyy/MM/dd'. Unexpected character: -

"Account","Flag","Date","Payee","Category Group/Category","Category Group","Category","Memo","Outflow","Inflow","Cleared"
"BNC MC","Red","2022-04-21","LastPass","True Expenses: Computer/Electronics/AV/Software 📺 💻💾","True Expenses","Computer/Electronics/AV/Software 📺 💻💾","voir BILL pour vrai montant (US$)",$15.15,$0.00,"Uncleared"

(it's a scheduled, yearly transaction)

[cmeury]

@stefer09 Have you tried changing the date format to match your nYNAB export?

[stefer09]

@cmeury Darnit... was only paying attention to the order of the year and month and day, not the separators, my bad!