![]() |
#46 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 5,788
Karma: 103362673
Join Date: Apr 2011
Device: pb360
|
Thanks! So the "source_wildcard" column also does not affect matching and its contents are not critical?
|
![]() |
![]() |
![]() |
#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.
|
![]() |
![]() |
![]() |
#48 | ||
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 5,788
Karma: 103362673
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? |
||
![]() |
![]() |
![]() |
#49 | |
Addict
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 328
Karma: 800105
Join Date: Feb 2013
Device: PW1
|
Quote:
Code:
PRAGMA user_version = 1; |
|
![]() |
![]() |
![]() |
#50 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 5,788
Karma: 103362673
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 |
|
![]() |
![]() |
![]() |
#51 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 5,788
Karma: 103362673
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 | 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 |