coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: lolainslacks on October 25, 2011, 05:37:55 AM

Title: Easy way to move albums from one category to another
Post by: lolainslacks on October 25, 2011, 05:37:55 AM
When I started off my gallery I sorted events pics by categories like Awards & Galas, Movie Premieres & Screenings, Film Festivals, etc.. But now I want to sort the albums by year. How do I move the albums from these categories to the years ones?

Is there an easy way to do that without losing the viewings count? Maybe via phpMyAdmin?

Help, please!

Thanks in advance!
Title: Re: Easy way to move albums from one category to another
Post by: lurkalot on October 25, 2011, 09:45:01 AM
See, http://documentation.coppermine-gallery.net/en/albums.htm#album_howMoveAlbum

All comments, views, votes etc will move with them.  If you're not sure, just create a test album, and try moving it around, and you see how it works
Title: Re: Re: Easy way to move albums from one category to another
Post by: lolainslacks on October 25, 2011, 10:22:58 AM
Quote from: lurkalot on October 25, 2011, 09:45:01 AM
See, http://documentation.coppermine-gallery.net/en/albums.htm#album_howMoveAlbum

All comments, views, votes etc will move with them.  If you're not sure, just create a test album, and try moving it around, and you see how it works

I have over 150 albums. Is there any way of batch doing it?
Title: Re: Easy way to move albums from one category to another
Post by: Αndré on October 25, 2011, 12:12:20 PM
There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.
Title: Re: Re: Easy way to move albums from one category to another
Post by: lolainslacks on October 25, 2011, 09:10:19 PM
Quote from: Αndré on October 25, 2011, 12:12:20 PM
There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

Do I have to change anything in the pictures table?
Title: Re: Easy way to move albums from one category to another
Post by: Αndré on October 25, 2011, 10:08:44 PM
No.
Title: Re: Re: Easy way to move albums from one category to another
Post by: lolainslacks on October 25, 2011, 10:26:28 PM
Quote from: Αndré on October 25, 2011, 12:12:20 PM
There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

What do you mean by adjust the category values?
Title: Re: Easy way to move albums from one category to another
Post by: Αndré on October 25, 2011, 10:55:38 PM
Just look at the albums table. There's a column with the categories' IDs in it, which determine which album belongs to which category. If you adjust that value (for each album), it/they will appear in the corresponding category.