ElkArte Community

General => OpenImporter => Topic started by: cjazz on January 30, 2020, 04:52:50 pm

Title: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: cjazz on January 30, 2020, 04:52:50 pm
I am trying to change from a SMF 2.0.17 board to the latest Elkarte 1.1.6 board and have hit a few problems.

What I have done so far:
Installed the Elkarte 1.1.6 board into a new folder named elkarte and used the old forum smf database with elkarte and used "elkarte" for the table prefix.
The new Elkarte board is up and running minus any data, checked the old smf database and the elkarte prefix have been added.

I downloaded OpenImporter and created a new folder named "openimporter" in the http folder and downloaded the contents into the openimporter folder, the folder now comprises of six files and a folder named importer.

I have tried running opening http://blahblah.c0m/openimporter through a web browser and just getting a Forbidden error, so I presume I am using the incorrect path for openimporter to work? or am I doing something else wrong?
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: Jason on January 30, 2020, 10:10:58 pm
The path will be http://xyz.com/openimporter/importer/import.php

Look for the import.php file and set the path to that
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: cjazz on January 31, 2020, 06:41:02 am
Thanks. I now have access to the openimporter.
Few other questions before I carry out the import.
My current board SMF 2.0.17 also runs a simpleportal. If I decide to install simpleportal on the new elkarte board, do I have to delete the old simpleportal database files from the original SMF database? and then carry out a new installation of simpleportal?

Because the new Elkarte board is now running under a different folder i.e. "elkarte" instead of the original SMF board folder "forum", would there be any problems renaming the elkarte folder back to forum?
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: radu81 on January 31, 2020, 07:29:12 am
As far as I know there is no no importer from smf SP to Elkarte SP. I also migrated from Smf +SP to Elkarte +SP and I set up the portal from scratch, manually
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: cjazz on January 31, 2020, 08:57:50 am
Thank you
Anyone able to answer my other question?
"Because the new Elkarte board is now running under a different folder i.e. "elkarte" instead of the original SMF board folder "forum", would there be any problems renaming the elkarte folder back to forum?"
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: radu81 on January 31, 2020, 11:37:08 am
It’s possible, you need to:
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: cjazz on January 31, 2020, 07:17:57 pm
Thank you radu81 the forum is now up and running.
One more question, my database size was previously 90Mb it's now risen to 205Mb. Is it safe to drop all of the SMF prefix database files?
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: radu81 on February 01, 2020, 04:02:33 am
Before deleting anything do a backup, you'll never know...
If you delete the smf tables your smf forum will stop to work, so be sure everything is imported correctly before deleting.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: Jason on February 02, 2020, 01:05:07 am
Yes do backup and try dropping the tables else have a full copy of the site in another folder with copy database and see if dropping the tables affect the forum.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: cjazz on February 11, 2020, 10:08:30 am
I have been having a problem with some text being incorrectly displayed since I converted my smf 2.0.17 to Elkarte 1.1.6. I am sure that the problem is associated with openimporter.
I set up a test board running smf and all the text characters were displaying fine, carried out a new Elkarte installation which imported with no problems. However, the text problem has now returned on the new Elkarte board.
Please can someone help with this problem, boards been off line for a few days?
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 18, 2020, 12:46:13 pm
Does everyone migrate from smf 2.0.17 without errors? The migration of my forum stops at an error converting tables to private messages. Even if you mark them as skip (don't convert).

So, with the Converter SMF on Elkarte 1.1, there is no exact instructions here, it is posted on different topics, with different recommendations. And from the main page of the Elkarte, the link leads to an outdated Converter.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: Antechinus on September 18, 2020, 05:04:19 pm
Converters do seem to be a bit of a mess, either for SMF or for Elk. Every thread I've read about them seems to mention problems.

Are you trying to convert to Elk 1.0 or Elk 1.1? I think the converter works best if you convert to 1.0, and then upgrade it to 1.1 once it is running on Elk.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 18, 2020, 05:52:07 pm
Quote from: Antechinus – Are you trying to convert to Elk 1.0 or Elk 1.1? I think the converter works best if you convert to 1.0, and then upgrade it to 1.1 once it is running on Elk.

I downloaded the latest version of the migrator from github. There is a choice of version Elk 1.1.
The post with the link was found here: https://www.elkarte.net/community/index.php?topic=4868.msg40208#msg40208

For an example.
I liked how another converter works: from SMF to wpForo. There was no error when converting the database.
https://wpforo.com/docs/root/migrate-to-wpforo/
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 21, 2020, 10:04:18 pm
Results of a simple experiment.

Empty SMF 2.0.17 downloaded from simplemachines.org, and installed in the main directory of the test site.
The elkarte folder is also created there. An empty ElkArte 1.1.6 downloaded from github and is installed in this folder.
Smf_ and elkarte_ were created in the database.
The openimporter folder was created. Openimporter with github https://github.com/OpenImporter/openimporter  is uploaded to this folder.
Launching the importer: /openimporter/import.php
Error! Table membergroups.

(Link-6607)

OK, go back 1 step and start the importer. Table membergroups skipped.
Error! Table memberdata to custom fields.

(Link-6609)

Then the errors continued.

Error! Table custom fields data.

(Link-6611)

Error! Recalculating statistics.

(Link-6613)

There was nothing more to skip.  :D

I remind everyone that the SMF 2.0.17 was clean after installation.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 23, 2020, 07:30:17 pm
Quote from: Antechinus – Are you trying to convert to Elk 1.0 or Elk 1.1? I think the converter works best if you convert to 1.0, and then upgrade it to 1.1 once it is running on Elk.

Convert to Elk 1.0 - the same problem with errors when converting tables membergroups and then https://www.elkarte.net/community/index.php?topic=5746.msg41168#msg41168

Error "Recalculating statistics" it always appears, it does not depend on the check-box "skip".
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: Antechinus on September 24, 2020, 04:49:58 pm
Sounds like fun. :)
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 24, 2020, 10:56:21 pm

Yes, it is extraordinary that the Converter does not work even if you skip almost all the tables database on the newly installed empty SMF 2.0.15 or 2.0.17. But what should I do?  :)
So I can't migrate from SMF to ElkArte.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: ahrasis on September 25, 2020, 01:20:43 am
Based on my readings, somewhere 8 months ago, OI works in importing data from a "fully functioning" (not newly installed) SMF 2.0.17 to EA 1.1.6.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 25, 2020, 10:13:22 am
Quote from: ahrasis – Based on my readings, somewhere 8 months ago, OI works in importing data from a "fully functioning" (not newly installed) SMF 2.0.17 to EA 1.1.6.

This is easy to check. Install an empty SMF and try to convert it to Elkarte 1.1.6.
If you do this successfully, it means that the problem is not in the converter.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: tino on September 25, 2020, 01:55:41 pm
Quote from: forumovod –
Quote from: ahrasis – Based on my readings, somewhere 8 months ago, OI works in importing data from a "fully functioning" (not newly installed) SMF 2.0.17 to EA 1.1.6.

This is easy to check. Install an empty SMF and try to convert it to Elkarte 1.1.6.
If you do this successfully, it means that the problem is not in the converter.

I can convert it ok from SMF 2.0.17 to Elkarte 1.1.6 with no issues. Just taken the latest download of each today. Also the master branch of the openimporter and it works without error.

MySQL version: 10.1.45-0+deb9u1
PHP: 7.4.10 (apache2handler)

Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 25, 2020, 03:53:59 pm
Quote from: tino – I can convert it ok from SMF 2.0.17 to Elkarte 1.1.6 with no issues. Just taken the latest download of each today. Also the master branch of the openimporter and it works without error.

Please give detailed instructions on how you converted and a link to the working converter.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: tino on September 25, 2020, 04:04:38 pm
Sure...

1. Install SMF 2.0.17
2. Install Elkarte 1.1.6
3. Download OpenImporter from https://github.com/OpenImporter/openimporter
4. Extract OpenImporter to Elkarte 1.1.6 Directory
5. Run importer/import.php
6. Follow Instructions
7. Import Complete
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 25, 2020, 05:11:41 pm
Quote from: tino – 1. Install SMF 2.0.17
2. Install Elkarte 1.1.6
Do you install databases SMF and Elkarte with prefixes in common database?

Quote from: tino – 4. Extract OpenImporter to Elkarte 1.1.6 Directory
Extract OpenImporter in the Elkarte directory? Or in a separate folder?

(Link-6618)
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: tino on September 25, 2020, 05:23:12 pm
Quote from: forumovod –
Quote from: tino – 1. Install SMF 2.0.17
2. Install Elkarte 1.1.6
Do you install databases SMF and Elkarte with prefixes in common database?

Yes

smf_
elk_

Quote
Quote from: tino – 4. Extract OpenImporter to Elkarte 1.1.6 Directory
Extract OpenImporter in the Elkarte directory?

Where Elkarte was extracted to, although I just tested and that doesn’t really matter just a web accessible location works on the same server as the other two installs.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 25, 2020, 05:33:02 pm
Quote from: tino – smf_
elk_
Where Elkarte was extracted to, although I just tested and that doesn’t really matter just a web accessible location works on the same server as the other two installs.

It remains only to ask you to attach the working converter here))
Otherwise, I do not know why I do the same, but the converter can't find any fields in the tables.

By the way, I observe this effect: the converter resets at 0 the SMF database even if it stops in error. You have to restore the database after each error.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: tino on September 25, 2020, 05:36:01 pm
I’ve given the link above.

Run through it and follow the instructions, pay attention to the to and from fields and make sure you have them the correct way round.
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 25, 2020, 05:41:23 pm
Quote from: tino – Run through it and follow the instructions, pay attention to the to and from fields and make sure you have them the correct way round.

And then I said to myself: Get killed and not get up!))
In the converter, you had to specify the path not the root directory, but the folder elkarte:
Path to destination:  .../elkarte/

Finish!
(Link-6620)
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: Antechinus on September 26, 2020, 04:36:48 pm
I assume this is Russian for FMD. :D
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: ahrasis on September 26, 2020, 06:42:45 pm
I think now he got it right. Congrats... ;D
Title: Re: SMF 2.0.17 to Elkarte 1.1.6 - openimporter query?
Post by: forumovod on September 26, 2020, 08:16:04 pm
Somehow it happened))

(Link-6622)