Thread: Aura H2O Bulk editing Pocket articles
View Single Post
Old 02-06-2017, 08:43 PM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
The metadata is stored in the database. You could run SQL against this to do the deletes or otherwise mark them as archived or deleted. I haven't paid much attention to the Pocket articles, but quickly:
- The table "content" has two rows for each article - one describes the article, the other is probably used for the current reading position.
- The contentId of the main row is the directory name of the article.
- The rows all have MimeType = 'application/x-kobo-html+pocket'
- There is a "PocketStatus". Changing that is probably what is needed, but I don't know the values.

But, I think the answer is a lot simpler: Sign out of Pocket on the device. This should clear all the articles. Then sign in and it should only download the current articles.

If you don't trust it, take a full copy of the book partition before doing the above. If it doesn't work, restore the copy in place of what you have. And I'd recommend doing this before fiddling with the database.
davidfor is offline   Reply With Quote