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

RedCherry · 2007-02-14, 10:14 PM

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.

Has anyone done this before?

2007-02-14, 10:14 PM	#1
RedCherry Of all the things I've lost, I miss my mind the most. Join Date: Apr 2004 Location: Middle of the Desert, Pahrump, NV Posts: 3,187	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. Has anyone done this before? __________________ Our 3D Comics and Props on Renderotica