Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2009, 05:44 PM
peolit peolit is offline
 
Join Date: Sep 2008
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Export user posts into Excel or text file?

Anybody know a way to export user posts into an Excel, Access or text file?
Reply With Quote
  #2  
Old 01-05-2009, 07:19 PM
Bellardia Bellardia is offline
 
Join Date: Jul 2007
Location: Hamilton, Ontario
Posts: 378
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 07-11-2009, 10:47 PM
riskofficer riskofficer is offline
 
Join Date: Dec 2004
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 07-13-2009, 07:37 AM
James Birkett James Birkett is offline
 
Join Date: Jun 2009
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
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.
Reply With Quote
  #5  
Old 07-14-2009, 11:23 AM
riskofficer riskofficer is offline
 
Join Date: Dec 2004
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm, no! export from board to excel or in another words import to excel from board
Reply With Quote
  #6  
Old 07-14-2009, 12:40 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you give a bit more info on why/what/how they want this. MAybe we can think of a solution for you.
Reply With Quote
  #7  
Old 07-14-2009, 02:46 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 07-16-2009, 11:37 AM
riskofficer riskofficer is offline
 
Join Date: Dec 2004
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
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 [DATE]1247748069[/DATE] at [TIME]1247748069[/TIME] ---------------

Quote:
Originally Posted by Marco van Herwaarden View Post
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)
Reply With Quote
  #9  
Old 07-16-2009, 12:30 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #10  
Old 07-16-2009, 03:26 PM
riskofficer riskofficer is offline
 
Join Date: Dec 2004
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
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?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04701 seconds
  • Memory Usage 2,250KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete