Meaning the web admin interface? That works good for
doing a few, but I’'m going to have lots of rosters
for lots of users. Its gotta be done with scripting
– I’'m not about to do all of these by hand! =)
I don’'t blame you.
Doing the SQL thing sounds good, although the
6-hour-delay thing is kinda strange, eh?
Yes and no. The delay is a result of the way Messenger caches certain data to improve performance and generally isn’‘t an issue since most people don’‘t jump into database to make changes. Typically, I recommend that if you are manipulating the database directly you do it while Messenger isn’'t running which helps avoid any sort of data integrity issues and with the added bonus of not having to wait up to six hours for the changes you make to take affect.
While you won’'t be able to use the import/export plugin directly you might want to look at the readme.html that comes with it. The file has a list of the different status types and what their associated numbers mean which will be helpful when creating your SQL statements.
If you need any additional help please let me know.