Thanks for this, and especially for the clear, step-by-step instructions with visuals 
1 Like
This is great, though I have like 1000 items left to burn 
If you ever implement a historic retrieval, I’d be very happy to use that.
1 Like
すごいソース！
Thanks, @eainge for the data sheet. And thanks @Belthazar for some extra ソース
1 Like
Thanks @eainge you might just have triggered me to reset and restart wanikani from scratch after a 18 months pause 
Ooo will you still be motivated to go forward if you start over? I think the data would look pretty interesting starting from your current point, it doesn’t need to start from the beginning.
Also I’m just coming back from a long hiatus myself! Just leveled up for the first time since summer 2019. My data looks terrible haha but what can ya do?
1 Like
For some reason, my spreadsheet stopped counting Radicals, Kanji, and Vocabulary separately? I pasted in the old numbers from my API 1.0 spreadsheet, could that be why?
1 Like
Hmm, this is really odd. I don’t think pasting old numbers into your API would do anything like this. I haven’t changed anything on my end, so it’s strange that it would happen all of a sudden.
Did you change anything around 1/6 or 1/7?
Nope, I have a healthy fear of javascript so I didn’t even go near it.
Do the totals line up correctly with your Wanikani website?
Also did you do anything in WaniKani - like reset back a level?
One final reply @bonkaholic
If you’re up for it, we could try to debug this together. Go to your excel and click Tools → Script Editor. You should have a script called fetchData2.gs. Click on that.
Now scroll down to line 29, which should say var radA = parsed.total_count; After that line, on line 30 or so, add in a new line that says console.log(radA).
Press the run button and share with me what it outputs in the exection log. Also you can go to your WaniKani spreadsheet and see that it’s put in a new row. Let me know what it looks like. You can delete this excel row afterwards, it won’t affect the code.
For your reference, the code just looks for the next free line and appends it each time. So you can run it as many times as you want manually, and delete the new row each time, and it won’t affect it. It also won’t affect it’s auto-run at midnight each day.
Lmao, ok I figured it out as soon as I copied a row when you said
go to your WaniKani spreadsheet and see that it’s put in a new row. Let me know what it looks like.
The text was white.
2 Likes
Hahaha, what?? I would never have guessed that.
1 Like
Hi! Just wanted to say that I love this spreadsheet and have been using it since last year to track my progress by checking it twice a month or so. However, I ran into a problem. On the stack and reversed stack view of the charts, I can’t seem to scroll right and the graphs just ends at february even though the data is up to this month. Ars there any solutions to this?
1 Like
Hi - It’s possible the graph’s dataset isn’t including all of your new data (or rather, you have so much data that the graph wasn’t expecting it). Right click on one of the charts and click on Data Range and see if it’s stopping somewhat short. You can then update it.
2 Likes
Thanks for the reply! I edited the data range and it actually stopped short like you said so I updated it. Do you think that I have to update it manually moving forward or do you think it will go back to normal and include my latest data?
It never updated automatically for new data, it just was set to a generically large data range. Just set it to be much much larger than what you think you need.
2 Likes
You can make it auto update with new data if you update the range with a column instead of a column:row
1 Like
I’m not sure, you may have to manually select the data yourself.