So you wanna migrate away from Square Space to WordPress (a more robust, customizable solution) huh?
First off, I’ll warn you this was a royal pain when it truly came down to getting the job done right, without sacrificing data loss and abandonment of all my embedded image files.
When: March 31, 2011
To: WordPress 3.0.1
Time: 30-45 min (+/-)
OS: Mac OS X (10.6)
Software: MS Excel, Apple Automator
+ TextMate (or the text editor of your choice)
The basic premiss of this solution is to get your data out of SS, pass it through TypePad as the universal translator and then import to WordPress.
* Export your blog from squarespace in Movable Type format
* Create a free typepad.com blog
* Import your squarespace blog into Typepad
* Export your blog from typepad
* Import to your custom WordPress.org website
The biggest challenge is to get your images out safely as most people lose these in the transition process described above, however I’ll explain in detail how to ensure the safety of your images.
Step by Step Tutorial:
1. Gathering Your Data
Since you’re leaving Square Space, I recommend you gather as much of your data, stats and intel from their admin interface as you can. You’ll want to make sure you do two kinds of exports…
Login to your SquareSpace.com account and export both forms of data backup.
a) First and most importantly, you’re going to need to export your blog/site content in a Moveable Type compatible format. This can be found by logging into SS and choosing “configure this page” from the Structure Editing view.
Then run the export which should download a plain .txt file to your computer appropriately formatted for Moveable Type.
b) Next, I suggest as a security measure you also export the XML version of your site just in case you find a use for it if something should go wrong. The more options you have and the more variations of your site data, the better.
From the main SS Dashboard, under the Data & Media menu you want to click on Data Snapshots. This may take up to 10 minutes so you can move on to the next step and just remember to double back and download this file later. (Note: you can only create one snapshot per day.)
c) Finally, depending on whether it’s valuable to you or not, I recommend either taking screen shots or printing some of your traffic stats to PDF for your own archive records.
2. Now for the Images
If you don’t care about your images (which I find highly unlikely, but from the number of forum posts I found online, most people seemed satisfied to just get their posts), you can skip this step. It’s a bit technical and somewhat of a hack, but it will get the job done.
How you go about this will depend on several variables such as; your technical skill, time commitment, and the number of images (or other files) you have locked up at SquareSpace.
a) Start by going to the SS Dashboard and choose File Storage from the Data & Media menu. If you have less than 20-30 files, it might just be easier to simply right click on each file and download it. (if you choose to do this, skip to step 3 below).
In my case I had over 150+ files and didn’t exactly want to spend that kind of time downloading each of them one by one. So using Microsoft Excel (or Numbers on a Mac) and a simple little automator workflow, you can quickly download the entire archive of files in a few minutes.
b) First, start by highlighing and copying the entire list of images/files from the Square Space file storage panel on their site. Then paste this into Excel/Numbers (a blank spreadsheet).
This should paste most of the data into separate columns due to the way the HTML table is laid out on their site (don’t worry if the size column is below the file names – we’ll fix that next). Delete all the columns except for the file names themselves.
You should now have a single column with either only file names or some extra rows of data (such as the size 44K, etc.) to remove this data, sort column A alphabetically and delete the non relevant data.
You should now have a nice clean list of all file names in a single column.
c) Next, you’ll need to perform a few quick excel tricks to build a simple html page with a link to each of your images on SS. Here’s the basic idea, but you can download a copy of my excel template if it helps.
Your spreadsheet will need 5 total columns (A-F) with the following data.
A = a href=”http://USERNAME.squarespace.com/storage/”
B = Your entire list of image names from the previous step.
C = “>
D = A 2nd cloned copy of your image names
E = /a> br />
Note: I left out both of the < brackets from the above code from row A and E to show the example without rendering the html in this post.
d) Now copy the entire spread sheet contents, paste into TextMate (or the text editor of your choice, TextEdit, Notepad, etc.)
Do a quick Find & Replace by copying a single TAB from between any two pieces of data and replace the TAB spacing with a blank character (meaning leave the replace field empty.) Then replace all to bring your content together and save the file as YourSite-Images.html on your desktop.
e) Now for some quick magic with Automator. This is where we turn 3+ hours of work into 3 minutes. If you’re not familiar with Automator, don’t worry, it’s simple once you know what you’re doing, and you can download my sample workflow here.
Open Automator (usually found in the root of your Applications folder). Setup the following workflow or download my example above.
Make sure you keep “Only return URLs in the same domain as the starting page” unchecked or it won’t work. If you have more than just image files you’ll need to add additional parameters to the Filter URL’s step (such as .pdf, etc.).
After customizing the workflow to suit your needs, run the script (click the play button in the top right corner.)
You’ll be prompted to create a new folder where you want to store the downloaded images. I recommend you create a folder called “storage” which will later be needed when you upload them to your WordPress web site.
Note: If you created sub-folders in SquareSpace, you’ll need to rinse and repeat step 2 as many times as necessary for each sub directory of images. Make sure you copy each of the sub directories into the same name dir and put them inside the main “storage” dir, keeping the file path structure intact.
3. Using TypePad to Translate Your Site
Now as much as this is kind of a quirky solution, it’s also the KEY to the entire operation. Assuming you don’t already have one, you’ll need to setup a free TypePad account here.
Tip: It looks like WP can now import blogs in Movable Type format directly which would eliminate the need for this step, skip to step 4 below and if that fails, you can still use TypePad.
Once setup, go to your new blog, then click on the Settings tab across the top and finally Import/Export on the side. Choose “TypePad, Movable Type, or other MTIF file” and browse to your computer to locate the original .txt file you exported and downloaded from Square Space in step 1.a.
Depending on the number of posts you have, this make take a few minutes. Once complete, you’ll then need to export your new TypePad blog.
4. Importing Your Site to WordPress
Again, assuming by now you’ve already setup a new hosting account and installed the latest build for WordPress, login to your new WP site and go to Tools > Import. Then install the “TypePad” import tool and run the import by uploading your recently downloaded export from TypePad.
You may be prompted to choose who you want all of the blog posts to be assigned to, you can either choose the admin or it will allow you to create a new user.
When it’s complete, you can preview your blog and all your pages and posts should be in order but they won’t have any images.
Note: Over 50% of our posts were embedded videos from YouTube and other sites and they moved over fine without any trouble.
5. Getting Your Images to Appear
Finally the last step… Simply copy the “storage” folder from your desktop containing all of your images into the public_html root of your WordPress site. All of the images should be referencing YourSite.com/storage/image.jpg, etc.
I’m sure there may be better ways of doing this and it’s a bit of an argues process, but in the end, at least you’ll get the job done. I’ll leave it up to you to figure out how to move your themes, css and other customizations, however if anyone has any tips or ideas, I’m open to your suggestions.
Also, if you find this information to be out of date or incorrect, please let me know so I can update it. Thanks.
* Will my comments be moved / migrated to WP?
The method I’ve outlined above does not automatically export your comments, however Rob Pickering has another variation of how to move from SquareSpace to WordPress and he mentioned that you can perform the export (from step 1.a) on each post that has comments (which may or may not include all of your posts). This would actually export all of the comments for each post you export for.
I don’t think you need to bother making a single import file either, because WordPress (3.x or above) is smart enough not to duplicate posts if you re-import the same post twice. So perhaps you could complete the steps from my tutorial and then perform the individual exports for only the posts with comments and import them as phase two.
RobPickering.com – Alternative guide – clean, concise and it get’s the job done.
TotallyUniqueLife.com – Bob Bessette on “Why I left SquareSpace for WordPress”.