vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0

[Ludachris]

If I've already imported avatars and attachments it sounds like I can skip those on the standard importer, right? And if I've already replicated most of my profile fields in XF, should I delete those before I try importing with the standard importer?

Thanks for the help @Jake Bunce much appreciated.

 

[Jake Bunce]

If I've already imported avatars and attachments it sounds like I can skip those on the standard importer, right? And if I've already replicated most of my profile fields in XF, should I delete those before I try importing with the standard importer?

Thanks for the help @Jake Bunce much appreciated.

Yes and yes.

 

[Jake Bunce]

If I've already imported avatars and attachments it sounds like I can skip those on the standard importer, right? And if I've already replicated most of my profile fields in XF, should I delete those before I try importing with the standard importer?

Thanks for the help @Jake Bunce much appreciated.

It is important to backup first. You are attempting something non-standard which will probably have some false starts, but it could potentially save time if you get it working.

 

[Ludachris]

Just backed up my XF db to have a good restore point (did it before I deleted all the user fields I created). I'm going to be importing from a copy of my live db, if that's possible with the standard importer.

 

[Jake Bunce]

I'm going to be importing from a copy of my live db, if that's possible with the standard importer.

That works.

 

[Ludachris]

Ahhh, will I also need to delete all of the usergroups I created, and paid membership groups? Sorry, figure it makes more sense to ask now than to find out after the fact.

 

[Jake Bunce]

Ahhh, will I also need to delete all of the usergroups I created, and paid membership groups? Sorry, figure it makes more sense to ask now than to find out after the fact.

No. The user field module has no dependencies. You should be able to run just that.

 

[Ludachris]

Was about to Validation Configuration on the standard importer and it recognized that attachments and avatars are stored in the file system. Since I already imported those with the big board importer should I clear out those fields so that it doesn't create duplicates? Or leave them alone?

 

[Ludachris]

Anyone? I'd really like to get this import going.

 

[Ludachris]

I just did another import using this plugin and am getting the same strange errors:

Warning 1366 Incorrect integer value: 'Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.' for column 'user_id' at row 2

Is this a problem with the Export or the Import?

 

[Ludachris]

I'm going to try my luck at the standard importer.

 

[Jake Bunce]

Was about to Validation Configuration on the standard importer and it recognized that attachments and avatars are stored in the file system. Since I already imported those with the big board importer should I clear out those fields so that it doesn't create duplicates? Or leave them alone?

The idea was to run the custom user field module only. You are supplementing the big board importer by running that one module to save yourself the trouble of having to manually create those fields.

 

[Jake Bunce]

I'm going to try my luck at the standard importer.

That's fine. It does take longer though. This can be time-prohibitive if you have millions of posts.

 

[Ludachris]

The idea was to run the custom user field module only. You are supplementing the big board importer by running that one module to save yourself the trouble of having to manually create those fields.

That was the only thing I ran with the standard importer - the user fields import. Then I ran the big board Import.php file. I got those errors again. I don't know where the problem is. Maybe this importer is just not going to work for my forum due to all the user fields I have set up and all the select menu user data I have, which creates a lot of extra coding and modification for this importer. I'm using up a lot of time trying to prepare to use this importer, which is probably taking just as much time as the standard importer at this point. I'm thinking maybe I just chalk up the $150 loss and try the standard importer and see if I have better luck. I have just shy of 4 million posts but oh well.

 

[Jake Bunce]

I just did another import using this plugin and am getting the same strange errors:

Warning 1366 Incorrect integer value: 'Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.' for column 'user_id' at row 2

Is this a problem with the Export or the Import?

That appears to be console output in your data. That's not right. Yes, that would appear to be a problem with the Export.

 

[Ludachris]

Well, I tried the standard importer and it took quite a bit longer than I had hoped. Granted, I stepped away from time to time, and a few db errors pausing the import it. But I'm afraid when I do the final import I'll have to shut the site down for an entire day. I'm going to take another shot at this importer and try to work out the errors.

I'll try to use the standard importer to import the User Fields only. I figure that means I'll still have to manually map the user fields in the Import.php file. I saw something in a post within this discussion that select option fields might have to be coded differently than the examples in the Import.php file. Is that the case?

Also, I'm planning on using the XenCentral Trading System - should I not import the iTrader ratings using this importer and just use the importer that comes with that plugin?

 

[Jake Bunce]

I'll try to use the standard importer to import the User Fields only. I figure that means I'll still have to manually map the user fields in the Import.php file. I saw something in a post within this discussion that select option fields might have to be coded differently than the examples in the Import.php file. Is that the case?

Also, I'm planning on using the XenCentral Trading System - should I not import the iTrader ratings using this importer and just use the importer that comes with that plugin?

Yes, the mapping in the Export script may require attention to differences in how a value for a field is stored in XF versus vB.

This importer doesn't do iTrader. Use the importer included with that addon.

 

[Ludachris]

Question - I did a full test import using the standard importer, except I used this importer for the attachments and avatars. The directories were created just fine, but the attachments and avatars are not showing up in the imported forum. I still plan to try and use this importer for my second test, but wanted to see why this first test didn't work the way I did it. I rebuilt attachment thumbnails but that didn't fix it.

 

[Jake Bunce]

Question - I did a full test import using the standard importer, except I used this importer for the attachments and avatars. The directories were created just fine, but the attachments and avatars are not showing up in the imported forum. I still plan to try and use this importer for my second test, but wanted to see why this first test didn't work the way I did it. I rebuilt attachment thumbnails but that didn't fix it.

How many posts do you have? You imported posts using the web-based importer? That leads me to believe you don't need this big board importer at all.

 

[Ludachris]

I have 4 million posts. It was a test import that I'm using for development, I still have to do another import once I have everything tested and set up. The problem with the standard importer, as you know, is speed. When I do the final import I can't have the site down a full day (or two) to run it. I'm planning to try and get this importer to work. Importing the threads with the standard importer took roughly 16 hours alone.