Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

App doesnt work but... #71

Open
ElSofaFuerte opened this issue Mar 12, 2021 · 4 comments
Open

App doesnt work but... #71

ElSofaFuerte opened this issue Mar 12, 2021 · 4 comments

Comments

@ElSofaFuerte
Copy link

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
Copy link
Author

ElSofaFuerte commented Mar 12, 2021

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
Copy link

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 #69 (comment) 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
Copy link

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
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants