Photopost Pro to vBGallery - Page 4

Chuck S · July 2nd, 2009, 08:52 AM

You can alter the addition that I gave you on that query and try this

WHERE id < 4000

and do an import

then change the addition to this

WHERE id > 4000

That should take care of your issue if it works that way.

djrichards · July 2nd, 2009, 10:48 PM

Still no joy.

Died at page 29 of 38 on the first 4000.

Same internal server error.

Chuck S · July 3rd, 2009, 09:00 AM

You can alter it to do in stages

Say like this

WHERE id < 2000

then run it with this

WHERE id > 2000 AND id < 4000

then this

WHERE id > 4000 AND id < 6000

then finally this

WHERE id > 6000

djrichards · July 4th, 2009, 12:41 AM

Inching ever closer.

It does fine up until the >6000. Then it dies as usual about halfway through.

And shouldn't this actually be ">1999 AND id < 4000", ">3999 AND id < 4000", etc?

Otherwise wouldn't image 2000, 4000, and 6000 get missed?

Chuck S · July 4th, 2009, 10:12 AM

<= and >= both would work in the queries

well if it dies after sometime 6000 alter it to break down as you want the remaining images you know it does 2000 at a time.

sross · July 18th, 2009, 07:28 AM

Hi, phew well finally got my import done. Went pretty good. The only MAJOR is that none of the custom ppost fields came over. I was hoping it would just dump them into the description area. Can you advise how to go about importing the custom pp fields into vbgallery? I may have to pay a coder to write this.. i had 25,000 bits of information within 4 custom fields. It is too much to lose. Thanks for any help!

Chuck S · July 18th, 2009, 09:26 AM

There is no custom field import it would appear correct. There is no way in the current script to do that and given the way how the custom fields store data honestly I do not know if its compatible with vbgallery.

sross · July 18th, 2009, 09:42 AM

I'll have to pay someone to try I guess. I have 25,000 images on a photo community that contained details like location, equipment, film, paper, etc. That alone made the gallery a very valuable resource. I just hope someone can find a way, even if it only dumps the data into a single field in vbgallery..

Chuck S · July 18th, 2009, 02:44 PM

Most likely a complex operation indeed.

sross · August 23rd, 2009, 06:06 AM

ok my coder has done the script for me and it worked great all of my custom field data in ppost pro has been successfully imported to my vbgallery custom fields. If anyone needs this just PM me and I will put you in touch with him. Thanks

Chuck S · August 23rd, 2009, 09:50 AM

Good to hear enjoy your weekend

SpadMan · September 6th, 2009, 05:53 PM

Am I the only one who gets an HTTP 500 error when running this import script?

I upgraded Photopost Pro to the latest version, double checked my paths, and tried running the import script from root, /forums, /gallery and /photopost.

Chuck S · September 6th, 2009, 07:25 PM

I would think possibly a path issue you want to use full server paths etc not relative ones.

SpadMan · September 6th, 2009, 07:29 PM

Thanks for the reply. I am. For example, my forums are in /home/.sites/_default/web/forum. If add add an 's' to the end of that I get a path error when I run the script so I don't think it's the paths causing me problems. I also disabled all my plugins and tried running it again but I still get an HTTP 500 in IE and a blank page in Google Chrome or Firefox.

Chuck S · September 6th, 2009, 07:33 PM

I would suggest you try looking at your server error logs. A server 500 error is the most generic error of all it can be anything which is why one needs to know the real issue.

SpadMan · September 6th, 2009, 08:27 PM

Why didn't I think of that?

Thanks for the help. Found the problem.

jbade · September 6th, 2009, 11:38 PM

Chuck,

HELP..
Got vbgallery installed no prob, imported the vbulletin albums after a few issues with timeouts.

Now I am working on importing from that old photopost install I told you about on the pre-sales forum.

I made the changes and I run it.

Code:

Content visible to verified customers only.

Chuck S · September 7th, 2009, 09:30 AM

Couple issues you need to think about

1. You want to clear any imported albums and do the photopost import FIRST

2. Disable any vb hacks you have as that error would suggest some type of hack issue. whats brotator? It has nothing to do with vbgallery?

jbade · September 7th, 2009, 05:10 PM

Quote:

Originally Posted by Chuck S

Couple issues you need to think about

1. You want to clear any imported albums and do the photopost import FIRST

2. Disable any vb hacks you have as that error would suggest some type of hack issue. whats brotator? It has nothing to do with vbgallery?

Got it..
Disabled plugins and the import has been running all day.

(Gathering images 70,000 of 0)
and still climbing.
Something isn't right.

I think I have just shy of 40k images.

Chuck S · September 7th, 2009, 05:16 PM

well is it importing anything? I cant speak on speed thats going to count on alot of things.