Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: PaulP on April 09, 2025, 04:13:50 PM

Title: Move text files into SMF
Post by: PaulP on April 09, 2025, 04:13:50 PM
I am building a board for about 15 people, trying to convert a bunch of text messages into a forum. I loaded a few messages in manually so I could see how the database stores them.

1) Using MyPHP, I went into the database, edited 'messages' to change a posters name and email address but it didn't affect the presentation of the message. I can't find a link in the message data that determines who posted it - is that determined by the email address or is there a hidden code somewhere

2) anyone have ideas on how to get about 400 texts into SMF?

Thanks

Paul
Title: Re: Move text files into SMF
Post by: Kindred on April 09, 2025, 07:23:36 PM
You should never edit the database directly.
The smf tables are interconnected... and the messages content and display is pulled from more than just the smf_messages table
Title: Re: Move text files into SMF
Post by: PaulP on April 09, 2025, 09:42:55 PM
I realized I forgot to change the ID of the poster, now any ideas on importing text messages?

Kindred, I understand relational databases and how SMF uses them.

Paul
Title: Re: Move text files into SMF
Post by: Kindred on April 10, 2025, 07:04:42 AM
No, seriously,  you should not edit the database directly, even if you understand relational databases

There are php functions that would create the post with the correct attributes and all the correct references... THAT is what you should be using