Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Merging two Coppermine Galeries  (Read 4731 times)

0 Members and 1 Guest are viewing this topic.

football-pics.com

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Merging two Coppermine Galeries
« on: June 08, 2006, 02:22:19 pm »

Hi,

Is there any tool that could help me merge my two Coppermine Galleries (both 1.4.8 by now) into one?
I started those as two different projects but as of right now merging them into one big project would make more sense.
Gallery 1 has 323 albums, Gallery 2 has 454 albums. To merge them would save me the time to do that by hand and hopefully can carry comments, views and ratings over to the big Gallery as well as the registered users...
Is there any tool/bridge/mod/plugin for that?

Thanks,
Marc
Logged

Nibbler

  • Guest
Re: Merging two Coppermine Galeries
« Reply #1 on: June 08, 2006, 02:23:30 pm »

Not afaik.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Merging two Coppermine Galeries
« Reply #2 on: June 08, 2006, 07:10:52 pm »

Would be hard to impossible to accomplish such a task. Not related to bridging though. Moving accordingly.
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: Merging two Coppermine Galeries
« Reply #3 on: June 08, 2006, 09:06:35 pm »

It would be require great care to convert all the record IDs from one of the galleries to new IDs for the merged gallery.  It might be possible.  It would mainly be difficult in being very fastidious about all the fields and IDs.  I don't think it's impossible, but it might be.

In any case, there wouldn't be that many people who would use such a thing, so I don't think anyone would spend the time to code such a tool unless it were a personal project.

If you have the skills, go for it.  It sounds like you have the motivation to do so.  And consider sharing once done.

If not, besides batch-adding the photos from one to the other (and recreating the albums & categories using maybe the MassImport plugin), you might post on the Freelancer board.

There are two plugins that might help, but I don't think they would work "out of the box", as they are now.
  • File2AlbumMover: mirrors your albums in your folder names - I don't think it handles categories though
  • Mass Import: mass-creates categories & albums based on your folder & file structure

I could imagine applying the first plugin to one gallery to re-organize the files & albums, then copying the new albums folder to the other gallery, then using MassImport to pull them in to effectively merge the galleries.  But this might not work with how the plugins are currently written.

At the very least, you could manually organize one gallery's photos into folders with the album names, then using MassImport to add them to the other gallery.  That should work well with a day's work or so.  If your current albums mirror the folders fairly well, you may just have to rename the folders before using MassImport.

Remember to backup your files & database first.  And test out whatever you do with a small number of files first.  MassImport is a very powerful but also a very frantic tool.   :D
Logged

numer9

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 4
    • KiBo-FoTo
Re: Merging two Coppermine Galeries
« Reply #4 on: December 01, 2006, 11:13:16 am »

Hey,
got the same problem... started two projects: picts from women boxing (http://foto.bokskobiet.com) and Polish kick-boxing (http://foto.kibo.pl) and now I want to merge them into one fighting gallery. Is there any script/plugin to do it... this topic is pretty old, so maybe some solution came up recently? thanks!
Logged
regards! :)
#9

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Merging two Coppermine Galeries
« Reply #5 on: December 02, 2006, 07:27:36 am »

No plugin/mod available (and probably never will be). Above suggestions by Paver and me still apply.
Logged

TenguTech

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
    • TenguTech
Re: Merging two Coppermine Galeries
« Reply #6 on: June 29, 2007, 12:34:15 pm »

I came looking for the same thing too, a way to merge multiple galleries :)

Having two of galleries with a couple of hundred photos each that I would like to merge, I thought if there was a tool available it would be much easier. Looks like I'll have to do it manually.

Maybe a MySQL dump of one and modification by hand (or regular expression). Then merge it into the other DB.




Logged
A

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Merging two Coppermine Galeries
« Reply #7 on: June 29, 2007, 03:12:01 pm »

Will almost certainly break things if you only change reference in the pictures table. You'll have to make sure that your IDs stay unique and that the reference in all other tables is changed accordingly as well.
If you decide to create a script that will accomplish this task, we would appreciate it if you contributed it when done.
Logged

TenguTech

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
    • TenguTech
Re: Merging two Coppermine Galeries
« Reply #8 on: June 30, 2007, 04:42:25 am »

Yes, probably have to change IDs in a few tables.
Is there a database diagram for Coppermine gallery?
I have had a look for it but only found the Developer documentation which doesn't have much info.
Logged
A

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Merging two Coppermine Galeries
« Reply #9 on: July 01, 2007, 10:10:12 am »

No, sorry: there's little dev documentation available. There's no DB diagram.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.