Skip to main content ↑ ↓
OpenImporter with SMF 2.1 ? Started by Graph · · Read 12494 times 0 Members and 1 Guest are viewing this topic. previous topic - next topic

OpenImporter with SMF 2.1 ?

This being my first post here, just wanna say Hello to all, and congratulate you for the good work!

Just installed ElkArte and the portal. I also have a test forum installed with SMF 2.1 beta2 (no Portal) which works fine, and which is by now populated with membergroups, categories, boards, topics etc. Instead of going thru all that work with the freshly installed ElkArte, can I use OI instead to bring over the data?

Best.

Re: OpenImporter with SMF 2.1 ?

Reply #1 –

Hi Graph and welcome! :)

As far as I remember 2.0 and 2.1 structure for that part is mostly the same, so OI should work (you could even select the tables you want to import clicking "advanced" in the page that asks for the settings). Honestly I never tested it in such a way, so I can't guarantee you 100% success rate... :(
Bugs creator.
Features destroyer.
Template killer.

Re: OpenImporter with SMF 2.1 ?

Reply #2 –

Hello @Graph . Welcome to ElkArte. :)

Re: OpenImporter with SMF 2.1 ?

Reply #3 –

I've also never tried it, but I assume it'll work given that the structure of things in SMF 2.1 is pretty much the same as in SMF 2.0.
LiveGallery - Simple gallery addon for ElkArte

Re: OpenImporter with SMF 2.1 ?

Reply #4 –

So I downloaded the .zip from GitHub, expanded it into a directory and then ftp'd it into the root of the ElkArte install on the server (FileZilla).

Then I ran the import.php and in the next screen I corrected the default paths. At first I entered the source db password, was rejected in the next step, then entered the destination db password (I feel this step could be presented more explicitly, but that might be just me  :) ), was accepted, looked at the long list of tables to be imported (not all applicable to my case, as my SMF 2.1 b2 is pretty much stock install, yet I changed nothing) - BUT after that:


Code: [Select]
Sorry, the database connection information used in the specified installation of your forum cannot access the installation of SMF 2.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'elkartedbusernamename'@'someip' for table 'smf_members''
error_line 329
error_file /pathtoelkarteroot/importer/OpenImporter/Importer.php

Need to add that after somewhat hurriedly looking for a OI user guide and finding none, I decided to risk it without. This is how far I got. How do I proceed from here?

Edit: I have smf 21b2 and elkarte105 hosted basically as sub-folders in a common folder where all my stuff relating to testing is installed, and this is on a shared Linux account on GoDaddy. Also, when I set up the db for smf I chose not to allow direct access. Hope these details may be of help.
Last Edit: November 01, 2015, 01:12:58 am by Graph

Re: OpenImporter with SMF 2.1 ?

Reply #6 –

Did that, and now it hangs at a diff table (smf_settings), but basically for the same reason, the elkarte db is denied access to the smf db.

Re: OpenImporter with SMF 2.1 ?

Reply #7 –

I thought I fixed that, but apparently I didn't.
Can you just give the elkarte mysql user read access to the smf database?
Bugs creator.
Features destroyer.
Template killer.

Re: OpenImporter with SMF 2.1 ?

Reply #8 –

Unfortunately, I can't. My db's are hosted on GoDaddy and at time of setup I chose not to allow direct access to them. From what I read on the web (but haven't called support tech yet), it looks like this is something that can not be changed at any other time but during initial setup. I have reasons to believe this to be so, because I logged into phpMyAdmin on GD and there is no option to add user or set privileges to the existing user - there just isn't anything relating to users, period.

So this is the plan: I will create a new SMF db and this time will allow direct access. I bet OpenImporter will work as designed. If not, then I will create a user for it and grant reading privileges.

Please stand by...

Re: OpenImporter with SMF 2.1 ?

Reply #9 –

You can install WAMP or XAMPP, download a copy of your files and import the database. You can do all the needed tests into localhost ;)
sorry for my bad english

Re: OpenImporter with SMF 2.1 ?

Reply #10 –

You're right, and that's an option I missed ;) Thanks for the wakeup call :)

I am actually using wamp to mirror my sites on localhost. But as I tried installing smf 2.1 beta2 I would get a fatal error at the last step and a few diff approaches I tried all ended up in this ditch. So my progress is slower than I expected. But it's a WIP.

Re: OpenImporter with SMF 2.1 ?

Reply #11 –

Ohh... I got it now.
Well, anyway I should try to fix again that code of mine... :-\
Bugs creator.
Features destroyer.
Template killer.

Re: OpenImporter with SMF 2.1 ?

Reply #12 –

Quote from: emanuele – Try the one attached to the first post here: http://www.elkarte.net/community/index.php?topic=2118.0

Is that the actual ipmorter, latest version? I need one soon, I'm trying to migrate another board from SMF 2.0.11 to ElkArte. Btw, do you want to be informed of the progress?

Re: OpenImporter with SMF 2.1 ?

Reply #13 –

I have to check again (it's a while I uploaded it) but I'm confident it is.
And, there is a known bug in that package: at some point of the importing process you may get an error and everything stops, but it's enough to reload the page and it starts again.
Yeah, feel fr Sure, let me know of any problem you encounter! And do some tests before converting the live instance! ;D
Bugs creator.
Features destroyer.
Template killer.

Re: OpenImporter with SMF 2.1 ?

Reply #14 –

Hm, maybe update the home page? It leads to an then maybe old importer version.

Okay, I will inform you of problems and achievements. And yes, Dad, I will work with copies.  ;D