I decided to jump and see if I could migrate users from v2.0.4 to v3.0. Seems like it's not too much of a headache depending on your installation.
I've used WebLoginPE in the past and moved over to FormLister and customUser.
Here's the script I wrote. It's basic. Doesn't check anything just works through whats needed.
- creates new TVs based on field in attributes_extended.
- adds the new TVs to PowerUser role.
- adds users to the same role
- adds the values to the TV from attributes_extended
When you check a user you will see the TV's listed along with their associated value.
There is no rollback, so backups are needed. There's also no feedback on the screen.
Just create a snippet and add it to a new document and open that page.
// This snippet will create new TV's based on web_user_attributes_extended
// It will also populate fields for each user
$fields = array();
// Change this role ID to the one you wish to choose in the Role
$roleid = 2; // PowerUser
// Change to match your Admin ID account. This prevents the user_attribute for that account from being changed inadvertently.
$adminid = 576; // Not always ID 1 so please checkdate
// Whether to update existing roles to the above role id?
// default 0 = no
// 1 = yes
$updateExistingRoles = 0;
// Table names
// You may wish to change the attributes_extended table depending on your old system setup.
$tbExtended = $modx->db->config['table_prefix'] . "web_user_attributes_extended";
// These table names can be left alone!
$tbUsers = $modx->db->config['table_prefix'] . "users";
$tbUserSettings = $modx->db->config['table_prefix'] . "user_settings";
$tbUserAttributes = $modx->db->config['table_prefix'] . "user_attributes";
$tbUserValues = $modx->db->config['table_prefix'] . "user_values";
$tbUserRoleVar = $modx->db->config['table_prefix'] . "user_role_vars";
$tbSiteTVs = $modx->db->config['table_prefix'] . "site_tmplvars";
// Get the extended attribute field names and create TVs
$sql = "SHOW COLUMNS FROM ". $tbExtended .";";
$rs = $modx->db->query($sql);
while ( $row = $modx->db->getRow($rs) )
{
$fields [] = $row['Field'];
}
unset($fields[0]);
unset($fields[1]);
echo "<h1>Getting Fields</h1>";
print_r($fields);
// Create new TV's based on above field list:
echo "<h1>Inserting new TVs</h1>";
foreach ( $fields as $field )
{
$insertflds = array(
'type' => 'text',
'name' => $field,
'caption' => $field,
'description' => $field,
'editor_type' => 0,
'category' => 0,
'editedon' => 0,
'createdon' => 0,
'locked' => 0);
print_r($insertflds);
echo "<br />";
$modx->db->insert($insertflds, $tbSiteTVs );
$newId = $modx->db->getInsertId();
$newRolesID[] = $newId;
// Assign each new field to a role!
// Insert new ID into roles
$roleData = array(
'tmplvarid' => $newId,
'roleid' => $roleid,
'rank' => 0
);
print_r($roleData);
echo "<br />";
$modx->db->insert($roleData, $tbUserRoleVar);
}
echo "<h1>Done! Working</h1>";
echo "<h1>New Role IDs</h1>";
print_r($newRolesID);
echo "<h1>Updating User Roles</h1>";
// Change User Roles for each user
$sql = "SELECT * FROM ".$tbUsers.";";
$rs = $modx->db->query($sql);
while ( $row = $modx->db->getRow($rs) )
{
// Change role of each user
// This will mean inserting a record for users who haven't been backend updated
// or changing the role for those that have!
$sql1 = "SELECT * FROM ". $tbUserSettings . " WHERE `user` = ".$row['id']." AND setting_name='role';";
$rs1 = $modx->db->query($sql1);
$count = $modx->db->getRecordCount($rs1);
if ( $count )
{
// Update
if ( $updateExistingRoles == 1 )
{
$roleUpdate = array(
'setting_value' => $roleid
);
echo "Updating: ".$row['id']."<br />";
$modx->db->update($roleUpdate, $tbUserSettings, 'user='.$row['id']);
}
} else {
// INSERT
$roleInsert = array(
'user' => $row['id'],
'setting_name' => 'role',
'setting_value' => $roleid
);
echo "Inserting: ".$row['id']."<br />";
$modx->db->insert($roleInsert, $tbUserSettings);
}
// Update user_attributes Role
if ( $row['id'] != $adminid )
{
$roleUpdate = array( "role" => $roleid);
$modx->db->update($roleUpdate, $tbUserAttributes, "internalKey = ".$row['id']);
}
}
echo "<h1>Done!</h1>";
echo "<h1>Creating User TV Values!</h1>";
// For each user role var we need to update user values accordingly
// for each role(field) we need to populate the value from extended
$i = 0;
foreach ( $fields as $field )
{
// first field to first role
$sql = "SELECT internalKey, ".$field. " FROM ". $tbExtended.";";
$rs = $modx->db->query($sql);
//echo "<strong>".$sql."</strong><br />";
while ( $row = $modx->db->getRow($rs) )
{
//Insert TV data for each field for each user!
$insertTVValue = array(
'tmplvarid' => $newRolesID[$i],
'userid' => $row['internalKey'],
'value' => $row[$field]
);
//echo "Updating: ".$newRolesID[$i]. " User: ".$row['internalKey']."Value: ".$row[$field]."<br />";
$modx->db->insert($insertTVValue, $tbUserValues);
}
$i++;
}
echo "<h1>Done!</h1>";
PS: I noticed that whilst the page may end up being blank there are still DB entries being populated in the back end. My setup had 1200+ TV entries to create.
Use with caution please or just have a read through to see what is needed!
