Support Forum

vBulletin Data Importer – not getting Posts

CH Claus Heinrich
Claus Heinrich
Member
Member since Oct 2012
7 posts
Oct 5, 2012 · 10:14 am · Edited

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

12 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
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…

CH Claus Heinrich
Claus Heinrich
Member
Member since Oct 2012
7 posts
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

CH Claus Heinrich
Claus Heinrich
Member
Member since Oct 2012
7 posts
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

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Oct 6, 2012 · 9:30 am

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

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
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…

CH Claus Heinrich
Claus Heinrich
Member
Member since Oct 2012
7 posts
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

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
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…

CH Claus Heinrich
Claus Heinrich
Member
Member since Oct 2012
7 posts
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

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Oct 20, 2012 · 2:24 pm

Unfortunately due to some heavy database work I am currently engaged in I can not test an import immediately although I will endeavour to build a system that will enable me to do so over the next day or so.

However – assuming you are using SP5.1.4 then I have discovered a bug in the code to do with the population of the forum and topic slugs. I doubt very much that this would effect the creation of post records but I also can not discount the possibility. If you would like me to send you an updated version of the importer plugin then I will happily do so unless you prefer to wait until I have rebuilt a system I can test your db import in…

CH Claus Heinrich
Claus Heinrich
Member
Member since Oct 2012
7 posts
Oct 24, 2012 · 1:09 pm

sure, I’d be happy to test the updated importer. Good news about the slugs