Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
vBulletin Data Importer - not getting Posts
Avatar
Claus Heinrich
Denmark
Member
Free Members
sp_UserOfflineSmall Offline
Oct 5, 2012 - 10:14 am

Hi, thanks for a great forum plugin. Tested it on a few sites and went Gold now.

I have an issue when using the Data Importer on my vBulletin 3.8.x database. It grabs everything fine, but does not grab any of the posts in the end.

This is a typical output:

IMPORTED:
12766 Users
8 Groups
42 Forums
3031 Topics
0 Posts

 

I have been doing a lot of searching before this post, and only thing I find is people with the same problem - but no solution.

Another notion I made was the forum & topic slugs are not set and needs to be made manually (not that fun with 3k+ :) )

I hope someone will take a look at it and make it work - it is crucial to me and others so we can make a good transition to SP - for now I will have to stick with vBulletin.
I have been trying to make my own fixes in sp-import/importers/vbulletin.php specific around the #SFPOSTS Table Mappings - but no luck.

Thanks for your time

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 5, 2012 - 12:28 pm

probably going to need Andy to return from vacation... he works the importers...  we have numerous folks that have successfully imported using vbulletin, so a bit odd...

he will be gone for couple weeks, but may check in from time to time...

if I get a chance this weekend, will see if I can dig around the importer... but I wont have any db to test with...

Avatar
Claus Heinrich
Denmark
Member
Free Members
sp_UserOfflineSmall Offline
Oct 6, 2012 - 2:49 am

Appreciate you took the time too read and respond Mr Papa.

I could try make a DB to you, if I can figure out how to simplyfy it down to you. Will have a look at it and maybe send something later today

Avatar
Claus Heinrich
Denmark
Member
Free Members
sp_UserOfflineSmall Offline
Oct 6, 2012 - 5:24 am

Ok, tried to make a very simple vbulletin db - hope I got the correct tables in there (took from what I could figure out the importer uses).

vbforum
vbpost
vbthread
vbuser

and made sure the forum -> thread -> post -> user is threaded correctly - there are 2 threads with 7 users replies - removed the rest of the rows from all tables.

If i am missing something in the db just let me know and I will make a new one.

I get the following Output when I run the importer (V5) - 10 Posts are missing

User/Member Data Created for Members 1 - 100

Forum Group Snydekoder Created

Forum Created: Jeg søger en snydekode (Topics: 0 Posts: 0)

Forum Created: Jeg har en ny snydekode (Topics: 0 Posts: 0)

Members Post Counts Updated

IMPORTED:
   7 Users
   1 Groups
   2 Forums
   2 Topics
   0 Posts

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 6, 2012 - 9:30 am

did you ever try it with the utf option on or off (ie both ways)??

Avatar
Claus Heinrich
Denmark
Member
Free Members
sp_UserOfflineSmall Offline
Oct 6, 2012 - 11:32 am

I did - same result

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 6, 2012 - 9:38 pm

okay thanks... no chance yet to look at db...  but it really might take Andy... but we shall see...

Avatar
Claus Heinrich
Denmark
Member
Free Members
sp_UserOfflineSmall Offline
Oct 8, 2012 - 2:16 am

thanks - I hope you get to figure it out. Would love to change to SP. And hope to be able to give back to the community in time.

And please also take a look at the slugs for forum/topic and probably also posts (when you get that to import). No slugs are set after import.

/Claush

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 8, 2012 - 8:33 am

we definitely will look into...  Sorry, I had no chance this weekend - schedules are tough on us when one is away on vacation...  It may not get much attention until Andy returns, but I will try...

Avatar
Claus Heinrich
Denmark
Member
Free Members
sp_UserOfflineSmall Offline
Oct 20, 2012 - 5:04 am

Will make a little bump - checking daily, but know things like this take time. Just want to make sure it does not get buried away

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625