Newsletter-Werkzeuge

Stand 2026-11-14 (nach #51–#60)
Bezug 2026-11-14_newsletter, newsletter, edwiki_import

Skripte, mit denen die Newsletter aus den Wayback-Kopien (HTML) zu Wiki-Seiten und Import-Paketen werden. Herunterladen: auf den Dateinamen über dem Code klicken.

Ablauf pro Block

  1. HTML-Kopien (Wayback, „Webseite komplett“) je in einen eigenen Ordner; Datumsliste newsletter_index.json (aus der Galnet-France-Liste).
  2. html2wiki.py <datei.html> <NNN> raw → raw/en_NNN.txt (Rohtext) + raw/images_NNN.json (Bilder in Reihenfolge, erstes = Kopfbild = Box-Bild).
  3. Gegenprobe mit dem Forumtext von CMDR Kzak (fehlende Sätze in beide Richtungen).
  4. clean_en.py raw newsletter_index.json en → en/en_NNN.txt: Inhaltsverzeichnis als fette Zeile, Links auf andere Newsletter als …, Einzelkorrekturen in FIXES.
  5. Deutsche Übersetzung von Hand (Claude) nach de/de_NNN.txt – gleiche Bildzeilen und Links wie EN (wird geprüft), Begriffe nach glossar, Drabble-Titel englisch + deutsch in Klammern, Rubrik „Elite Fiction“ → „Elite-Fiction“. Lange Abschnitte, die unverändert bleiben (Buchlisten mit Shop-Links), als Platzhalter @@EN a-b@@ und mit de_fill.py <NNN> aus der EN-Datei übernehmen. Originaltext von Frontier auf Deutsch (z. B. #28) wörtlich übernehmen.
  6. meta.json je Nummer: author, wayback, related (nur vorhandene Seiten), translation.
  7. build_newsletter.py . <von> <bis> → pakete/newsletter_paket_<von>-<bis>_tN.zip (≤ 3,7 MB, CSV im letzten Teil), dazu luecken_*.txt mit defekten Bildern.

Regeln

Skripte

html2wiki.py
#!/usr/bin/env python3
"""Mailchimp-Newsletter (Wayback-Kopie) -> DokuWiki-Rohtext (Englisch) + Bildliste.
 
Aufruf: html2wiki.py <newsletter.html> <nr> <ausgabeordner>
Schreibt <ausgabe>/en_<nr>.txt (Seitenrumpf ohne Rahmen) und <ausgabe>/images_<nr>.json
"""
import json
import os
import re
import sys
import urllib.parse
 
from bs4 import BeautifulSoup, NavigableString, Tag
 
SKIP_IMG = re.compile(r'(social|google|tumblr|like_|cdn-images|facebook|twitter)', re.I)
WAYBACK = re.compile(r'^https?://web\.archive\.org/web/\d+[a-z_]*/', re.I)
MEDIA_NS = 'news:newsletter:{nr}:'
 
 
def clean_name(fname):
    """Wayback-Anhang entfernen, DokuWiki-taugliche Kleinschreibung."""
    base, ext = os.path.splitext(fname)
    base = re.sub(r'_[A-Za-z0-9_-]{4}$', '', base)  # _0oNk, _bV-R, ___O7 usw.
    base = re.sub(r'[^A-Za-z0-9]+', '_', base).strip('_').lower()
    ext = ext.lower().replace('jpeg', 'jpg')
    return base + ext
 
 
def wrap(text, mk):
    """Formatierung je Absatz/Zeile, Leerraum außerhalb der Marker."""
    parts = re.split(r'(\n+)', text)
    res = []
    for p in parts:
        if not p.strip() or p.startswith('\n'):
            res.append(p)
            continue
        lead = p[:len(p) - len(p.lstrip())]
        trail = p[len(p.rstrip()):]
        res.append(lead + mk + p.strip() + mk + trail)
    return ''.join(res)
 
 
def esc(text):
    """Sternchen-Folgen (z. B. Teaser 'the *****') vor DokuWiki schützen."""
    return re.sub(r'(?<!\*)(\*{3,})(?!\*)', r'%%\1%%', text)
 
 
def orig_url(href):
    href = WAYBACK.sub('', href or '')
    return href
 
 
class Conv:
    def __init__(self, path, nr):
        self.path = path
        self.dir = os.path.dirname(path)
        self.nr = nr
        self.out = []          # Liste von Blöcken
        self.inline = []       # laufender Absatz
        self.images = []
        self.seen = set()
 
    # ---------- Ausgabe
    def flush(self):
        txt = ''.join(self.inline)
        txt = re.sub(r'[ \t ]+', ' ', txt)
        txt = re.sub(r' *\n *', '\n', txt).strip()
        # leere Formatierungen entfernen
        prot = re.findall(r'%%.*?%%', txt)
        txt = re.sub(r'%%.*?%%', '\x00', txt)
        txt = txt.strip()
        for pr in prot:
            txt = txt.replace('\x00', pr, 1)
        if txt:
            for para in re.split(r'\n{2,}', txt):
                para = para.strip()
                if para:
                    self.out.append(('p', para.replace('\n', ' \\\\ ')))
        self.inline = []
 
    def add_img(self, img):
        src = urllib.parse.unquote(img.get('src', ''))
        if SKIP_IMG.search(src) or not src:
            return
        local = os.path.join(self.dir, src)
        if not os.path.exists(local):
            local = os.path.join(self.dir, os.path.basename(os.path.dirname(src)), os.path.basename(src))
        name = clean_name(os.path.basename(src))
        if name in self.seen:
            return
        self.seen.add(name)
        try:
            w = int(re.search(r'\d+', img.get('width') or '560').group())
        except Exception:
            w = 560
        link = img.parent.get('href') if img.parent and img.parent.name == 'a' else ''
        self.images.append({'name': name, 'local': local, 'width': w,
                            'orig': orig_url(link) if link and re.search(r'\.(jpe?g|png|gif)', link, re.I) else ''})
        self.flush()
        self.out.append(('img', name, w))
 
    # ---------- Durchlauf
    def walk(self, node, fmt=''):
        for ch in node.children:
            if isinstance(ch, NavigableString):
                if ch.__class__.__name__ == 'Comment':
                    continue
                t = esc(str(ch).replace('\r', '').replace('\n', ' '))
                self.inline.append(t)
                continue
            if not isinstance(ch, Tag):
                continue
            n = ch.name
            if n in ('script', 'style'):
                continue
            if n == 'img':
                self.add_img(ch)
            elif n == 'br':
                self.inline.append('\n')
            elif n in ('h1', 'h2', 'h3', 'h4'):
                self.flush()
                t = re.sub(r'\s+', ' ', ch.get_text()).strip()
                if t:
                    self.out.append(('h', t))
                for im in ch.find_all('img'):
                    self.add_img(im)
            elif n in ('ul', 'ol'):
                self.flush()
                items = []
                for li in ch.find_all('li', recursive=False):
                    sub = Conv(self.path, self.nr)
                    sub.seen = self.seen
                    sub.walk(li)
                    sub.flush()
                    items.append(' '.join(b[1] for b in sub.out if b[0] == 'p'))
                    self.images += sub.images
                self.out.append(('ul' if n == 'ul' else 'ol', items))
            elif n in ('p', 'div', 'td', 'tr', 'table', 'tbody', 'blockquote', 'center'):
                self.flush()
                self.walk(ch)
                self.flush()
            elif n in ('strong', 'b', 'em', 'i'):
                mk = '**' if n in ('strong', 'b') else '//'
                inner = self.sub_inline(ch)
                self.inline.append(wrap(inner, mk))
            elif n == 'a':
                href = ch.get('href', '')
                if ch.find('img'):
                    for im in ch.find_all('img'):
                        self.add_img(im)
                    continue
                text = self.sub_inline(ch)
                if not href or href.startswith('#') or 'return to contents' in text.lower():
                    if 'return to contents' not in text.lower():
                        self.inline.append(text)
                    continue
                url = orig_url(href)
                if url.startswith('mailto:'):
                    self.inline.append(text)
                    continue
                self.inline.append('[[%s|%s]]' % (url, text.strip()) if text.strip() else '')
            else:
                self.walk(ch)
 
    def sub_inline(self, node):
        sub = Conv(self.path, self.nr)
        sub.seen = self.seen
        sub.walk(node)
        self.images += sub.images
        paras = []
        for b in sub.out:  # Bilder in Formatierung
            if b[0] == 'img':
                self.flush()
                self.out.append(b)
            elif b[0] == 'p':
                paras.append(b[1].replace(' \\\\ ', '\n'))
        paras.append(''.join(sub.inline))
        return re.sub(r'[ \t\u00a0]+', ' ', '\n\n'.join(x for x in paras if x.strip()))
 
 
def main():
    path, nr, outdir = sys.argv[1], sys.argv[2], sys.argv[3]
    html = open(path, encoding='utf-8', errors='replace').read()
    html = re.sub(r'<!-- BEGIN WAYBACK TOOLBAR INSERT -->.*?<!-- END WAYBACK TOOLBAR INSERT -->', '', html, flags=re.S)
    soup = BeautifulSoup(html, 'html.parser')
    body = soup.find(id='templateBody') or soup.body
    header = soup.find(id='templateHeader')
    c = Conv(path, nr)
    if header:
        for im in header.find_all('img'):
            c.add_img(im)
    c.walk(body)
    c.flush()
    # Ende abschneiden: "Follow Elite: Dangerous" und alles danach
    blocks = []
    for b in c.out:
        if b[0] == 'h' and re.match(r'follow elite', b[1], re.I):
            break
        blocks.append(b)
    ns = MEDIA_NS.format(nr=nr)
    lines = []
    # Kopfbild (mail_head / erstes Bild im Kopf) nicht in den Text, es ist das Box-Bild
    if blocks and blocks[0][0] == 'img':
        blocks = blocks[1:]
    grouped = []
    for b in blocks:
        if b[0] == 'img' and b[2] < 500 and grouped and grouped[-1][0] == 'imgs':
            grouped[-1][1].append(b)
        elif b[0] == 'img' and b[2] < 500:
            grouped.append(('imgs', [b]))
        else:
            grouped.append(b)
    blocks = grouped
    for b in blocks:
        if b[0] == 'imgs':
            lines.append(' '.join('{{%s%s?%d|}}' % (ns, i[1], i[2]) for i in b[1]) + '\n')
            continue
        if b[0] == 'p':
            lines.append(b[1] + '\n')
        elif b[0] == 'h':
            lines.append('===== %s =====\n' % b[1])
        elif b[0] == 'img':
            lines.append('{{%s%s?%d|}}\n' % (ns, b[1], min(b[2], 560)))
        elif b[0] in ('ul', 'ol'):
            mark = '*' if b[0] == 'ul' else '-'
            lines.append('\n'.join('  %s %s' % (mark, i) for i in b[1]) + '\n')
    os.makedirs(outdir, exist_ok=True)
    open(os.path.join(outdir, 'en_%s.txt' % nr), 'w').write('\n'.join(lines))
    json.dump(c.images, open(os.path.join(outdir, 'images_%s.json' % nr), 'w'), indent=1)
 
 
if __name__ == '__main__':
    main()
clean_en.py
#!/usr/bin/env python3
"""Rohtext (html2wiki) -> bereinigter englischer Seitenrumpf.
 
- Inhaltsverzeichnis: Überschrift -> fette Zeile, ohne "Follow Elite: Dangerous", Banner bleibt
- Links auf andere Newsletter (Mailchimp-IDs) -> interne Links
- E-Mail-Adressen nicht fett, kleine Leerzeichen-/Satzzeichenfehler
- gezielte Einzelkorrekturen (FIXES)
Aufruf: clean_en.py <raw-ordner> <index.json> <ausgabe-ordner>
"""
import json
import os
import re
import sys
 
FIXES = {
    '026': [("//''A new sighting", "//'A new sighting")],
    '015': [('**[[http://elite.frontier.co.uk/|http://elite.frontier.co.u]]k**', '**[[http://elite.frontier.co.uk/|http://elite.frontier.co.uk]]**'),
            ('**Engines**//: "When', '**Engines:** //"When')],
    '002': [('but**[[', 'but **[['), (']]**to check', ']]** to check')],
    '003': [('**[[http://i1305.photobucket.com/albums/s553/FrontierAshley/EmpireshipsketchesCropped_zpsc19947fb.jpg|smaller Imperial Ships]]**',
             '**[[NL:002|smaller Imperial Ships]]**')],
    '004': [('**[[http://s1305.photobucket.com/user/FrontierAshley/media/FedandEmpirefighters_zps35212663.jpg.html|early concept thumbnails]]**',
             '**[[NL:001|early concept thumbnails]]**'),
            ('\nShield Systems:\n', '\n**Shield Systems:**\n')],
    '007': [('&e=[UNIQID]', '')],
    '008': [(' \\\\ --- \\\\ This week’s drabble', '\n\n===== Elite Fiction: Childish Dreams =====\n\nThis week’s drabble'),
            ('**[[http://www.laveradio.com/|their site]]**now', '**[[http://www.laveradio.com/|their site]]** now')],
    '009': [('**“**"We don\'t need the whole universe, just the Milky Way." Where to start?',
             '“We don\'t need the whole universe, just the Milky Way.” Where to start?'),
            ('ring system(s). **”**', 'ring system(s).'),
            ('\n- Elsewhere in the Elite galaxy', '\nElsewhere in the Elite galaxy')],
    # Fußnotensternchen, kein Fettdruck
    '039': [('****LHS 417:Gernhardt Camp****', '%%**%%LHS 417:Gernhardt Camp%%**%%'),
            ('** New market to watch**', '%%**%% New market to watch')],
    # Im Original wurde der ganze Satz als Linkadresse eingetragen
    '048': [('[[http://caiburn%20told%20a%20touching%20tale%20about%20his%20late%20father%20on%20the%20frontier%20forums%20%E2%80%93%20the%20warm%20response%20to%20his%20story%20can%20be%20seen%20in%20the%20complete%20thread%20-%20https//forums.frontier.co.uk/showthread.php?t=54588&highlight=screen|',
             '[[https://forums.frontier.co.uk/showthread.php?t=54588|')],
    '049': [('|become a]]**[[', '|become a]] **[[')],
    '052': [('|listed as a produc**t**]]', '|listed as a product]]')],
    '057': [('"f**ck you"', '"f%%**%%ck you"')],
}
 
 
# nr -> [(Anfang, Ende)] – Bereich, in dem alle ** entfernt werden
UNBOLD = {
    '034': [('**GalNet News Transmission 1', 'hard-earned credits.**')],
}
 
 
def main():
    rawdir, index, outdir = sys.argv[1:4]
    idx = json.load(open(index))
    by_id = {}
    for r in idx:
        m = re.search(r'id=([0-9a-f]{10})', r['url'])
        if m and re.fullmatch(r'\d+(\.\d)?', r['nr']):
            # Sonderausgaben wie #51.5 heißen 051_5
            whole, _, frac = r['nr'].partition('.')
            by_id.setdefault(m.group(1), '%03d' % int(whole) + ('_' + frac if frac else ''))
    os.makedirs(outdir, exist_ok=True)
    for fn in sorted(os.listdir(rawdir)):
        m = re.match(r'en_(\d{3}(?:_\d)?)\.txt$', fn)
        if not m:
            continue
        nr = m.group(1)
        t = open(os.path.join(rawdir, fn)).read()
        # Inhaltsverzeichnis
        t = re.sub(r'===== Table of Contents[^=]*=====', '**Contents:**', t)
        t = re.sub(r'\n  \* (\*\*)?Follow Elite: Dangerous(\*\*)?\n', '\n', t)
        # persönliche Anrede aus dem Mailchimp-Seriendruck (Name des Abonnenten) neutralisieren
        t = re.sub(r'^Hi (?!Commander)[^,\n]{1,40},', 'Hi Commander,', t)
        t = re.sub(r'^===== return to contents =====\n', '', t, flags=re.M | re.I)
        t = re.sub(r'^(back to contents|return to contents)\s*\n', '', t, flags=re.M | re.I)
        t = re.sub(r'^\{\{[^}]*transparent[^}]*\}\}\n', '', t, flags=re.M)  # Platzhalter-GIF
        # zwei aufeinanderfolgende Links mit gleichem Ziel zusammenfassen
        # (ohne Leerzeichen, wenn ein Wort mitten im Link getrennt wurde: „S“+„leepless…“)
        def join_links(m):
            a, b = m.group(2).strip(), m.group(3).strip()
            sep = '' if re.search(r'[A-Za-z]$', a) and re.match(r'[a-z]', b) else ' '
            return '[[%s|%s%s%s]]' % (m.group(1), a, sep, b)
        pat = r'\[\[([^|\]]+)\|([^\]]*)\]\]\[\[\1\|([^\]]*)\]\]'
        while re.search(pat, t):
            t = re.sub(pat, join_links, t)
        # Werbe-Parameter (utm_…) aus Links entfernen
        t = re.sub(r'[?&]utm_[^|\]]*?(?=[|\]])', '', t)
        t = re.sub(r'&e=[0-9a-f]{6,}', '', t)  # Abonnenten-Kennung
        t = re.sub(r'[?&]_ga=[\d.]+(?=[|\]])', '', t)  # Google-Analytics-Kennung
        t = t.replace('%E2%80%8B', '')  # unsichtbares Leerzeichen (Zero Width Space) in Linkadressen
        # Einzelkorrekturen
        for a, b in FIXES.get(nr, []):
            assert a in t, (nr, a[:60])
            t = t.replace(a, b)
        # Abschnitte, die im Original komplett fett und in Stücke zerlegt sind: Fettung entfernen
        for start, end in UNBOLD.get(nr, []):
            i = t.index(start); j = t.index(end, i) + len(end)
            t = t[:i] + t[i:j].replace('**', '') + t[j:]
        # Links auf andere Newsletter
 
        def nl_link(mm):
            url, text = mm.group(1), mm.group(2)
            i = re.search(r'id=([0-9a-f]{10})', url)
            if i and i.group(1) in by_id:
                target = by_id[i.group(1)]
                if target != nr:
                    return '[[NL:%s|%s]]' % (target, text)
            return mm.group(0)
        t = re.sub(r'\[\[https?://us2\.campaign-archive\d?\.com/home/[^|\]]*\|', '[[NL:start|', t)
        t = re.sub(r'\[\[(https?://us2\.campaign-archive[^|\]]*)\|([^\]]*)\]\]', nl_link, t)
        # Fettung um Links mit eigener Fettung: [[url|**x**]] -> **[[url|x]]**
        t = re.sub(r'\[\[([^|\]]+)\|\*\*([^\]]*?)\*\*\]\]', r'**[[\1|\2]]**', t)
        # E-Mail-Adresse nicht fett
        t = re.sub(r'\*\*([\w.]+@frontier\.co\.uk)\*\*', r'\1', t)
        t = re.sub(r' +([.,!?])', r'\1', t)
        t = re.sub(r'\]\]\*\*(?=[A-Za-z])', ']]** ', t)
        t = re.sub(r'(?<=[A-Za-z])\*\*\[\[', ' **[[', t)
        t = re.sub(r'\]\](?=[A-Za-z])', ']] ', t)
        t = re.sub(r'(?<=[a-z])\[\[(?=https?:)', ' [[', t)
        # „>“ am Zeilenanfang wäre in DokuWiki ein Zitat
        t = re.sub(r'^>', '%%>%%', t, flags=re.M)
        t = re.sub(r'^If you do not wish to receive any more.*\n', '', t, flags=re.M)
        t = re.sub(r'\n{3,}', '\n\n', t).strip() + '\n'
        open(os.path.join(outdir, 'en_%s.txt' % nr), 'w').write(t)
 
 
if __name__ == '__main__':
    main()
de_fill.py
#!/usr/bin/env python3
"""Hilfsskript beim Übersetzen: lange Linkblöcke aus dem englischen Text übernehmen.
 
Im deutschen Entwurf steht eine Zeile  @@EN <von>-<bis>@@  (Zeilennummern der EN-Datei).
Sie wird durch diese EN-Zeilen ersetzt, wobei feste Wendungen übersetzt werden (REPL).
Aufruf: de_fill.py <en_NNN.txt> <de_NNN.txt>   (überschreibt de_NNN.txt)
"""
import re
import sys
 
REPL = [
    ('**eBook preorder:**', '**E-Book vorbestellen:**'),
    ('**Hardback preorder:**', '**Gebundene Ausgabe vorbestellen:**'),
    ('**Paperback preorder:**', '**Taschenbuch vorbestellen:**'),
    ('Hive UK – support your local bookshop!', 'Hive UK – unterstützt eure Buchhandlung vor Ort!'),
    ('**, by ', '**, von '),
    ('**, by', '**, von'),
]
 
 
def main():
    en = open(sys.argv[1]).read().split('\n')
    de = open(sys.argv[2]).read()
 
    def sub(m):
        a, b = int(m.group(1)), int(m.group(2))
        block = '\n'.join(en[a - 1:b])
        for x, y in REPL:
            block = block.replace(x, y)
        return block
    de = re.sub(r'^@@EN (\d+)-(\d+)@@$', sub, de, flags=re.M)
    open(sys.argv[2], 'w').write(de)
 
 
if __name__ == '__main__':
    main()
build_newsletter.py
#!/usr/bin/env python3
"""Newsletter-Paket für edwiki-import.php bauen.
 
Eingaben (Arbeitsordner):
  en/en_NNN.txt          bereinigter englischer Rumpf (clean_en.py)
  de/de_NNN.txt          deutsche Übersetzung (Claude)
  raw/images_NNN.json    Bildliste (html2wiki.py)
  newsletter_index.json  Nummer, Datum, Original-Link (galnet.fr-Liste)
  meta.json              je Nummer: author, wayback, related, translation
 
Ausgabe: build/pages/..., build/media/..., build/newsletter_NNN-NNN.csv,
         pakete/newsletter_paket_<von>-<bis>_tN.zip (je <= 3,7 MB, CSV im letzten Teil)
Aufruf:  build_newsletter.py <arbeitsordner> <von> <bis>
"""
import csv
import io
import json
import os
import re
import shutil
import sys
import zipfile
 
from PIL import Image
 
MAXPX = 1920
ZIPMAX = 3_700_000
KI_NOTE = '//Übersetzung aus dem Englischen: Claude, ungeprüft.//'
LANGS = {'de': 'news:newsletter', 'en': 'en:news:newsletter'}
 
 
def frame(title, body, footer):
    return f"""[<>]
 
<WRAP centeralign>
====== {title} ======
</WRAP>
 
----
 
<WRAP group>
<WRAP twothirds column box round>
{body.strip()}
 
{footer}
</WRAP>
 
<WRAP third column box round>
{{{{structbox>newsletter}}}}
</WRAP>
</WRAP>
 
----
 
[<>]
"""
 
 
def de_date(iso):
    y, m, d = iso.split('-')
    return f'{d}.{m}.{y}'
 
 
def links(text, lang):
    ns = LANGS[lang]
    text = text.replace('[[NL:start|', '[[news:newsletter:start|')  # Übersicht gibt es nur auf Deutsch
    return re.sub(r'\[\[NL:(\d{3}(?:_\d)?)\|', lambda m: f'[[{ns}:{m.group(1)}|', text)
 
 
def save_image(src, dst):
    try:
        Image.open(src).verify()
    except Exception:
        return 'FEHLT (Wayback-Kopie defekt)'
    os.makedirs(os.path.dirname(dst), exist_ok=True)
    ext = os.path.splitext(dst)[1]
    if ext == '.jpg':
        im = Image.open(src)
        if max(im.size) > MAXPX:
            im.thumbnail((MAXPX, MAXPX), Image.LANCZOS)
            im.convert('RGB').save(dst, 'JPEG', quality=88, optimize=True)
            return 'verkleinert'
    shutil.copyfile(src, dst)
    return ''
 
 
def main():
    work, a, b = sys.argv[1], int(sys.argv[2]), int(sys.argv[3])
    idx = {r['nr']: r for r in json.load(open(os.path.join(work, 'newsletter_index.json')))}
    meta = json.load(open(os.path.join(work, 'meta.json')))
    build = os.path.join(work, 'build')
    shutil.rmtree(build, ignore_errors=True)
    rows, report, gaps = [], [], []
    # Nummern im Bereich, dazu Sonderausgaben wie 051_5 (#51.5) direkt nach ihrer Hauptnummer
    nrs = []
    for k in range(a, b + 1):
        nrs.append('%03d' % k)
        nrs += sorted(x for x in meta if x.startswith('%03d_' % k))
    for nr in nrs:
        whole, _, frac = nr.partition('_')
        n = str(int(whole)) + ('.' + frac if frac else '')   # Anzeige: 51 bzw. 51.5
        info, m = idx[n], meta[nr]
        date = info['date']
        title = f'Elite: Dangerous Newsletter #{n}'
        src = f'//Quelle: Frontier Developments, {title}, {de_date(date)}//'
        de = links(open(os.path.join(work, 'de', f'de_{nr}.txt')).read(), 'de')
        en = links(open(os.path.join(work, 'en', f'en_{nr}.txt')).read(), 'en')
        pages = {
            f'pages/news/newsletter/{nr}.txt': frame(title, de, KI_NOTE + ' \\\\\n' + src),
            f'pages/en/news/newsletter/{nr}.txt': frame(title, en,
                f'//Source: Frontier Developments, {title}, {date}//'),
        }
        for p, t in pages.items():
            os.makedirs(os.path.dirname(os.path.join(build, p)), exist_ok=True)
            open(os.path.join(build, p), 'w').write(t)
        # Bilder: alle, die im Text vorkommen + Kopfbild (Box)
        used = set(re.findall(r'\{\{news:newsletter:%s:([^?|}]+)' % nr, de))
        imgs = json.load(open(os.path.join(work, 'raw', f'images_{nr}.json')))
        head = imgs[0]['name']
        if m.get('header_local'):  # Wayback hat ein falsches Kopfbild geliefert (gleicher Dateiname bei Mailchimp)
            imgs[0]['local'] = m['header_local']
            report.append(f'#{n} Kopfbild ersetzt durch {os.path.basename(m["header_local"])}')
        for im in imgs:
            if im['name'] in used or im['name'] == head:
                note = save_image(im['local'], os.path.join(build, 'media/news/newsletter', nr, im['name']))
                if note.startswith('FEHLT'):
                    gaps.append(f'#{n}\tnews:newsletter:{nr}:{im["name"]}\t{im["orig"] or "-"}')
                elif note:
                    report.append(f'#{n} {im["name"]}: {note} auf {MAXPX} px')
        missing = used - {i['name'] for i in imgs}
        if missing:
            report.append(f'#{n} FEHLENDE BILDER: {sorted(missing)}')
        rows.append({
            'pid': f'news:newsletter:{nr}',
            'number': str(n),
            'date': date,
            'picture': f'news:newsletter:{nr}:{head}',
            'author': m['author'],
            'url': re.sub(r'&e=[^&]*', '', info['url']),  # Abonnenten-Kennung entfernen
            'archive': m['wayback'],
            'translation': m.get('translation', 'KI'),
            'relations.related': ','.join(m.get('related', [])),
        })
    # feste Seiten (Übersicht, Vorlage, news:start, Sidebar): static/pages/... 1:1 übernehmen
    shutil.copytree(os.path.join(work, 'static', 'pages'), os.path.join(build, 'pages'), dirs_exist_ok=True)
    if gaps:
        open(os.path.join(build, f'luecken_newsletter_{a:03d}-{b:03d}.txt'), 'w').write(
            'Nr\tfehlendes Bild (Medien-ID)\tOriginal (über Wayback suchen)\n' + '\n'.join(gaps) + '\n')
        report.append(f'{len(gaps)} Bilder fehlen, siehe luecken_newsletter_{a:03d}-{b:03d}.txt')
    csvname = f'newsletter_{a:03d}-{b:03d}.csv'
    with open(os.path.join(build, csvname), 'w', newline='') as fh:
        w = csv.DictWriter(fh, fieldnames=list(rows[0]))
        w.writeheader()
        w.writerows(rows)
    # Pakete
    files = []
    for root, _, fs in os.walk(build):
        for f in sorted(fs):
            full = os.path.join(root, f)
            rel = os.path.relpath(full, build)
            if rel.endswith('.csv'):
                continue
            files.append((rel, full))
    files.sort()
    outdir = os.path.join(work, 'pakete')
    shutil.rmtree(outdir, ignore_errors=True)
    os.makedirs(outdir)
    parts, cur, size = [], [], 0
    for rel, full in files:
        s = os.path.getsize(full) + 200 + len(rel) * 2
        if cur and size + s > ZIPMAX:
            parts.append(cur)
            cur, size = [], 0
        cur.append((rel, full))
        size += s
    cur.append((csvname, os.path.join(build, csvname)))
    parts.append(cur)
    for i, part in enumerate(parts, 1):
        zn = os.path.join(outdir, f'newsletter_paket_{a:03d}-{b:03d}_t{i}.zip')
        with zipfile.ZipFile(zn, 'w', zipfile.ZIP_DEFLATED) as z:
            for rel, full in part:
                z.write(full, rel)
        report.append(f'{os.path.basename(zn)}: {len(part)} Dateien, {os.path.getsize(zn) / 1e6:.2f} MB')
    print('\n'.join(report))
 
 
if __name__ == '__main__':
    main()

Metadaten

meta.json
{
 "001": {
  "author": "Michael Brookes",
  "wayback": "https://web.archive.org/web/20190316200753/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=bafc8227dd",
  "related": [
   "hangar:ships:sidewinder",
   "codex:federal:start",
   "codex:imperial:start"
  ],
  "translation": "KI"
 },
 "002": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20150408094846/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=b5519ec0fe",
  "related": [
   "hangar:ships:sidewinder",
   "hangar:ships:anaconda",
   "codex:imperial:start",
   "codex:federal:start",
   "galaxy:systems:lave"
  ],
  "translation": "KI"
 },
 "003": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20170901205441/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=7b8136bd4a",
  "related": [
   "hangar:ships:sidewinder",
   "codex:imperial:start",
   "codex:federal:start"
  ],
  "translation": "KI"
 },
 "004": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20201112042442/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=d266df1c3b",
  "related": [
   "hangar:ships:sidewinder",
   "hangar:ships:cobra_mk3",
   "codex:federal:start",
   "galaxy:systems:lave"
  ],
  "translation": "KI"
 },
 "005": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20151104160412/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=a4bd777a7f",
  "related": [
   "codex:imperial:start",
   "codex:federal:start",
   "codex:corporations:lakon_spaceways",
   "codex:corporations:saud_kruger",
   "codex:corporations:gutamaya",
   "codex:corporations:core_dynamics"
  ],
  "translation": "KI"
 },
 "006": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20151104144759/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=94dad3b09c",
  "related": [
   "hangar:ships:eagle",
   "hangar:ships:adder",
   "hangar:ships:asp_explorer"
  ],
  "translation": "KI"
 },
 "007": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20151104144817/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=c0b11fe947",
  "related": [
   "hangar:ships:imperial_courier",
   "hangar:ships:imperial_cutter",
   "codex:imperial:start"
  ],
  "translation": "KI"
 },
 "008": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20150130055157/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=b3760cf65e",
  "related": [
   "hangar:ships:sidewinder",
   "hangar:ships:anaconda",
   "codex:federal:start",
   "codex:imperial:start",
   "codex:alliance:start"
  ],
  "translation": "KI"
 },
 "009": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20140901000640/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ffe2385d13",
  "related": [
   "codex:federal:start",
   "codex:imperial:start",
   "codex:alliance:start",
   "codex:misc:pilotenvereinigung",
   "galaxy:systems:sol",
   "galaxy:systems:achenar",
   "galaxy:systems:alioth"
  ],
  "translation": "KI"
 },
 "010": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20140901000639/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ee59a3bb5e",
  "related": [
   "hangar:ships:dolphin",
   "hangar:ships:orca",
   "codex:corporations:gutamaya"
  ],
  "translation": "KI"
 },
 "011": {
  "author": "Ashley Barley",
  "wayback": "https://web.archive.org/web/20140723125234/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=7157d0e3e1",
  "related": [
   "hangar:ships:cobra_mk3",
   "codex:federal:start"
  ],
  "translation": "KI"
 },
 "012": {
  "author": "",
  "wayback": "https://web.archive.org/web/20190316185013/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=d6ef3ab726",
  "related": [],
  "translation": "KI",
  "header_local": "/home/claude/nl2_in/Elite_Dangerous Newsletter #017_files/mail_head_copy_jWHE.JPG",
  "header_note": "Wayback-Kopien von #12 und #17 haben die Kopfbilder vertauscht (Mailchimp-Dateiname mail_head_copy.jpg doppelt)"
 },
 "013": {
  "author": "",
  "wayback": "https://web.archive.org/web/20150130220838/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=94e38570c6",
  "related": [],
  "translation": "KI"
 },
 "014": {
  "author": "",
  "wayback": "https://web.archive.org/web/20140901000640/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=f703580f39",
  "related": [
   "hangar:ships:sidewinder",
   "codex:corporations:remlok"
  ],
  "translation": "KI"
 },
 "015": {
  "author": "",
  "wayback": "https://web.archive.org/web/20140901000556/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=4075b302f4",
  "related": [
   "hangar:ships:sidewinder",
   "hangar:ships:anaconda",
   "hangar:ships:cobra_mk3"
  ],
  "translation": "KI"
 },
 "016": {
  "author": "",
  "wayback": "https://web.archive.org/web/20170901201148/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=7d88ceec82",
  "related": [
   "hangar:ships:anaconda",
   "hangar:ships:sidewinder",
   "codex:federal:start"
  ],
  "translation": "KI"
 },
 "017": {
  "author": "Michael Brookes, Mark Boss",
  "wayback": "https://web.archive.org/web/20150131230822/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=f9f6f99d01",
  "related": [
   "codex:corporations:sirius_corporation"
  ],
  "translation": "KI",
  "header_local": "/home/claude/nl2_in/Elite_Dangerous Newsletter #012_files/mail_head_copy_vJtR.jpg",
  "header_note": "Wayback-Kopien von #12 und #17 haben die Kopfbilder vertauscht (Mailchimp-Dateiname mail_head_copy.jpg doppelt)"
 },
 "018": {
  "author": "",
  "wayback": "https://web.archive.org/web/20140806215529/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=89b597852e",
  "related": [
   "hangar:ships:cobra_mk3",
   "hangar:ships:sidewinder",
   "hangar:ships:python",
   "codex:corporations:faulcon_delacy"
  ],
  "translation": "KI"
 },
 "019": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140901000600/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=d6f301a16e",
  "related": [
   "hangar:ships:cobra_mk3",
   "hangar:ships:eagle",
   "hangar:ships:sidewinder",
   "codex:misc:pilotenvereinigung",
   "galaxy:systems:sol",
   "galaxy:systems:achenar",
   "galaxy:systems:alioth"
  ],
  "translation": "KI"
 },
 "020": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140901000638/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ee05d74c71",
  "related": [
   "hangar:ships:imperial_courier",
   "hangar:ships:sidewinder",
   "codex:federal:start",
   "codex:imperial:start",
   "codex:alliance:start"
  ],
  "translation": "KI"
 },
 "021": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140530044854/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=cfcdbae60e",
  "related": [
   "hangar:ships:cobra_mk3",
   "hangar:ships:sidewinder",
   "galaxy:systems:sol"
  ],
  "translation": "KI"
 },
 "022": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170617133847/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=f72c0f91b2",
  "related": [
   "codex:misc:pilotenvereinigung",
   "codex:misc:dark_wheel",
   "codex:imperial:start",
   "codex:federal:start",
   "codex:alliance:start"
  ],
  "translation": "KI"
 },
 "023": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20141023233129/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=d9e6b2724b",
  "related": [
   "codex:misc:genship",
   "hangar:ships:sidewinder",
   "hangar:ships:eagle",
   "hangar:ships:cobra_mk3"
  ],
  "translation": "KI"
 },
 "024": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901194626/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=f3f6656d39",
  "related": [
   "hangar:ships:type-9_heavy",
   "hangar:ships:anaconda",
   "hangar:ships:eagle",
   "codex:corporations:core_dynamics",
   "codex:corporations:lakon_spaceways"
  ],
  "translation": "KI"
 },
 "025": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140901000557/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ae4c732e15",
  "related": [
   "hangar:ships:anaconda",
   "hangar:ships:cobra_mk3",
   "hangar:ships:type-9_heavy"
  ],
  "translation": "KI"
 },
 "026": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150128145308/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=4a0814bda4",
  "related": [
   "hangar:ships:cobra_mk3",
   "codex:imperial:start"
  ],
  "translation": "KI"
 },
 "027": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20190316200749/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=0b43285619",
  "related": [
   "hangar:ships:type-9_heavy",
   "hangar:ships:cobra_mk3"
  ],
  "translation": "KI"
 },
 "028": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901185021/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=09a3391149",
  "related": [
   "hangar:ships:hauler",
   "codex:corporations:zorgon_peterson",
   "hangar:ships:sidewinder",
   "hangar:ships:anaconda"
  ],
  "translation": "KI"
 },
 "029": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140806221722/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=1824c0b05a",
  "related": [
   "hangar:ships:hauler",
   "codex:corporations:zorgon_peterson",
   "hangar:ships:sidewinder"
  ],
  "translation": "KI"
 },
 "030": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150129140201/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ddf8da5f8b",
  "related": [
   "codex:misc:pilotenvereinigung",
   "hangar:ships:hauler",
   "codex:corporations:zorgon_peterson",
   "hangar:ships:cobra_mk3",
   "codex:federal:start"
  ],
  "translation": "KI"
 },
 "031": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20201112043317/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ecf2198bb5",
  "related": [
   "codex:misc:pilotenvereinigung",
   "hangar:ships:cobra_mk3",
   "hangar:ships:eagle",
   "hangar:ships:hauler",
   "codex:corporations:zorgon_peterson",
   "codex:corporations:core_dynamics",
   "galaxy:systems:i_bootis",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "032": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150131194535/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ac1081437f",
  "related": [
   "codex:misc:pilotenvereinigung",
   "hangar:ships:cobra_mk3",
   "hangar:ships:eagle",
   "hangar:ships:hauler",
   "codex:corporations:zorgon_peterson",
   "codex:corporations:faulcon_delacy",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "033": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20200410145501/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=c5e7202cb7",
  "related": [
   "hangar:ships:type-6_transporter",
   "codex:corporations:lakon_spaceways",
   "hangar:ships:sidewinder",
   "hangar:ships:eagle",
   "hangar:ships:type-9_heavy",
   "hangar:ships:hauler",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "034": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20141029064757/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=8b7e3f3ba9",
  "related": [
   "hangar:ships:viper_mk3",
   "hangar:ships:type-6_transporter",
   "hangar:ships:sidewinder",
   "hangar:ships:cobra_mk3",
   "codex:corporations:faulcon_delacy",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "035": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140901000634/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=2da6569754",
  "related": [
   "hangar:ships:hauler",
   "hangar:ships:viper_mk3",
   "hangar:ships:anaconda",
   "hangar:ships:type-6_transporter",
   "hangar:ships:type-9_heavy",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "036": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140901000635/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=76df98203b",
  "related": [
   "galaxy:systems:i_bootis",
   "hangar:ships:hauler",
   "hangar:ships:anaconda",
   "hangar:ships:type-6_transporter",
   "codex:corporations:faulcon_delacy",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "037": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150131210629/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=c695f8c0ad",
  "related": [
   "galaxy:systems:lave",
   "hangar:ships:anaconda",
   "hangar:ships:hauler",
   "hangar:ships:type-6_transporter",
   "hangar:ships:type-9_heavy",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "038": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20140904114135/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=a6f83ce7d1",
  "related": [
   "codex:corporations:gutamaya",
   "codex:misc:dark_wheel",
   "hangar:ships:viper_mk3",
   "hangar:ships:hauler",
   "codex:imperial:start",
   "codex:federal:start"
  ],
  "translation": "KI"
 },
 "039": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20141029065252/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=aa530da9ec",
  "related": [
   "hangar:ships:sidewinder",
   "hangar:ships:viper_mk3",
   "hangar:ships:anaconda",
   "hangar:ships:hauler",
   "codex:federal:start",
   "codex:imperial:start"
  ],
  "translation": "KI"
 },
 "040": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20141029064917/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=cbbe7b15e6",
  "related": [
   "hangar:ships:eagle",
   "hangar:ships:asp_explorer",
   "hangar:ships:viper_mk3",
   "hangar:ships:imperial_courier",
   "hangar:ships:cobra_mk3",
   "hangar:ships:hauler",
   "codex:corporations:core_dynamics",
   "codex:misc:pilotenvereinigung"
  ],
  "translation": "KI"
 },
 "041": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20181005141620/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=e676783725",
  "related": [
   "hangar:ships:asp_explorer",
   "hangar:ships:imperial_courier",
   "hangar:ships:cobra_mk3",
   "codex:corporations:faulcon_delacy",
   "codex:corporations:core_dynamics",
   "codex:corporations:lakon_spaceways",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "042": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901192004/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=c02ce26b9b",
  "related": [
   "codex:person:denton_patreus",
   "codex:corporations:manticore",
   "hangar:ships:asp_explorer",
   "hangar:ships:cobra_mk3",
   "codex:corporations:faulcon_delacy",
   "codex:federal:start",
   "codex:alliance:start",
   "codex:misc:pilotenvereinigung",
   "codex:corporations:bank_of_zaonce"
  ],
  "translation": "KI"
 },
 "043": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901204555/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=396ec1dd05",
  "related": [
   "hangar:ships:asp_explorer",
   "galaxy:systems:i_bootis"
  ],
  "translation": "KI"
 },
 "044": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901204535/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=763bb19c70",
  "related": [
   "hangar:ships:cobra_mk3",
   "hangar:ships:anaconda",
   "hangar:ships:eagle",
   "hangar:ships:asp_explorer",
   "hangar:ships:type-9_heavy"
  ],
  "translation": "KI"
 },
 "045": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150128140009/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=fdacb0a6c0",
  "related": [
   "hangar:ships:cobra_mk3",
   "hangar:ships:viper_mk3",
   "hangar:ships:anaconda",
   "hangar:ships:sidewinder",
   "hangar:ships:eagle"
  ],
  "translation": "KI"
 },
 "046": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901190924/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=73dca87078",
  "related": [
   "hangar:ships:sidewinder",
   "hangar:ships:eagle",
   "hangar:ships:fer-de-lance"
  ],
  "translation": "KI"
 },
 "047": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901200659/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=ed3d21f568",
  "related": [
   "hangar:ships:imperial_clipper",
   "hangar:ships:federal_dropship",
   "hangar:ships:hauler",
   "hangar:ships:viper_mk3",
   "galaxy:systems:sol",
   "codex:federal:start",
   "codex:imperial:start"
  ],
  "translation": "KI"
 },
 "048": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150308145833/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=721f168fd0",
  "related": [
   "hangar:ships:hauler",
   "hangar:ships:sidewinder"
  ],
  "translation": "KI"
 },
 "049": {
  "author": "Frontier-Team, David Braben",
  "wayback": "https://web.archive.org/web/20150204053547/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=cea4f4cd56",
  "related": [
   "hangar:ships:hauler"
  ],
  "translation": "KI"
 },
 "050": {
  "author": "Frontier-Team, David Braben",
  "wayback": "https://web.archive.org/web/20151104145039/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=6b99a1d038",
  "related": [
   "codex:person:hengist_duval",
   "codex:federal:start",
   "codex:imperial:start",
   "codex:alliance:start",
   "galaxy:systems:sol"
  ],
  "translation": "KI"
 },
 "051": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20181126013651/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=3e8912d873",
  "related": [
   "codex:person:hengist_duval",
   "codex:imperial:start",
   "galaxy:systems:sol",
   "hangar:ships:cobra_mk3",
   "hangar:ships:viper_mk3"
  ],
  "translation": "KI"
 },
 "051_5": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901204057/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=91dae42e83",
  "related": [
   "hangar:ships:viper_mk3",
   "hangar:ships:cobra_mk3"
  ],
  "translation": "KI"
 },
 "052": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20150128110933/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=560d50221f",
  "related": [
   "codex:person:hengist_duval",
   "codex:person:denton_patreus",
   "codex:person:zemina_torval",
   "codex:imperial:start",
   "codex:federal:start",
   "codex:alliance:start"
  ],
  "translation": "KI"
 },
 "053": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20190316200747/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=8c803c1c03",
  "related": [
   "hangar:ships:adder",
   "hangar:ships:type-7_transporter",
   "codex:corporations:zorgon_peterson",
   "codex:corporations:lakon_spaceways",
   "codex:person:zemina_torval",
   "codex:person:denton_patreus",
   "codex:person:jasmina_halsey",
   "codex:person:zachary_hudson"
  ],
  "translation": "KI"
 },
 "054": {
  "author": "Frontier-Team, David Braben",
  "wayback": "https://web.archive.org/web/20170901192707/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=e4d0ac038a",
  "related": [
   "codex:person:zemina_torval",
   "codex:person:denton_patreus",
   "codex:person:jasmina_halsey",
   "codex:corporations:mastopolos_mining"
  ],
  "translation": "KI"
 },
 "055": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20190316200752/https://us2.campaign-archive.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=75583e8064",
  "related": [
   "codex:person:zemina_torval",
   "codex:person:denton_patreus",
   "codex:person:hengist_duval",
   "codex:person:arissa_lavigny-duval",
   "codex:person:jasmina_halsey",
   "codex:corporations:mastopolos_mining"
  ],
  "translation": "KI"
 },
 "056": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901185420/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=2676b3e890",
  "related": [
   "codex:person:arissa_lavigny-duval",
   "codex:person:aisling_duval",
   "codex:person:zemina_torval",
   "codex:person:denton_patreus",
   "codex:person:jasmina_halsey",
   "codex:person:zachary_hudson",
   "hangar:ships:cobra_mk3"
  ],
  "translation": "KI"
 },
 "057": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20171018002227/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=2bd451e951",
  "related": [
   "hangar:ships:fer-de-lance",
   "codex:person:denton_patreus",
   "codex:person:zemina_torval",
   "codex:person:jasmina_halsey",
   "codex:person:zachary_hudson"
  ],
  "translation": "KI"
 },
 "058": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20151104153537/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=63075a3a4e",
  "related": [
   "codex:person:zemina_torval",
   "galaxy:systems:sol",
   "hangar:ships:cobra_mk3"
  ],
  "translation": "KI"
 },
 "059": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20170901195108/http://us2.campaign-archive1.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=f7ab285b67",
  "related": [
   "galaxy:systems:sol",
   "codex:person:denton_patreus",
   "codex:person:jasmina_halsey",
   "codex:person:hengist_duval"
  ],
  "translation": "KI"
 },
 "060": {
  "author": "Frontier-Team",
  "wayback": "https://web.archive.org/web/20151104150845/http://us2.campaign-archive2.com/?u=dcbf6b86b4b0c7d1c21b73b1e&id=53c2aa5471",
  "related": [
   "hangar:ships:orca",
   "codex:corporations:saud_kruger",
   "hangar:ships:sidewinder",
   "hangar:ships:eagle",
   "hangar:ships:cobra_mk3",
   "galaxy:systems:lave"
  ],
  "translation": "KI"
 }
}