Migrating from 1.
0
to 1.5
A step by step tutorial
Sam
Joomla!Day Thailand, 2007 Moffatt
About Me
Sam Moffatt
[ pasamio ]
Joomla! Core Member
Developer
Joined J!Core January 06
Google SoC Student 05, Mentor 06/07
Australian
Toowoomba – Australia
University Student
Freelance Web Dev
Migrating Joomla! 1.0 to 1.5
2
Presentation Overview
• Exporting from 1.0
• Importing into 1.5
– FTP Upload
– SQL Upload
• News for developers
Migrating Joomla! 1.0 to 1.5
3
Overview
The Journey of 1.0 to 1.5
• Generate a SQL dump out of 1.0
• Do a base 1.5 install
• At the migration step either upload via FTP or HTTP
• Run the migration wizard and finish installation.
Migrating Joomla! 1.0 to 1.5
4
Installing the Migrator
Getting the installation package
• http://joomlacode.org/gf/project/pasamioprojects/frs
• Download available on the web
Migrating Joomla! 1.0 to 1.5
5
Installing the Migrator
• Install into Joomla! 1.0
Migrating Joomla! 1.0 to 1.5
6
Doing your migration!
• The Migrator welcome screen explains all
of the steps, normally all you need to do is
click “Create Migration SQL File”
Migrating Joomla! 1.0 to 1.5
7
Doing your migration
• A few screens will flash past as the
migrator works and it will be completed:
• Note the SQL download file name before
you click “Download”, in this case it was:
'moffats_joomla_1013_20070727_102337.sql'
Migrating Joomla! 1.0 to 1.5
8
Download the SQL Dump
• The download page lists all available dump
files, click “Download” to retrieve the
dump file from your website.
Migrating Joomla! 1.0 to 1.5
9
Joomla! 1.5 Install
• Now that we have the dump of our old
site, we start creating a new 1.5 install.
Migrating Joomla! 1.0 to 1.5
10
Upload Options
• If you are migrating a small site
(generated SQL file smaller than 2MB) you
can use the HTTP upload facility on the
migration form
• If you are migrating a site larger than this,
you will need to upload your SQL into the
“/installation/sql/migration/” folder on
the server and call it “migrate.sql”
• Both methods require reuploading the
document again if the migration process
fails or is interrupted.
Migrating Joomla! 1.0 to 1.5
11
Migration
• You can start migration. Please note the
RC1 build has an error that will say that
migration failed, you can safely ignore this
(and it will be fixed in the final release!)
• When prompted click next and enter your
site name, and click next to finish
installation.
Migrating Joomla! 1.0 to 1.5
12
Migration
• Enter site name, migration complete!
Migrating Joomla! 1.0 to 1.5
13
Migration Complete
• Your Joomla! site should continue as
normal, delete the 'installation' folder and
view your new site.
• Keep in mind:
– A new main menu module is created
automatically and published
– All other modules are migrated as unpublished
– You will have to install the 3PD modules from
your old site, either the 1.0 versions using the
legacy plugin or 1.5 versions that have been
updated.
– Some menu URL's might not work
Migrating Joomla! 1.0 to 1.5
14
For 3PD Developers
• The migrator allows for plugins installable
in the 1.0 site for third party extensions
• There is no way to perform actions as a
part of the 1.5 installation process, only
SQL can be used.
Migrating Joomla! 1.0 to 1.5
15
Developing ETL Plugins
• Two types of plugins: ETL and SQL.
• An ETL plugin allows you to transform and
export your actual data from Joomla!
• A SQL plugin prepends SQL files to your data
dump before the ETL plugins start
• Very easy to write, very quick to develop:
– ETL Plugin just needs to be named to the
table name and extend the ETLPlugin class.
– SQL plugin is a plain SQL file
Migrating Joomla! 1.0 to 1.5
16
A Simple ETL Plugin Example
<?php
class TableName_ETL extends ETLPlugin {
function getName() { return “Descriptive name”; }
function getAssociatedTable() { return “tablename”; }
}
Migrating Joomla! 1.0 to 1.5
17
ETL Plugins
• An ETL Plugin can be more complicated to
allow for:
– renaming fields,
– altering field values
– and writing custom transformation steps (e.g.
moving settings in configuration files into a
database)
Migrating Joomla! 1.0 to 1.5
18
Q&A
Question & Answer session
Migrating Joomla! 1.0 to 1.5
19
Presentation Summary
• Joomla! 1.0 data export
• Joomla! 1.5 migration import
• Developing ETL plugins
• Q&A
Migrating Joomla! 1.0 to 1.5
20
