07-15-2018, 11:14 AM | #46 |
Grand Sorcerer
Posts: 5,257
Karma: 98507638
Join Date: Apr 2011
Device: pb360
|
Thanks! So the "source_wildcard" column also does not affect matching and its contents are not critical?
|
07-15-2018, 01:08 PM | #47 |
Addict
Posts: 328
Karma: 800105
Join Date: Feb 2013
Device: PW1
|
Yeah, I haven't seen it make a difference so far, unless they've finally started doing something with it. I just set it to be the same as the entity's name and leave it at that.
|
07-22-2018, 12:57 PM | #48 | ||
Grand Sorcerer
Posts: 5,257
Karma: 98507638
Join Date: Apr 2011
Device: pb360
|
Quote:
Quote:
One other problem that I have run into is that if I do a round trip by dumping the database then making what should be a duplicate db by loading the dump into a new db, the kindle does not recognize that new db as a valid XRAY file. Do you know what might be happening with that? |
||
07-24-2018, 01:54 PM | #49 | |
Addict
Posts: 328
Karma: 800105
Join Date: Feb 2013
Device: PW1
|
Quote:
Code:
PRAGMA user_version = 1; |
|
07-24-2018, 08:39 PM | #50 | |
Grand Sorcerer
Posts: 5,257
Karma: 98507638
Join Date: Apr 2011
Device: pb360
|
Quote:
That worked. Thanks! The way I made it was to run sqlite3 on the original db, then set output file to Wap.sql, did a .dump then did sqlite3 XRAY.entities.B00JCDK5ME.asc < Wap.sql in a directory that had no file named XRAY.entities.B00JCDK5ME.asc As you suspected, user_version = 0 My sqlitebrowser at work has an Edit Pragmas tab, but I have no XRAY file there. At home, sqlitebrowser doesn't have an Edit Pragmas tab so I just used sqlite3 |
|
08-31-2018, 01:38 PM | #51 |
Grand Sorcerer
Posts: 5,257
Karma: 98507638
Join Date: Apr 2011
Device: pb360
|
I've updated the original post to summarize the results (XRAY file delivered by Amazon no longer broken). I've also attached a fix to the XRAY content errors for this book that I know about to that post.
|
Tags |
war and peace, x-ray |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
10h BBC Radio dramatisation of "War and Peace" | HarryT | Deals and Resources (No Self-Promotion or Affiliate Links) | 14 | 01-15-2015 05:09 PM |
Proposal: CSS "normalisation" functionality in Sigil | Man Eating Duck | Sigil | 17 | 08-20-2013 12:25 PM |
Suggestions for Functionality of the "consumer" iLiad | Riocaz | iRex | 20 | 06-01-2006 08:08 AM |