YNAB4 Converter Tool [alpha]

[RPNnerd]

Looking at the json file:

  "_id": "budget_ebb300ec-452f-443b-9133-34c8595204b0",
    "name": "<budget_name>",
    "currency": "USD",
    "hints": {
      "outflow": true
    },
    "created": "2016-11-20T20:11:15.329Z",
    "checkNumber": false


It does have a created stamp in the json.


Is there something to look for in the json to identify why it may have halted or is the source file the more likely point to investigate?

[Joel]

@RPNnerd - you would have to zip the entire .ynab4 folder and then send it as a zip file.

Yes, I'm hesitant to do that as the first step... I'm wondering how to tell YNAB to save the latest or financier which file is most recent?

I think YNAB is saving the latest-- under the file.  I see the latest via the timestamp (ls -al).

I don't see any particular file that ended on April 28th (last transaction date recorded in the conversion)

I would open the ynab4 folder and look at what data# folders exist. If you then save a version in ynab4, it should create a new data# folder. The .yfull file you need should be in the new data# folder.

Also, it may be worth compacting your ynab4 budget to clean things up. Ctrl + Shift + Alt + C

[RPNnerd]

@RPNnerd - you would have to zip the entire .ynab4 folder and then send it as a zip file.

Yes, I'm hesitant to do that as the first step... I'm wondering how to tell YNAB to save the latest or financier which file is most recent?

I think YNAB is saving the latest-- under the file.  I see the latest via the timestamp (ls -al).

I don't see any particular file that ended on April 28th (last transaction date recorded in the conversion)

I would open the ynab4 folder and look at what data# folders exist. If you then save a version in ynab4, it should create a new data# folder. The .yfull file you need should be in the new data# folder.

Also, it may be worth compacting your ynab4 budget to clean things up. Ctrl + Shift + Alt + C

Yes, @Joel I have compacted in the past. 

I'm not seeing it create a new folder... just new data# files.

[Joel]

There should be the new yfull file in the newly created data# folder.

[RPNnerd]

@Joel  -- I am on a Mac... if that makes a difference between file/folder handling.

[Joel]

@Joel  -- I am on a Mac... if that makes a difference between file/folder handling.

The file structure is not any different for ynab4 whether you are using Windows or Mac.

[RPNnerd]

@Joel  -- I am on a Mac... if that makes a difference between file/folder handling.

The file structure is not any different for ynab4 whether you are using Windows or Mac.

Hmmmm....

OK.

First level of directories:
/Users/<username>/Dropbox/YNAB/

ls * gives:
Exports/<budget1 from 09/05/16>.csv

<budget1>.ynab4/
Backup<date and identifier>.y4backup
...
Budget.ymeta
data1~C0D1DEE7/
data2-4E27F89B/
readme.txt

<budget2>.ynab4/
....

<budget3>.ynab4/
...
<budget4>.ynab4/
....

I see the Data directories you mentioned now... it was the Backup with the current date that caught my attention.


The data1 directory has contents removed and a file that says it was compacted and therefore content removed.

Content in the data2 directory has

7D1C3725-3841-8F32-997A-2F8707037CE1   
B9397F71-A532-A0B8-F29B-334D53A0C4A0   
EAD8F13B-7CFA-4F30-93A7-F488B43EE582
B412BE51-8F03-4906-A9CC-E6EACC2C4881   
C2000CBA-4F7B-9822-5BB6-19418771558A
devices


A little further-- the first one stops at the end of April:
ls -al 7D1C3725-3841-8F32-997A-2F8707037CE1/
total 3504
  136 Oct  1 06:53 .
272 Apr 17  2016 ..
1785731 Apr 24  2016 Budget.yfull
5913 Apr 30  2016 budgetSettings.ybsettings

The other directories have many files that go into the Nov20th time stamp.

Thanks!

[Joel]

If you save a version (within ynab4), it should create a new data# folder for you. Within that new folder will be the .yfull file you need to convert

[jerryfmccarthy]

Brilliant Work Alex! The converter worked flawelessly and took less than seconds to prepare my YNAB4 file of 18 months data for import.
And everything was imported correctly. Amazing work. With a few more developments this is without a doubt what YNAB5 should have been.  parrot


Jerry

[RPNnerd]

I tried a second budget.  It pulled in data only through December 2015.   

I'm not on the primary machine that initiated the budget--- but Dropbox should be the same across them, right?

[isildo]

I pulled the budget.yfull file from my Data1 folder first and realized it only had a few transactions from when I first set up YNAB back in 2014. I looked for the highest number data file (I think it was data52) and pulled that budget.yfull file, and that had all my information up to the current date.

[Bruce]

Brilliant Work Alex! ..... Amazing work. With a few more developments this is without a doubt what YNAB5 should have been.  parrot

Well said and I agree 100%

[MacMichael]

I just converted/imported 2 1/2 years of YNAB 4 data into Financier.  It worked great on the first try and all the data is correct.  My computer is a Mac running El Capitan (version 10.11.6)  A huge thanks to Alex.

[Joel]

This alpha works better than what other companies are selling their real product for...

[tbdoml]

It worked! My whole ynab4 budget is now on Financier. I've been lurkin here off and on, and I like the progress you are making.
I plan on running both ynab4 and Financier until the phone app is available, (wife needs to have a
simple way to add transactions).Thanks Alex!!!