2
If there is a better way, I haven't found it. I exported the users table to CSV. Then using one user line as a guide, I used Excel to populate rows with the information (userid, pw etc.) Saved this to CSV and imported back to the table. Did the same with groups table. Seemed to work fine.
Rob