Is there any reason you can think of that stops some of the data from being imported? I have 84,000 threads and 181,000 users, but only 83,000 threads and 180,000 users are imported - I've done it like 3 times, same result each time(even increased the time from 2 to 3 hours).

Comments

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Postponed (maintainer needs more info)

Have had a look at the source but can't see any immediate reason why a user/thread wouldn't be imported. Firstly: is the discrepancy in the database (i.e. are the number of rows in the users table of Drupal what you expect), or in the number of users Drupal is reporting?

Secondly: I'm going to need a sample of the users that have failed to the import. Otherwise I'm working totally in the dark!

zahor’s picture

zahor commented

I'll try to get that sample (still never imported the other 3,000). Another problem this brought to my attention is that running the script multiple times...is not really feasible. It doesn't lend to the scenario that an active vbulletin site is being ported to Drupal, and thus while Drupal development is on going, vbulletin use will continue Ideally, it would be able to be run multiple times and I'd not have to worry about duplicating users or posts (I also get duplicate polls with different node IDs) or any other problems. There are a few other improvements which would be nice(e.g being able to import into a nodeprofile instead of core profile module), but I think I'll work on that myself as soon as I have some more free time.

liam mcdermott’s picture

liam mcdermott commented

When migrating our site, I created a little SQL script that deleted all nodes, polls, forum table entries, users, vocabularies, etc. with a uid/nid/vid/whatever greater than 1000000. Have lost the thing now, however it never was very clever or difficult to create.

You are correct that the script doesn't lend itself to importing the same data multiple times. Although it is only polls that mess this process up (if I remember correctly).

Do feel free to provide a patch for importing to nodeprofile. That's a lot more work than I can take on at the moment (unless someone were to pay me to do it!)

liam mcdermott’s picture

liam mcdermott commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

I strongly suspect the issue with missing threads is due to: #281861: If duplicate existing Drupal usernames exist, then VBulletin user and posts are skipped

Marking as duplicate.