I now plan to do a import into ipboard from Kunena (as thats the forum software on joomla), and them xenforo import from ipboard. Tests I have done, it was always the users bit that got messed up hence the jfusion import
Anyway, the user ID's in the posts and threads are way when importing from ipboard BUT the usernames are good.
I have looked at this post:
But my mysql skills are rudimentary. I basically want to replace the user_id in posts and threads with the same user_id that matches the usernames in say xf_users. Any ideas if possible?
I can then rebuilt the thread counts and clear all caches and fingers crossed it should all match up again.