New Software for Jeff Bearer.com

First it was geeklog, then it was b2evolution, and now it's drupal. jeffbearer.com is now on it's 3rd generation. And I just might start blogging again. All the old posts on here were imported from the old blog.

Importing the stories from b2evolution to drupal was fairly easy, not perfect, but easy. The work to migrate photos and the like was just not worth it. I used the Node Import module in Drupal. I exported the evo_posts table with phpMyAdmin using the following options:


Fields terminated by: =====
Fields enclosed by: "
Fields escaped by: \
Lines terminated by: =-=-=-=
Replace NULL by: NULL


Then I ran the file through several iterations of perl.


cat evo_posts.csv | perl -ane 's/\n//g;print' | perl -ane 's/=====/\t/g;print'|perl -ane 's/=-=-=-=/\n/g;print'|perl -ane 's/"//g;print'|perl -ane 's/\r//g;print' > import.csv


Then I uploaded the import.csv file into node importer and the rest was magic.