Support Forum

SP5 Importer

MW Mike Warren
Mike Warren
Member

I just tried the beta of the SP5 importer but can’t get it to work.

After activating it I click on Forums->Importer and this page tries to load: /wp-admin/sp-import/admin/spimport-setup.php

Is that path set incorrectly in the plugin or should I be moving and renaming it from /wp-admin/plugins/SP5-Importer to /wp-admin/sp-import

29 Answers

New Answer

MW Mike Warren
Mike Warren
Member

Ah, looks like all I had to do was rename the plugin directory from SP5-Importer to sp-import.

Testing now…

MW Mike Warren
Mike Warren
Member

Using the SMF1 importer, it imported the users and created the groups and forums, but did not import any posts.

MW Mike Warren
Mike Warren
Member

I should also mention that the 4.5 importer doesn’t completely work either. Everything is imported except the posts of one forum. The other thing is that some posts are truncated. I’ll continue to play to see if I can get more clues.

MP Mr Papa
Mr Papa
Member

will have to let Andy reply when he is back tomorrow… but I can say we have hundreds or thousands of successful imports (on the 4.x importer) and only a handful of failures – usually related international characters…

if you continue to have issues, and are willing to share your db, you can email it to support at simple-press dot com for investigation…

please be sure you have a clean forum…  that is, no groups, forums and topics…  usually best to uninstall SP, then re-install and do the import… as always, keep a current db backup before importing…

MW Mike Warren
Mike Warren
Member

Uninstall -> reinstall is how I’ve been doing it.

 

My lastest test was to install PHPBB and import everything from SMF, then import to SP4.5. This solved the truncated posts issue, but not the one forum that won’t import at all.

Looks like the posts were truncating on the ‘ character by a Mexican poster. The forum that won’t import at all only has 2 posters. Myself and someone from England so I wouldn’t expect strange characters.

MP Mr Papa
Mr Papa
Member

is that a single quote or an accent character? the latter would meet my international characters… which there is a ticket open for but really need an example db to see if we can account for…

MW Mike Warren
Mike Warren
Member

I’m happy to give you access to my SMF and PHPBB admin. The posts were truncating on words like “don’t”, but not after conversion to PHPBB. The other problem remains a mystery. I haven’t been able to discover what might be different about that particular forum.

MP Mr Papa
Mr Papa
Member

no, its not access to the sites, we need, but a copy of the db… so we can try it on our local systems and try to replicate the error…

so you would need to use phpmyadmin or other and export the phpbb or smf tables…

MP Mr Papa
Mr Papa
Member

okay. thanks. Andy is in UK so gone for night… will be tomorrow earliest before he has chance to look at it…

MW Mike Warren
Mike Warren
Member

No problem. None of this is super important to me. It would be nice if I can retain the old data, but not essential.

BTW, the forum that won’t import is called BarronRiverProject.

MW Mike Warren
Mike Warren
Member

I can sort of fix the non-importing forum by moving one of the topics to another forum. Then, everything imports fine and I just need to move the topic back to its proper place in SP.

And I guess I could fix my other problem by doing a find & replace in MySQL on the character used as an apostrophe by the Mexican poster, so for me, it looks like I have a solution.

 The offending character is 0xB4 while it should be 0x27, AFAICS.

 

I’ll leave my DB as it is for the moment though, in case Andy still wants to play with it.

 

There is still the 2 issues with the current beta SP5 importer.

-Directory needs to be renamed to sp-import before it will run

-Doesn’t import any posts.

YS Yellow Swordfish
Yellow Swordfish
Member

I have re-built the zips this morning. Thanks for that.
Any chance you could give me a post table ID of one of the offending posts – just to save me hunting for it?

MW Mike Warren
Mike Warren
Member

The poster is called DLS. He is in Mexico and uses a Mac. The second post he made contains the offending character in this text:

 
HELLO…?
IS THERE ANYBODY IN THERE?
JUST NOD IF YOU CAN HEAR ME.
IS THERE ANYONE AT HOME?
COME ON, NOW,
I HEAR YOU <-truncated here

 

I am not familiar with databases but AFAICS it is in the table smf_messages and the ID_MSG is 5.