unifying publications in wh40k

publications.md

# in repo directory
$files = dir * -Include *.cat,*.gst
$datas = $files | % { [xml] (cat $_) }
$roots = @($datas.catalogue, $datas.gameSystem) | % { $_ } | ? {$_}

# show all unique pub names
$roots.publications.publication.name | % { $_ } | select -Unique | sort

# find all publications (by name) that appear in more than one file
$grp = $roots.publications.publication | Group-Object -Property name
$grp | ? Count -gt 1 | select Name,@{l='catalogues';e={$_.Group.ParentNode.ParentNode.name -join ', '}}
# or
# $files|%{[xml](cat $_)}|%{$_.catalogue;$_.gameSystem}|%{$_}|?{$_}| % { "--- " +$_.name; $_.publications.publication.name | % { $_ } | sort }

# find unreferenced publications
$pubs = $roots.publications.publication
for ($i = 0; $i -lt $pubs.Count; $i++) {
    $pub = $pubs[$i]
    $id = $pub.id
    $name = $pub.name
    $catName = $pub.ParentNode.ParentNode.name
    Write-Progress "Searching for unreferenced publications..." -Status "Checking publications in $catName" -CurrentOperation "$name ($id)" -PercentComplete (100 * $i / $pubs.Count)
    $hits = $files | Select-String $id -SimpleMatch -CaseSensitive | Measure-Object
    if ($hits.Count -eq 1) {
        Write-Output "pubId $id has only single match"
    }
}