XF 2.1 Cannot import vBulletin 4 blogs

[ivp]

Just tried importing vBulletin 4 blogs without success.

First used vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] to import forum, then upgraded to XF 2.1.1.

Then installed XenForo Importers 1.2.2 and checked only the following for the import:

• Blog entries
• Blog attachments (legacy data)
• Blog attachments (vBulletin 4 data)
• Blog comments
• Blog tags
• Blog moderators

It processed all blog entries, but at the end it reported 0 blogs imported and import_log_vbulletin4withblog_1 is empty.

 

[ivp]

Tried on clean XF 2.1 installation, the same thing.

Again reinstalled XF and tried with checked "User groups", "Users" and "Retain content IDs" and it finally worked.

But how to import blogs on existing XF installation?

 

[Paul B]

Does it work with the blog items checked as well as user groups and users but without retain content IDs checked?

Blog entries have to be associated with a valid user so user groups and users are most likely a prerequisite.

 

[ivp]

Even if it works that way, I wouldn't want to mess with the existing user base of current XF installation.

So actually there is no official solution for importing blogs on existing installation?

What about the following idea:

1. Install new XF 2
2. New XF: Import blogs with "User groups", "Users", all "Blog*" items and "Retain content IDs" checked.
3. New XF: Find the current AUTO_INCREMENT values for every table affected by blog content import.
4. Existing XF: Find the current AUTO_INCREMENT values for all affected tables in existing XF.
5. Existing XF: Raise AUTO_INCREMENT value for all affected tables in existing XF to be higher than number of records from step (3) plus step (4).
6. New XF: Increment ID of every record in affected tables according to step (4)
7. Export & import affected tables.
8. Rebuild counters

Affected tables are the following if I haven't missed any:

• import_log_vbulletin4withblog_1
• xf_approval_queue
• xf_attachment
• xf_attachment_data
• xf_deletion_log
• xf_ip
• xf_post
• xf_tag
• xf_tag_content
• xf_thread
• xf_thread_user_post
• xf_thread_watch