+* ownCloud - admin_migrate

+* @author Tom Needham

+* @copyright 2012 Tom Needham tom@owncloud.com

+OC_APP::registerAdmin('admin_migrate','settings');

+ 'id' => "admin_migrate_settings",

+ 'href' => OC_Helper::linkTo( "admin_migrate", "settings.php" ),

+<?xml version="1.0"?>

+<info>

+ <id>admin_migrate</id>

+ <name>ownCloud Instance Migration</name>

+ <description>Import/Export your owncloud instance</description>

+ <version>0.1</version>

+ <licence>AGPL</licence>

+ <author>Thomas Schmidt and Tom Needham</author>

+ <require>2</require>

+ <default_enable/>

+</info>

+<?php

+

+/**

+ * ownCloud - admin_migrate

+ *

+ * @author Thomas Schmidt

+ * @copyright 2011 Thomas Schmidt tom@opensuse.org

+ * @author Tom Needham

+ * @copyright 2012 Tom Needham tom@owncloud.com

+ *

+ * This library is free software; you can redistribute it and/or

+ * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+ * License as published by the Free Software Foundation; either

+ * version 3 of the License, or any later version.

+ *

+ * This library is distributed in the hope that it will be useful,

+ * but WITHOUT ANY WARRANTY; without even the implied warranty of

+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+ * GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+ *

+ * You should have received a copy of the GNU Affero General Public

+ * License along with this library. If not, see <http://www.gnu.org/licenses/>.

+ *

+ */

+OC_Util::checkAdminUser();

+OC_Util::checkAppEnabled('admin_migrate');

+

+// Export?

+if (isset($_POST['admin_export'])) {

+ // Create the export zip

+ if( !$path = OC_Migrate::export( null, $_POST['export_type'] ) ){

+ // Error

+ die('error');

+ } else {

+ // Download it

+ header("Content-Type: application/zip");

+ header("Content-Disposition: attachment; filename=" . basename($path));

+ header("Content-Length: " . filesize($path));

+ @ob_end_clean();

+ readfile( $path );

+ unlink( $path );

+ }

+// Import?

+} else if( isset($_POST['admin_import']) ){

+ $from = $_FILES['owncloud_import']['tmp_name'];

+

+ if( !OC_Migrate::import( $from, 'instance' ) ){

+ die('failed');

+ }

+

+} else {

+// fill template

+ $tmpl = new OC_Template('admin_migrate', 'settings');

+ return $tmpl->fetchPage();

+} \ No newline at end of file

+<form id="export" action="#" method="post">

+ <fieldset class="personalblock">

+ <legend><strong><?php echo $l->t('Export this ownCloud instance');?></strong></legend>

+ <p><?php echo $l->t('This will create a compressed file that contains the data of this owncloud instance.

+ Please choose the export type:');?>

+ </p>

+ <h3>What would you like to export?</h3>

+ <p>

+ <input type="radio" name="export_type" value="instance" /> ownCloud instance (suitable for import )<br />

+ <input type="radio" name="export_type" value="system" /> ownCloud system files<br />

+ <input type="radio" name="export_type" value="userfiles" /> Just user files<br />

+ <input type="submit" name="admin_export" value="<?php echo $l->t('Export'); ?>" />

+ </fieldset>

+</form>

+<?php

+/*

+ * EXPERIMENTAL

+?>

+<form id="import" action="#" method="post" enctype="multipart/form-data">

+ <fieldset class="personalblock">

+ <legend><strong><?php echo $l->t('Import an ownCloud instance. THIS WILL DELETE ALL CURRENT OWNCLOUD DATA');?></strong></legend>

+ <p><?php echo $l->t('All current ownCloud data will be replaced by the ownCloud instance that is uploaded.');?>

+ </p>

+ <p><input type="file" id="owncloud_import" name="owncloud_import"><label for="owncloud_import"><?php echo $l->t('ownCloud Export Zip File');?></label>

+ </p>

+ <input type="submit" name="admin_import" value="<?php echo $l->t('Import'); ?>" />

+ </fieldset>

+</form>

+<?php

+*/

+?>

+

+<?php

+class OC_Migration_Provider_Bookmarks extends OC_Migration_Provider{

+

+ // Create the xml for the user supplied

+ function export( ){

+ OC_Log::write('migration','starting export for bookmarks',OC_Log::INFO);

+ $options = array(

+ 'table'=>'bookmarks',

+ 'matchcol'=>'user_id',

+ 'matchval'=>$this->uid,

+ 'idcol'=>'id'

+ );

+ $ids = $this->content->copyRows( $options );

+

+ $options = array(

+ 'table'=>'bookmarks_tags',

+ 'matchcol'=>'bookmark_id',

+ 'matchval'=>$ids

+ );

+

+ // Export tags

+ $ids2 = $this->content->copyRows( $options );

+

+ // If both returned some ids then they worked

+ if( is_array( $ids ) && is_array( $ids2 ) )

+ {

+ return true;

+ } else {

+ return false;

+ }

+

+ }

+

+ // Import function for bookmarks

+ function import( ){

+ switch( $this->appinfo->version ){

+ default:

+ // All versions of the app have had the same db structure, so all can use the same import function

+ $query = $this->content->prepare( "SELECT * FROM bookmarks WHERE user_id LIKE ?" );

+ $results = $query->execute( array( $this->olduid ) );

+ $idmap = array();

+ while( $row = $results->fetchRow() ){

+ // Import each bookmark, saving its id into the map

+ $query = OC_DB::prepare( "INSERT INTO *PREFIX*bookmarks(url, title, user_id, public, added, lastmodified) VALUES (?, ?, ?, ?, ?, ?)" );

+ $query->execute( array( $row['url'], $row['title'], $this->uid, $row['public'], $row['added'], $row['lastmodified'] ) );

+ // Map the id

+ $idmap[$row['id']] = OC_DB::insertid();

+ }

+ // Now tags

+ foreach($idmap as $oldid => $newid){

+ $query = $this->content->prepare( "SELECT * FROM bookmarks_tags WHERE bookmark_id LIKE ?" );

+ $results = $query->execute( array( $oldid ) );

+ while( $row = $results->fetchRow() ){

+ // Import the tags for this bookmark, using the new bookmark id

+ $query = OC_DB::prepare( "INSERT INTO *PREFIX*bookmarks_tags(bookmark_id, tag) VALUES (?, ?)" );

+ $query->execute( array( $newid, $row['tag'] ) );

+ }

+ }

+ // All done!

+ break;

+ }

+

+ return true;

+ }

+

+}

+

+// Load the provider

+new OC_Migration_Provider_Bookmarks( 'bookmarks' ); \ No newline at end of file

+<?php

+

+/**

+ * ownCloud - user_migrate

+ *

+ * @author Tom Needham

+ * @copyright 2012 Tom Needham tom@owncloud.com

+ *

+ * This library is free software; you can redistribute it and/or

+ * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+ * License as published by the Free Software Foundation; either

+ * version 3 of the License, or any later version.

+ *

+ * This library is distributed in the hope that it will be useful,

+ * but WITHOUT ANY WARRANTY; without even the implied warranty of

+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+ * GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+ *

+ * You should have received a copy of the GNU Affero General Public

+ * License along with this library. If not, see <http://www.gnu.org/licenses/>.

+ *

+ */

+OC_Util::checkAdminUser();

+OC_Util::checkAppEnabled('user_migrate');

+

+// Import?

+if (isset($_POST['user_import'])) {

+

+ $root = OC::$SERVERROOT . "/";

+ $importname = "owncloud_import_" . date("y-m-d_H-i-s");

+

+ // Save data dir for later

+ $datadir = OC_Config::getValue( 'datadirectory' );

+

+ // Copy the uploaded file

+ $from = $_FILES['owncloud_import']['tmp_name'];

+ $to = get_temp_dir().'/'.$importname.'.zip';

+ if( !move_uploaded_file( $from, $to ) ){

+ $error = array('error'=>'Failed to move the uploaded file','hint'=>'Try checking the permissions of the '.get_temp_dir().' dir.');

+ OC_Log::write( 'user_migrate', "Failed to copy the uploaded file", OC_Log::ERROR );

+ $tmpl = new OC_Template('user_migrate', 'admin');

+ $tmpl->assign('error',$error);

+ return $tmpl->fetchPage();

+ }

+

+ if( !$appsstatus = OC_Migrate::import( $to, 'user' ) ){

+ $error = array('error'=>'There was an error while importing the user!','hint'=>'Please check the logs for a more detailed explaination');

+ $tmpl = new OC_Template('user_migrate', 'admin');

+ $tmpl->assign('error',$error);

+ return $tmpl->fetchPage();

+ } else {

+ // Check import status

+ foreach( $appsstatus as $app => $status ){

+ if( $status != 'true' ){

+ // It failed for some reason

+ if( $status == 'notsupported' ){

+ $notsupported[] = $app;

+ } else if( !$status ){

+ $failed[] = $app;

+ }

+ }

+ }

+ // Any problems?

+ if( isset( $notsupported ) || isset( $failed ) ){

+ if( count( $failed ) > 0 ){

+ $error = array('error'=>'Some app data failed to import','hint'=>'App data for: '.implode(', ', $failed).' failed to import.');

+ $tmpl = new OC_Template('user_migrate', 'admin');

+ $tmpl->assign('error',$error);

+ return $tmpl->fetchPage();

+ } else if( count( $notsupported ) > 0 ){

+ $error = array('error'=>'Some app data could not be imported, as the apps are not installed on this instance','hint'=>'App data for: '.implode(', ', $notsupported).' failed to import as they were not found. Please install the apps and try again');

+ $tmpl = new OC_Template('user_migrate', 'admin');

+ $tmpl->assign('error',$error);

+ return $tmpl->fetchPage();

+ }

+ } else {

+ // Went swimmingly!

+ $tmpl = new OC_Template('user_migrate', 'admin');

+ return $tmpl->fetchPage();

+ }

+ }

+

+} else {

+// fill template

+ $tmpl = new OC_Template('user_migrate', 'admin');

+ return $tmpl->fetchPage();

+} \ No newline at end of file

+<?php

+

+/**

+ * ownCloud - user_migrate

+ *

+ * @author Tom Needham

+ * @copyright 2012 Tom Needham tom@owncloud.com

+ *

+ * This library is free software; you can redistribute it and/or

+ * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+ * License as published by the Free Software Foundation; either

+ * version 3 of the License, or any later version.

+ *

+ * This library is distributed in the hope that it will be useful,

+ * but WITHOUT ANY WARRANTY; without even the implied warranty of

+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+ * GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+ *

+ * You should have received a copy of the GNU Affero General Public

+ * License along with this library. If not, see <http://www.gnu.org/licenses/>.

+ *

+ */

+// Init owncloud

+require_once('../../../lib/base.php');

+

+// Check if we are a user

+OC_JSON::checkLoggedIn();

+OC_Util::checkAppEnabled('user_migrate');

+// Which operation

+if( $_GET['operation']=='create' ){

+$uid = !empty( $_POST['uid'] ) ? $_POST['uid'] : OC_User::getUser();

+if( $uid != OC_User::getUser() ){

+ // Needs to be admin to export someone elses account

+ OC_JSON::error();

+ die();

+}

+// Create the export zip

+if( !$path = OC_Migrate::export( $uid ) ){

+ // Error

+ OC_JSON::error();

+ die();

+} else {

+ // Save path in session

+ $_SESSION['ocuserexportpath'] = $path;

+}

+OC_JSON::success();

+die();

+} else if( $_GET['operation']=='download' ){

+ // Download the export

+ $path = isset( $_SESSION['ocuserexportpath'] ) ? $_SESSION['ocuserexportpath'] : false;

+ if( !$path ){

+ die();

+ }

+ header("Content-Type: application/zip");

+ header("Content-Disposition: attachment; filename=" . basename($path));

+ header("Content-Length: " . filesize($path));

+ @ob_end_clean();

+ readfile($path);

+ unlink( $path );

+ $_SESSION['ocuserexportpath'] = '';

+}

+<?php

+

+/**

+* ownCloud - user_migrate

+*

+* @author Tom Needham

+* @copyright 2012 Tom Needham tom@owncloud.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Affero General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+OC_APP::registerPersonal( 'user_migrate', 'settings' );

+OC_APP::registerAdmin( 'user_migrate', 'admin' );

+OC_Util::addScript( 'user_migrate', 'export');

+

+// add settings page to navigation

+$entry = array(

+ 'id' => "user_migrate_settings",

+ 'order'=>1,

+ 'href' => OC_Helper::linkTo( "user_migrate", "admin.php" ),

+ 'name' => 'Import'

+);

+?> \ No newline at end of file

+<?xml version="1.0"?>

+<info>

+ <id>user_migrate</id>

+ <name>User Account Migration</name>

+ <description>Migrate your user accounts</description>

+ <version>0.1</version>

+ <licence>AGPL</licence>

+ <author>Tom Needham</author>

+ <require>2</require>

+ <default_enable/>

+</info>

+$(document).ready(function(){

+ // Do the export

+ $('#exportbtn').click(function(){

+ // Show loader

+ $('.loading').show();

+ $.getJSON(

+ OC.filePath('user_migrate','ajax','export.php'),

+ {operation:'create'},

+ function(result){

+ if(result.status == 'success'){

+ // Download the file

+ window.location = OC.filePath('user_migrate','ajax','export.php?operation=download') ;

+ $('.loading').hide();

+ $('#exportbtn').val(t('user_migrate', 'Export'));

+ } else {

+ // Cancel loading

+ $('#exportbtn').html('Failed');

+ // Show Dialog

+ OC.dialogs.alert(t('user_migrate', 'Something went wrong while the export file was being generated'), t('user_migrate', 'An error has occurred'), function(){

+ $('#exportbtn').html(t('user_migrate', 'Export')+'<img style="display: none;" class="loading" src="'+OC.filePath('core','img','loading.gif')+'" />');

+ });

+ }

+ }

+ // End ajax

+ );

+ });

+}); \ No newline at end of file

+<?php

+

+/**

+ * ownCloud - user_migrate

+ *

+ * @author Thomas Schmidt

+ * @copyright 2011 Thomas Schmidt tom@opensuse.org

+ * @author Tom Needham

+ * @copyright 2012 Tom Needham tom@owncloud.com

+ *

+ * This library is free software; you can redistribute it and/or

+ * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+ * License as published by the Free Software Foundation; either

+ * version 3 of the License, or any later version.

+ *

+ * This library is distributed in the hope that it will be useful,

+ * but WITHOUT ANY WARRANTY; without even the implied warranty of

+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+ * GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+ *

+ * You should have received a copy of the GNU Affero General Public

+ * License along with this library. If not, see <http://www.gnu.org/licenses/>.

+ *

+ */

+OC_Util::checkAppEnabled('user_migrate');

+

+// fill template

+$tmpl = new OC_Template('user_migrate', 'settings');

+return $tmpl->fetchPage(); \ No newline at end of file

+<form id="import" action="#" method="post" enctype="multipart/form-data">

+ <fieldset class="personalblock">

+ <?php if(isset($_['error'])){ ?>

+ <h3><?php echo $_['error']['error']; ?></h3>

+ <p><?php echo $_['error']['hint']; ?></p>

+ <?php } ?>

+ <legend><strong><?php echo $l->t('Import user account');?></strong></legend>

+ </p>

+ <p><input type="file" id="owncloud_import" name="owncloud_import"><label for="owncloud_import"><?php echo $l->t('ownCloud User Zip');?></label>

+ </p>

+ <input type="submit" name="user_import" value="<?php echo $l->t('Import'); ?>" />

+ </fieldset>

+</form>

+<fieldset class="personalblock">

+ <legend><strong><?php echo $l->t('Export your user account');?></strong></legend>

+ <p><?php echo $l->t('This will create a compressed file that contains your ownCloud account.');?>

+ </p>

+ <button id="exportbtn">Export<img style="display: none;" class="loading" src="<?php echo OC_Helper::linkTo('core', 'img/loading.gif'); ?>" /></button>

+</fieldset>