Migrating users and posts from Drupal to WordPress

Few weeks ago I decided it was time to change the look and feel of Santako.com and also take the opportunity to start using a content management system that simplifies the administration. It didn’t take us very long to chose WordPress due to its versatility, high quantity of plugins available and the little maintenance required.

One of the first challenges has been to migrate the users and articles from the current version, which uses Drupal. I haven’t found any plugin that executes the migration automatically so I decided to export the data in CSV tolater import it in WordPress. The steps I’m explaining bellow were executed with Drupal 7 and WordPress 3.6. In my case, I just needed to import some basic elements from the posts, so many fields such as the author, dates and tags were not migrated.


  • Access the Drupal installation database from phpMyadmin.
  • Select the ‘users’ table.
  • Click on ‘Export’ and select ‘CSV’ as file format.
  • Once the file is generated, edit it and add the following headers in the first line, linking these to the columns (you can delete the rest of columns):
    • user_login
    • user_pass
    • user_email
  • Install this plugin in WordPress and enable it:  http://wordpress.org/plugins/import-users-from-csv/
  • Access the ‘Users’ menu and select ‘Import from CSV’.
  • Click on ‘Import’.


  • Access the Drupal installation database from phpMyadmin.
  • Click on the ‘SQL’ tab.
  • Paste the following query and click on Go’:
 FROM node
 INNER JOIN field_revision_body
 ON node.nid=field_revision_body.entity_id;
  • Install this plugin in WordPress and enable it: http://wordpress.org/plugins/wp-all-import/
  • Access the plugin from the administration sidebar.
  • Select ‘Upload File From Your Computer’  and click on ‘Next’.
  • In the following steps you will be asked to drag and drop the imported data to the fielsd they belong to and confirm some default options.

Once the import is complete, I recommend using the plugin Broken Link Checker  to make sure everything worked properly and there are no broken links.

Starting with vermiculture

Vermiculture is a very interesting practice because it allows recycling vegetable remains while creating a very good fertilizer for our plants. Yesterday we finished our homemade vermicomposter and it is fully functioning with our worms creating great compost .

Vermicompostador casero

The material we used to build the vermicomposter are:

  • 3 plastic boxes – Carrefour = 12 €
  • Tap to collect liquid in the bottom box – Leroy Merlin = 2 € (comes with 2 units)
  • 5 boxes of 20 Dendrobaena worms – Decathlon = 8 €
  • Silicone to seal the boxes – Leroy Merlin = 2 €

This is how it works:

  1. In the second tray the vegetable remains are left  and humidified regulary or soaked for 24 hours before adding them, to decompose them so worms can absorb the remainings.
  2. In the bottom tray liquids fall and can be used directly as fertilizer.
  3. In the top tray more vegetable remainings are left and once the worms finish eating what’s on the second floor, they go up to the first plant to get some more meal.

The vermicompost can be placed in the kitchen because it has no odor but remember to avoid using meat, fats, synthetic materials or citrus (worms do not like them). Also avoid having them receiving any type of lights, so be careful to cover the vermicompost with a towel or something that does not let light through.

Wwe will keep posting about how this invention evolves.

Making pesto

As the basil has grown and with the winter her  we had to prune it, Karen and I decided to try to make pesto and the result has been very good.

The recipe is very simple. Add the following to a small bowl:

  • Basil leaves (enough to nearly fill the bowl).
  • A couple of garlic.
  • A handful of nuts (pine nuts are usually added but we  didn’t have).
  • Half a coup of oil
  • A slice of cheese (parmesan ideally).

Then grind everything for a couple of minutes and the sauce is ready to enjoy with some delicious pasta or salad.



Relaxing homemade bath

Some days ago I woke up with a generous headache that grew increasingly powerful throughout the day, so when I got home I decided to take a bath and I thought I would take a look around Internet to find out how to prepare it.

I found several homemade “recipes” for people that, like myself, do not have a pantry full of oils and soaps. In the end I decided to prepare a mixure that worked quite well.

  1. Grab a couple of oranges, juice and drink it yourself. This is not really essential to the bathroom, it is important to keep the skins of oranges.
  2. Begin to fill the tub with hot water.
  3. While the tub is being filled, add:
    • 3 infusions of chamomile.
    • The orange peel cut into pieces
    • A couple of of baking soda tablespoons.

The concoction is ready to enjoy a bath scented orange that will also relax you. 20 minutes of calm and you will be left as good as new.

Rescue in Copacabana

Yesterday we were hanging out on Copacabana beach when suddenly we saw a drowning swimmer. Within seconds the rescue team appeared in a quad and 5 minutes later a helicopter was rescuing the swimmer and the guards who came to save him.

It so happens that on the same beach, in the morning, another helicopter had crashed while trying to save a swimmer.