Description

This plugin migrates articles, stories, pages, categories, tags and images from Drupal to WordPress.

It has been tested with Drupal 4, 5, 6, 7, 8 & 9 and WordPress 5.8. It is compatible with multisite installations.

Major features include:

migrates the Drupal articles
migrates the Drupal 6 stories
migrates the Drupal basic pages
migrates the Drupal categories
migrates the Drupal tags
migrates the Drupal images
uploads all the posts media in WP uploads directories
uploads external media (option)
modifies the post content to keep the media links
resizes images according to the sizes defined in WP
defines the featured image to be the first post image (option)
keeps the alt image attribute
modifies the internal links
compatible with the MySQL, PostgreSQL and SQLite Drupal database drivers

No need to subscribe to an external web site.

Premium version

The Premium version includes these extra features:

migrates the comments
migrates the authors
migrates the administrators
migrates the users
migrates the custom post types
migrates the custom taxonomies
migrates the custom fields
migrates the custom users fields
migrates the users pictures
migrates the navigation menus
migrates the blocks as inactive widgets
authenticates the users with their Drupal passwords
SEO: redirects the Drupal URLs to the corresponding WordPress URLs
ability to not import some data
ability to import only specific node types
imports and replaces the Image Assist shortcodes
imports the images managed by the Image Attach Drupal module
imports the nodes relationships
imports the Drupal 8 Media entities
imports the Drupal Media
imports the Video Embed fields

The Premium version can be purchased on: https://www.fredericgilles.net/fg-drupal-to-wordpress/

Add-ons

The Premium version allows the use of add-ons that enhance functionality:

CCK Custom Content Kit
Meta tags
Location custom fields
Ubercart store
Drupal Commerce store
Name custom fields
Addressfield custom fields
Internationalization
NodeBlock fields
EntityReference relationships
Media Provider (S3, SoundCloud, YouTube media)
Forum
Field collections
Paragraphs
Domain Access
Countries
Profile2 user fields
Entity Embed

These modules can be purchased on: https://www.fredericgilles.net/fg-drupal-to-wordpress/add-ons/

Translations

English (default)
French (fr_FR)
other can be translated

Screenshots

Parameters screen

Installation

Install the plugin in the Admin => Plugins menu => Add New => Upload => Select the zip file => Install Now
Activate the plugin in the Admin => Plugins menu
Run the importer in Tools > Import > Drupal
Configure the plugin settings. You can find the Drupal database parameters in the Drupal file sites/default/settings.php

FAQ

I get the message: “[fg-drupal-to-wp] Couldn’t connect to the Drupal database. Please check your parameters. And be sure the WordPress server can access the Drupal database. SQLSTATE[28000] [1045] Access denied for user ‘xxx’@’localhost’ (using password: YES)”

First verify your login and password to the Drupal database.
If Drupal and WordPress are not installed on the same host:
If you use CPanel on the Drupal server, a solution is to allow a remote MySQL connection.
- go into the Cpanel of the Drupal server
- go down to Database section and click “Remote MySQL”
- There you can add an access host (WordPress host). Enter the access host as the SOME-WEBSITE-DOMAIN-OR-IP-ADDRESS and click add host.
Another solution is to copy the Drupal database on the WordPress database:
- export the Drupal database to a SQL file (with phpMyAdmin for example)
- import this SQL file on the same database as WordPress
- run the migration by using WordPress database credentials (host, user, password, database) instead of the Drupal ones in the plugin settings.

I get this error when testing the connection: “SQLSTATE[HY000] [2002] Connection refused” or “SQLSTATE[HY000] [2002] No such file or directory”

This error happens when the host is set like localhost:/tmp/mysql5d.sock
Instead, you must set the host to be localhost;unix_socket=/tmp/mysql5d.sock

The migration stops and I get the message: “Fatal error: Allowed memory size of XXXXXX bytes exhausted” or I get the message: “Internal server error”

First, deactivate all the WordPress plugins except the ones used for the migration
You can run the migration again. It will continue where it stopped.
You can add: define('WP_MEMORY_LIMIT', '512M'); in your wp-config.php file to increase the memory allowed by WordPress
You can also increase the memory limit in php.ini if you have write access to this file (ie: memory_limit = 1G). See the increase memory limit procedure.

The media are not imported

Check the URL field that you filled in the plugin settings. It must be your Drupal home page URL and must start with http:// or https://

The media are not imported and I get the error message: “Warning: copy() [function.copy]: URL file-access is disabled in the server configuration”

The PHP directive “Allow URL fopen” must be turned on in php.ini to copy the medias. If your remote host doesn’t allow this directive, you will have to do the migration on localhost.

I get the message: “Fatal error: Class ‘PDO’ not found”

PDO and PDO_MySQL libraries are needed. You must enable them in php.ini on the WordPress host.
Or on Ubuntu:
sudo php5enmod pdo
sudo service apache2 reload

I get this error: PHP Fatal error: Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’

You have to enable PDO_MySQL in php.ini on the WordPress host. That means uncomment the line extension=pdo_mysql.so in php.ini

Does the migration process modify the Drupal site it migrates from?

No, it only reads the Drupal database.

I get this error: Erreur !: SQLSTATE[HY000] [1193] Unknown system variable ‘NAMES’

It comes from MySQL 4.0. It will work if you move your database to MySQL 5.0 before running the migration.

I get this error “Parse error: syntax error, unexpected T_PAAMAYIM_NEKUDOTAYIM”

You must use at least PHP 5.3 on your WordPress site.

I get this error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

It is a compatibility issue with your version of MySQL.
You can read this post to fix it: http://forumsarchive.laravel.io/viewtopic.php?id=8667

None image get transferred into the WordPress uploads folder. I’m using Xampp on Windows.

Xampp puts the htdocs in the applications folder which is write protected. You need to move the htdocs to a writeable folder.

Do I need to keep the plugin activated after the migration?

No, you can deactivate or even uninstall the plugin after the migration (for the free version only).

My screen hangs because of a lot of errors in the log window

You can stop the log auto-refresh by unselecting the log auto-refresh checkbox

Don’t hesitate to let a comment on the forum or to report bugs if you found some.

Reviews

Andrew September 21, 2021

В третий раз с третьим сайтом пытаюсь. Что-то делает, быстро, несколько секунд. И ничего. Несколько страниц без текста только заголовок. Записей вообще нет. Результат — нуль. Не теряйте времени.

newsspider September 8, 2021

This plugin did a fantastic job of transferring a complex Drupal site over to WordPress. The author provided good support and helped me to resolve any issues that I encountered. Recommended!

spinelinfi March 23, 2021

Perfect plugin to migrate content from drupal to wordpress, but you need the premium version to have all the content (and two more related plugins that are also paid). The support is great in premium version, I received the answer in less than 5 minutes! 🙂

Denis Jallet March 4, 2021

Perfect plugin to migrate data from Drupal. Perhaps you will need the paid version if you use some advanced Drupal features but it worth it. Support is great too.

agnieszkaskuza February 23, 2021

Helped me to save a lot of time!

jaybee1956 February 5, 2021

Frederic did a really great job. One caveat dough. It is not 100% useful, about 98%. To get 100% you'll have to open your wallet again to purchase some additional extensions. Very commercial but consumerunfriendly. If you propose a solution, don't trick you customer in paying more to achieve his goal, regardless of your promises.

Read all 82 reviews

Contributors & Developers

“FG Drupal to WordPress” is open source software. The following people have contributed to this plugin.

Kerfred

Translate “FG Drupal to WordPress” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

3.8.1

Fixed: Images surrounded with a link were not imported in the content

3.6.0

New: Add a spinner during the AJAX actions

3.4.3

Fixed: Some variables were not escaped before displaying

3.4.1

Fixed: Wrong plural terms
Tested with WordPress 5.8

3.2.0

New: Display the reference of the Drupal entity when a media can’t be downloaded

3.1.0

New: Add the hook “fgd2wp_modify_links_in_content”

3.0.4

Fixed: Images containing spaces were not replaced in the post content

3.0.2

New: Add the hook “fgd2wp_set_plugin_options”
Tweak: Refactoring

3.0.0

New: Add the “map_taxonomy” function
New: Add the “fgd2wp_pre_dispatch” hook
Tweak: Rename “convert_node_type” by “map_post_type”

2.40.0

New: Log a message during internal links modification
Tested with WordPress 5.7.2

2.39.0

New: Check if we need the Geodata add-on
Tested with WordPress 5.7.1

2.38.1

Fixed: Media containing % were not imported
Fixed: The Metatag add-on warning was not displayed for Drupal 8 databases

2.38.0

Tested with WordPress 5.7

2.37.0

Tweak: Remove the “wp_insert_post” that consumes a lot of CPU and memory

2.36.0

New: Make the plugin more generic to be able to import the data that are not in the “node” table
Tested with WordPress 5.6.2

2.35.0

Tested with WordPress 5.6.1

2.34.3

Fixed: Wrong version of Drupal guessed when taxonomies are not set

2.34.2

Fixed: “Warning: unserialize() expects parameter 1 to be string, resource given” with PostgreSQL database

2.34.1

Fixed: Media with space not imported

2.34.0

Fixed: Issue with numeric only taxonomy slugs
Fixed: Counter doesn’t reach 100% with Drupal 8

2.31.0

New: Get the post slug from the URL alias

2.30.0

New: Ability to download the media by http, ftp or file system
Fixed: Images inserted in the post content with width and height = 0 when the option “Don’t generate the thumbnails” is selected

2.29.0

New: Add documentation about WP CLI
Fixed: Plugin and add-ons not displayed in the debug informations on Windows

2.28.2

Tested with WordPress 5.6

2.27.4

Fixed: JQuery Migrate warning: jQuery.fn.load() is deprecated

2.27.1

Fixed: Character ” not displayed in the settings

2.27.0

New: Ability to change the default import timeout by adding define('IMPORT_TIMEOUT', 7200); in the wp-config.php file

2.26.0

Tested with WordPress 5.5.3

2.23.0

New: Check if we need the Profile2 add-on
Fixed: Warning: max(): Array must contain at least one element
Fixed: Progress bar at 0% if the site is in https and the WordPress general settings are in http
Tested with WordPress 5.5.1

2.22.2

Tweak: Remove unused function parameter

2.22.1

Fixed: Backward compatibility with older versions of WordPress

2.22.0

Compatible with WordPress 5.5
Fixed: Timezone was not the same between the start and the end time in the logs

2.21.0

New: Add an option to not generate the images thumbnails
New: Make the max_allowed_packet human readable
Change: Set the media timeout to 20 seconds

2.20.1

Fixed: Body content imported in wrong language (regression from 2.13.3)

2.20.0

New: Ability to change the file paths (Drupal 8+)

2.19.3

Fixed: Files containing “&” were not imported

2.17.0

New: Check if we need the Countries add-on

2.15.0

New: Display the PHP errors in the logs
Fixed: [ERROR] Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘stylehome.drupal_field_data_body’ doesn’t exist
Tested with WordPress 5.4.2

2.13.3

Fixed: Body and excerpt not imported if the body language is not equal to the node language (regression from 2.13.1)
Tested with WordPress 5.4.1

2.13.1

Fixed: Content imported in wrong language

2.13.0

Fixed: Notice: Array to string conversion
Tweak: Refactoring

2.12.0

Fixed: Logs were not displayed
Tested with WordPress 5.4

2.11.0

New: Add allow_url_fopen in the Debug Info
Fixed: Notice: Undefined index: REQUEST_SCHEME

2.9.0

New: Add the hook “fgd2wp_post_import_post”

2.8.0

Tweak: Refactor the modify links function

2.7.2

Fixed: Logs were not displayed due to mod_security

2.7.0

New: Check if the Drupal database contains Vimeo media

2.6.0

Fixed: Notice: date_default_timezone_set(): Timezone ID ” is invalid

2.5.1

Fixed: Some internal links containing anchors were badly modified

2.3.0

New: Import HTML media
Tested with WordPress 5.3.2

2.2.0

Fixed: Nodes with an excerpt length longer than 65K were not imported
Tested with WordPress 5.3.1

2.0.0

New: Add an help tab
New: Add a debug info tab

1.92.0

New: Compatible with Drupal 4
Fixed: Logs were not displayed if the URL is wrong in the WordPress general settings

1.91.0

New: Download the media even if they are redirected
New: Check if the Drupal Commerce module is used

1.90.0

New: Add some hooks
Tested with WordPress 5.2.3

1.87.0

Fixed: Images duplicated in the media library
Fixed: The progress bar exceeds 100% with Drupal 8 multilang sites
Tested with WordPress 5.2.2

1.86.0

Tested with WordPress 5.2.1

1.81.1

Tested with WordPress 5.1

1.76.1

Fixed: “[ERROR] Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘media_field_data’ doesn’t exist” on Drupal 7
Tested with WordPress 5.0.3

1.75.0

New: Check if the Paragraphs Drupal module is used

1.74.0

Fixed: Some NGINX servers were blocking the images downloads
Tested with WordPress 5.0.2

1.69.0

New: Compatible with Drupal 8.5 taxonomies hierarchy
Tested with WordPress 5.0

1.67.1

Fixed: [ERROR] Error:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘b.body_summary’ in ‘field list’

1.67.0

New: Generate the audio and video meta data (ID3 tag, featured image)

1.66.0

New: Check if the Drupal site contains navigation menus

1.65.3

Fixed: No data was imported if the taxonomies tables don’t exist on Drupal
Fixed: Drupal 8 media not imported
Tweak: Cache some database results to increase import speed

1.62.1

Fixed: [DOM] Found 3 elements with non-unique id #fgd2wp_nonce
Fixed: [DOM] Found 2 elements with non-unique id #hostname

1.62.0

Tested with WordPress 4.9.8

1.61.0

Fixed: Images with absolute paths were not imported if Drupal is located on a subdirectory

1.60.2

Tested with WordPress 4.9.7

1.60.0

Change: Wording of the label “Remove only previously imported data”
Tested with WordPress 4.9.6

1.58.3

Fixed: Media containing “+” were not imported

1.58.0

New: Check if the Field Collection Drupal module is used

1.57.2

Fixed: The media containing attributes or anchors in their link were not imported
Tested with WordPress 4.9.5

1.56.0

New: Check if the Nodewords Drupal module is used
New: Check if the Page Title Drupal module is used

1.53.0

New: Ability to import the taxonomies by module (Drupal 6 only)

1.50.0

Tested with WordPress 4.9.4

1.49.1

Fixed: Remove default Drupal prefix
Tweak: Use WP_IMPORTING
Tested with WordPress 4.9.2

1.48.0

New: Can import the Drupal databases stored on PostgreSQL
Tested with WordPress 4.9.1

1.47.2

Tested with WordPress 4.9

1.47.1

Fixed: SQL error when some taxonomies contain quotes

1.46.0

Fixed: Displayed a warning about the Localization module if there were disabled languages
Fixed: Displayed a warning about the Nodeblock module if the Field Collection module was used without the Nodeblock module

1.45.0

New: Can import the Drupal databases stored on SQLite

1.44.0

New: Check if we need the Forum add-on
Tested with WordPress 4.8.3

1.43.0

Fixed: [ERROR] Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘config’ doesn’t exist

1.42.0

New: Check if we need the Entity Reference add-on (Drupal 8)

1.41.1

Fixed: Wrong images imported

1.41.0

Fixed: Sanitize the file names with spaces

1.40.0

New: Keep the images alignments
Tested with WordPress 4.8.2

1.39.0

New: Check if we need the Media Provider add-on

1.38.1

Fixed: Avoid double slash in the media filenames
Tweak: code refactoring

1.37.0

New: Check if we need the Entity Reference add-on
Fixed: Security cross-site scripting (XSS) vulnerability in the Ajax importer
Tested with WordPress 4.8.1

1.33.0

New: Import the image caption in the media attachment page

1.32.0

New: Check if the NodeBlock add-on is necessary

1.31.0

New: Check if we need the CCK add-on (Drupal 5)

1.28.0

New: Modify internal links in drafts

1.27.0

New: Block the import if the URL field is empty and if the media are not skipped
New: Add error messages and information

1.25.0

New: Add the percentage in the progress bar
New: Display the progress and the log when returning to the import page
Change: Restyling the progress bar
Fixed: Typo – replace “complete” by “completed”
Tested with WordPress 4.8

1.23.2

Fixed: Allow media src containing extra spaces
Tested with Drupal 5

1.23.1

Tested with WordPress 4.7.4

1.22.0

Tweak: Add a hook

1.19.0

New: Check if we need the Internationalization module
Tweak: Add some hooks for internationalization
Fixed: Images not imported on Drupal 8
Tested with WordPress 4.7.3

1.18.0

New: Migrates the Drupal 6 stories

1.17.0

New: Import the images stored on Amazon S3
New: Check if we need the Ubercart add-on

1.16.4

Fixed: Medias that are not in the standard /sites/default/files directory were not imported
Fixed: [ERROR] Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘field_data_field_image’ doesn’t exist
Tested with WordPress 4.7.2

1.16.2

Fixed: Images not imported on some servers
Tested with WordPress 4.7.1

1.16.1

Tweak: Code refactoring

1.16.0

New: Import the images descriptions

1.15.1

Fixed: Existing images attached to imported posts were removed when deleting the imported data
Tested with WordPress 4.7

1.14.1

Fixed: Images not imported if there is no node summary

1.14.0

New: Can import taxonomies terms with a same name and a different parent
New: Check if the Name add-on is needed
New: Check if the Addressfield add-on is needed
Tweak: Taxonomies import speed increased

1.13.0

Fixed: Wrong progress bar color

1.12.3

Fixed: Notice: register_post_type was called incorrectly. Post type names must be between 1 and 20 characters in length.
Tweak: Add the fgd2wp_post_save_button_click hook
Tweak: Add the fgd2wp_post_import_taxonomies hook

1.12.2

Fixed: The progress bar didn’t move during the first import
Fixed: The log window was empty during the first import

1.12.0

Tweak: Add the fgd2wp_database_connection_successful hook

1.11.2

Fixed: The “IMPORT COMPLETE” message was still displayed when the import was run again

1.11.1

Fixed: The images protected by a user agent protection were not imported

1.11.0

New: Check if the Metatag add-on is needed
Fixed: Database passwords containing “<” were not accepted

1.10.1

Tweak: Code refactoring

1.10.0

New: Add a hook for Drupal 6 images
Tweak: Code refactoring

1.9.0

Fixed: Drupal 6 custom taxonomies containing spaces were not assigned to custom post types
Fixed: Drupal 6 terms which taxonomy contains spaces were not imported
Tweak: If the import is blocked, stop sending AJAX requests

1.8.1

Fixed: Notice: Undefined index: body_summary
Fixed: Notice: Undefined index: body_value

1.8.0

New: Authorize the connections to Web sites that use invalid SSL certificates

1.7.0

New: Check if the CCK add-on is needed
New: Check if the Location add-on is needed

1.6.0

New: Modify links like /node/xx and like /taxonomy/term/xx in the posts content

1.4.0

New: Test if the Drupal database contains some URL alias

1.3.2

Fixed: Drupal 6 nodes imported with a wrong revision

1.3.0

New: Test if the Drupal database contains some custom post types and custom taxonomies

1.2.0

New: Released a Premium version which migrates the comments and the users

1.1.1

FAQ created
Tested with WordPress 4.6.1

1.1.0

New: Compatible with Drupal 6

1.0.0

Initial version: Import Drupal articles, basic pages, categories, tags and images

WordPress.org