Web Wiz Support and Community Forums : Archive - Forum Topics https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:24:13 +0000 Sat, 20 Nov 2004 11:13:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12604 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Archive - Forum Topics : up[dating does take a bit of knowlege...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69949.html#69949 Author: dj air
Subject: 12604
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.
]]> Sat, 20 Nov 2004 11:13:04 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69949.html#69949 <![CDATA[Archive - Forum Topics : Sorry dj air misunderstood what...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69942.html#69942 Author: mbd2
Subject: 12604
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

]]> Sat, 20 Nov 2004 10:29:03 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69942.html#69942 <![CDATA[Archive - Forum Topics : you could run the method i said...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69925.html#69925 Author: dj air
Subject: 12604
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.]]> Sat, 20 Nov 2004 05:52:48 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69925.html#69925 <![CDATA[Archive - Forum Topics : dj air wrote:if you want to...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69915.html#69915 Author: mbd2
Subject: 12604
Posted: 20 November 2004 at 1:14am

Originally posted by dj air dj air wrote:

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.

Would not the data still be in the db; and the db would still be the same size?

Dale

]]> Sat, 20 Nov 2004 01:14:30 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69915.html#69915 <![CDATA[Archive - Forum Topics : MadDog wrote:If your database...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69914.html#69914 Author: mbd2
Subject: 12604
Posted: 20 November 2004 at 1:12am

Originally posted by MadDog MadDog wrote:

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.

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

]]> Sat, 20 Nov 2004 01:12:41 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69914.html#69914 <![CDATA[Archive - Forum Topics : if you want to archive into a...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69891.html#69891 Author: dj air
Subject: 12604
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.
]]> Fri, 19 Nov 2004 18:57:47 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69891.html#69891 <![CDATA[Archive - Forum Topics : If your database is getting big...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69890.html#69890 Author: MadDog
Subject: 12604
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.]]> Fri, 19 Nov 2004 18:52:54 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69890.html#69890 <![CDATA[Archive - Forum Topics : Xeerex At present my db is 13.6...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69889.html#69889 Author: mbd2
Subject: 12604
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

]]> Fri, 19 Nov 2004 18:41:00 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69889.html#69889 <![CDATA[Archive - Forum Topics : Hmm..That seems like a lot of...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69849.html#69849 Author: xeerex
Subject: 12604
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 adminmodule. I have a forum setup with admin-only access and hidden fromeveryone 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 makesure and manually "sticky" or "announce" it. When I batch I simply moveall the normal posts.
]]> Fri, 19 Nov 2004 11:56:26 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69849.html#69849 <![CDATA[Archive - Forum Topics : I did a search and found no real...]]> https://forums.webwiz.net/archive-forum-topics_topic12604_post69844.html#69844 Author: mbd2
Subject: 12604
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

Dale

 

]]> Fri, 19 Nov 2004 09:43:24 +0000 https://forums.webwiz.net/archive-forum-topics_topic12604_post69844.html#69844