Importing from a legacy forum


(Kristen) #1

I am wanting to transfer Users and Posts from an antique forum. It uses SQL Server and Snitz [forum software] (which has been dead for many years …)

I’ve had a bit of a look at the import solutions offered here, and it looks like they rely on mounting a local restored database - MySQL or similar, e.g. based on phpBB - and then a Ruby script pulling the data from that DB. I’ve little familiarity with Ruby etc. but I suspect the easiest solution with my skill set would be to export existing database to something like XML / JSON etc. I could take care of converting local links into something generic that an import into Discourse was able to parse and sort out. Current forum has no attachments, so I’m just looking at Threads (with Title and Forum/Category), Original Message and Replies (nothing threaded, just chronological messages) each with a Date, Time and User.

Is this sounding doable with import tools that already exist?

Many thanks

(Sam Saffron) #2

Plenty of examples in the import scripts folder, there is no generic import tool.

It’s likely going to require a small amount of ruby hacking unless you somehow get your data into one of the forums we already have an importer for, or do a 2 phase import.

(Jeff Atwood) #3

Yes, see