vBulletin Albums Importer -> vBGallery

Michael P · May 19th, 2009, 06:43 PM

2.5 includes a script you can use to import your vBulletin Albums into vBGallery. This script is very safe - you can "undo" your import and clear out all the photos you imported (and albums) without damaging any data you may currently have in your gallery.

The script is located at: admincp/importalbums.php

And requires you to login as an admin to execute. There are two options:

1) Run importer.
2) Clear out previous import. Do this ONLY if you want to start over.

For the first run, we recommend performing a backup of your database and gallery directory just for safe keeping.

Once you've done that you can Run Importer. This will import your albums, your photos and your comments.

If you have a need to start over, you can select option #2 to clear out your previous import data and start over. (Clearing out will also remove the imported images from the image directories).

RUNNING THIS SCRIPT DOES NOT REMOVE ANY ALBUMS OR THEIR PHOTOS! NOR DOES IT TURN OFF OR OTHERWISE CHANGE ANYTHING ABOUT YOUR ALBUM SETUP!

If you want to disable your albums, you would need to do this yourself. We do not remove any files, so any links to the original locations will still work in the forums.

IMPORTANT ASSUMPTION!

There is one assumption about this import script - that your have the default Member's Categories still setup. This is a catuserid of "3" - in the importalbums.php script, we use this explicitly. If you want to put these albums into a different Member's Categories, you will need to modify the script accordingly:

Code:

Content visible to verified customers only.

Where the "3" appears (twice) you would need the catid of the category you want to use.

Ivo2 · May 21st, 2009, 04:11 AM

I've tried several times, but allway get an sql-error for an album and a picture which doesn't exist.

Code:

Content visible to verified customers only.

Thanks for help

Chuck S · May 21st, 2009, 09:27 AM

There would have to be a mysql entry in your database have you checked your tables in the vb database? The error is because there is no CATID for this photo.

Ivo2 · May 21st, 2009, 10:52 AM

Quote:

Originally Posted by Chuck S

There would have to be a mysql entry in your database have you checked your tables in the vb database? The error is because there is no CATID for this photo.

That picture isn't in the database. Couldn't find it.

Chuck S · May 21st, 2009, 11:10 AM

You did a title search or username search?

From what I see there has to be an entry in the album table.

Ivo2 · May 21st, 2009, 11:16 AM

Quote:

Originally Posted by Chuck S

You did a title search or username search?

From what I see there has to be an entry in the album table.

I have made userid search, title search (are 2 pic's but not that one) albumid search and picture id search. Nothing

Chuck S · May 21st, 2009, 12:20 PM

There has to be an entry in tables because the data can not come out of thin air. We do a loop

How about the picture and albumpicture tables?

PossumX · May 21st, 2009, 04:19 PM

How is the CATUSERID set in the ppgal_categories table? In mine, CATUSERID is '0' for all rows.

I want to perform this integration step, but am befuddled as to what to do here. The CATID for the Members Galleries is '500', but I don't think that is what is relevant here.

Where would I locate the CATUSERID = '3'. I haven't changed anything, however, I did convert Photopost Pro to vBGallery, just yesterday.

Any help would be greatly appreciated.

Thanks.

Chuck S · May 21st, 2009, 04:25 PM

Not a problem

PossumX · May 21st, 2009, 04:32 PM

So, if I understand you Chuck, what I was referring to above is all irrelevant to the import script and it should work correctly? When completed, are the Album pictures put into Member Galleries, or integrated elsewhere? I would think Member Galleries, but I am just confirming, as when I ran the script, I received no errors, but no other Member Galleries existed either.

The script appears to run, and then just says:

"done..."

with no other detail on the screen above it, and I cannot locate the Album images in the vBGallery anywhere.

Chuck S · May 21st, 2009, 09:21 PM

Read the IMPORTANT ASSUMPTION ABOVE.

This should assist you. The importer assumes the member gallery is catid 3 if yours is different you need to modify accordingly.

PossumX · May 21st, 2009, 10:09 PM

Got it and thanks, had to change CATID to 500 for me and it worked smooth. Thanks!

Frogger · May 21st, 2009, 11:59 PM

my server keeps dropping connection when I am running the importer script.
Any way I can prevent this?

Ivo2 · May 22nd, 2009, 01:29 AM

Quote:

Originally Posted by Chuck S

There has to be an entry in tables because the data can not come out of thin air. We do a loop

How about the picture and albumpicture tables?

Yes, it was from the beginning as user deleted albums or pictures, but it seems that haven't deleted all entrys such comments and others.
I've made it now by hand, for over 100 pictures and comments.

Chuck S · May 22nd, 2009, 07:44 AM

well if a user deletes stuff vb should delete any table entries that to me sounds like an issue with there coding if it is not removed. As stated our importer would simply import the content from the tables so if there is erroneous false info we can not control that.

Frogger have you contacted your host about the issue? Sounds to me like a mysql server issue.

Johnbmtl · June 14th, 2009, 02:10 PM

You mention version 2.5. I just installed PhotoPost 6.23.
How do I transfer my albums from my Vbulletin installation?

Chuck S · June 14th, 2009, 08:29 PM

There is no importer for Photopost Pro at this time that will be released as soon as we can make one for that product.

Johnbmtl · June 15th, 2009, 07:31 AM

Thanks for the reply.
So in fact, the features of PhotoPost Pro are not available to me since I would lose all of my existing photos.

You should mention that fact in your Photopost Pro vs vbGallery comparison.
It is a significant difference between the two. Had I known an importer wasn't available I wouldn't have gone through the trouble of installing PhotoPost Pro.

Is this something that you are expecting to release in a couple of weeks or much longer? Should I wait or install vbGallery instead?

John

Chuck S · June 15th, 2009, 08:54 AM

John

vbAlbums is not a gallery. The features of Pro yes are alot vaster than vbgallery indeed. However you need to consider vbgallery just came out of a beta cycle where we added this importalbums ability and flash uploader. Photopost Pro will go into beta cycle some time shortly and when we are able to release an importer we will but I can not give you an exact timeframe. Since development time is a very fluid thing release dates are not given by any company.

Regs · June 27th, 2009, 04:22 PM

Arggghhh, sometimes I ask myself, self, why do you even care?

Chuck,

His main point seems to be that the product comparison between the 2 products on this site should be updated to reflect vbalbums can be imported into vBgallery but not photopost.

Maybe it is just me but I would have thanked the user for the very valid suggestion and assure him that the company will look into updating the marketing materials appropriately.

He doesn't need someone to tell him "vbAlbums is not a gallery" especially when he never insinuated it was - the very fact that he bought your product tells me that he knows vbAlbums is a limited solution when it comes to a gallery product!

Anyways...