Another two great milestones over the weekend for student newspapers moving from College Publisher to WordPress. William P. Davis of The Maine Campus published an epic tome on how he migrated their CP 4 archives to WordPress MU:
The database they gave us contained almost 12,000 entries and was much to big to be handled by a program like Excel or even Access. I’m telling you right now: don’t even try. What you should do is dump the entire CSV into a MySQL database. I found the easiest way to do it was with Navicat MySQL. They offer a free trial. If you have problems, make sure you have enabled database access for your IP address. The easiest way to drop data in is to convert the CSV to an Excel file and then it will go right in using Navicat. Otherwise you might have serious problems with special characters and such. Also, I had a problem with a few spam entries (from where, I wonder?) that broke the database, but I took those out in Excel.
If manual steps aren’t your thing, then the CP Import plugin released by John Luetke could be the ticket. If you convert your College Publisher export files from CSV to XLS, it will import each entry into WordPress through the WordPress API. He reported that it took about 30 minutes to import about 50 MB of pure text for The Marquette Tribune‘s coming website. It will also reportedly add your related media as galleries attached to a post. CoPress is currently converting databases with a Python script but, if it turns out to work well, this might compel us to switch.