Integration of EUEI and EUWI communities of practice on Capacity4dev

Pre-setup

1. Protect user emails. (add .test to end of a users emails) (Already in startup script)
   drush scr export_data/prepare/protect_email.php
2. Put export_data folder with migrated files to sites/default/files
3. Patch drupal dbtng module.
   In file /sites/all/modules/contrib/dbtng/database/query.inc fix __clone method.

   function __clone() {
   $this->changed = TRUE;
   foreach ($this->conditions as $key => $condition) {
   if ($key !== '#conjunction' && $condition['field'] instanceOf QueryConditionInterface) {
     $this->conditions[$key]['field'] = clone($condition['field']);
   }
   }
   }

4. For make work clean url on dev version need put .htaccess file in root directory.
   https://github.com/drupal/drupal/blob/6.x/.htaccess
5. Before migrate EuProfile disable auto title generation for People type in Content-type -> People -> Edit.
6. Order of run migration:
   First Part: EuUser -> EuProfile -> EuMembership
Second Part: EuDocument -> EuEvent -> EuNews -> EuComment
Third part: EuCounter -> EuBodyLink

Post-setup

1. Enable auto title generation for the People contenty type via Content-type -> People -> Edit.
2. Remove .test on the end of email for all users
   drush scr export_data/prepare/protect_email.php --unprotect=1
3. Put .htaccess files to EUEI and EUWI server for make redirects from old groups to new on C4D.

Dev

On current step all groups should be made manually.

Startup script for setup C4D system from zero on dev machine.

#!/bin/sh

# Drop exists database.
echo "Drop old database\n";
yes | drush sql-drop

# Import a backuped database.
echo "Import a new database.\n"
# drush sql-cli < ~/projects/migrate/c4d/c4d-with-exported-data.sql # Dump without groups
pv ~/projects/migrate/distr/C4D_original_dump_last.sql | drush sql-cli

# Change password for admin to 'admin'.
echo "Update password for the admin\n"
drush sql-query "UPDATE users SET pass='21232f297a57a5a743894a0e4a801fc3' WHERE uid='1'"

# Protect users by append .test to their mails.
echo "Protect users by append .test to their mails."
drush scr sites/all/modules/custom/euei-euwi-migrate/export_data/prepare/protect_email.php

# Import a 'exported tables'.
echo "Import 'exported tables'"
drush sql-cli < ~/projects/migrate/distr/exported-data.sql

# And clean a cache.
echo "Clean a cache\n"
drush cc all

# Enable migrate_ui module
echo "Enable migrate_ui module\n"
yes | drush en migrate_ui

# Reenable migrate_eu module.
echo "Reenable migrate_eu module\n"
yes | drush dis migrate_eu 
yes | drush en migrate_eu

# Enable devel module.
echo "Enable devel module\n"
yes | drush en devel

# Run migration once to make all working tables.
echo "Run migration"
drush ms

# Apply path for the EuMembership migration.
drush ev '
$ret = array();
db_add_field($ret, "migrate_map_eumembership", "destid1", array("type" => "int", "length" => 11));
$ret = array();
db_add_field($ret, "migrate_map_eumembership", "destid2", array("type" => "int", "length" => 11));
'

# finish
echo "Finished!\n"

Post script for restore admin password and uninstall migrate modules

cd /sites/all/modules/custom/euei-euwi-migrate
sh postscript.sh

#!/bin/bash

# Restore password for admin to default password.
echo "Restore password for the admin\n"
drush sql-query "UPDATE users SET pass='3e2f6687be0716873562cc35ab6ec778' WHERE uid='1'"

# Disable and delete migration modules.
echo "Disable migration modules"
yes | drush dis migrate_eu migrate_ui migrate 

# Disable and delete migration modules.
echo "Uninstall migration modules"
yes | drush pmu migrate_eu migrate_ui migrate 

# Remove postifx `test` for user emails.
echo "Remove postfix .test for user emails"
drush scr export_data/prepare/protect_email.php --unprotect=1