News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Dumb Blonde moment...how to convert phpBB3.x to smf

Started by shadav, July 18, 2020, 07:50:49 PM

Previous topic - Next topic

shadav

ok I need a dummies guide on how to convert

I have a phpbb3.x (not sure if it's 3.2.9 or 3.3.0....it's a bit messed up due to failed attempts at updating) that's like a decade old

I'd like to convert it over to smf but I guess I really don't understand  :laugh:  :o  :laugh:
I downloaded the phpbb32 converter and there's 2 files in there a convert.php and sql file
I uploaded the convert.php and pointed to it's url and well it just says

QuoteWhich software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.

Try again
:-\

vbgamer45

Both should be uploaded to your SMF forum.
Then run the file and enter the information for your phpBB forum


Haven't tested with phpBB 3.3
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

shadav

going to have to say it doesn't work
just stuck on a blank screen for step 1

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

shadav

#4
 :-[ i lied....
I downloaded 2.1 instead of 2.0.17
wasn't paying attention *doh*

well it sort of worked but I can't log in, keeps saying that password is incorrect....
and all the posts are striked out as in like this
it's going to need a lot of fixing and custom bbcode  :laugh:


how in the heck can i log in if it's not accepting my password, and I know it's correct

[edit]
ok, I was able to change the password in the db and log in.....
I tried the i forgot my password and it said it sent the email but it didn't

now to figure out how to fix all the other issues

shadav

another stupid question but I can delete all of the phpBB_ from the database and keep the smf_ ones, correct?

shadav

for some reason the converter changed all bbcode to html

what should look like this
[align=center][media]https://youtu.be/_E3OM7rZg1g[/media][/align]

[spoiler title=If the above doesn't play, click here][episode]http://www.foamyfanatics.net/player.php?title=Reboot+Button&location=episodes/Classic/Season09&file=RebootButton[/episode][/spoiler]


looks like this
<r><ALIGN align="center"><s>[align=center]</s><YOUTUBE id="_E3OM7rZg1g"><s>[media]</s><URL ogp="{"title":"Reboot Button : Foamy The Squirrel","description":"Sick of hearing Germaine's nonsense... Foamy gives her a mysterious reboot button. (Kind of the last episode in a way. But not really.) illwillpress.com","image":"https://i.ytimg.com/vi/_E3OM7rZg1g/hqdefault.jpg"}" url="https://youtu.be/_E3OM7rZg1g">https://youtu.be/_E3OM7rZg1g</URL><e>[/media]</e></YOUTUBE><e>[/align]</e></ALIGN>

<SPOILER title="If the above doesn't play, click here"><s>[spoiler title=If the above doesn't play, click here]</s><EPISODE content0="Reboot+Button" content1="episodes/Classic/Season09" content2="RebootButton"><s>[episode]</s>http://www.foamyfanatics.net/player.php?title=Reboot+Button&location=episodes/Classic/Season09&file=RebootButton<e>[/episode]</e></EPISODE><e>[/spoiler]</e></SPOILER></r>


:o

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

shadav

uggg that sucks.....
700 posts that will need fixed.....

shadav

thanks for the help :)
marking this solved as aside from the issue of every post being html the conversion mostly worked....

it did not however transfer user avatars
and it closed all polls

these three issues seem to be the only things that I have as of yet noticed

a lot of work to be done to get it up and running again but it did mostly work....everything else can be fixed with time, just annoying to have to edit every post to remove html codes

and on a personal side note  :laugh: kind of proud of myself, mostly recreated the template..obviously it's not 100% the same but close enough  ;D

vbgamer45

Yeah the template looks good. I have to work on the html parsing from phpBB was trying to think of way not to include a ton of files/functions to clean it all
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

shadav

thank you

a feature request would be to add the avatars to the conversion
not a big issue, folks will just have to reset them  :P

but it didn't upload the avatar directory at all

shadav

bwahahahaha found another error bwahahahaha

um the last edit date got messed up also

Antechinus

Is there any rhyme or reason to the weird HTML tags? If there's some sort of logic there it should be possible to clean the whole lot up pretty easily with db queries. If it's all random crap, that's a different matter.

shadav

i wish ug....

when it converted from phpbb to smf as vbgamer already explained, phpbb saves things in html, so all of the bbcode tags got messed up

it's mostly random unfortunately....
it's url, embed, and image codes

don't know where the r and s tags came from

thank you though :) I wish it was a simply find and replace, but it's not, because it really messed the code all up
what should just be
[center][embed]youtubelink[/embed][/center]
[spoiler title="If the above doesn't play, click here"][episode]selfhostedplayerlinkwithtitleinformation[/episode]


it's all garbly goop
<r><ALIGN align="center"><s>[align=center]</s><YOUTUBE id="uyqCCLVKKMA"><s>[media]</s><URL ogp="{"title":"Postcards From The Ledge : Foamy The Squirrel","description":"Foamy & Pilz-E receive a postcard from Germaine and prep for her return. (Stuff gets back on track next week, so the "boring" Germaine sub-story is pretty mu...","image":"https://i.ytimg.com/vi/uyqCCLVKKMA/hqdefault.jpg"}" url="https://youtu.be/uyqCCLVKKMA">https://youtu.be/uyqCCLVKKMA</URL><e>[/media]</e></YOUTUBE><e>[/align]</e></ALIGN>

<SPOILER title="If the above doesn't play, click here"><s>[spoiler title=If the above doesn't play, click here]</s><EPISODE content0="Postcards+From+The Ledge" content1="episodes/Classic/Season08" content2="PostcardsFromTheLedge"><s>[episode]</s>http://www.foamyfanatics.net/player.php?title=Postcards+From+The Ledge&location=episodes/Classic/Season08&file=PostcardsFromTheLedge<e>[/episode]</e></EPISODE><e>[/spoiler]</e></SPOILER></r>


eh it's slow going....not quite halfway done....but it's also giving me a chance to remove the youtube links that no longer work (youtube decided to delete half of the creator's work and demonetize him after almost 10 years)

Antechinus

Pity. I've been contemplating a similar conversion myself, but in that case it would be 41,000 posts to deal with. I can edit that many posts manually (have done it before when really necessary) but it's one hell of a tedious job.

Still, it shouldn't be hard to write queries to simplify the task to some extent. For example, the fake e and r and s tags could just be deleted everywhere, as could some of the others (ALIGN, SPOILER, etc).

ETA: Or it could even be done in a heavy duty code editor with a dump of the table. Notepad++ would choke on it for any large number of posts, but ConTEXT would have handled it (not sure if that's still a goer) and there are others that would do the business.

shadav

it would probably work....
I think that a lot of the url issue is due to some extensions that were installed....probably would be best to uninstall extensions and then do the conversion, probably be less issues than I'm currently having

Advertisement: