FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » Need help transferring messages from FuseTalk
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Need help transferring messages from FuseTalk [message #24208] Tue, 19 April 2005 19:33 Go to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
We're in the process of upgrading an old FuseTalk board to FUDforum and are having some problems transferring the message archives. The FuseTalk board keeps them in a MS-SQL database format, and they've also been exported to a MS Access database, so we have them in both formats. What we need to do is get them into a format that FUDforum can use, including a way to make sure each message goes to the appropriate individual forum. Can anyone please give us some help with this?
Re: Need help transferring messages from FuseTalk [message #24215 is a reply to message #24208] Tue, 19 April 2005 22:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
FUDforum API has functions for posting messages, you can use that to import your messages.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24217 is a reply to message #24215] Tue, 19 April 2005 23:06 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
API? Not sure what that is, but can it be used to import a very large number of messages? We're talking archives going back to 1996.
Re: Need help transferring messages from FuseTalk [message #24230 is a reply to message #24217] Wed, 20 April 2005 09:46 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
FUDAPI is a script fudapi.inc.php found inside the scripts/ directory. That script has stand-alone functions to adding new topics & replies. You can use those functions to add as many messages as you like to the forum.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24245 is a reply to message #24230] Wed, 20 April 2005 15:42 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
We'll look into that. Thanks!

One more question if you don't mind. It looks like we'll be able to transfer the user data over. We've extracted it with unencrypted passwords. My biggest concern is overwriting the existing user data (since the FUD forum has been up for experimentation purposes) and losing my "admin" user. Is the "admin" user data kept in with the other user data, or is is separate? If user data is overwritten, will the "admin" user be lost? If so, is there a way to reestablish it?
Re: Need help transferring messages from FuseTalk [message #24246 is a reply to message #24245] Wed, 20 April 2005 17:13 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
All user data is kept in the same SQL table in the forum, it does not matter if the user is an admin or normal subscriber.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24254 is a reply to message #24230] Thu, 21 April 2005 00:41 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Wed, 20 April 2005 06:46

FUDAPI is a script fudapi.inc.php found inside the scripts/ directory. That script has stand-alone functions to adding new topics & replies. You can use those functions to add as many messages as you like to the forum.



Could you possibly explain how to use this in some detail? Does a program need to be written that reads up the existing data and uses their functions to add it to FUDforum?
Re: Need help transferring messages from FuseTalk [message #24258 is a reply to message #24254] Thu, 21 April 2005 09:34 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The script contains PHP functions, you call those functions with message component parameters and forums creates new messages.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24267 is a reply to message #24258] Thu, 21 April 2005 13:15 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Thu, 21 April 2005 06:34

The script contains PHP functions, you call those functions with message component parameters and forums creates new messages.


We're venturing into PHP for the first time, so please bear with us. We're trying to figure this stuff out as we go along. The new FUD forum is all set up and ready to go. The only thing holding it back is this transfer of messages from the old FuseTalk forum. BTW, FuseTalk really sucks, so I'm very anxious to replace it with FF.

Could you, perhaps, give an example of how the FUDAPI script is used somewhere?

Thanks.
Re: Need help transferring messages from FuseTalk [message #24275 is a reply to message #24267] Thu, 21 April 2005 16:37 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
There are fairly detailed comments in that script and how to use it.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24367 is a reply to message #24208] Mon, 25 April 2005 15:42 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
OK, this hasn't been very helpful, but I've found some help elsewhere. I think we'll be able to transfer the message archives OK.

Next question, we've extracted the user data with unencrypted (plain text) passwords from the old FuseTalk forum. If this data is imported into FUD forum, will the passwords work?
Re: Need help transferring messages from FuseTalk [message #24370 is a reply to message #24367] Mon, 25 April 2005 18:54 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
FUDforum does not store plain-text versions of user passwords, instead is stored the 32 character long (hexadecimal) md5 checksum of the password. As long as this value is placed correctly into passwd field for each user, old logins will work.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24483 is a reply to message #24370] Thu, 28 April 2005 16:52 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Mon, 25 April 2005 15:54

FUDforum does not store plain-text versions of user passwords, instead is stored the 32 character long (hexadecimal) md5 checksum of the password. As long as this value is placed correctly into passwd field for each user, old logins will work.


We've run into a couple of snags transferring the user data. We converted the passwords to md5 and that worked just fine, but when one attempts to log in using one of the imported usernames and passwords, an "Invalid URL" error is generated. Any suggestions for getting around this?

Also, FUD forum seems to have automatically deleted all the imported users with a message count of 0. We changed those message counts to 1 to get around this, but is there an option to auto-delete or "prune" inactive users? I have not seen such an option in the admin CP where I might be able to turn it off.
Re: Need help transferring messages from FuseTalk [message #24484 is a reply to message #24483] Thu, 28 April 2005 17:02 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The problem is that when you created the user accounts you didn't mark them as verified. This is why you may see login problems and accounts with no posts were removed.

Look inside fud_users.sql to see how to mark the account as verified.


FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24489 is a reply to message #24484] Thu, 28 April 2005 22:14 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Thu, 28 April 2005 14:02


Look inside fud_users.sql to see how to mark the account as verified.


Where do I find this? There isn't a table in the database with that name, the closest being "FUD26_users". There isn't a file by that name, the closest being "/FUDforum/sql/fud_users.tbl". Neither of these shows any field for marking users as "verified".
Re: Need help transferring messages from FuseTalk [message #24490 is a reply to message #24489] Thu, 28 April 2005 22:22 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
fud_users.tbl, has list of bitmask values and their meaning at the bottom of the file...

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24492 is a reply to message #24490] Fri, 29 April 2005 00:05 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Thu, 28 April 2005 19:22

fud_users.tbl, has list of bitmask values and their meaning at the bottom of the file...


Could it be:

# 2097152 acc_status (P/A)

If so, how and where is this set?

If not, could you please be more specific? Exactly what does need to be set where?

Please understand that we've been working on this for 5 months now, having tried out and rejected other web forum software along the way. FUD forum is the best and will work the best for our needs. We're now finally so VERY close to having this online and in use, that anything that would expedite the process would be greatly appreciated!

Thanks.
Re: Need help transferring messages from FuseTalk [message #24493 is a reply to message #24492] Fri, 29 April 2005 01:00 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
I think we can figure this out by registering and confirming a test user, then comparing that user to the imported users. We're going to try.
Re: Need help transferring messages from FuseTalk [message #24497 is a reply to message #24493] Fri, 29 April 2005 08:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
That and # 131072 email_conf (ON/OFF) is what you need. You set those options by oring (|) them to the users_opt field.

FUDforum Core Developer
Re: Need help transferring messages from FuseTalk [message #24572 is a reply to message #24497] Wed, 04 May 2005 15:04 Go to previous messageGo to next message
BobB is currently offline  BobB   United States
Messages: 165
Registered: April 2005
Location: Tucson, AZ
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
We got the user data transferred successfully.

We're now preparing to transfer the message archives. We did a test run of 160 messages this morning. They imported OK, but FUDforum sent them all to the mailing lists. I've turned off the "Synchronize Forum Posts to Mailing List" option for each of the mailing lists. We also plan to turn off the FUDforum for the transfer of the bulk of the message archives (over 100,000 messages). I'm assuming that, once the forum and the sync are turned back on again after the message import, FUDforum will not attempt to send them all to the mailing lists. Am I correct in this assumption?
Re: Need help transferring messages from FuseTalk [message #24573 is a reply to message #24572] Wed, 04 May 2005 15:36 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You are correct in your assumption.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: FUD with my own user account?
Next Topic: Ipb 1.3 to last version of FUDforum
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 11 19:42:32 EST 2017

Total time taken to generate the page: 0.00970 seconds