Rapidforum converter?

Started by johnofchar, January 26, 2009, 03:46:01 PM

Previous topic - Next topic

earrame

Got it. I uploaded the sql file from Rapidforum to the /simplemachinesforum folder.

Getting an 'incorrect database name' error now. Off to look for an answer in the common problems forum.

earrame

Here is the entire result:

Converting members... Unsuccessful!

This query:
SELECT
id AS ID_MEMBER, SUBSTRING(name, 1, 255) AS memberName,
SUBSTRING(name, 1, 255) AS realName, email AS emailAddress,
password AS passwd, '' AS memberIP, '' AS memberIP2, postings AS posts,
'' AS additionalGroups, emailvisible AS hideEmail, string0 AS websiteTitle,
string0 AS websiteURL, string4 AS location, string5 AS avatar,
string6 AS personalText, CONCAT(lastvisit,'00') AS lastLogin,
CASE usermode
WHEN '2' THEN '1'
WHEN '1' THEN '2'
ELSE '0'
END AS ID_GROUP, IF(string9 = 'W', 2, 1) AS gender, string3 AS birthdate,
CONCAT(signuptime,'00') AS dateRegistered, string2 AS signature
FROM `0000010923-69f50bba3d8a2349b88a63e061c3d80f.sql`.users_10923
LIMIT 0, 500;

Caused the error:
Incorrect database name '0000010923-69f50bba3d8a2349b88a63e061c3d80f.sql'

earrame

Reading this thread:

http://www.simplemachines.org/community/index.php?topic=271437.msg1776776#msg1776776

One of the suggestions sounds like a condition that is not possible in the case of Rapidforum; installing SMF in the same database.

Should I try to import my Rapidforum sql file into the SMF database? I tried putting the Rapidforum sql in it's own database on my host account. I was way out in the dark there and it didn't work anyway. That is what is shown in the previous screen capture.

Thanks :)

ThorstenE

yes, you cannot use the .sql file for the converter. you must import your rapid sql-file to a database first (this is very complicated, because the rapid dump must be cleaned before you can import it).
Is your native language german? I've written a tutorial howto import a database (in german).




earrame

My native language is English. No second language. :(

How long is the tutorial? We have a native German speaker in our community. I can ask her to translate it. What is the likelyhood of an accurate translation if she does not understand the content?

Probably better just to pay someone to clean it for us.

ThorstenE

The tutoria (attached)l is about 8 pages and you must install a MySQL-Server to clean the dump.

But I can clean your dump (for free).  PM me a link to your dump and I'll clean it and send it back to you.

earrame

Conversion successful! Thanks TE!

SMF was available in my host account applications. That install routine didn't give me the option of choosing a database. So I just imported the clean Rapidofrum dump to the existing SMF database and the converter ran fine. 8)

I have one glitch; the characters; my name for example, Eärrámë, shows up on the converted forum only as 'E'.

I also saw a forum post where everything after an apostrophy was lost. Other places the apostrophy was present. Strange.

Is the fix for this to run the converter with a different default character set? I think I read elsewhere that utf-8 is recommended?

Can I re-convert over an existing forum with a different character set or do I need to remove it and convert to an empty forum?

Thanks  8)

earrame

I just looked in the SQL table itself. My name as 'E' in the originaldatabase. It seems to me like I should be able to edit the table in SQL then run the import again to fix my name?

Perhaps my name and the odd apostrophy that is cutting off sentences are different issues?

Maybe a manual edit in the the SQL table to fix my name and a different default character set to fix the odd apostrophy that cuts off sentences.

SleePy

You could simply go to your Profile and change your username (As well as login name) to do this :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

earrame

Ok, cool beans SleePy. Thanks!

I just did that on my account. There are several others. I would rather clean it up on the conversion before I bring everyone else to the new site. But if it is more than a simple matter of re-converting with a different charset then I'll just change them myself.

So that leaves the oddball apostrophy as the main issue.

ThorstenE

I'm not sure but I think I've send you an UTF-8 coded database dump. You should install / convert your SMF to UTF-8 first, then run the rapid-forum conversion.
More infos about the UTF-8 conversion: Forum Maintenance

earrame

Thanks TE. I followed those instructions during the following steps.

1. I uninstalled SMF, database, files and everything.
2. I reinstalled SMF and went to the SQL manager to see that the database was utf8.
3. I ran the forum maintenance procedure to convert everything to utf8.
4. I imported the cleaned up Rapidforum file to the SMF database.
5. I ran the Rapidforum to SMF conversion, making sure the converter was set to utf8.

The aforementioned character issues are still present.

It looks like I will fix the usernames manually and live with the rest of the issues scattered amongst the forum posts. Maybe I'll manually correct what I can before Rapidforum goes Tango Uniform on June 1st.

I appreciate all the help and advice you have given TE. All in all I have to call it a successful conversion and I could not have made it this far without your assistance and I am greatful. 8)

ThorstenE

I can also send you a full converted SMF database dump with fixed characters. You only need to import the dump then.

earrame

How does that differ from the sql file you cleaned for me?

One of the steps I took earlier was I uploaded the cleaned sql file to a database of it's own. When I looked at the tables directly in my SLQ manager the odd characters were missing.

Where in the process are the characters being dropped? Are they present in the original dump from Rapidforum?

It would not be fair for you to spend extra time working with conversions for me if we don't have the correct characters from the Rapidfoorum dump in the first place.

Thanks again for your help and advice. :)

ThorstenE

I've checked your dump and there is a mixed charset (UTF-8 coded and latin coded characters) in it.

Example with character: É
É (utf-8 in a latin collated table)
É (latin in a latin collated table)

I have written a character-fix-script for such issues, but it's only for german umlauts. I can modify this script with your special characters. is it possible to post a list of these characters?

earrame

Very interesting. So that's why Éowyn's entire name vanished on the conversion.

That also explains a curious behavior of the Rapdiforum system; our nicknames display ok, but when someone quotes a post our name is the quote box is garbled. Exactly like your example in Éowyn's case. But that is now ancient history.

I will compile a list. Other than a handful of nicknames I don't think there are many other instances. That odd apostrophy is the only one I have seen so far.

Thanks TE!

earrame

Here's what I have found so far.

These are the characters in member usernames

É
í
á
ä
á
ë

This one is in a category title:

ú

These are the characters that I found in forum posts. A person in Denmark is that author of all the posts that contain the following characters. The apostrophy is the most trouble. It cuts off most of the things he has posted.

´
æ
å

As I was poking around the forums I found another issue. Several of the categories are not displaying the boards within them. The topic and post count is correct but the topic list shows 'No Messages'.

ThorstenE

can you post or PM me a link to your forum? I would like to analyse some of the issues first.

earrame

Just a quick note of completion. My Rapidforum to SMF conversion is complete and everything works excellent.

Anyone else out there that needs to move from Rapidforum; SMF does a beautiful job of bringing in the Rapidforum dump. This thread details the issues I encountered along the way. Nothng that the excellent support staff here couldn't easily handle. 8)

jliski

Okay, RapidForum seems to have died. I have the latest database dump downloaded from the site. Is there anyone here who could guide me throuugh setting up a SimpleMachines-forum and importing the RapidForum database there?

Advertisement: