Drupal to WordPress migration activity diagram

This UML activity diagram accompanies my post, Drupal to WordPress migration explained.

Drupal to WordPress migration process activity diagram

Diagram created with draw.io.

Migration steps listing

  1. Prepare tables: This is where we reset the development database tables to a known state, ready for another migration pass.
  2. Delete unwanted vocabularies
  3. Delete unwanted terms
  4. Merge terms? Yes: go to step a; No: go to step 5
    1. Create tables for each vocabulary to merge
    2. Create duplicate table for each vocabulary
    3. Make duplicate terms unique
    4. Merge terms
  5. Create tags
  6. Create categories and sub-categories
  7. Set uncategorized term
  8. Create posts from nodes
  9. Set posts and page types
  10. Associate posts with terms
  11. Update tag counts
  12. Set default category
  13. Migrate comments
  14. Migrate authors
  15. Site-specific settings and customisation: this would include WordPress site information settings and URL redirects

Philippine National Bank (Europe) plc

Philippine National Bank has been in the UK since 1986. In 2004 it needed a back-office database upgraded for new UK regulations.

My Role as a freelance

Database Developer, Feb 2004 to Aug 2004

I worked as a freelance developer upgrading Microsoft Access databases for London and Amsterdam branches. The upgrades were written in VBA and were successfully completed within tight deadlines.

Technical skills important for this role were:

  • Microsoft Access 2000
  • VBA
  • UML
  • Microsoft Windows 98 and XP

Money Transfer Company (name withheld)

This is a UK-based money transfer company with branches in the US, Canada and the Philippines. It needed a front-office application for recording remittance transactions.

My Role as a freelance

Database Developer, May 2002 to Apr 2004

As a freelance developer, I designed and developed the application, saving the client money using existing office software. The application was created with Microsoft Access and VBA. After the first development phase, I also continued to maintain it, adding new features as required.

Technical skills important for this role were:

  • Microsoft Access 2000
  • VBA
  • UML
  • Microsoft Windows 98 and XP