Importing users and messages from SMF to EE Forum

hello bjornbjorn

wonderfull extra !!! just what I needed

I a new new new to EE just became a member today .. 😉

i looked at your tutorial but there was one thing I couldn’t find in SMF the Ids of the members(only 23) and the Ids of each forum ! this is probably a very noob question but really could’nt find it. Could you or someone else help me with that ?

Thanks a lot

regards zhangfei

Hello zhangfei and welcome,

if you hold your link over a forum (for instance) you’ll typically see the id of the forum somewhere in the URL in the status bar.

As for members, you do not need the id’s of the members, but the id of the usergroup - since you’ll need to move them from a SMF usergroup to an EE usergroup. Use the same method, go to the usergroup administraiton and hover over the links and you should see the url somewhere in URL (shown in the statusbar in your browser).

hello to all,

I have tried the transfert on my local machine everything went fine with the members and then went on to to the posts tranferts and BAMM can’t connect anymore to EE or the forum !! really don’t get the reason espacially when the admin name and password are the same in SMF and EE.

I guess the transfert screwed up the passwords !

how can I correct that mistqke if possible ?

Thanks for the help

best regards Zhangfei

Hi,

that is expected behaviour as SMF and EE use different password algorithms so ALL PASSWORDS have been reset (as specified in the install docs 😉 ) ..

you need to go through EE’s “forgot password” procedure.

thanks for the fast reply !

Well I must have missed something since I don’t know where the install docs are !! So this means that each user will have to do the forgot passwords procedure ?

I only have 23 members is there a way to do it manually ? in the database maybee ?

Since on my localhost I entered a fake email i guess I will have to start everything up again.

Thanks

best regards zhangfei

You can enter the db and change passwords manually yes, in addition to your e-mail.

The “install doc” is the blogpost I wrote when releasing the script; Converting from SMF to ExpressionEngine Forum.

e.g. for updating your e-mail:

UPDATE exp_members SET email='[email protected]' WHERE username='yourusernamehere'

I can’t think of a way to update all users passwords in the db without letting everyone know everyones password 😉

just one more thing really quickly 😉

what is the name of the database that I should edit in EE ? I mean witch one in the EE database?

anyway don’t know if I’ll be able to do it never played with SQL before and would like to avoid it !

I’ll try with my forum online i see how it turns out

Thanks again for your help

best regards

unfortunately, I don’t know the name of your database - you specified it when installing EE.

Never mind with the DB It’s too hard for me anyway.

But I have sucesfully transfered the memebers and the forums post to EE so it seems to be okay. However on the forum index page the posts are not reference under topics and replies its says 0 is that normal ? or something I did wrong ?

http://www.wugong.fr/EE/index.php/forums

here is a link if you want to see for yourself.

best regards

zhangfei - I advise you to read the blogpost I linked to above. The answers to your questions can be found there (in the latest case you need to recount the stats).

Hello Bjorn

thanks for the help. I have read your blog about ten times at least. But the recount stats did not work the first time execpt in EE but couldn’t see it on the forum I’ve done it again and now it works 😉

Thanks so much 😉

BTW : still can’t see were you mention that the users password won’t work from smf in your blog.

Best reagrds Zhangfei

my bad - I thought for sure I’d mentioned it in my blog entry but apparantly I had not. Now the text has been updated to incldue that important piece of information 😊

Thanks for letting me know.

Good luck with you site.

Bjørn

Bjørn -

I set up the smf_import module today for a test. It imported my users and forums msgs just fine.

But, it stored non-Super Admins (SMF) users in EE’s group_id as “0” instead of the “5” that I used within the forum array in the utility.

Any idea why that occurred?

I fixed it with the database itself, but am curious as to what happened.

I did get a number of PHP errors during the import, I believe it was line #133.

TIA

carvingCode,

you mean the group array not the forum array right? The group_id -> group_id links should be pretty straightforward. Anyway, it’s hard to tell what happened without seeing the arrays you used and the PHP error you got.

Glad you got it working though 😊