New Snitz Conversion Script (Samuel)

Tue, 25 Oct 2005 14:13:48 GMT

Big thanks to Tom as he wrote a conversion script for users of the latest Snitz version 3.4.05 -> 2.5.5 Unicode and was kind to share his work with us. Here is what he wrote in his email:

Samuel,

Here's the package. It uses most of the stuff available on the forums but repackages it then adds some automation and my own tweaks.

I used osql and batch files to do most of the grunt work. I work off an SQL server with trusted permissions so that is how all my scripts are setup. If different access is needed the scripts can be tweaked accordingly. Also some of them are inefficient as hell but I wanted them to be flexible for deployement reasons. I run tests on a few local systems before moving to my live systems so automation is important, lol.

The readme.txt file walks you through the process and everything is in sql or bat files so it'll be easy enough to check for malicious code.
The only exe is the one I downloaded off the forums (convertSnitz.exe).

Some of the stuff I did was integrating a slightly modified transparent password transfer handler, inserting the admin and guest users, changing ownership of tables (minimizes errors and trouble later on), automating all the conversions up to the latest Unicode release and a bunch of other minor tweaks.

Also, if someone wanted to go 2.5.5 ANSI it would probably be an easy tweak since that would cut out having to build a new database and copy over all the data. The switch to Unicode portion of the conversion is handled in 3.convert.bat, everything before that would remain the same.

Any questions or problems with it let me know. I was tempted to wrap it all in a .net executable but figured this did the job and would allow people to mess with it easier so why bother. :)

Tom

error: conversion terminated (Samuel)

Wed, 12 Mar 2003 19:59:37 GMT

Mike Napurano at http://www.fxol.com reported a problem and provided a solution for Snitz conversion script. Big Thank you to Mike for the info.

The following is the problem and the solution he wrote in an e-mail:

Problem
during the conversion STEP1.SQL, I am getting:

Server: Msg 2601, Level 14, State 3, Line 1
Cannot insert duplicate key row in object ' pgd_Members' with unique index ' Login' .
The statement has been terminated.

Solution
When you delete a member from Snitz... apparently, it simply FLAGS them as deleted. It also
changes their M_NAME (Login name field) to " n/a" . This was the problem. I deleted
those users, and the script worked.

Snitz Conversion Script (Samuel)

Mon, 23 Sep 2002 00:24:41 GMT

Please note: This conversion script upgrades to Version 2.5.5 Unicode. To upgrade to the latest version 3, you will need to upgrade from 2.5.5 Unicode.

The following is the readme file of the Snitz conversion script. The conversion script is written by Gene from Ovusoft.com.

BACKGROUND
----------
convertSnitz.exe will convert Snitz topics/replies to ASPPlayground format and
update member profiles converted from Snitz to ASPPlayground pgd_members table
using Chris Kaminski' s (HomeNetHelp.com) .SQL script so that they work with
the client-side message parsing used by ASPPlayground. I took Chris' ASP-based
message conversion script and modified it to work within an EXE file so that
timeouts were not an issue when converting larger Snitz Forum' s to ASPPlayground.
I converted over 48,000 posts and updated over 18,000 members profiles using this
tool, so it does work.

DEPENDENCIES
------------
convertSnitz.exe has the following dependencies and they must be already present
on your system (no install file here, dudes):

- MSVBVM60.DLL
- MS ADO 2.6 or later (get it at http://www.microsoft.com/data)
- MS VBScript Regular Expressions 5.5 or later (get it at
http://www.microsoft.com/scripting)

Additionally, you MUST convert your FORUM_MEMBERS and FORUM_FORUMS tables to
ASP-PGD using Chris' sql script from snitz2play_v13.zip (included in the zip).
Note that this is the original script from Chris and will need modification
to support your database versions. *** convertSnitz.exe is designed to
replace Chris' STEP2.ASP program ***

SUPPORT (or lack thereof)
-------------------------
Source code is included, feel free to modify to suit your needs. This project
is unsupported, but if I' m in a good mood, I might be able to help you ;-) You can
e-mail me at gene@ovusoft.com.

HOW TO...
---------
1) Install ASP-PGD on the same server and in the same database as Snitz -- they
use different table names so there is no chance of writing over your data.

2) Shut down your Snitz forum. Delete anything from Snitz FORUM_TOPICS and
FORUM_REPLIES that you don' t want to transfer (by date, perhaps). Eliminate
duplicate member names from FORUM_MEMBERS (they can exist, use an SQL statement
to find them).

3) Modify Chris' STEP1.SQL script to match the current version of ASP-PGD' s
database and to convert any custom fields you may have in Snitz' FORUM_MEMBERS
table that you want to bring over to ASP-PGD.

4) Run the modified STEP1.SQL script (if you don' t know how to do this, you' re
going to have to figger it out on your own... HINT: Try Enterprise Manager!)

5) Run convertSnitz.exe and fill in the blanks with your username, password, etc.
Note that you can run this from any client that has access to the server, even
over a TCP/IP (Internet) connection. If you are using dial-up, though, this
might take FOREVER, as it wasn' t designed with client/server performance in mind.
It' s best to run it directly on the LAN where the server is located.

6) Click the " Convert Msgs" button -- you can pause it as it runs, expect it to
take a while if you have lots of messages. This routine is transferring data
from the Snitz topic & replies tables into the single ASP-PGD " pgd_messages"
table. It' s also converting double-quotes to prevent ASP-PGD from bombing on the
display of messages (ASP-PGD uses client-side Javascript to parse UBB-style code
and double-quotes will bomb it -- trust me on this).

7) Click the " Fix Sigs" button -- this converts double-quotes in signatures for
the same reason as in 6 above.

8) Run Chris' STEP3.SQL script.

That' s it. If you screw up anywhere along the way, simply delete all member records
with " mem > 0" in pgd_Members, all forums with " ForumID > 0" in pgd_Forums, and
everything in pgd_Messages. DO NOT DELETE ANYTHING IN SNITZ. This program doesn' t
edit Snitz data at all.

GOOD LUCK! ASPPlayground ROCKS!

The following is the readme from the original conversion script which is an essential part of the conversion process as well. This script was written by Chris from homenethelp.com

----------------------------------------------------------
SNITZ 3.3.x to ASPPLAYGROUND.NET forums conversion routine

written in one day on a LOAD of stimulants
ver 1.3

Chris Kaminski
http://forum.homenethelp.com
chrisk@homenethelp.com
-----------------------------------------------------------

This does not convert the following things
- some user data missing like start date
- moderators are not moved
- forum categories are not moved
- security and groups are not moved
- archived posts
- the ' locked status' on posts

Things that ARE converted
- users & most user info
- forums with names and descriptions
- messages with properly ordered replies!

**** NO SUPPORT PROVIDED ******
**** USE AT YOUR OWN RISK *****

==========
STEPS
==========

1) Install the aspplayground.net SQL into a new database called FORUMS with an owner of dbo

2) Go to your new aspplayground forum default page with a web browser. This will populate
the database with a few default values. If you dont do this, the next script will fail.

3) run the step1.sql in the database that has SNITZ (on the same server)

4) Edit the STEP2.ASP
a) Change the include path to your adovbs.inc
b) change your my_conn.open connect string to your DB with SNITZ
(The login must also have owner priv on the FORUMS database

5) execute STEP2.ASP - pref on the same server as the database
it may time out if you have loads of posts - set timeout if necessary

6) run STEP3.ASP in the forum database

7) PRess the UNLOAD button for the the web application
from in IIS (or reboot the IIS computer). You can' t simply
stop and start the web app.

==========
Edits
==========
You will have to manually edit the SORT column of the pgd_forums.
Sort your forums like this 1,2,3,4,5,etc for each category

==========
NOTES
==========
Posts that are from users that no longer exist get assigned to GUEST (user -1).

=============================
Chris Kaminski
http://HomeNetHelp.com
http://forum.homenethelp.com
chrisk@homenethelp.com

- accept donations through paypal at chrisk@homenethelp.com

If you are a registered customer and wish to migrate your Snitz forum, please kindly send me an e-mail to support@aspplayground.net and I will send you correct version of the software + the conversion script (the conversion script is available in our private forum)

Thank you!