changes to all views, most connections done, pre sssm