search

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

App doesnt work but... #71

Open ElSofaFuerte opened 3 years ago

ElSofaFuerte commented 3 years ago

I'm not saying I wouldn't use this app once its fixed by either genious7 or someone else forking this, but would anyone perhaps want to tackle the challenge of trying to make an export tool for the .bak files to convert the library into text/pdf/ebook files. I have an absolute ton of stories some of which are not even on the site anymore and a way to save them would be great. I am sure other people think similarly.

ElSofaFuerte commented 3 years ago

Generally the .bak files are easily opened by using a zip/rar program and all the contents are saved as .html files on a per chapter basis with a ID_CHAPTER.html. The actual name of the fic, author, category, description, etc. are all stored in the SQL database file library.db with the most important data being in fanfiction_library_fts_content because it also includes the story ID associated with the html files. You could probably do this all by hand but my question is if someone can make a light tool to take the info from the fanfiction_library_fts_content table and the html chapters and compile it into PDF format for the story name as the file name and the description, author, and other info on page 1 with the chapters following or something like that.

Luminatrix-eng commented 3 years ago

I'm not saying I wouldn't use this app once its fixed by either genious7 or someone else forking this, but would anyone perhaps want to tackle the challenge of trying to make an export tool for the .bak files to convert the library into text/pdf/ebook files. I have an absolute ton of stories some of which are not even on the site anymore and a way to save them would be great. I am sure other people think similarly.

You might be able to use a SQLite reader (like https://sqlitebrowser.org/) to extract the .bak files although I'm not entirely sure how. I saw this post https://github.com/genious7/FanFictionReader/issues/69#issuecomment-774638080 to extract story id's and put them in excel spreadsheet but I'm not sure where to find the .bak file and extract it in a similar manner compared to retrieving the story id's (assuming it's possible with SQLite reader?)

You'll have to ask @genious7

Luminatrix-eng commented 3 years ago

Generally the .bak files are easily opened by using a zip/rar program and all the contents are saved as .html files on a per chapter basis with a ID_CHAPTER.html. The actual name of the fic, author, category, description, etc. are all stored in the SQL database file library.db with the most important data being in fanfiction_library_fts_content because it also includes the story ID associated with the html files. You could probably do this all by hand but my question is if someone can make a light tool to take the info from the fanfiction_library_fts_content table and the html chapters and compile it into PDF format for the story name as the file name and the description, author, and other info on page 1 with the chapters following or something like that.

Could you use the Pocket feature in Mozilla Firefox to save the html chapters and somehow download it and convert it to pdf or ebook format? https://support.mozilla.org/en-US/kb/save-web-pages-later-pocket-firefox

ElSofaFuerte commented 3 years ago

Sure, you can do all this by hand. I can use Combine plugin with Notepad++ to combine the HTML chapters into one and utilize Chromes pretty robust Print to PDF to turn the new file into a PDF but considering I have over 2k stories this would all be time consuming.