Need help combining 2 galleries (bid/quote?)

jenkaufman

I've got a client w/ 2 separate galleries - different MySQL logins, etc. The galleries are for artist galleries and some of the artists are in both galleries. The client wants to consolidate galleries and have just 1 gallery now.

Can anyone offer to combine these two into a single gallery?
Time/Cost estimate?

I will pay for help and/or a solution for this problem. And before you respond suggesting I re-number photos, etc... I'm not that technical, nor do I care to do it manually myself. I am looking for someone to assist & take care of this entirely.

Please respond and/or contact me if you can help.

acrylian

I guess there is more info needed to say anything about that. I think this has not been done before.

Generally it is possible to just copy the contents of the root albums folder to one install to get those albums to another install. But of course that would loose all data entered like descriptions or sort orders and also not transfer user accounts.

If you like you find an e-mail address on my (still under construction) site www.maltem.de if you like to contact me directly to discuss if I could help. Please include links to those two sites in question.

jenkaufman

Sorry for the delayed response. Here are the two locations (on the same site).

http://www.divinitytattoo.com/scottsdale/index.php
http://www.divinitytattoo.com/phoenix/index.php

I'm not opposed to other solutions or ideas - it's not a software I installed or am really familiar with, so I'm really just looking for some help in getting a resolution.

Thanks.

sbillard

Just making a quick look at the sites I have the impression that they have not made [much] use of things like titles and descriptions so the databases probably do not contain much data that would need to be replecated.

It also seems that there are no duplications in the top level album (folder) names.

That being the case, just copy the album folders from one site to the other.

The theme is not one of ours, so maybe there is some special code in it. For instance, how is the "make an appointment with...." link done? If it is hard-coded into the scripts then the albums copied over would need to have their links created. Of course, a better solution would be to generate the link from the album name, but that does not look like what was done.

acrylian

I indeed think this is quite simple, too. Since those site use a very old 1.1.7 install there is no user management for each artist's album (which I thought based on your first post). So you should indeed be able to just copy the content from the albums folder (in the root of each Zenphoto install, this is where the albums and images are stored in) from install to the other. Since Zenphoto is filesystem based it will recognize the new folders you copied as albums.

Since as sbillard mentioned there are no titles set (you seem to use the file names for images). You might neeed to retitle some albums as automatically the folder names will be used.

You might need to copy over the php files that do the "Make an appointment" link which is surely something third party and possibly not even Zenphoto unrelated (from the source code it seems like a Dreamweaver script the whole site seems to be design with).

Of course before you attempt all this make a backup..;-)

jenkaufman

Thanks for the comments, I really do appreciate the tips.

Based on what you're saying, I "should" be able to take the individual album names from within /scottsdale/albums/ for instance and move them to the /phoenix/albums/ folder (or vice versa).

There is one duplicate album name (the artist) and several of the same sub-album names within that artist. Assuming we can still copy/paste in the unique items from one or the other and the system will automatically integrate them into the gallery.

Does this sound about right?

You've already been a big help & it sounds like we're close to having a viable option here. Just need a couple more specifics (above) finalized.

Thanks!

acrylian

Yes, you should be able to copy the subalbums from one toplevel album to the other one. They then would appear as subalbums as well. You might of course have to sort the order of the albums again.