Set projects with 0 versions to 'File' (`select p.slug as proj, p.status from HProject p where defaultProjectType is NULL and id not in (select distinct project_id from HProjectIteration);`)
Set obsolete projects to File or whatever
Where versions agree, set project to same
Manually check remaining projects based on present documents / filenames, update directly
Metadata eg. msgctx could be used to determine gettexts?
`select docId from HDocument where poHeader_id is not NULL` for "is a po project"