Migrate 'Unspecified' (null) projects to something resembling the proper type

Description

"Safe" migrations:

  • 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

Todo/consider:
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"

Status

Assignee

Unassigned

Reporter

Damian Jansen

Labels

None

Tested Version/s

None

Priority

unspecified
Configure