post phpBB2 2.0.3 import cleanup - lost users/PM's

[tryckjävel]

Jerry did my import for me back when gold was first released, and all went well except 2 things.


almost exactly 100 users that had joined the board between 1/13/03 to 1/16/03 were not imported, however their posts were (and dubbed as annonmyous)
All users Private Messages were returned to their respective From address rather then To address. What i mean is instead of PM's that were sent TO the user, their inbox contained only PM's sent FROM the user.


I want to know: with the release of the impex system, before I dig into it, is there a way i can import just those 100 users and all the PM's into their respective boxes correctly.

Thanks in advance,
-Dana

[Jerry]

I take it this is to re-import the 100 users and PM's into a currently working board ?

[tryckjävel]

yeah, I just want to add in at least the users and get their old posts associated with their username again...
it would be nice if i could go through and get all the PM's and put them into the right boxes (did you figure out how to fix that for the public import script?)


side note: some of the ~100 users signed back up again with their same usernames... i dunno if that would be a problem or not.

[tryckjävel]

Jerry/Others - any ideas for those select members?

[Jerry]

yeah, I just want to add in at least the users and get their old posts associated with their username again...
it would be nice if i could go through and get all the PM's and put them into the right boxes (did you figure out how to fix that for the public import script?)

You would have to prune a user table to get the source data sorted so it didn't try to import all of them again.


side note: some of the ~100 users signed back up again with their same usernames... i dunno if that would be a problem or not.

Going to make things difficult but not impossible, you'd just have to associate them.

[tryckjävel]

so i should:

-import the whole source data from phpbb again into a test board w/ 3.0.1

-prune all users except for the ones that registered between date&time that im almost positive they're from

-backup that ~100 user (with all posts) board data

-try and import that into the functioning board i have now?

-then get the users new names (which most of them have provided me with) and 'merge' users

Do i need to import the old posts too so they're associated with those users? or will they automatically be associated (after restoring counters and such).

[Jerry]

Nope.

Take a copy of the phpBB source.

Prune that table to the 100 users you want.

Run 002 to associate the ones you want with the ones that re-registered.

Run 003 to import the rest.

Run 009 to import the posts. (Changing its $_dependent to 003)

[tryckjävel]

Ok, I'll give it a try and let you know what happens