FUDforum: Converters » Need help transferring messages from FuseTalk

Home » FUDforum Development » Converters » Need help transferring messages from FuseTalk

Show: Today's Messages :: Polls :: Message Navigator

Need help transferring messages from FuseTalk [message #24208]

Tue, 19 April 2005 23:33

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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?

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24215 is a reply to message #24208]

Wed, 20 April 2005 02:49

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

FUDforum API has functions for posting messages, you can use that to import your messages.

FUDforum Core Developer

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24217 is a reply to message #24215]

Wed, 20 April 2005 03:06

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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.

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24230 is a reply to message #24217]

Wed, 20 April 2005 13:46

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24245 is a reply to message #24230]

Wed, 20 April 2005 19:42

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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?

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24246 is a reply to message #24245]

Wed, 20 April 2005 21:13

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24254 is a reply to message #24230]

Thu, 21 April 2005 04:41

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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?

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24258 is a reply to message #24254]

Thu, 21 April 2005 13:34

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

FUDforum Core Developer

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24267 is a reply to message #24258]

Thu, 21 April 2005 17:15

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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.

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24275 is a reply to message #24267]

Thu, 21 April 2005 20:37

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

There are fairly detailed comments in that script and how to use it.

FUDforum Core Developer

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24367 is a reply to message #24208]

Mon, 25 April 2005 19:42

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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?

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24370 is a reply to message #24367]

Mon, 25 April 2005 22:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24483 is a reply to message #24370]

Thu, 28 April 2005 20:52

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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.

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24484 is a reply to message #24483]

Thu, 28 April 2005 21:02

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24489 is a reply to message #24484]

Fri, 29 April 2005 02:14

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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".

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24490 is a reply to message #24489]

Fri, 29 April 2005 02:22

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

FUDforum Core Developer

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24492 is a reply to message #24490]

Fri, 29 April 2005 04:05

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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.

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24493 is a reply to message #24492]

Fri, 29 April 2005 05:00

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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.

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24497 is a reply to message #24493]

Fri, 29 April 2005 12:19

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24572 is a reply to message #24497]

Wed, 04 May 2005 19:04

BobB

Messages: 165
Registered: April 2005
Location: Tucson, AZ

Karma: 0

Senior Member

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?

Report message to a moderator

Re: Need help transferring messages from FuseTalk [message #24573 is a reply to message #24572]

Wed, 04 May 2005 19:36

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You are correct in your assumption.

FUDforum Core Developer

Report message to a moderator

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) ] [

]

Current Time: Sun Nov 24 12:20:10 GMT 2024

Total time taken to generate the page: 0.03689 seconds