| User | Post |
|
2:35 am
8 Aug 2008
|
Dannymh
Member
| | | |
|
| posts 5 |
|
|
I am in the process of writing a converter for SMF to SimpleForum I am doing this so I can truly see it's speeds etc whilst I do it.
It is going to be pretty basic and I wont plan on supporting it simply because I am at this moment only doing it for myself.
I will release what I write on to this site so others can use it and/or expand it. There will need to be a few things of note about what I am writing
1- I will be writing a fresh install of WP and forum script only (this means if you have existing sites and members you are either going to have to change the script or make some hard decisions about your wordpress members. Because I will be doing an exact 1 for 1 import, you SMF ID will be imported in as your WP and simple forum id, it is just simple and suits my needs, however it wont be hard to adapt)
2 - Your current wp admin will be deleted, at the end of the script you will be able to select a user from the list and mark them as them as the administrator (I may just make you put in a username or ID if you have more than 1000 members otherwise the script will be too sluggish)
3 - This is going to be a no frills importer, I wont be importing every little detail just what I think I need for benchmarking, you will however be able to adapt it and at a later stage I may be making this into something of an all over database to database importer where you can map a field to another field.
4 - THIS IS IMPORTANT: I will be either modifying or adding a new login module, this will be needed to take the uniquely salted SMF passwords and match them, it will then take the users password and re-salt it as a standard wp password. This is the main thing that sucks about SMF it has proprietry login hashes and makes a quick switch over impossible if not cumbersome. If you do not mind having your users go to 'Forgot Password' then this won't be needed as the system will send them a new password  I suggest putting it in place and then just informing people to do 'Forgot Password' after a few months, if they haven't logged in after a few months then I don't see why you should continue to have to doctor code to get them in.
I hope everyone will be happy with this. I only ask in return that you either help me benchmark this once I have a dev site up and running or visit one of my sites for me, I am trying to build some ranking.
My Sites: http://lpgconversions.org http://www.cheaperoil.org http://www.blokeman.com http://silvertails.net
Cheers
Dan
|
|
|
7:43 am
8 Aug 2008
|
Dannymh
Member
| | | |
|
| posts 5 |
|
|
Ok so far I have
- Users finished
All wp users are deleted, then user groups are deleted
We then disable the auto increment and import user groups, we then import users with the user group id intact etc so they will match exactly.
The only thing to note is that because of the difference in permissions once you import everything you will need to go to the member groups and add their permisisons it is just too much work to do a proper permissions import.
Once the users are imported, you are asked to identify the Admin user (your account) and change it's password. This will set it as the wp admin and will change the password to remove the SMF salt.
I also advise having at least 1 SMF test user so that once everything is converted you can test the modified login which fixes the users salting and hash. I still after everything think it best to either send out an auto password update to all users or ask them to do it, have both as a backup I say!
TO DO on Monday with time permitting:
- Import Topics
- Import Posts
- Write Modified login script to account for SMF hashing
That should be it really I can't see me needing to add anything else for benchmarking. This has so far been a pretty pleasant experience and pretty easy to do, there are some things you just have to accept with a conversion and it won't be 100% perfect, but since I am not commercialising this in anyway don't expect it to be
Any thoughts or feedback would be appreciated. Before I finish work for the day I may add a link to the user importer if ppl want to start with it.
Oh also it is a pretty untidy UI but I wasn't looking for awards just functionality it is just a series of links on each page.
Dan
|
|
|
7:53 am
8 Aug 2008
|
Dannymh
Member
| | | |
|
| posts 5 |
|
|
Oh forgot to mention I don't check user bans or import banned users, this is a little too complicated for my needs. If you need this. I suggest making a 1 for 1 comparison and then manually re-banning them, sorry, just a bit lazy at the moment
|
|
|
|
|
We do get asked from tiem to time for an SM importer. I'll make sure to pass people this thread. Thanks.
I wish you the best of luck with it…
|
|
|
2:20 pm
10 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
|
1:35 pm
14 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
I guess lack of response means there's no progress?
|
|
|
|
|
Afraid we have heard nothing further on this.
|
|
|
11:28 am
17 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
What a shame… is there anyway for me to manually transfer stuff (without getting too complicated). I only need basic user details (username/password/email), groups, categories and posts.
|
|
|
8:02 pm
17 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
I've managed to import my users, groups, forums & topics but the messages are killing me
|
|
|
|
|
|
7:41 pm
18 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
posts  (SMF calls them messages)
I can import them into the database, but it messes things up, i get errors and the post info doesn't display so there's something I'm either missing (some kind of relationship link up maybe? ) or getting wrong which is not surprising considering I really don't know what I'm doing…
|
|
|
|
|
Well you also need to make sure the other columns in sfposts are filled with the correect ID's etc. Then, if you manage to get all of that done you will need to run two or three functions to build the slugs and the indexes.
|
|
|
11:39 pm
18 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
I spent too long on it so I've given up - my skill level just isn't high enough to make it work.
At least I've got the groups and boards set up LOL… it's a start for the new content. Thankfully it wasn't a busy board yet anyway so no real harm done. I will leave a link to the old SMF form for ppl to reference as needed.
|
|
|
|
|
Sorry top hear that but yes - you do need some experience….
|
|
|
11:50 pm
18 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
I think I did well to get as far as I did.
I had already manually filled in slugs and made sure I matched up all the data for IDs and everything else as best I could figure out - but I must have missed something important  it was kind of frustrating that I felt like I got so close but just couldn't get those last few steps figured out
|
|
|
12:43 am
19 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
I fixed it! I got it to work! all my posts are there and no errors!! I'm stunned - totally stunned - and rather impressed with myself LOL
THere may be bugs with the odd post - but I hope not, and of course all my members will have to retrieve their passwords - but I did it!
|
|
|
2:23 am
19 Sep 2008
|
Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
Congrats! 
Was it by hand or automated for others to use? guessing by hand…
|
|
|
3:40 am
19 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
oooh, it was the hard way LOL, by hand, in a multi step process (due to my lack of skills but knack of finding some way or other to get the job done in the end) it involved exporting table data to excel, comparing notes and rearranging/adding/removing data as required, then importing to MS Acess and then exporting from there and importing the data into the new database. The whole excel/access thing was because I needed to be able to move columns around so couldn't do it in access and I couldn't get excel to export in such a way that it'd be compatible to import via myphpadmin.
Biggest problem I'm left with is I couldn't keep any of the date info (couldn't find a way to convert it from the 10 digit format that SMF uses) so all my posts have the same date. Not a big issue, i'm just glad to have the posts.
Unfortunately, none of that is really going to be of use to anyone else - other than to say it can be done I guess
|
|
|
5:02 am
19 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
|
7:11 am
19 Sep 2008
|
Dannymh
Guest
| | | |
|
| |
|
|
Sorry for the delay in getting back to you.
I havent finished this yet due to work commitments. I am starting a new site of which this will be part of it. At this stage I am looking to pick it up in a few weeks.
Will let you know
The messages are the easy part to import, you just have to write a simply loop, it is the membergroups which are difficult
|
|
|
11:10 am
19 Sep 2008
|
Tal
Member
| | | |
|
| posts 34 |
|
|
I'm glad you're still working on it, I'm sure it'll be helpful to others. While there's a plugin to tie SMF in with Wordpress I found it didn't work very well and I like the way SF ties everything into Wordpress much more nicely.
Usergroups weren't a problem for me because I didn't have any :) The only thing I really wish I'd been able to do was save the post date info - but it's not really tragic - the post info was the most important thing. Haven't emailed my users to tell them they need a new password yet but will do that today.
|
|
This forum is currently locked - access is read only
Forums
