XF 1.2 Importer - Problem with "users"

Richey

Member
Hello xenForo Community,

I switched from IPB to xenForo and try to import my IPB 3.4.5 data into xenForo 1.2.

Now there is an error when importing the users. I have about 800 users but xenForo only imports 45 of them (without displaying errors). All of them are validated and in the same member-group.

Can someone please help me?

Kind regards,
Richey.
 

Richey

Member
Hi Brogan,

there are only 45 users in the front end, the acp and in the MySQL-table, so xenForo definitely imported only 45 entries.
 

Brogan

XenForo moderator
Staff member
Is there anything unusual about the 750+ users who weren't imported?
Anything in common between them?
 

Brogan

XenForo moderator
Staff member
And these are all valid, active members on your IPB forum currently?
Can you link to a few of the ones which weren't imported?
 

Richey

Member
And these are all valid, active members on your IPB forum currently?
Yes. But not all of them are active in the last time. And I just noticed in the MySQL table that the most of the "not imported users" have no entry in the "last_post/last_visit" columns. I will fix this and tell you if it works.
 

Brogan

XenForo moderator
Staff member
Was this an import from different software previously?
I am wondering how that data is missing as there should always be a last post/visit time and date no matter how long ago it is.

Although admittedly I have no knowledge of IPB or how it works, so this could be standard functionality, but it seems unlikely.
 

Richey

Member
Yes, there was a different software in the past.
But I can't find differences between the imported table rows and the non-imported (in the IPB database).
 

Brogan

XenForo moderator
Staff member
It sounds like incomplete data in the IPB database (possibly due to the previous import) is causing the records to not be imported.
As borne out by the fact that there is no data in some of the fields.
 

Richey

Member
OMG, I found the "problem". The IPB database has a table called "pfields_content". IPB stores the content of profile fields there. There are only 45 entries ... don't ask me why ;) I only had to create the missing rows for the other members with a mysql script. That's it.

And thank you for your help @Brogan !
 

Brogan

XenForo moderator
Staff member
I'll flag this to @Mike just in case.

I don't know anything about the IPB schema so have no idea if it's normal for users not to have a record in that table.

If it is then the XF importer can be updated to take that into account.
 

Mike

XenForo developer
Staff member
I've tweaked the code, but I suspect all users should have a record in that table.
 
Top