| Author |
 Topic  |
|
depswa
Starting Member
3 Posts |
 Posted - 10 June 2004 : 02:58:20
|
I recently stumbled onto snitz through hotscripts and I was very impressed. So much that I decided to replace my old discussion board.
I finally got it up and running, but now I need to find out how I can go about transferring all the people from my old forum's database to the snitz database so that they can keep their passwords,etc.
I noticed that my password is encrypted in the snitz database and that whatever I import to the password field won't actually work as a password.
So, how can I go about importing my old database to work with snitz? I have a ton of people and it'd be impossible to add them manually?
Any help would be greatly appreciated!
Thanks!
Dan |
|
|
Tyler M.
New Member
USA
82 Posts |
Posted - 10 June 2004 : 03:33:49
|
| You could get an old copy of the database version 3.1 (not sure on the version) that was before the encryption , and then convert your info, and then do a database upgrade... |
 |
|
|
Tyler M.
New Member
USA
82 Posts |
Posted - 10 June 2004 : 03:37:51
|
You can get the older version here:
http://sourceforge.net/project/showfiles.php?group_id=8812&package_id=8895
I believe 3.1 Final does not use encryption for password, then once you convert your information over, have the Snitz forums do an upgrade with the setup.asp file.
Anyway that's my inital thoughts on the subject, someone with more wisdom might have other ideas. |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 June 2004 : 04:18:56
|
| He doesn´t mention that the old forum is Snitz !? |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 June 2004 : 10:05:12
|
| Oh yes, and Tyler is right, but this guy just found Snitz, so that makes it quite clear to me that he wants to transfer from non-Snitz to Snitz, which we all know is not easy. |
|
|
|
depswa
Starting Member
3 Posts |
Posted - 10 June 2004 : 13:54:31
|
O.K. I'll try downloading the old ver.
I know how to import CSV files to tables, so that's not a problem. I can format the CSV file to fit the fields in the member table, but I just need to know if there are any problems I'll run into like if any fields need to be generated by snitz only? I tried importing one row with the current version and didn't get an error, but when I tried to log in, the password (because of the encryption) didn't work, but everything else looked O.K. Will using the unencrypted ver. resolve this issue and allow the imported users to log in? |
Edited by - depswa on 10 June 2004 13:55:58 |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 10 June 2004 : 15:44:33
|
| If you use an older unencrypted version to import into, simply upgrade to the newest version after the import is complete and the upgrade script should hash all of the passwords for you. |
Erick
Snowmobile Fanatics
|
|
|
|
depswa
Starting Member
3 Posts |
Posted - 10 June 2004 : 16:17:59
|
| If that's all it'll take that's awesome. Is there anything I need to watch out for when I format my old database to import it into the old versions member table? Weird fields, etc.? |
|
|
|
perica
Starting Member
Canada
4 Posts |
|
|
kushalnaik
Starting Member
6 Posts |
Posted - 14 November 2004 : 22:56:50
|
| Yeah, would like to know how that went. |
|
|
|
perica
Starting Member
Canada
4 Posts |
|
|
charlton
Starting Member
26 Posts |
Posted - 04 December 2004 : 09:31:41
|
seesh....
Once the mouse snatches the cheese....g'bye!
Happens every time |
|
|
|
JLatiolait
Starting Member
12 Posts |
Posted - 07 December 2004 : 20:57:24
|
hello,
(putting the cheese back I guess...)
*Access DB
this support forum has taken me to the point i am now without needing to post any questions, so maybe i can now contribute...
i need to do as described above; i need to import about 200 records from an external db table (non-snitz) that includes userid and password. i thus need to encrypt(pw). i will install snitz 3.1 and then upgrade to 3.4.5 for this purpose.
* but first a question -- i need to add several attributes/columns to the forum_members table(3.1). will this cause problem during the Upgrade to 3.4.5 - or any other problems for that matter? if i take this route i’m sure to find myself adding more and more columns to the forum_members table.
[Note: i still don't think it's wise to create separate tables with 1:1 relationship even if the entity sets (tables) do contain sectionalized data and i will have allot of nulls in the forum_memebers table otherwise... any comments here are appreciated?]
thanks, j |
Edited by - JLatiolait on 07 December 2004 21:18:16 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 07 December 2004 : 22:50:21
|
| What kind of columns will you need to be adding? |
-Stim |
|
|
|
JLatiolait
Starting Member
12 Posts |
Posted - 08 December 2004 : 00:09:50
|
hi Da,
thanks for the quick reply.
Access 2000 - Text, Number and Memo fields.
i have an online student registration system i'm goign to integrate with snitz. snitz FORUM_MEMBERS will contain the additional student profile data.
Note: i may very well migrate this to SQL Server in the coming year.
|
Edited by - JLatiolait on 08 December 2004 00:10:38 |
|
|
|
Topic |
|
Topic Locked
