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?

Kenny B! · 2007-02-15, 10:05 AM

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

RedCherry · 2007-02-15, 11:16 AM

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.

emmanuelle · 2007-02-15, 11:43 AM

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

Trev · 2007-02-15, 03:42 PM

Quote:

Originally Posted by RedCherry

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.

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.

RedCherry · 2007-02-15, 11:29 PM

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.

2007-02-15, 10:05 AM	#2
Kenny B! I'm normally not a praying man, but if you're up there, please save me Superman! Join Date: Dec 2003 Location: Montreal Posts: 472	You should contact Omar or Alfredo to help you out on this one. __________________ ken@iacash.com icq: 53962376

2007-02-15, 11:16 AM	#3
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	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. __________________ Our 3D Comics and Props on Renderotica

2007-02-15, 11:29 PM	#6
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	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. __________________ Our 3D Comics and Props on Renderotica

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

2007-02-15, 11:43 AM	#4
emmanuelle 0100011101100101011001010 1101011001000000100001101 1010000110100101100011 Join Date: Mar 2004 Location: Montreal Posts: 1,441	Why not just use the delivery options? 130 galleries are not a lot, and you probably would have had it done by now :-)