YNAB Converter

Question

YNAB Converter

lassensurf opened this issue 4 years ago · 4 comments

I've used this converter tool in the past without issue, it's great! But today, not all the data is importing into the tool. It's there when I open the file in excel, but it doesn't load it all in the YNAB tool. Any ideas?

Answer 1 · 2021-01-18T22:37:18.000Z

Thank you for the report @lassensurf. I would only be able to help if you'd provide some (anonymised) file contents. Can be pasted here as raw text. Without that I'm not really able to do much.

You could also take one of the previous excels that worked for you earlier and try uploading it to the converter to see if they also get broken or is it fine for them but breaks for the current one. This might lead us to the reason too.

Answer 2 · 2021-01-19T02:41:42.000Z

I figured it out, I had to delete some lines from the csv that had items in it like "pending" then import that new csv into the converter. Thanks!

…

On Mon, Jan 18, 2021, 5:37 PM Ania Warzecha ***@***.***> wrote: Thank you for the report @lassensurf <https://github.com/lassensurf>. I would only be able to help if you'd provide some (anonymised) file contenta. Can be pasted here as raw text. Withou that I'm not really able to do much. You could take one of the previous excels that worked for you in earlier and try uploading it to the converter to see if they also get broken or is it fine for them but breaks for the current one. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEI7PWYO6UGXU36WQQQVTNTS2SZ23ANCNFSM4WH4BN3Q> .

Answer 3 · 2021-01-19T07:50:52.000Z

Happy it worked! Were these lines containing only the word pending so that the converter was cutting off everything below of them?

Answer 4 · 2021-01-21T15:50:39.000Z

It was only importing the dates along with the words "Pending" or "Cleared" and nothing else. I don't think it could recognize the column headers that said "Date" "Amount" "Description" etc.Once I got rid of some of the other lines, it all worked fine.

…

On Tue, Jan 19, 2021 at 2:51 AM Ania Warzecha ***@***.***> wrote: Happy it worked! Were these lines containing only the word pending so that the converter was cutting off everything below of them? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEI7PW2TQQRG6JIRN2NDL4TS2U2WXANCNFSM4WH4BN3Q> .