News:

10/23/16 - Welcome to the new forums!

Main Menu

Hacking Financier's data format

Started by Alex, November 15, 2016, 09:32:48 PM

Previous topic - Next topic

Alex

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. :)
I am the Financier owner/admin/coder dude.

asromzek

Building a converter for YNAB4/nYNAB budget exports is underway...
/s implied, unless stated otherwise.

asromzek

#2
The working title will be YNAC (You Need A Converter).
/s implied, unless stated otherwise.

ottyacat

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.

asromzek

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.
/s implied, unless stated otherwise.

Alex

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.
I am the Financier owner/admin/coder dude.

Alex

@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. ;)
I am the Financier owner/admin/coder dude.

asromzek

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/

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.
/s implied, unless stated otherwise.

Alex

Sweet! I cannot wait to see what you come up with. :)
I am the Financier owner/admin/coder dude.