Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How do you import data from ver7 to ver8 ?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How do you import data from ver7 to ver8 ?
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Mattias Nordin View Drop Down
Groupie
Groupie


Joined: 30 March 2005
Status: Offline
Points: 60 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattias Nordin Quote  Post ReplyReply Direct Link To This Post Topic: How do you import data from ver7 to ver8 ?
    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 ?
Back to Top
Mattias Nordin View Drop Down
Groupie
Groupie


Joined: 30 March 2005
Status: Offline
Points: 60 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattias Nordin Quote  Post ReplyReply Direct Link To This Post 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):
 
New database:
 
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
Back to Top
Mattias Nordin View Drop Down
Groupie
Groupie


Joined: 30 March 2005
Status: Offline
Points: 60 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattias Nordin Quote  Post ReplyReply Direct Link To This Post 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


Edited by Mattias Nordin - 03 September 2006 at 12:13pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.

Edited by -boRg- - 03 September 2006 at 11:13am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Mattias Nordin View Drop Down
Groupie
Groupie


Joined: 30 March 2005
Status: Offline
Points: 60 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattias Nordin Quote  Post ReplyReply Direct Link To This Post 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.
 
 
Back to Top
Mattias Nordin View Drop Down
Groupie
Groupie


Joined: 30 March 2005
Status: Offline
Points: 60 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mattias Nordin Quote  Post ReplyReply Direct Link To This Post 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/)
...
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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.