Best way to get some data from VNDB into Excel?
|#1 by lucumo|
2022-01-03 at 20:14
|< report >Hello there,|
first off, I'm basically lacking any software knowledge. However, I would like to get two data points into an Excel document. The first one would be the VNDB id and the second one would be the main title. Whether those two data points occupy the same column or not doesn't matter (well, the id would have to come first).
Two filters matter to me and that's that it's a Japanese release and that it has a Windows release. Currently, that applies to 20552 VNs. I looked into doing it via the search function, but ordering by id (which is important to me) is not an option and there would be other data points getting in the way as well (release date).
So...any pointers on how best to achieve this?
|#2 by Yorhel|
2022-01-03 at 20:22
|< report >The query interface has an export-to-Excel feature. I believe this query should do it: table with download button (sql)|
|#3 by lucumo|
2022-01-03 at 21:26
|< report >I looked at that before but my browsers generally just give me a blank page. And like I said, I have no software knowledge, so...|
|#4 by Yorhel|
2022-01-04 at 05:42
|< report >You don't need software knowledge to ask someone to write a query for you... and a modern browser with JS enabled should display that just fine.|
|#5 by lucumo|
2022-01-04 at 11:09
|< report >Depends, I did look around after all and it all seemed gibberish to me. As for the browser display...no clue. My Firefox is the last version that was able to run XUL-based addons but my Palemoon shouldn't have an issue. Oh well, I will just poke you on IRC.|
/edit: Seemed like Palemoon also wasn't good enough. New browser (Librewolf) and it works now. Thank you (hurray for IRC).Last modified on 2022-01-04 at 11:48
You must be logged in to reply to this thread.