|
|
Rank: Member
Joined: 11/19/2007
Posts: 12
Location: USA
|
I'm just about the embark on a table/field mapping exercise to import a Snitz DB into a YAF DB. I will map out the tables/fields in a spreadsheet to start with and add notes for non-direct conversions. Before I start on this, is there anyone out there who has already done this? Anybody out there interested in this if it hasn't been done?
|
|
|
Rank: YAF Developer
Joined: 1/8/2007
Posts: 1,084
Location: Heart of Europe
|
I see you found it.  When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.
|
|
|
Rank: Member
Joined: 10/17/2007
Posts: 10
|
Fused, is there anything I can help w/ ? I too and about to embark on importing snitz into yaf, maybe two heads will be better than one? let me know if you want to split up the tasks.
Thanks!
Loren
|
|
|
Rank: Member
Joined: 11/19/2007
Posts: 12
Location: USA
|
LTY38, Yes, would appreciate the help. What extra features do you have installed on your Snitz Forum that you need to port. One of the add-ins that I have is the file upload/manager which looks like it will be a challenge.
My initial thoughts about the port are to match up as many tables and fields in the 2 databases and write some T-SQL to import the data.
I've noticed that in Snitz, the dates are stored as varchar(14) and in YAF we are using a datetime field. One thing that you can immediately do if you have the time is to work out the SQL syntax for converting the Snitz string date to a datetime and post that snippet here.
Do you know of any document that describes the YAF DB structure both conceptually and in detail? That would be useful to glance over to understand the rational for the schema and for targetting the right fields.
I'm about 30% of the way through setting up a spreadsheet to map the 2 DB's but I'm finding them fairly different so it's not easy going.
Anybody reading this know of any tools that people use to map 2 tables that need to be transfered?
|
|
|
Rank: YAF Developer
Joined: 7/12/2005
Posts: 1,324
Location: on Dock Street
|
YAF DB Structure : http://forum.yetanotherf...Documentation-Here.aspx
I also found that hooking up a copy of MS Visio to the SQL Server produced some rather nice DB maps.  "It's a case of RTFM.. the only problem being we don't have a manual!" When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon )
|
|
|
Rank: Member
Joined: 10/17/2007
Posts: 10
|
I've got most the user data mapped and some of the posts via c#, the only issues (quite large) that I have is moving the passwords over, I don't believe this is going to be possible, Snitz uses SHA256 encryption where YAF uses MD5 - if anyone knows of a way of converting password hashes from SHA256 to MD5 that would be great, otherwise I believe I may have to abandon this in fear of requiring users to somehow reset their password.
One of my thoughts was to setup a seperate form where users (that are logged into snitz) can fill out a forum w/ their password that would save it in MD5 format, i'm really trying not to do this because it puts the requirement on the user which I'm not sure if they are going to be to excited to do this.. any other thoughts?
|
|
|
Rank: YAF Camper
Joined: 9/25/2006
Posts: 14
Location: Georgia - USA
|
If you are using SQL Server (or a varient like SQL Server Express) you can use SQL Server Integration Services (SSIS) to map the tables and move the data.
|
|
|
Rank: YAF Developer
Joined: 7/12/2005
Posts: 1,324
Location: on Dock Street
|
LTY83 wrote:Snitz uses SHA256 encryption where YAF uses MD5 - if anyone knows of a way of converting password hashes from SHA256 to MD5 that would be great This is not a problem with version 1.93 as you can set which hash method to use in the Membership provider. "It's a case of RTFM.. the only problem being we don't have a manual!" When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon )
|
|
|
Rank: Member
Joined: 11/19/2007
Posts: 12
Location: USA
|
Sorry for my lack of response. I only got an email today that there'd been a reply to this topic. Some good ideas here. Sounds like the password problem is solved with v 1.93. LTY83: How do you have the data mapped? By table/column name in a spreadsheet or with some other DB tool? Do you have a function for converting the Snitz string date formats to datetime objects? Thanks Mek, I'll have a look at that in Visio. Dan, I've never used SSIS but will try and find time to take a look at it today. I think we're getting closer... 
|
|
|
Rank: Member
Joined: 11/19/2007
Posts: 12
Location: USA
|
I'm trying to get more info on SSIS. Is it a separate product from MS or part of SQL Server Enterprise? Where do I find it?
|
|
|
Rank: Member
Joined: 10/17/2007
Posts: 10
|
I have it mapped in a c# application, I use a simple DateTime function i built to do the conversion on the dates. I have to tweak a couple things in regards to inserting without table constraint errors, havne't gotten that far yet but should be there soon.
|
|
|
Rank: Member
Joined: 10/17/2007
Posts: 10
|
Mek wrote:LTY83 wrote:Snitz uses SHA256 encryption where YAF uses MD5 - if anyone knows of a way of converting password hashes from SHA256 to MD5 that would be great This is not a problem with version 1.93 as you can set which hash method to use in the Membership provider. Is 1.93 available for download yet?
|
|
|
Rank: Member
Joined: 11/19/2007
Posts: 12
Location: USA
|
LTY83 wrote:I have it mapped in a c# application, I use a simple DateTime function i built to do the conversion on the dates. I have to tweak a couple things in regards to inserting without table constraint errors, havne't gotten that far yet but should be there soon. You've got further than I have. I was thinking of doing the conversion by using a number of SQL procs, one for each table, but I was still trying to associate the correct YAF tables/columns with the equivalent Snitz ones. C# does have have the distinct advantage of giving us the string manipulation power for that datetime stuff. Perhaps I can help you with some of the stuff that you're doing?
|
|
|
Rank: Member
Joined: 10/17/2007
Posts: 10
|
I may wait until I can get a copy of 1.9.3 because until then we will be screwd when it comes to password migration.
|
|
|
Rank: Member
Joined: 11/19/2007
Posts: 12
Location: USA
|
We won't be able to use the DB to log in for regular users but we should still be able to recreate 1 user and test the conversion. How did you work out which Snitz columns mapped to which YAF columns. That's the list that we really need to define.
|
|
|
| Users browsing this topic |
|
Guest (2)
|