Our legacy forum is implemented under Squarespace 5. I can export it as a giant XML dump, do you have any recommendations for which of the existing discourse import tools might be the most appropriate starting point ? I only need to pull in the basics like author, title, date, body – the structure is more like a blog than a forum so I’m hoping that’s going to make it easier… Any ideas? Thanks!

Hi Greg, I’ve come from the future (it’s bleak by the way, don’t ask me who won the election :grimacing:) and since you’re clearly clueless, (note to self: were you always this way?) here’s what I’d recommend: Start by taking a look at discourse/script/import_scripts at main · discourse/discourse · GitHub. There’s close to 40 importers there, and while none of them will do what you need, you can see what’s possible and generally how it’s done. You will notice they are all written in ruby. Remember how you learned ruby and thought it so amazingly great? You’re thinking at this point that it was developed by space creatures with no index fingers. Just breathe, it will come back to you over time. Most of the importers are mysql based, they’re importing directly from source forum databases because many of them are trying to suck in as many of the suck-in-able features that can be sucked. Clearly this is not what you want to do, but you’ll also notice that most of the scripts spend their time transforming data from one concept to another – you’re going to have to do that as well, so you can find some helpful tips & tricks there – and especially see what valid data is supposed to look like. There are a handful of scripts that actually process csv and xml files. Specifically, have a look at the Discus importer. It’s so right for you in a lot of ways. More specifically look at the line Nokogiri::XML::SAX::Parser.new(@parser) – aaah? aaaaaaah??? Check out the Nokogiri page too, as well, also. You’re going to like this brave new world. As you’re going through the scripts, look for def execute, that’s going to give you a quick idea of how much that particular script is going to bite-off as well as what’s basically possible to import… all the way from: [image] down to something more your speed: [image] Check out discourse/script/import_scripts/bespoke_1.rb at main · discourse/discourse · GitHub for an example of csv handling. And even check out discourse/script/import_scripts/drupal_json.rb at main · discourse/discourse · GitHub for an example of how to be a wuss and just load users because “I’m so afawaid of bweaking something!” Finally, you’re not going to find anything that’s just a giant bunch of scripted INSERT statements. So if you were hoping to leverage your awesome Excel and vi skills, it ain’t gonna happen (so maybe you should submit one. Oh you’re so lazy, I forgot that about you). That should get you pointed in the right direction. I’m off now to watch :skull_crossbones:President Camacho’s State of the Union address.:skull_crossbones: You worry too much!

Hi Sam, I got it basically working, through a mix of automated screen-scraping and whatever XML a squarespace backup coughs up, but I lost the UNIX image I was working on, and then the need for a solution evaporated a few months later anyway (they decided to just shutter the forum, not move it). So I don’t have any shareables. HOWEVER, on a totally different tangent, they’re looking at replacing a bunch of sharepoint with a forum concept and I’ve told them they should definitely host with you – so if they actually decide to change, I’m sure they will. So there’s that.

Suggestions for where to start importing an XML dump from Squarespace

Product Support

sam (Sam Saffron) March 25, 2019, 11:11pm 4

Hi Greg,

Curious what ended up happening here?

Topic		Replies	Views
Importing from a legacy forum Migration	2	1810	May 11, 2015
Easier forum migration to Discourse Feature	13	5761	April 9, 2016
Migrating legacy data from other applications Migration	5	1550	March 3, 2018
Import from self build board? Self-hosting	4	799	April 2, 2020
Importing Data to Discourse Migration wordpress	1	1544	August 24, 2022

Suggestions for where to start importing an XML dump from Squarespace

Related topics