News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Move text files into SMF

Started by PaulP, April 09, 2025, 04:13:50 PM

Previous topic - Next topic

PaulP

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

Kindred

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
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

PaulP

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

Kindred

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
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: