ok I managed to do this using the buddypress import members plugin http://www.youngtechleads.com/buddypress-members-import/ (17$) and adding the field “last_activity” with a value of i.e. “2013-09-21 22:06:14” (could be any date I’m sure)
Good plugin for importing users in general!
adding a row in the database to usermeta ‘last_activity’, ‘with date’ in the database shows the user profile as theyve become ‘active users’, I need 1000 users activitated, anybody any dea how could do this as a batch?