Any chance there is going to be a Rapidform converter for Simple Machines in the near future. The Rapid database will be open March 2, 2009. Rapid shut down for good is Jun 2, 2009.
do you have access to the database then? our converters need database access (mysql) in order to work..
This is what has been posted & has gone through a German to English conversion:
John
---------------
Everything has an end times, including Rapid Forum. With nearly 10 years the project has certainly also be the longest running Internet projects worldwide, in spite of legal security crisis, which lately has not improved. After seeing more and more often by courts (greetings from Hamburg, Cologne and Grave Reuth) be personally liable for any actions taken in forums of my customers happened, I see no possibility that the project be continued in Germany. Since the project anyway since some years before hindümpelt, I have decided to completely cease. The roadmap for the careful setting of the service will look like this:
4.11.2008: A message to all the forums and in the footer in the admin area that will soon Rapid Forum is set to link to this post.
1.3.2009: Guaranteed service ends. Complete Datenbankdumps from 1.3.2009 will be in each Adminarea available. Rapid Forum will continue to run. Should there be a disaster dates technical nature, will not be restored Rapid Forum!
1.5.2009: It is again a current database backup available.
1.6.2009: Rapid Forum is finally shut.
It was fun, Rapid forum to create and keep going. A sale or publication of the source code is not in question, as many follow-on projects also partly based on this source code. Meanwhile, other forums as platforms developed long Rapid Forum. I recommend to avoid this.
Frequently Asked Questions:
Q: Why not now Datenbankdumps available?
A hacker can come from a database structure much rauslesen and possibly detect security vulnerabilities, which do not currently known. This risk, I do not. On 1.3. are all on the SQL dumps plunge and write converter.
---------------------
thanks for the information. My native language is german and I've contacted Rapidforum via email. Hopefully I have some infos about a converter soon..
Thank you very much. Eagerly waiting for reply.
John
I got an answer from the RapidForum Support.. They don't publish any database dumps before 2009-03-01. I also cannot register a testforum because they closed their registration for new users. Maybe you can send me your database dump on 2009-03-01, so I can work on a converter?
Sure I can do that. Any idea how long that might take? Got a bit of a time thing going on.
John
Quote from: johnofchar on February 02, 2009, 10:57:40 PM
Any idea how long that might take?
absolutely no, my fastest work was the thwboard converter (3 hours), other converters are more than 2 months in developement... this depends on the database layout from RapidForum.
OK thanks, understood. But do you think we'll have something before the June deadline? So far I think the Burning Board folks are the only ones that have said they will.
yes, I hope so.. the RapidForum layout looks similar to phpBB and maybe they use a similar database structure. I'll give my best ;)
That's surely all that can be asked for. Thank's for all the help. I'll contact you when the database is available.
Thanks a lot
John
Hi
I didn't want to open a new topic for that, because I'm looking for the same...
Sorry for my English, my native language is also German - that's why I'm registered in smfportal.de and not here (until today)... ;D
I really would appreciate a Rapid / SMF Converter, because it would make things easier... So I would not need to convert from Rapid to phpBB and after that from phpBB to SMF... Maybe some data could be lost by converting 2 times...
Anybody else, who is interested in a Rapid Converter??
Anyway - thanks in advance for working on that converter!!!!
Hi TE,
I don't need the converter any more as we went ahead and did it the hard way, not trusting what might happen at Rapidforum.
However, I do have the Rapid db backup (63mb) for our old forum available on our new server if you would like to take a look at it.
I can PM you the link if you like.
Regards
John
thanks John, but I allready have a dump and a Rapid to SMF Converter is also ready to use. I'll post it later, maybe some other users still need a converter.
Quote from: TE on March 03, 2009, 11:56:53 AM
maybe some other users still need a converter.
Like me. :)
you must import your old rapid database (this is the heavy part)
then the first step: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
you need two files, rapidforum_to_smf.sql (attached) and convert.php (attached to this topic: http://www.simplemachines.org/community/index.php?topic=140741.0)
Thanks TE! :D
I seem to be hung up on getting the conversion to start. Regardless of what I put in the the 'Path to SMF' box I get this same error:
You tried to access the address http://simplemachinesforum/rapid_converter/convert.php?step=1, which is currently unavailable.
I haven't a clue what to do with that as the address it's reporting isn't close to anything I am putting in the converter input boxes.
Pouring through the conversion doc here (http://docs.simplemachines.org/index.php?topic=15) hasn't yet yielded a solution.
I would be greatful for a little nudge in the right direction. :D
ok, a short step by step guide:
1) import your old rapid database.
2) install SMF Installing SMF (http://docs.simplemachines.org/index.php?board=2.0;sort=subject)
3) place the rapidforum_to_smf.sql and convert.php via FTP in the same folder as SMF was installed (Then the path to SMF is automatically detected from convert.php).
4) go to www.yourdomain.com/path_to_forum/convert.php
Ahhh, #3 looks like the hangup. I didn't have the converter in my SMF folder. I see it in the doc now. I managed to overlook that yesterday. Sorry.
Thanks! :D
No dice. Basically the same error;
You tried to access the address http://simplemachinesforum/convert.php?step=1, which is currently unavailable.
I get the exact same address that doesn't exist regardless of what is in the 'Path to SMF' box. Here's a screen cap of my input:
http://theshirefellowship.net/images/converter.png
Thanks for your help. :)
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.
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'
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 :)
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).
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.
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.
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)
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.
You could simply go to your Profile and change your username (As well as login name) to do this :)
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.
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 (http://docs.simplemachines.org/index.php?board=64.0;sort=subject)
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)
I can also send you a full converted SMF database dump with fixed characters. You only need to import the dump then.
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. :)
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?
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!
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'.
can you post or PM me a link to your forum? I would like to analyse some of the issues first.
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)
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?
Hi all!
Yesterday I convted the RapidForum-Dump successfully to SMF. Thanks a lot to TE for writing the converter!
@jliski:
Just follow the instructions posted a little bit earlier in this topic. There is a pdf that describes how to prepare the dump for further use but it's written in german (was no problem for me as my native language is german too). If that should be a problem or other trouble occurs, just leave a note ;)
kruimel
Ok. I've installed forum and I have the old rapidforum database dumb. But since I'm an absolute beginner, I have no idea how to import my dump in MySql-database. I guess I know how to create one with some sort of html-based admin panel from my host, since I managed to install the SMF.
But did I understand correctly that the next thing I should do would be importing that rapidforum dump to a database on our server?
Quote from: jliski on July 07, 2009, 04:30:09 AM
But did I understand correctly that the next thing I should do would be importing that rapidforum dump to a database on our server?
yes, exactly.