Export user posts into Excel or text file?

[peolit]

Anybody know a way to export user posts into an Excel, Access or text file?

[Bellardia]

If you export the table from phpMyAdmin as a .sql file, you can open it in any plaintext editor.
phpMyAdmin also supports exporting the files in the formats of Excel, Word and XML.

If you export as .sql (recommended if you want to re-upload it somewhere else). I'd recommend opening it in WordPad instead of Notepad, since it tends to format the information better.

The table is "TABLE_PREFIX".post but note that this only contains posts. If you're doing it as a backup I'd recommend backing up at least "TABLE_PREFIX".thread as well.

[riskofficer]

How can forum members import user posts into an Excel, or maybe .txt? I mean, I need something that help my users import threads from my board? Is anything like this already done? Sorry my english.

[James Birkett]

You want your users to be able to import threads into your forum database? Strange request... also very unsafe. Giving other users the ability to inject into your database is just asking for SQL exploits in my opinion :rolleyes:
It's not available as a default feature (unless you give them admin privileges), although you could probably whip up a PHP script to do so.

[riskofficer]

hmm, no! export from board to excel or in another words import to excel from board

[Marco van Herwaarden]

Can you give a bit more info on why/what/how they want this. MAybe we can think of a solution for you.

[Lynne]

There is a modification that allows you to download a thread as a text file. I'm sure if you searched on "download*" or "thread*" in "all mods" "titles only" that you could find it.

[riskofficer]

There is a modification that allows you to download a thread as a text file. I'm sure if you searched on "download*" or "thread*" in "all mods" "titles only" that you could find it.

thank you, this is good mod, but it can download only thread content (posts), but not forum content (threads), anyway thanks!

--------------- Added 1247748069 at 1247748069 ---------------

Can you give a bit more info on why/what/how they want this. MAybe we can think of a solution for you.

because in my forum there is external database of operational risks, forum members post new threads, each of the thread is operational risk accident

now, because lots of members and new threads everyday, it is hard to copy-paste from forum to excel this base

it will be easier to download threads, with names (because name of thread is name of accident) and content (posts, because posts are description of accident)

[Marco van Herwaarden]

Is it really needed to move to Excel? Is it not possible to read the data directly from teh database. Not sure, but Excel might even be able to read from MySQL.

[riskofficer]

Is it really needed to move to Excel? Is it not possible to read the data directly from teh database. Not sure, but Excel might even be able to read from MySQL.
my forum on the host by hosting provider, how can Access or Excel connect to my forum's MySQL?

[Marco van Herwaarden]

Well that depends if your host allows to make a connection from an external source to the database.

[riskofficer]

Well that depends if your host allows to make a connection from an external source to the database.

my host allows this, but this is admin access not user, I mean if you connect via ssh to mysql, this will be admin access. And as you understand this is not the solution. Because I need give access to users. Thank you.