Skip to content

Latest commit

 

History

History
467 lines (405 loc) · 17.2 KB

index.md

File metadata and controls

467 lines (405 loc) · 17.2 KB
Raw

JWPUB to Epub

Step-by-step guide to converting JWPUB, to EPUB.

Blog - how things are going

Let's start with something simple, Good News From God! looks nice.

It's 8mb in size, and it's a zip.

After unzipping we get:

fg_E.jwpub/
├── contents
└── manifest.json

/manifest.json

note: things after // got added

{
  "name": "fg_E.jwpub", // This is file name codename_mepslangcode.format
  "hash": "3624ce30399a31e795bb02132081883adb3580aa59432990f57aa4ca47132a88", // sha256sum fg_E.jwpub/contents
  "timestamp": "2019-02-05T20:49:53Z",
  "version": 1,
  "expandedSize": 8990059,
  "contentFormat": "z-a",
  "htmlValidated": false,
  "mepsPlatformVersion": 2.1,
  "mepsBuildNumber": 8427,
  "publication": {
    "fileName": "fg_E.db",
    "type": 1,
    "title": "Good News From God!",
    "shortTitle": "Good News",
    "displayTitle": "Good News  (fg)",
    "referenceTitle": "Good News",
    "undatedReferenceTitle": "Good News",
    "symbol": "fg",
    "uniqueEnglishSymbol": "fg",
    "uniqueSymbol": "fg",
    "undatedSymbol": "fg",
    "englishSymbol": "fg",
    "language": 0,
    "hash": "b2014fb5b5008ee4e7802f76c9ed218208604cbd",
    "timestamp": "2019-02-05T20:49:53Z",
    "minPlatformVersion": 1,
    "schemaVersion": 8,
    "year": 2012,
    "issueId": 0,
    "issueNumber": 0,
    "variation": "",
    "publicationType": "Brochure",
    "rootSymbol": "fg",
    "rootYear": 2012,
    "rootLanguage": 0,
    "images": [
      {
        "signature": "2ed101473a1ec33cf45dbd6335e7cff7c5d700c0:600:771",
        "fileName": "1102012181_E_cvr.jpg",
        "type": "c",
        "attribute": "r",
        "width": 600,
        "height": 771
      },
      {
        "signature": "604fc195ebc7acea48155e1e5862b81e8862902b:120:120",
        "fileName": "1102012181_univ_sqr-120x120.jpg",
        "type": "t",
        "attribute": "r",
        "width": 120,
        "height": 120
      },
      {
        "signature": "604fc195ebc7acea48155e1e5862b81e8862902b:270:270",
        "fileName": "1102012181_univ_sqr-270x270.jpg",
        "type": "t",
        "attribute": "r",
        "width": 270,
        "height": 270
      },
      {
        "signature": "604fc195ebc7acea48155e1e5862b81e8862902b:600:600",
        "fileName": "1102012181_univ_sqr-600x600.jpg",
        "type": "t",
        "attribute": "r",
        "width": 600,
        "height": 600
      },
      {
        "signature": "a401a6f6630483bc33846bd46d320fbfa5215ba9:240:120",
        "fileName": "1102012181_univ_lsr-240x120.jpg",
        "type": "lsr",
        "attribute": "r",
        "width": 240,
        "height": 120
      },
      {
        "signature": "a401a6f6630483bc33846bd46d320fbfa5215ba9:560:280",
        "fileName": "1102012181_univ_lsr-560x280.jpg",
        "type": "lsr",
        "attribute": "r",
        "width": 560,
        "height": 280
      },
      {
        "signature": "a401a6f6630483bc33846bd46d320fbfa5215ba9:1200:600",
        "fileName": "1102012181_univ_lsr-1200x600.jpg",
        "type": "lsr",
        "attribute": "r",
        "width": 1200,
        "height": 600
      }
    ],
    "categories": [
      "brch"
    ],
    "attributes": [],
    "issueAttributes": [],
    "issueProperties": {
      "title": "",
      "undatedTitle": "",
      "coverTitle": "",
      "symbol": "",
      "undatedSymbol": ""
    }
  }
}

/content

After unzipping it we got:

fg_E.jwpub/
├── contents
│   ├── 1102012181_E_cvr.jpg
│   ├── 1102012181_univ_lsr-1200x600.jpg
│   ├── 1102012181_univ_lsr-240x120.jpg
│   ├── 1102012181_univ_lsr-560x280.jpg
│   ├── 1102012181_univ_sqr-120x120.jpg
│   ├── 1102012181_univ_sqr-270x270.jpg
│   ├── 1102012181_univ_sqr-600x600.jpg
│   ├── 1102012181_univ_sqr.jpg
│   ├── 1102012182_E_cnt_2.jpg
│   ├── 1102012182_univ_cnt_1.jpg
│   ├── 1102012182_univ_sqr.jpg
│   ├── 1102012183_univ_cnt_1.jpg
│   ├── 1102012183_univ_sqr.jpg
│   ├── 1102012184_univ_cnt_1.jpg
│   ├── 1102012184_univ_cnt_2.jpg
│   ├── 1102012184_univ_cnt_3.jpg
│   ├── 1102012184_univ_sqr.jpg
│   ├── 1102012185_univ_cnt_1.jpg
│   ├── 1102012185_univ_cnt_2.jpg
│   ├── 1102012185_univ_sqr.jpg
│   ├── 1102012186_univ_cnt_1.jpg
│   ├── 1102012186_univ_cnt_2.jpg
│   ├── 1102012186_univ_sqr.jpg
│   ├── 1102012187_univ_cnt_1.jpg
│   ├── 1102012187_univ_cnt_2.jpg
│   ├── 1102012187_univ_cnt_3.jpg
│   ├── 1102012187_univ_sqr.jpg
│   ├── 1102012188_univ_cnt_1.jpg
│   ├── 1102012188_univ_cnt_2.jpg
│   ├── 1102012188_univ_cnt_3.jpg
│   ├── 1102012188_univ_sqr.jpg
│   ├── 1102012189_univ_cnt_1.jpg
│   ├── 1102012189_univ_cnt_2.jpg
│   ├── 1102012189_univ_cnt_3.jpg
│   ├── 1102012189_univ_sqr.jpg
│   ├── 1102012190_univ_cnt_1.jpg
│   ├── 1102012190_univ_cnt_2.jpg
│   ├── 1102012190_univ_sqr.jpg
│   ├── 1102012191_univ_cnt_1.jpg
│   ├── 1102012191_univ_cnt_2.jpg
│   ├── 1102012191_univ_cnt_3.jpg
│   ├── 1102012191_univ_cnt_4.jpg
│   ├── 1102012191_univ_sqr.jpg
│   ├── 1102012192_univ_cnt_1.jpg
│   ├── 1102012192_univ_cnt_2.jpg
│   ├── 1102012192_univ_cnt_3.jpg
│   ├── 1102012192_univ_sqr.jpg
│   ├── 1102012193_univ_cnt_1.jpg
│   ├── 1102012193_univ_cnt_2.jpg
│   ├── 1102012193_univ_cnt_3.jpg
│   ├── 1102012193_univ_cnt_4.jpg
│   ├── 1102012193_univ_sqr.jpg
│   ├── 1102012194_univ_cnt_1.jpg
│   ├── 1102012194_univ_cnt_2.jpg
│   ├── 1102012194_univ_sqr.jpg
│   ├── 1102012195_univ_cnt_1.jpg
│   ├── 1102012195_univ_cnt_2.jpg
│   ├── 1102012195_univ_sqr.jpg
│   ├── 1102012196_univ_cnt_1.jpg
│   ├── 1102012196_univ_cnt_2.jpg
│   ├── 1102012196_univ_cnt_3.jpg
│   ├── 1102012196_univ_sqr.jpg
│   ├── 1102012198_univ_cnt_1.jpg
│   ├── 1102012198_univ_cnt_2.jpg
│   ├── 1102012198_univ_sqr.jpg
│   ├── 502014331_univ_lsr.jpg
│   ├── 502015752_univ_wsr.jpg
│   ├── 502016852_univ_wsr.jpg
│   ├── 502016853_univ_wsr.jpg
│   ├── 502017850_univ_wsr.jpg
│   ├── 502017855_univ_wsr.jpg
│   ├── 502017858_univ_wsr.jpg
│   ├── 502018850_univ_wsr.jpg
│   ├── 502018853_univ_wsr.jpg
│   ├── 502018856_univ_wsr.jpg
│   └── fg_E.db
├── contents.orig
└── manifest.json

1 directory, 78 files

So a couple of jpegs, and a fg_E.db. I think that we all know how images work, so let's head over to fg_E.db

/contents/fg_E.db

(hidden info in source (a failed attempt))

Document.MepsDocumentId is equal to https://www.jw.org/finder?docid=thispart&prefer=lang&wtlocale=E

$ sqlite3 fg_E.jwpub/contents/fg_E.db "SELECT Content FROM Document WHERE DocumentId=8" | hexdump 0000000 2fda 9755 0aa7 555b 92d4 9bbb a9db f1de 0000010 9daa 35e6 34ea 5170 672a 595e 6444 bdff 0000020 0a22
0000022

wc --bytes returned 32

we also know that ContenLength returned: 7457 And we also know that ParagraphCount is equal to: 20

We also know that: sqlite3 fg_E.jwpub/contents/fg_E.db "SELECT ParagraphCount FROM Document WHERE DocumentId<8"

2 + 12 + 18 + 12 + 10 + 21 + 19 + 19 = 113 so this is the first paragraph.

So following paragraphs are being included:

DocumentParagraphId DocumentId ParagraphIndex ParagraphNumberLabel BeginPosition EndPosition
114 8 1 10 159
115 8 2 161 246
116 8 3 319 398
117 8 4 1 674 1561
118 8 5 2 1563 2067
119 8 6 2 2069 2203
120 8 7 2386 2472
121 8 8 3 2496 2939
122 8 9 4 3172 3658
123 8 10 3713 3795
124 8 11 5 3819 4509
125 8 12 4564 4640
126 8 13 6 4664 5239
127 8 14 7 5241 5928
128 8 15 5983 6072
129 8 16 8 6504 7277
130 8 17 7331 7526
131 8 18
132 8 19 6329 6460
133 8 20

So what do we know from that? No idea.