SMF Support > Converting to SMF

Converting from Snitz

<< < (2/2)

17acklen:
webewitch & PaulP,

I don't remember exactly what I did to solve it because I deleted the conversion files after I finished.  But I think I remember enough to get you started. 

First, the forum I converted used an MS Access database that stored R_DATE as a string.  I had to import the Access db into mysql and then I converted R_DATE to a date type field - it should be in the form of YYYY-MM-DD.  In the snitz_to_smf.sql file in the "Preparing Conversion part 1" section, I changed R_DATE to UNIX_TIMESTAMP(R_DATE) to get it to an integer.  I also think that I may have gone down to the "converting posts" sections of the .sql file and removed a "FROM_UNIXTIME()"... but I'm not sure.  I think you will need to do the same thing with T_DATE in the "Preparing Conversion part 2" section.

Hope that helps you out.

webewitch:
17acklen, many thanks for your reply. I have moved on a little further, it now moves on to the 'Converting...Preparing Conversion (part 1)...' part but seems to be just hanging here.
Does this part take a while, ie. should I wait or is it quite fast? Thanks again for your time on this

17acklen:
My conversion only took 10 minutes or so (once I got it to run without errors) but I was only dealing with 50,000 posts.  If you are into the millions, I suppose it could take a while.  I remember reading about conversions that took several hours during my online searches.  Mine never hung up without an error message though.

Navigation

[0] Message Index

[*] Previous page