Drupal 5.x

45,000 Wordpress posts converted to Drupal

Submitted by Steve on Tue, 29 Jul, 2008 - 23:47

Okay, the title said 45,000 posts but in reality how does converting or transferring, call it what you want, 45,936 posts from Wordpress 2.5 to Drupal 5.8 sound. I helped out a registered user HitBoy with the conversion, that is, I did it on my machine locally for him. Before I go any further here's a screen-shot of the Analyse Wordpress section.

Screen shot - Analyse Wordpress

I didn't specifically time the process but I reckon it was closer to the two hour mark than it was to the one hour mark, so transferring 45,000 posts is not a 5 minute process. Obviously, if done using remote databases it would take a little longer. How much longer, well I don't know and I'd only be guessing.

HitBoy's going to make a follow-up entry in Check My Site thread and there he'll promote his site, so at least you can see that it is possible to convert massive amounts of data.

During this process I was chatting to HitBoy about other things, as you do, and found out that he's starting a new venture, a hosting business. If you're after some free (or paid) web-hosting why not check him out at OpenSourceSetup. His site went live yesterday (Monday 29 July, 2008).

The link I provided IS NOT an affiliate link and I do not benefit in any way.

Logging into a Remote Database

Submitted by Steve on Fri, 13 Jun, 2008 - 14:09

Okay, so you know all the connection details in order to connect to remote MySql databases and yet the converter claims it can't make a connection.

In order to connect to your remote MySql database(s) you need to activate the 'allow remote connections' setting at your server. If 'allow remote connections' is switched off, a connection will never be made.

Image - Manage Remote Access

Using cpanel as a guide, navigate to your database section and select "Manage Remote MySql Access". At the following screen merely enter your home computer IP address as an 'Access Host'. To simplify things further entering a % key will allow access to your MySql database from any computer.

If you can't find such a setting your hosting provider should be able to help.

Version 1.04 - available for download

Submitted by Steve on Fri, 13 Jun, 2008 - 00:07

Version 1.04 of the Wordpress 2.5 to Drupal 5.x/6.x converter has been released and available for download from here.

For details regarding what's new in this release check here.

By all means for any suggestions, comments or questions here is a good start.

Enjoy.

1.04

Submitted by Steve on Thu, 12 Jun, 2008 - 23:12

Bug fixes and enhancements for Version 1.04.

Versions

Submitted by Steve on Thu, 12 Jun, 2008 - 22:36

The pages of this chapter merely indicate what changes occurred for each version.

Version 1.04 - What's in it

Submitted by Steve on Mon, 9 Jun, 2008 - 01:57

The next version (1.04) of the converter will be out soon. This will include some bug fixes and slightly improved progress meter.

The bug fixes are:

  1. Titles of posts now correctly display symbols whereas as before html code appeared in lieu of the symbol eg. £ appeared instead of the symbol £ and so on.
  2. The same process, as above, is applied to the user name of the comments table.
  3. Included additional option, the setting of the filter format for comments.
  4. Corrected the category hierarchy, under certain conditions sub-categories were not being recorded accurately. This has been addressed.
  5. Comment headings to be created, first four or five words of the comment to be the comment heading.
  6. Not that this will be overly noticeable, but the thread field of the comments table is now correctly populated with Base 36 (Vancode) numbers.

Improved Progress Window

Created two additional progress bars to the Importing Progress Window. Included now are progress bars relating to comments per post and the assigning of categories to posts. All bars should tick over at a constant rate, at least the user knows something is happening.

Status

The only bug fix left at this stage pertains to the the comment heading aspect. Hopefully that will be addressed within the next few days, when done, I'll upload.

By all means report all problems or issues here.

1.03

Submitted by Steve on Tue, 27 May, 2008 - 19:10

As promised the Wordpress to Drupal 6.x converter (Version 1.03) is now available for download.

What's new.

  • Conversion to 5.x and 6.x
  • Filter Formats specifically retrieved from Drupal
  • More flexibility re - Content types, Promote to Front page and published
  • Teasers created re - <!--More--> tag
  • More thorough snapshot of the Wordpress database

For full details see the manual.

Analyse Wordpress

Submitted by Steve on Tue, 27 May, 2008 - 17:28

This particular screen is more for informational purposes and should be self-explanatory.

Image - Analyse Wordpress

Post Status to Drupal Published

Submitted by Steve on Tue, 27 May, 2008 - 17:24

Image - Post Status - Screen Shot

Wordpress uses a number of status types for posts and those status types are retrieved and displayed in the left column of the above two column list. The process of assigning values is as per post types to content types.

These Wordpress types correspond to the Drupal published information. Your only choices are either the corresponding status type is either published or not.

Image - Post Status - Screen Shot

If all the content type, promote to front page and published information has been input then the 'Import' button will become active. At this point the conversion can take place.

Post Type to Content Type

Submitted by Steve on Tue, 27 May, 2008 - 17:13

Image - Post Type Screen Shot

From here is where we can associate Drupal content types to Wordpress post types. The left column is populated from your Wordpress database and lists all the post types used and available. Columns two and three relate to Drupal content types and 'Promote to Front Page' settings. Initially, these columns will be empty.

In order to assign corresponding values to the Wordpress post types, merely click on a Wordpress post type and you will note that the post type is displayed in a separate field below the post type column. This particular field is not editable but the drop down boxes to the right are and is where selections are made and ultimately assigned to the Wordpress post type by clicking the 'Assign' button.

Image - Post Type Screen Shot

Image - Post Type Screen Shot

Upon assigning values corresponding to the Wordpress post types, they will be displayed in the list. All post types must be accounted for.

Image - Post Type Screen Shot

The Drupal content types are retrieved from your Drupal database. If a particular content type is not present, ie Blog, then it's just a matter of adding the blog module to your system, via Drupal. Likewise, if you prefer other content types, simply create them within Drupal, then return to the importer and they will be available to be selected.

Syndicate content

Clickbank Testing (I'm figuring this stuff out)

This relates to piano lessons which is relevant to me at this point in time.

Item
Issue
Description
1
1
Node Title and Comment Name - now correctly display symbols where before in certain cases HTML code was displayed. A secondary text file is included with the program. It is to reside in the same directory as the program. This file contains the relevant codes to be translated.
2
2
Comment headings now created (now enables comment links)
3
3
Comment thread field now correctly populated with Base 36 number system, previously was Base 10 (decimal). I doubt this was a cause of any dramas, it's just that I recently became aware of it.
4
4
Filter format option for comments. Same as for nodes, which was introduced in 1.03
5

free hit counter