pre-migration formatting update