Anyone use sitedepth CMS script and has bulk copied galleries from one site to nother
 

I'm going crazy. I'm setting up a new site that is taking 130 galleries from 3 sites and putting it on that site. I tried going into php my admin and doing the follwing:

bulk exported my galleries from website_galleries table.

pulled out the ones I wanted, changed the site ID#, date, etc, then uploaded them to the same table.

found the new gallery# it assigned, added the section #, and added it with sql to the website_galleries_section table.

I go into site depth, all the galleries show up in the right sections. yipee.

But none of the galleries show up on the site. The only way I can get them to show up on the site is one at a time but selecting the gallery from the old site, going to delivery options, adding it to the new site within site depth.

I'm guessing that this procedure touching one of the other tables, but I can't find out where. I've got a ticket into support, but not sure how fast they can get back to me, so I thought I'd throw that out to all the php people on the board. I really don't want to have to do these one at a time. |cry| Has anyone done this before?

You should contact Omar or Alfredo to help you out on this one.

I did. I put in a support ticket. I was hoping maybe someone knew the answer quickly so I didn't have to wait. It drove me crazy yesterday.

Why not just use the delivery options? 130 galleries are not a lot, and you probably would have had it done by now :-)

It's assigning new gallery numbers? Did you look on you server to see if it's actually moving or copying the content and you have matching folders and content for the new gallery #'s?

If you have gallery #10, and what you're doing changes it to gallery #400, is it making a new, matching folder in the SiteDepth galleries directory?

When you use the display options, it links to the same gallery, with the same number.

I figured it out. When I uploaded the first file, it set the end date to 0000-00-00 instead of NULL. So it was reading the files as they shouldn't be open. When I edited it in my admin, poof they all showed up. :)

Alfredo got back to me and told me I was doing it the correct way, so that really drove me crazy.

Trev, yea, it has a gallery # which doesn't change, then it has an id, which does change. When you update the other table, you have to use the id #, not the gallery #. The id is unique for every instance of every gallery where as the gallery# is the same for each set that is re-used in different sites. My problems all stemmed from the end date, not iputting wrong numbers anywhere. :D