Print Page | Close Window

How do you import data from ver7 to ver8 ?

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=21200
Printed Date: 09 April 2026 at 3:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: How do you import data from ver7 to ver8 ?
Posted By: Mattias Nordin
Subject: How do you import data from ver7 to ver8 ?
Date Posted: 02 September 2006 at 11:53am
Hello all.
 
I have installed version 8 on my new website. Now i need to import all the posts that has been made on my old website.

How do you import data from wwForum version7 to version8 ?



Replies:
Posted By: Mattias Nordin
Date Posted: 02 September 2006 at 10:36pm
I found another thread with a link to the migration tool.
But after running the script (without errors) the result is not that good. The threads are split into duplicate topics. I have several topics with the same name in the newly created database...
 
Original database (after running the script):
http://mattiasnordin.net/web2005/forum/default.asp - http://mattiasnordin.net/web2005/forum/default.asp
 
New database:
http://mattiasnordin.net/web07/tab5/default.asp - http://mattiasnordin.net/web07/tab5/default.asp
 
For example. In the original database i had a forum topic called "Mattias webforum", after the migration to version 8 i have two forum topics called "Mattias webforum".
 
I have opend the database and compared the fields etc but it's hard to see anything wrong without debugging the code.
 
Another thing... if i open the web wiz forums control panel the forum list looks fine (!). All forums and topics are grouped as usually.
 
Could this be a bug on the "default.asp" page?
 
Please help me


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 9:21am

Hello again.

I compared the wrong version of the database yesterday. The original version 8 database and the upgraded version 7 database do NOT match.
 
For example the field Sub_ID does not exist in the tblForum table in the upgraded database (the old 7).
 
Do you have a tool to import data from the old database into the blank database instead? Then it isnt nessesary to modify the tables at all.
 
I like version 8 better then 7. It's very good!
 
Best regards
Mattias
 
RED 06-09-03: The database have the same fields but in another order. The new fields are placed in the end and you need to scroll to see them // RED


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 11:13am
You need to use the 7.x to 8.x database upgrade tool from the Web Wiz Forums download page. If you are using a migration tool then it is an un-official 3rd party tool and you should use the official upgrade tool.

What you need to do is upgrade your version 7 database to version 8 database using the official upgrade tool. Then reset the forum permissions, by editing the forum data, from the online admin area in version 8. If you follow these upgrade instructions you will find that any duplicate forums will disappear.

You should also NOT run the upgraded version 8 database with version 7 otherwise it will corrupt your database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 11:30am
Thank you for your reply Borg! You are making a good job :)
Below i have quoted the instructions available for me.
 
The pink changes is a suggestion on how to be more specific. I might not be that clever but it was not clear to me if i should put the  ‘access_update.asp’ file in my version 7 or version 8 folder (different paths on my server). I guess that what made it un-logical för me was that i downloaded and installed the version 8 at a different path on the server before i even found the upgrade tool.
 
Anyway i don't follow you... Where do i find the place to "reset the forum permissions"? I can't find any option to do that in the version 8 Admin -> control panel interface.
 
Super thanks !
 
Originally posted by Instructions Instructions wrote:

Web Wiz Forums version 7.x to 8.x Upgrade Tool v1
-------------------------------------------------

This tool comes with NO GURANTEE that it will work or will not loose,
destroy, or corrupt data in the database that is being upgraded.
USE THIS TOOL AT YOUR OWN RISK.

Modified version 7.x databases
-------------------------------
If you have modified your version 7.x database you may need to un-modify the database in order for the upgrade tool to work.
 
How to use this tool
---------------------
1. Back-up your database
2. Back up your database, this is so important I thought I had
better repeat this step.
3. To prevent errors you must ensure that no-one else access the
database during the update, the simplest way to do that is to remove
the file ‘common.asp’ from the forum directory.
4. Place the file ‘access_update.asp’ in the version 7 forum directory
5. Browse to your forum version 7 and open the file ‘access_update.asp’ in your favourite web browser.
6. Type in the connection details for your forums database into the form
fields provided.
7. Submit the form to the web server to start the update process. Once the update process is started DO NOT HIT REFERSH. As each stage of the update process is executed you will be informed. Some of these stages may take sometime so please be patient.
8. Once the upgrade is complete you will be displayed a message telling
you of this.
9. Delete the file ‘access_update.asp’ from the web server.
10. The database update will now be complete.
11. Upload Web Wiz Forums version 8 to the web server, make sure you do NOT overwrite your updated Access database file and do NOT attempt to run Web Wiz Forums version 7.x on the new updated database.
12. Run your new Web Wiz Forums version 8.

Security Notice!!!
------------------
Forum Group and Member permissions may have changed, so please check these before setting your new forum live.
 
 


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 12:06pm

I just tried once more without succeding.

This is how i do it.
 
1) Install wibwiz version8 on the path "/web07/" on my webserver. I don't want it to interfere with the "/web2002/" version of my website.
...
2) I follow the instructions above and copy the "access_update.asp"-file into the root of the webwiz ver7 folder.
...
3) I backup the database by creating a duplicate file with a different file name.
...
4) I verify that the IUSR_machinname have access rights to the access database file.
...
5) I run the "access_update.asp" file via the "/web2002/" website hosting the version 7 of webwiz.
...
6) No errors in the process. The database is modified in some way since the file size is bigger then before.
...
7) I copy the wwForum.mdb file to the "/web07/ path.
...
8) I move the file to a secure location and set the IUSR_machinename access rights on the file. I also rename the database according to your suggestion.
...
9) I open the address to the new forum (version8) on my new website ( http://mattiasNordin.Net/web07/tab5/ - http://mattiasNordin.Net/web07/tab5/ )
...
10) I log on to the forum. And i log on once more when pressing the admin link.
...
11) I check the "forum admin" page in the control panel. Everything looks fine here (but not in the actual forum).
...
12) I have tried all kind of things. Removing all the groups creted. Creating new forums and moving threads etc... but i havent found anything that removes all the duplicate topics in default.asp file view.
 
Also in the database, i dont seem to have duplicates. It looks fine in the database.
 
What is the difference on the default.asp page and on the admin_view_forums.asp page? The latest of them work.
 
I would be very glad if you could help me because i really need to keep the old posts and their dates intact.
 
Thank you.


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 12:21pm
The part you are getting wrong is it would be best to remove version 7 before attempting any upgrade.

Then use the upgrade tool to upgrade your version 7 to version 8 database, first making sure you back it up incase things go wrong.

Once this is completed with no errors, upload the version 8 files changing the path to the Access database, then login to the admin section of version 8.

Once in the admin area click on the 'Forum Deatils' page where you create forums and click on each forum in turn making sure the permissions are correct then submitting the page to the server. By doing this process it will reset the permissions for each of your forums. If you still have problems then you may need to also remove and redo any individual permissions you have set for members.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 12:31pm
By the way when I look at your version 8 forum I don't see any duplicate forums which suggests an issue with individual forum permissions.

If you still have difficulties delete all entries in the table tblPermissions, all forums will tehn disappear, but don't worry, go into the admin area and in the Forum Configuration page edit each forum and resetup all the permissions for that forum.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 1:17pm
Hello again. Thanks for the help.
 
Here are two screenshots that describes the problem.
1) http://mattiasnordin.net/forum_incorrect.gif - The incorrect default.asp view
2) http://mattiasnordin.net/forum_is_correct.gif - The correct admin_view_forums.asp
 
I will try to delete the tblPermissions to see if that helps. I'll get back to you soon. :)


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 1:40pm
I can see the problem now, it is beceuase you have not set an order number for your forums and categories.

Each category must have it's own unique order number and each forum within the category must have it's own unique order number for the forums to display correctly. eg.

Cat 1  order no. 1
Forum 1 order no. 1
Forum 2 order no. 2

Cat 2 order no. 2
Forum 3 order no. 1

Cat 3 order no. 3
Forum 4 order no. 1
Forum 5 order no. 2
Forum 6 order no. 3


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 1:40pm
You really have a bug in there somewhere :(
 
I deleted all 89 rows in the tblPermissions table and as you said, the forum seemed to be blank on the webserver.
 
I went into the control panel and started to reset the permissions. It worked as you explained untill...
 
http://mattiasnordin.net/forum_is_correct2.gif - http://mattiasnordin.net/forum_is_correct2.gif
 
... I reset the permissions on the "access database" forum. When i did that i got the same response on the default.asp page as earlier...
 
http://mattiasnordin.net/forum_incorrect2.gif - http://mattiasnordin.net/forum_incorrect2.gif
 
... suddenly i have two forums called "Mattias webforum".
 
Could it still have something to do with the permissions?
 
Would it help if i sent my database to you?
 
Best regards
Mattias
 


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 1:44pm
Please see my last reply as from your previous screen shoots I can see the issue.

It's not with the database or permissions, but simply beceuase you haven't set the order forum and categorises should display in.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 1:46pm
BINGO !
 
THANK YOU...
 
It had to do, as you said, with the forum order. If i changed the forum order to different numbers on each it works fine again.
 
THANK YOU...


Posted By: Mattias Nordin
Date Posted: 03 September 2006 at 1:51pm
If it was possible ;) ...
 
I would mark this thread as solved. Mostly i get questions in my forum and it would be good if the thread starter could mark a specifik post as the problem solver and that should also be marked in the user interface.
 
Sorry for posting in the wrong part of the forum.


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 1:52pm
Turned out to be somthing quite simple in the end, sometime you just can't see the wood through the tree 

I've not seen this issue coursed by this for along time as when you create a forum in version 8 it is automatically assigned a unique order number, whereas in version 7 it didn't because order numbers were not vital to the running of the forum.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: WebWiz-Bruce
Date Posted: 03 September 2006 at 1:57pm
Originally posted by Mattias Nordin Mattias Nordin wrote:

If it was possible ;) ...
 
I would mark this thread as solved. Mostly i get questions in my forum and it would be good if the thread starter could mark a specifik post as the problem solver and that should also be marked in the user interface.
 
Sorry for posting in the wrong part of the forum.


All topics in this support forum are resolved except maybe 1 in every 500 as nearly all issues I have come across many times, it's only when a new version is released that it takes as long as this to find the new issues users face.

If you wanted to mark topics that are solved in your own forum then version 8 allows you to place a topic icon next to a topic, this could be used to show which topics are solved.

At the moment you would need to edit the first post in a version 8 topic to display a different topic icon but the next version will allow this to be changed by clicking the 'topic admin' button at the top of a topic.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net