[02:47:35] interesting approach 😀 (re @Nikki: I would probably use quarry for something like that though, the dumps are *huge*) [02:56:02] Thanks for the suggestion! 🤩 [02:56:03] Based on your idea I came up with this: [02:56:05] grep for the line numbers of each QID in the database and make a list in a file [02:56:06] for each line number: [02:56:08] use sed to extract the line (https://linuxcommando.blogspot.com/2008/03/using-sed-to-extract-lines-in-text-file.html) to a new file [02:56:09] use python and qwikidata to iterate the new file (re @Nikki: if I were doing it from a dump anyway, I'd probably use grep (no point wasting time parsing an entity that doesn't have any swed...) [03:01:30] Oh the sed step is not needed as grep returns the whole line by default (https://superuser.com/questions/783622/how-to-make-grep-command-return-entire-matching-line) [03:02:44] So a nifty python script that first use grep and then qwikidata is probably the fastest to avoid parsing all the json that is irrelevant. [03:57:46] FWIW I got an error from PAWS when trying to read the dump line by line instead and only parse if the QID is in the set of QIDs yet to be processed... : https://tools-static.wmflabs.org/bridgebot/384b3afe/file_55866.jpg [05:44:46] 👋 [07:28:42] 👍 [08:17:47] I've added a comment to the ticket :) (re @gopavasanth: WikiVideos - Automating Video Creation from Wikimedia Projects [08:17:47] [08:17:48] This concept emerged from informal discussions during lunch at I...) [08:19:07] Thanks @Ideophagous :) (re @Ideophagous: I've added a comment to the ticket :)) [21:04:10] I'm excited to announce the release of the first experimental version of the *Adiutor* extension. This new extension is now available for testing on your local server's MediaWiki software. I warmly invite you to try it out and explore its features. Your feedback is invaluable to the development process, as it will help refine and enhance the extension's capabilities. Don't miss t [21:04:11] his opportunity to be a part of this innovative journey and contribute to its development. [21:04:12] [21:04:14] *The 5 global features included in the first version are: [21:04:15] * [21:04:17] Speedy deletion request [21:04:18] Propose deletion [21:04:20] Protection request [21:04:21] Page move request [21:04:23] Article tagging [21:04:24] [21:04:26] https://www.mediawiki.org/wiki/Extension:Adiutor