MG 1.1 XFMG: Import From Photopost - vBulletin = No ratings

[Olli2k]

Due to fact that there is no XMFG 2.0 from PP pro importer I wanted to import my PP pro vBgallery to a XMFG 1.x installation and then upgrade it.
Everything is working fine, but not picture rating.
Importer says successfull after not even a second with 1 task.

So what I checked so far: there is a pp_ratings table, but only 3 entries.

I already tried to rename pp_ratings for a import because in php file I read something about a "noratingstable" scenario.

Ratings I want to be imported seem to be in pp_photos in column rating.

Any hints?

 

[Chris D]

In the code, in the "noRatingsTable" scenario we look for a rating column in the pp_comments table. Are you saying that's in the pp_photos table instead?

As far as I can remember in the two different versions I saw, the ratings were stored as comments (in the comments table) without any comment text.

I guess if you're 100% sure the ratings are in there, I'll give you some advice on what to change in the code (if I can...)

EDIT: Actually, I'm not sure about that... I would guess that the overall rating is stored in the pp_photos table, but not who rated and when.

 

[Olli2k]

Okay, you are right. I forgot something. Originally community software was Woltlab Burning Board 2.x with Gallery v3 (custom addon). i converted this gallery manually to my Photopost Pro installation. Everthing was fine except rating. In old galery v3 there were 4 related colums regarding rating:

gal_bew: 96,13 (sum of all ratings, amount of ratings)
gal_bew_id: 1,32,4355,6567,7666 (User IDs rated, sepereated by ,)
gal_bewert: 7,4 (current rating from 0 to 10)
gal_bewtime: 1150805995 (I think this should be date and time of last rating)

I still have a backup of this old database, so I think I will exclude all data and make a manual table of pp_ratings an upload this to my current pp installation. I just need to connect old user id with new one and old image id with new one.
id username userid date rating photo cat ipaddress
seq number new user id [gal_bewtime] sum/amount new pic id new cat id 0.0.0.0

After uploading pp_ratings, I will try another import. Will this work? Would it also work to create a manual xengallery_rating table?

 

[Chris D]

I think creating a pp_ratings table with the data and retrying the import will work the best. That'll make sure all of the ratings information and caches are built correctly after the import.