I have just installed and got ElkArte running and now wish to import data from my old phpbb forum on the same host. I found OpenImporter and am now stuck as there are no instructions. I assume it needs installing on my host? could some kind soul please point me in the right direction?
Hello and welcome to elkarte!
I did not test Openimporter with a phpBB forum, but should work, the steps you need to do are:
- do a full backup of your files and database. The importer should not overwrite your files or your database but it's always better to have a backup.
- download Elkarte 1.0.10 (the latest version of 1.0 series) https://github.com/elkarte/Elkarte/archive/v1.0.10.zip
- install elkarte 1.0 into your forum, let's say yourdomain.com/elkarte . I wasn't able to use openimporter with different databases, so I installed elkarte into the same database of the source forum, but using a different table prefix.
- download, unzip Openimporter and then upload it to your server, let's say yourdomain.com/openimporter
- point your browser to yourdomain.com/openimporter and start the import
- once your forum is imported you can update to elkarte 1.1.x
Let us know if it works for you or if you have problems.
Morning! Thank you. In the meantime I managed to work it out and can now run OpenImporter thanks.
It is asking for the database password. I tried several such as my cPanel login and host login passwords but no go. So I foolishly changed the database password in cPanel. It didn't show what the old password was and the new one I entered didn't work in OpenImporter anyway! :-[
So I am stuck. I've asked my Hosts support about the password but not got a reply as yet. The program does say to look in settings.php for the password but where to find that file? And anyway it will be encrypted won't it?
You can always check your forum database login and password in the Settings.php file.
Yes but where is the settings.php file please??
Root of your forum.
Just rereading Radu81's reply I realised he means I have to have Elkarte installed to the same phpbb database but using its own prefix. Ah. It's already installed with its own database and is in use.
So if I installed a tempoary Elkarte and ran openimport, could I then import that into my production Elk?
There must be a way of getting the phpbb data into elk without writing a fullblown SQL query which is beyond me anyway!
try this tutorial - https://www.elkarte.net/community/index.php?topic=5170.0 It is for MyBB, but the steps are same.
"Now enter the database password of ElkArte (if you don’t remember, get the password from settings.php)"
That's great Jason but it means I would then have two Elkarte databases - my production one and the imported one. Now how would I merge the two please?!
sorry i don't have any idea. Wait for the experts.
Okay, here we are.
Long lasting problem: merging two forums.
Merge two Elk installs is not entirely so easy.
OpenImporter doesn't really help on this, because the script is developed considering the need to import from an existing forum platform to a new install of another platform. So one of the first things that OI does is to wipe out any data from the destination database.
Assuming you would be good enough to have a merge of the posts (i.e. no personal messages) the cleanest way to "merge" two forums would be to take each message from the "source" database and create an entirely new post in Elk (to ensure consistency of the database), then update the necessary fields (like time of creation).
Assuming this can be done somehow easily, this approach would have quite a drawback: in ElkArte both messages and topics are sorted by the "id" of the topic (not by the data of creation), the design choice was taken a looooooooooooong way ago because the key is supposed to always be representative of the position of the topic in the time-based order and this saves the creation of an index ensuring the best performances.
I proposed a while ago to drop this requirement (i.e. add an index to the time columns of topics and messages tables and sort by that) because nowadays, space is cheap and the performance loss is risible (in fact it would be the additional time necessary when a topic/post is created in order to update an additional index). But honestly I didn't invest much time, because the only advantage would be exactly this: be able to merge two forums without many side-effects. And this is not really a frequent case. Annoying for the one facing the situation, indeed, but still a quite limited problem.
I think the merging script could be sorted out somehow, in theory it could even be possible to merge two existing forums into a third preserving the sorting, it's a bit more complex, but it's not impossible.
try this if you want to. First install phpbb in yoursite.com/phpbb and import your old database into phpbb. Once done, install Elkarte in the root (yoursite.com) and use open importer to import your old phpbb post from yoursite.com/phpbb.
@Jason thanks for the suggestion. It seems OI has to be in the same directory as the forum then. I'll look at that, thanks.
@emanuel you have clearly given my transfer issue a lot of thought. Thank you. My skills are limited as regards databases. I wonder if I wouldn't be better off using a free relational database manager on my PC to simply extract the actual post contents and make them available to my users as a read-only archive as it is the content itself they want. Pity Microsoft Access isn't still around, I could use that!
hmm... let me think a bit, something is going in circle in my mind and I have a foggy idea, but I have to clear it up a bit.