Financier Forums

Financier App => Other => Topic started by: Alex on November 15, 2016, 09:32:48 PM

Title: Hacking Financier's data format
Post by: Alex on November 15, 2016, 09:32:48 PM
If you want to create your own tool to import/manipulate data for Financier, check out the new data docs!


https://blog.financier.io/financier-data-format-docs-47b89d92761b


Discuss here with other users and ask questions if you have any. :)
Title: Re: Hacking Financier's data format
Post by: asromzek on November 15, 2016, 09:51:43 PM
Building a converter for YNAB4/nYNAB budget exports is underway...
Title: Re: Hacking Financier's data format
Post by: asromzek on November 15, 2016, 10:02:14 PM
The working title will be YNAC (You Need A Converter).
Title: Re: Hacking Financier's data format
Post by: ottyacat on November 15, 2016, 10:42:39 PM
Quote from: asromzek on November 15, 2016, 10:02:14 PM
The working title will be YNAC (You Need A Converter).

I actually LOLd at work in a quiet room. Ahh this made my day.
Title: Re: Hacking Financier's data format
Post by: asromzek on November 15, 2016, 11:17:10 PM
This is going to be fun...


There are some significant differences between the YNAB4 and nYNAB exported CSV formats. It's going to be a challenge to automatically detect some critical details like which accounts are on/off budget, which accounts are open or closed (the user may need to specify that for each account), and which categories are active/hidden.


@Alex, I want a raise.
Title: Re: Hacking Financier's data format
Post by: Alex on November 15, 2016, 11:55:53 PM
Quote from: asromzek on November 15, 2016, 11:17:10 PM
This is going to be fun...


There are some significant differences between the YNAB4 and nYNAB exported CSV formats. It's going to be a challenge to automatically detect some critical details like which accounts are on/off budget, which accounts are open or closed (the user may need to specify that for each account), and which categories are active/hidden.


@Alex, I want a raise.

Now you see why I procrastinated doing import from CSV. ;) It's definitely worth doing, though.
Title: Re: Hacking Financier's data format
Post by: Alex on November 15, 2016, 11:59:49 PM
@asromzek I know you're looking at getting importing working from the CSVs, but the YNAB 4 JSON file format is a bit less convoluted:

http://jack.codes/projects/2016/09/13/reversing-the-ynab-file-format-part-1/

In case *someone* wanted to hack away at that. ;)
Title: Re: Hacking Financier's data format
Post by: asromzek on November 16, 2016, 12:05:06 AM
Quote from: Alex on November 15, 2016, 11:59:49 PM
@asromzek I know you're looking at getting importing working from the CSVs, but the YNAB 4 JSON file format is a bit less convoluted:

http://jack.codes/projects/2016/09/13/reversing-the-ynab-file-format-part-1/ (http://jack.codes/projects/2016/09/13/reversing-the-ynab-file-format-part-1/)

In case *someone* wanted to hack away at that. ;)


It's like you're reading my mind... I was just about to go down that path. I see 3 options at this point: convert the YNAB4 budget directly from the native format stored in Dropbox (best solution), convert the YNAB4 budget from the exported CSV (not as fun), convert the nYNAB budget from the exported CSV (least fun method, but the one I need for myself to migrate). I'm going to prototype a few things over the next couple of days. It's a littler tougher working on a laptop in a hotel room... I miss my multi-monitor set up at home.
Title: Re: Hacking Financier's data format
Post by: Alex on November 16, 2016, 08:22:17 AM
Sweet! I cannot wait to see what you come up with. :)