I am new to amember, just got the updates all done, upgraded the VB plug in, and now ready to import members. I need to import one group of current members called Founding Members (their subscriptions cost less than regular members). I have that group set up in amember, I just am not sure how to create that CSV file to use for the import. Would someone mind helping me with that? I would reallllly appreciate it. Thanks!
sweating it out here. lol does anyone know how to make a cvs file in vbulletin of your members? username, password, name L, name F, etc?? please please?
Ok, I found in the plug in for VB that it has the code to produce a CSV for us. Cool! The code says function get_users_for_amember(){ global $db; $searchquery = " SELECT username, email FROM " . TABLE_PREFIX . "user AS user LEFT JOIN ".TABLE_PREFIX."usergroup AS usergroup USING (usergroupid) WHERE usergroup.adminpermissions = 0 AND (user.amemberid <= 0 OR user.amemberid IS NULL) "; return $db->query_read($searchquery); } I Neeeed it to import these things... username, password, email, name last, name first Can I just add that in the code?