Galerie V3.5.0 to vBGallery 3.0
 

Hi folks,
i wanna upgrade another board system to vB4. At the moment the system for this comunity is at Woltlab Burning Board 2.3.6.

It is a community about 6000 member and there was an old gallery system too. So here we are at my big problem, i dont wanna loose this content. We are talking about 1500 Images, not that much, but too much, to make this import manually.

I think it must be quiet easy, to import the data, but im not expierienced enough to do a script by myself.

Of course i'm willing to pay a little amount for a import script, but i would be thankful for some hints, to do it by my own, too.

First of all i will begin with the data structure:
Galerie V3.5.0:
/html/wbb2/galerie_data/
/html/wbb2/galerie_data/pics/
/html/wbb2/galerie_data/thumbs/
/html/wbb2/galerie_data/mini/
Filenames:
- Thumbs: t_imageid(?)_title_uperid_xxxx.jpg
- Pics: imageid(?)_title_uperid_xxxx.jpg
In some cases it is userid, not uperid.

Copying this files manually is nor problem.

Database Structure:
tables:
bb1_gal_cats (think thats not important, that can be done manually)
bb1_gal_groups (think thats not important, that can be done manually)
bb1_gal_highlights (can be ignored, no similar function at the vB gallery)
bb1_gal_mailed (not important)
bb1_gal_main:
Here we are, main information for the pics, list of fields and description:
gal_id: gallery picture id
gal_date: upload date (format like: 1080061092)
gal_catid: caterogy id
gal_picname: pic title
gal_picdesc: pic description
gal_hits: picture visits
gal_closed: private or public (1 = pic is public, 0 = pic is private)
gal_link: dont know, but always empty
gal_link_on: dont knwo, but always 0
gal_down: filename
gal_userid: gallery user id, similar to userid
gal_username: gallery username, similar to forum username
gal_size: dont know
gal_imp: dont know, always 0
gal_lastv: maybe last visit, format: 1290510403
gal_bew: pic rating format: xx,x (xx = summation of all ratings, x = number of ratings)
gal_bew_id: userids who rated the picture, always starts with a 0. format: 0,userid1,userid2,userid3...
gal_comment: comments for the pics (one text field for alle comments), format:
gal_comcount: total number of comments
gal_bewert: rating value, seems to be first value of gal_bew/secondvalue (total rating summation/number of ratings)
gal_bewtime: dont know, maybe rating time.. format: 1180374065

Notice for the rating system: It is a 10 Point System, User can select 1 to 10 from a dropdown menu and rate the picture.

Some things that i would like to see:
- pic posting date, should be the original one, not the on from the import
- private pictures can be ignored (gal_closed = 0)
- would be really nice, to import the rating from the 10 point system, to the 5 star vbgallery system.
- there must be a solution for a new cat id, is new cat ids are not equal to the old ones (but i think cat ids would be similar)
- i dont know, if it is possible to get the same userids after a import of a wbb2.3.6 system to a vB4. My last import (phpBB) result in new userid = olduserid + 1, because of the Adminstaror user of the vB. Hope there is a way to handle this problem.

Nice to have:
Actually there is just one textfield for comments, would be really great to seperate the comments, extract date and time, and to add comments one by another belonging to the correct user. If this is not possible, There should be 1 Comment, containing the old comments. This comment should be assigned to a special user id.


thank you.

Ok, first of all, i'm on a good way, without a script.

I used phpmyadmin, excel and notepad++ to get it nearly working, but some probs left.

First of all i exported my old image table as an xls file, same for the vbgallery image table. After this, i did a lot of excel functions (sverweis for old to new userid and so on) to the tables. Result was a complete ppgal_image table, which i imported as a csv file.
Database was up and looking good (except comments, this is my next step).

After this i downloaded my complete old image folder. First of all i created a batch file for the folders using excel. For example user id 5326 to mkdir \5\3\2\6 for all user ids. Next step was creating a copy batch file with the folder name and the old image name > copy xxxx_test_userid_oldid.jpg \5\3\2\6.

Just one click and all files were at the correct folder at my local machine. After uping them by my ftp client and rebuilding the image informations: IT WORKED! :)

I know, it is not the ususal way until now, but better than to skip this little project.

I just got one problem left: thumbnails.
For me the adminstartor user it worked. The rebuild thumbnail script created all thumbnail pics and i can see them in the gallery, too. But only for me, not for the other user. Chmod on folders seems to be fine and the script is working on every image.

Any hints?

I do not beleive anyone could speculate without seeing your site. Your obviously doing all this by hand. As far as I know if the main image and all the information is correctly entered for an image you should be able to rebuild the thumbnail.

Well, i got it by myself. Chmod was ok, but chown.. yeah sometimes it is hard to see the easy way :)
To get the Comments was a hard way, not the import thing, but extracking, username, dateline, comment from a big clear text with up to 150 comments was awful...

Just one little problem is left:
The member link on the username in comments is wrong:
it directed me to: /forums/gallery/member.php
correct path should be: /forums/member.php

This happens only in the comments, link for profil in the uploader data is correct.

Feel free to post a topic in the actual support forums on any issue you think is not relative to any import you did like a comments link.

Known bug... fixed for gallery 3.01 that michael should post any moment..

BTW, to avoid errors on big galleries, i usually only import 1 pic, never thumbnails or intermediate sizes...
filename = the biggest available pic.
then admin has to rebuild images.. then (after importing)
he can rebuild thumbnails, normal images and originals.
(in that order) so the images will all be correct size and so will the thumbnails and it saves you lots of coding.
Luc

I did it that way, just copied all the files, because i don't want to have the work to filter it out just for winning a couple of mb space.

I'm quiet happy with my import :)