Popular forum exporters
-
@psychobunny Same issue with both 0.4.1 & 0.4.0.
After tid_10 it aborts the process. Hopefully @bentael will be along soon to assist.
-
Mo progress, mo errors. Hadn't commented
Topics.pushUnreadCount();Anyway, got through the process, now receiving this error:
[import][debug] restoring configs
[import][debug] undefined
[import][error] Something went wrong while restoring your nbb configs
[import][warn] here are your backed-up configs, you do it.
[import][warn] undefined/home/a_5mith/nodebb/node_modules/redis/index.js:516
throw callback_err;
^
Error: Error: ERR wrong number of arguments for 'hmset' commandconfig.json looks fine, so not sure what's going on.
-
@a_5mith sorry I wasn't home all day.
So, after reading this thread, i think I have an idea why this issue (in the comment) is happening, removing
--flushwill not flush your db and attempt to run NodeBB setup for you, this is designed to "pick up where you left off", however it assumes that you were successfuly able to run it at least once in the beginning for it to generatepath/to/storage/import.backedConfig. But it looks like your initial issue is whatever caused thiserror: NodeBB automated setup didn't go too well.can you tell me which OS you are using?
Also, say you do use--flushback again, (this will flush your db), the logger should've printed out a much more detailed error, I hope, see this line
could you share that part of your logs?As for speeding post imports in, like @psychobunny mentioned, you can disable the redirect stuff, but still, there is many things that NodeBB is doing, at each record creation, my future plans is to skip the NodeBB modules usage, and hit the DB directly, but that would require mimicing almost everything that the core code does, minus the fancy unnecessary stuff for the import process.
-
@bentael Hey pal, thanks for the help thus far over on git, running Ubuntu 12.04.4 on Digital Ocean VPS. What I've put in this thread is pretty much all I got. Their is a log file inside the bin folder of your plugin, but all it contains is it skipping all the topics (as they're already in the DB) and then the error I displayed at the end. If this is the one you mean I can drop it in a pastebin for you to look through, but I don't recall seeing any other logs.
On a separate note, the forum is up and running, minus a few posts etc that I'm not too concerned about as they're from sub cats, so I can put the ones I want into the main cats before I do my next export if I want them. BUT, how would you go about translating all the code entries, as it's a mixture of UTF-8, html & bbcode, I know @psychobunny made a plugin that should solve this, but it doesn't seem to do much for me. I noticed in the readme that you include some form of html-ml and bbcode-ml section, would this have to be done prior to import? (I'm going to set up another clean forum tomorrow and have another attempt at importing the database files etc to make sure everything works before I attempt a proper transfer, but from what I'm looking at so far, it shouldn't be long before I'm using nodebb long term and I can go into the list of "Who's using NodeBB"
On another separate note, with all these posts, the forum seems a little, unstable. Seems to have a heart attack if I try and change anything. But
topshows it as still responding. Could just be the amount of rubbish I've installed along side NodeBB in my "getting to know Ubuntu" phase, I'll create a new droplet when I've got the importing posts down to a tee, as I'm pretty sure I've got things installed I'm never going to use. (Ajenti being one of them) -
@a_5mith Id like to see the failed logs if you still have it, or can reproduce it again. I am missing the notifications from this thread, so i am going to paste what I said on the github issue
let's keep the conversation here, or there, but in one place please.so, .. I migrated all of your files, smoothly in 10.4 minutes, see the partial logs at the end here
As for the numbers mismatch, here what i came up with:
You have 23905p.*files in storage, so that's 23905 posts, you also have 1788t.*files so that's 1788 topics, however, when you create a TOPIC, NodeBB creates a POST for that TOPIC, as the main parent POST, which means add 1 post to each topic, hence the25693 = 23905 + 1788which is represented by25.7with the NodeBB stats widget.
This behavior is normal, however, it looks like PHPBB doesn't count the "parent" posts in its stats, that's all.
As for why have 23905 posts files and not 22.1k, I have no clue, that's pre-importer, that's exporter phase.About converting the content:
By default, the importer does not touch the content, however, there is a config setting called 'convert', you can set it to either '"convert": "bbcode-to-md"
OR"convert": "html-to-md"` and it will convert accordingly, but keep in mind 2 things:- it will impact the importer performance, and make it slower than what it already is
- the conversion is not perfect, some thing might slip through,
In your case, since you would need
bbcode-to-mdand since @psychobunny didn't do much you can these 2 things together:- use the
"convert": "bbcode-to-md"as my conversion function covers more ground then psychobunny's, no offense, but still doesn't cover everything... - go to http://localhost:4567/admin/plugins/markdown and disable the
Sanitize HTMLoption, if that solves the HTML sanitization, you can use nodebb-plugin-sanitizehtml in production to stay safe. WARNING I haven't tested this plugin for a long time, and it's probably broken__ but I will try to get it up to date ASAP.
-
so I used the
bb-to-markdownconfig and tested a run down on your data, took 10.9 minutes, then disabled the SanitizeHTML, and it looks like the content got much better, but not enough... looks like my bbToMarkdown function is not that great, ... it was based off of https://github.com/feralhosting/BBCode-To-Markdown-Converter anyways.I saw somewhere that you are using phpbb3, could by any chance the bb code be different in format? I am not a BBCode guy, so I would need some else's opinion on how to convert that to markdown
-
I saw somewhere that you are using phpbb3, could by any chance the bb code be different in format? I am not a BBCode guy, so I would need some else's opinion on how to convert that to markdown
I wrote this for phpBB2, not sure if its different for phpBB3. I could probably write another set of regexes for phpBB3 if I know all the possible cases
-
@bentael Hey buddy, I will try and find the logs, but I'm not sure where to look for them. I will try and repro today if I can't find. I remember what I did last time more or less. (Didn't uncomment that code for a start
)Turning off Sanitize HTML did fix a lot of the formatting, but as you suspected your plugin is out of date for latest version of NodeBB. Performance isn't a huge issue for me, I can leave it running if needs be, but I do have quite a few custom bbcode strings that I've added myself which I may tackle before I export from SMF.
I'm cracking on with a new node now, so I'll let you know how I get on with newer data. Few hundred more posts and a bit more knowledge.
I don't think the BBcode has changed from exporting from SMF to PHPBB3. Fortunately, most of my embeds are soundcloud based. And all I need to do with them is completely remove all the
[soundcloud]bbcode in posts. Which I can do from phpmyadmin before I import it into PHPbb so I'm only left with the URL, which the nodebb plugin already supports. -
@a_5mith https://github.com/akhoury/nodebb-plugin-sanitizehtml now supports NodeBB 0.4.x,
you're welcome
There is an "Advanced Option" that lets you write your own JavaScript to mutate the content of each post/signature, say you want to do something custom with each, enjoy the power.
-
@bentael Hey buddy, I'm running through the import again now, so far no errors. Apart from me running the script from the lib folder instead of the bin folder like a donut... I've manipulated a lot of the bbcode in phpmyadmin before importing, but I'm also running the bbcode-to-md for the more advanced bits like URLS and the like. But all my youtube & soundcloud links should be working fine. I will then install and run your plugin when the data is in and report back on my findings.
Thanks again for a cracking few plugins.
-
Me again. Quick query, any chance I can keep current passwords? They're currently encrypted with SHA-1, noticed that the passwords go over to phpbb with their conversion tool, but not nodeBB. We're a relatively anon style forum, so for a while, their was no account activation requirements, enter in a username, any email address and a password, and you were in. So sending emails out probably wouldn't work for each member, and I'd like it to be rather seamless changeover if possible.
-
@julian hm, now that is an issue.
Not sure how to tackle this one, as a lot of email addresses aren't real, they can't just reset their passwords and I don't fancy losing members because their passwords have just been changed. Anyone got any ideas on this?
-
I didn't really think about this as an issue before, but I guess it's possible to write a plugin that checks your SHA1 encrypted password vs. the phpBB password, which then brings you to a modal which asks you to enter a new password. Not totally impossible, but would require at least one new hook to be written in core (and the actual plugin itself of course).
Others who have gone through this migration process have just mass-emailed their users with the new password. IMO not too bad of a way to get inactive users to come back, if you sell yourself well in that "We're back - new and improved!" email
-
@Jedis Yupp, when I first tried converting my forum, an SMF exporter didn't exist (until I built one), so my workaround was to import into phpbb3 then NodeBB. Worked fine, only built my own to get around the bbcode ID rubbish that phpbb uses.
Edit: Might have been phpbb2... But pretty sure I used 3. The plugin officially supports 2, but assuming the table schema is the same, it shouldn't be a problem. If you wanted to be 100% sure, you could send a database to @bentael to clarify that the phpbb2 importer will work with phpbb3 too.
-
@Jedis to be honest I never had a phpbb2 db to test with, I only tested with phpbb3
If there are any missing fields from phpbb3 that NodeBB could already supports and they are not being migrated, let us know, or open an issue here:
https://github.com/psychobunny/nodebb-plugin-import-phpbb/issues but ping me in it using my github handle @akhoury -
Sorry to necro a [somewhat] old topic, however, I've not used NodeBB for sometime now (only loosely followed it's development) and I'm wondering if migration from a somewhat vanilla phpBB3 installation is more or less seamless and without any major issues. Has somebody done it with good success?
I've got a big board that was started in 2002. Emphasis on "big" -
I imported small phpbb3 database of our local students' community about 2 months ago. It took a lot of time to get it to work.
In that time:- groups weren't imported
- I had to set by hand all of privileges to categories
- attachments weren't imported
- parents categories weren't imported
- current version was doubling first post of topic, and consequently I had to back to old version of plugins (nodebb-plugin-import and nodebb-plugin-import-phpbb) and back to plugins' supported version of NodeBB
- BBCode wasn't converted properly, so I had to use about 7 regex to correct that (automatic links, quote, redundant escaping characters, emoticons)
- avatars weren't imported (and it looks like they aren't imported because of that)
