genious7 / FanFictionReader

An android app that improves browsing Fan Fiction stories on a mobile device
GNU General Public License v3.0
56 stars 24 forks source link

Not really a Issue. #69

Open jonathanmw opened 3 years ago

jonathanmw commented 3 years ago

I was wondering if anyone knew how to extract a list of story ids from the backup file. I've used this app for years between having and not having internet so I have quite a few stories that I don't have on my account. It would be great if I could just extract the ids and copy and paste them into the site.

hallowknight99 commented 3 years ago

From a closed ticket https://github.com/genious7/FanFictionReader/issues/64 Here are instructions: Create a backup (Settings > back up files to memory) Transfer the file to your computer Rename the file to Fanfiction_backup.zip Open the zip file and go to databases > library.db Open library.db in an SQLite reader (like https://sqlitebrowser.org/) If you're using SQLite reader, right click on Tables > fanfiction_library_fts_content and click "Browse Table" You can then select all the IDs in the doc id column, right click and click "Copy" These IDs can be pasted wherever you want to. You'll need to add "www.fanfiction.net/s/" before each ID to import them with fanficfare

zeek17 commented 3 years ago

Yeah, it's possible that way, but quite complicated and require third party software. And it'd be great if we could extract such list with one button tap from app itself. And import back as well - straight to download/update queue. Because it's only way I can make backups - standard way is not possible for me, I can't free necessary space to create backup.