Archive - Forum Topics
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12604
Printed Date: 11 April 2026 at 1:20pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Archive - Forum Topics
Posted By: mbd2
Subject: Archive - Forum Topics
Date Posted: 19 November 2004 at 9:43am
|
I did a search and found no real answer so here it goes... I'm looking for a mod or need help developing a mod that will Archive old topics and convert them into html files. It would be great if in the Topic Admin to check a box that would create a html file with topic name and all data. This file would be save in a Archive Topics Directory which would have a main search able archive page. Wow, that a lot to ask for... plus, the topic would be automatically closed. Manual deletion of the topic could be preformed after a check to make sure the file was converted properly. Right now I manual closing the topic, using the print topic function to create the html file, saving the file, edit file to add a description, and post this file to a directory. I'm using a search feature that will search the files. Anybody have any ideas or have seen any features like this? This is what I have so far (test area) http://www.mbd2.com/forum/archieves/Topic/site_search.asp - http://www.mbd2.com/forum/archieves/Topic/site_search.asp Dale
------------- Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video |
Replies:
Posted By: xeerex
Date Posted: 19 November 2004 at 11:56am
|
Hmm..That seems like a lot of work. Personally, I just use the "Batch Close" and "Batch Move" in the admin module. I have a forum setup with admin-only access and hidden from everyone else. When I get ready to "archive", I just batch them over. Of course, if I want a post to remain in it's original location, I make sure and manually "sticky" or "announce" it. When I batch I simply move all the normal posts. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: mbd2
Date Posted: 19 November 2004 at 6:41pm
|
Xeerex At present my db is 13.6 mb, I'm looking to reduce its size. Yes, it has been compacted, but would I not reduce size my archiving files to html files? The reduction in db size should keep forum running faster. At lease, that is the assumption I going by. Doing a "Batch Close" and "Batch Move" doesn't reduce db size does it? Dale ------------- Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video |
Posted By: MadDog
Date Posted: 19 November 2004 at 6:52pm
|
If your database is getting big you really should upgrade to SQL since Access is not a very good database to use on a live website. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: dj air
Date Posted: 19 November 2004 at 6:57pm
|
if you want to archive into a html file so its like the print friendly version why not . make it so that the content of the friendly version is stored in a veriable then open (on server) or create an html file with its content the veriable. |
Posted By: mbd2
Date Posted: 20 November 2004 at 1:12am
|
I'm familiar with SQL but not that knowledgeable when it come to using it in a db. Is there a major conversion or just a change to the database itself. Plus do mod have to be reconfigure or is just the support files like common.asp? Dale ------------- Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video |
MadDog wrote:Posted By: mbd2
Date Posted: 20 November 2004 at 1:14am
|
Would not the data still be in the db; and the db would still be the same size? Dale ------------- Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video |
Posted By: dj air
Date Posted: 20 November 2004 at 5:52am
| you could run the method i said and have a delete query to delete the thread/topics from the database. |
Posted By: mbd2
Date Posted: 20 November 2004 at 10:29am
|
Sorry dj air misunderstood what you where saying. That would be a solution. I would like to know more about the SQL option. Since I have an Access 2000 version running, what would it take to convert? I search the forum to see if I can find anything. If anybody has any input I'm open to suggestions. Thanks Dale ------------- Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video |
Posted By: dj air
Date Posted: 20 November 2004 at 11:13am
|
up[dating does take a bit of knowlege and time. as you have to update record IDs, user IDs etc. and the same for threads. as i said a lot of work. |