Hi Brajesh

Thanks to your helpful hints… I did it! I’m still fairly new to writing my own PHP, so there is probably a more elegant way of doing this, but in case it’s any help, here’s the code I used…

function my_update_posts() {
   
    $args = array(
        'post_type' => 'rtmedia_album',
        'numberposts' => -1
    );
    $myposts = get_posts($args);
	
	foreach ($myposts as $mypost){
		
		if ( ! function_exists( 'mpp_is_user_gallery_component' ) ) { 
		return;
	}
		
		$gallery_id = mpp_create_gallery( array(
		'creator_id'	 => $mypost->post_author,
		'title'			 => $mypost->post_title,
		'description'	 => '',
		'status'		 => 'public',
		'component'		 => 'members',
		'component_id'	 => $mypost->post_author,
		'type'			 => 'photo',
		'date_created' => $mypost->post_date,
		'date_updated' => $mypost->post_modified
	) );
	
	if ( $gallery_id ) {					
		mpp_update_wall_gallery_id( array(
			'component'		=> 'members',
			'component_id'	=> $mypost->post_author,
			'media_type'	=> 'photo',
			'gallery_id'	=> $gallery_id
		) );
	}
	
	  $args2 = array(
        'post_type' => 'attachment',
        'post_parent' => $mypost->ID,
        'numberposts' => -1
    );
    $myposts2 = get_posts($args2);
	
	foreach ($myposts2 as $mypost2){
	
	mpp_import_attachment( $mypost2->ID, $gallery_id);
		
	}
	
	}
    
}

Important notes to anyone thinking of trying this…

Back up your database (and image files) first! You can only run this code once – if it goes wrong, the references to rtMedia_albums will have gone/attachments will have moved, and you’ll need to start afresh.

I’d hoped that adding date_created and date_updated to the code would mean the galleries/albums would retain the dates when they were originally uploaded but this didn’t seem to work. Possibly there’s a fault in my code somewhere but I’m just happy that it worked as well as it did!

It’s not fast… I had about 10,000 images and it took about an hour to run… then again, it’s not that slow either 😉

Hope this might be of some help to someone, especially if you can write neater code.

Warm regards
Nik

PS. Now… if I can just figure out why comments on photos keep disappearing (see my other post), I’ll be a happy girl!

Hi Brajesh

Yes my code was definitely just a quick and dirty version for my own purposes but I’d be pleased if the general concept was some help.

And yes… I also found it strange that RTMedia seems to use both wp_posts and its own separate table in the database too, perhaps one is a legacy of the other? I think I’m right in saying that if you wanted to import views/specify privacy etc, that would need to come from the RTMedia table but for my purposes, the information in the wp_posts table was enough.

If you’d like any further info, please do let me know. It’s the least I can do in return for such great support.

Regards
Nik

As mentioned above, you are more than welcome to get in touch @Brajesh 😉

Although I have now successfully switched to Mediapress on the particular site I was working on, I have kept a backup copy prior to conversion, so could always use that to test any code you come up with.

I’ll mark this as resolved now but feel free to contact me any time.

Warm regards
Nikki