Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Conversion from Snitz Access to WebWiz MySQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Conversion from Snitz Access to WebWiz MySQL

 Post Reply Post Reply Page  123>
Author
highinfidelity View Drop Down
Newbie
Newbie


Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote highinfidelity Quote  Post ReplyReply Direct Link To This Post Topic: Conversion from Snitz Access to WebWiz MySQL
    Posted: 14 May 2009 at 8:59am

Hello everybody.

We are finally undergoing a long-awaited process to migrate from a Snitz Forums 2000 software with Access database to WebWiz Forums on mySQL.

There used to be a piece of software in .asp which did the conversion almost automatically and which used to be here:

http://forums.webwiz.net/forum_posts.asp?TID=16577&KW=convert+snitz+webwiz+database&PID=114369#114369

but is now no longer available. My first question is: does anyone still has that script, and would he be so kind to forward it to me or post it here?
 
Now to the second question: we did a lot of work on WebWiz V 7.9 like customize icons etc. (it was year 2005) but later we couldn't use the software because it was not supported by our host at the time. The question is: does the mentioned script work only to convert to V 7, so V 7 must be installed to check the results? Or it would work on V 9 as well? What problems could we find if we decide to stay stuck to V 7? I see that a lot of things have been changed from V7 to V9 (icons to say one, and the general layout of the board) and we are not positive about redisigning customized icons, reset colors etc. once a year or such.
 
Finally, there was a fellow who already did this type of conversion who at the beginning was willing to help and do the conversion for us on a very moderate wage. We have now raised funds for him but it seems I can't have a regular email or PM connection with him, so I give up. If there's anyone else who ACTUALLY did this kind of conversion, has knowledge of tricks and troubles that it implies, and is willing to help in change of some money (don't expect a huge bunch of bucks, but it's still there for you to catch...) please email me or PM.
 
Thanks a lot for reading!
Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 14 May 2009 at 10:08pm
I was one of the members who successfully made the conversion / script a long long time ago...not sure if I still have it somewhere, but I'll have a look for you.
Back to Top
highinfidelity View Drop Down
Newbie
Newbie


Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote highinfidelity Quote  Post ReplyReply Direct Link To This Post Posted: 15 May 2009 at 7:45am
Hi there and thanks a lot. I recall you being among the nicknames of that topic. DJair was another name in there, if this helps. Is it impossible to retreive that topic here in the forum? If that script went lost, that would be AWFUL news.
 
As said, we have some funds in case you may volounteer to help us in the conversion Wink
Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 15 May 2009 at 9:25am
I think this topic might help;


I've also found the script, which I've uploaded here - http://rapidshare.com/files/233182885/Snitz_WWF.zip.html

I'm not sure what version of WWF and Snitz this was for, so you may need to read through the above topic to find that bit out, or if you ask Bruce nicely, he might be able to tell you what the latest version was when the above topic was made, and hopefully send you a copy!  I would have thought Snitz would be the version they're running now, as that doesn't seem to have been updated for years LOL

I would offer to assist with the conversion, but I never get any spare time to do much now-a-days, so you may be waiting a while.  All I can suggest is backup your database, and use the backup as a trail for the conversion!  Once you're happy that the conversion is working ok after testing on a trial WWF forum, then backup your live database and go for it!

Once you're running on the old WWF version, you should then be able to follow the WWF steps to upgrade to the latest.

Hope that helps!

Oli
Back to Top
highinfidelity View Drop Down
Newbie
Newbie


Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote highinfidelity Quote  Post ReplyReply Direct Link To This Post Posted: 15 May 2009 at 1:41pm

Hello MortiOli, thank you very much. That is exactly the post to which I was referring to, thanks for finding it out again. I saved the script and all pages of the thread for future reference.

Just one last thing. If you read the very last post, at the end it mentions a problem regarding a messed up visualization of posts and reports a link (not working again) where the problem was addressed. Do you remember what was the problem and eventually how it was solved?

Thank you.

Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 15 May 2009 at 2:14pm
I think it was just issues with <br/> tags not being converted over, so you may find posts are a little squashed up.  However, posts made after your convert will be fine.

Either that, or certain characters like £, $ etc showed up as a square - this is due to a change in page encoding, but once set in WWF, they're ok.
Back to Top
highinfidelity View Drop Down
Newbie
Newbie


Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote highinfidelity Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2009 at 10:50am
Okay, thank you very much so far.
 
I uploaded all the stuff and made the first steps (at this point I was already hoping that forums were never invented Wink).
 
Config.asp stops immediately reporting a type mismatch in "Cdate". I understand this may probably be related to different ways of writing the date in US and Europe, but how can it be fixed? (That is: what format is the convert.asp expecting?)
 
Thanks.
Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2009 at 3:43pm
Just did a quick Google, and Cdate looks like it's a function to convert any date expression into a valid Date.

So 18 May 2009 will be converted to 5/18/09.

Could you post the whole error?

Cheers!
Back to Top
 Post Reply Post Reply Page  123>

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.