vBlogetin to vBulletin Blog issues

[Merriweather]

I have read through every thread I could find on this issue and can't seem to find an answer to my problem.

I am importing my vBlogetin data to vBulletin Blog via Impex.

1. I backed up the vBlogetin tables and the user table and put them into a temporary DB.
2. I removed vBlogetin.
3. I installed vBulletin Blog.
4. I downloaded Impex from the members area and installed it.
5. Step one was fine.
6. I skipped step two.
7. On step three, I choose to match by email address, and it always fails, telling me there is a duplicate key. **edited to add** I tried matching on user id and it gave me the same error.

Here is the error I just got on trying to match by user id:

ImpEx Database errormysql error: Invalid SQL: 
                    INSERT INTO blog_user
                    (
                        bloguserid, importbloguserid, title, description, options,
                        viewoption, comments, lastblog, lastblogid,
                        lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
                        entries, allowsmilie, subscribeown, subscribeothers,
                        moderation, deleted, draft, options_everyone,
                        options_buddy, options_ignore, ratingnum, ratingtotal,
                        rating, pending, uncatentries
                    )
                    VALUES
                    (
                        '7',
                        '7',
                        'title',
                        'description',
                        '0',
                        'all',
                        '0',
                        '0',
                        '0',
                        '',
                        '0',
                        '',
                        '0',
                        '23',
                        '1',
                        'none',
                        'none',
                        '0',
                        '0',
                        '0',
                        '3',
                        '3',
                        '0',
                        '0',
                        '0',
                        '0',
                        '0',
                        '0'
                    )
                

mysql error: Duplicate entry '7' for key 1

mysql error number: 1062

Date: Sunday 27th 2008f July 2008 12:06:41 AM
Database: ***
MySQL error:

Can anyone help me figure this out?

[Tigratrus]

I've been doing the same import (done it a few times on our test system) and other than the Blog entry titles not importing right (the title of the Blog itself ends up being imported as the title for every entry, while the title of the blog itself defaults to "title" I've been able to get it all to import.

However I'm *not* matching the users on email, I'm matching them on Userid instead, have you tried doing that for step 3?

James and Susan

[Merriweather]

I've been following your progress. I don't think I tried by userID, I will try that tonight and see what happens.

[Merriweather]

I forgot that I also wanted to ask:

(1) Are comments importing? I saw some threads where they weren't...
(2) What happens if a user has a blog in vBulletin blog, and they had one in vBlogetin -- will the old blog replace the new one, or will they merge?

[Merriweather]

Still no luck trying to match by userid. I updated the first post with the error that I get.

[Merriweather]

Ok, I cleaned out the vBulletin Blog tables and it worked perfectly. No idea why that happened to me the first time I tried the import, as the tables should have been clean, but whatever.

Now my issue is importing the few blog entries that were made on vBulletin Blog and adding them to existing vBlogetin Blogs. Any ideas? :?

[Jerry]

That issues comes from a partial user import, then a re-run.

It's always best to reset the database to the backup of a blog import between tests.

[Merriweather]

Got it. Thanks.

Now, is there anyway to add the entries users made on vb blog before the import to the blogs that were imported?

[Jerry]

Got it. Thanks.

Now, is there anyway to add the entries users made on vb blog before the import to the blogs that were imported?

Meaning the difference from when you did the import till now ?

If thats what you mean you're talking about a differential import and they aren't supported at the moment.

[Merriweather]

Yes, that's what I mean. Is there anyone who can give unofficial format as to doing it manually? I only have about 5-10 to add.