Migration: Joomla 1.x  (including Docman/Community Builder/Fireboard/Seyret/Bookmarks/mxcomment) to Joomla 1.5 (including Docman/Jomsocial/hwdvideoshare/bookmarks/jomcomment)

 

IMPORTANT: BACKUP, BACKUP, BACKUP at every important or less important step and name the backups logically! This docu has been written while migrating http://youproduce.net.

 

##### PREPERATIONS #####

Preperations JOOMLA (1.x):

- Disable registrations (CB)
- Disable uploads (Docman)
- Disable other content generating features (forums etc.)
- Backup all important images (comprofiler/stories/etc.) and copy the to the same location in the target website (D) - you'll know what (D) is if you read on.

Preperations DOCMAN:

- Download docman lastest release (http://www.joomlatools.eu/downloads/cat_view/8-docman.html) and it's ETL-Plugins (http://blog.joomlatools.eu/2008/01/migrating-docman-to-joomla-15.html)

Preperations COMMUNITY BUILDER:

- Download CB lastest release
- Create a backup of the config (administrator/components/com_profiler/ue_config.php)

Preperations SEYRET (including migration to hwdvideoshare):

- Download Seyret lastest release (http://www.joomlaholic.com/index.php?option=com_docman&Itemid=2)
- Download hwdvideoshare (http://hwdmediashare.co.uk)

Preperations FIREBOARD:

- Download Kuena (http://joomlacode.org/gf/project/kunena/frs/)

Preperations BOOKMARKS:

- Make a backup of your bookmarks tables and file it "bookmarks.sql"

Preperations mycomment:

- Make a backup of your bookmarks tables and file it "comments.sql"

##### Migration process #####

NOTE: To make the migration of a running joomla 1.x site smoothly you need to have several joomla websites.

(A) Your live Joomla 1.x website
(B) The copy of your live Joomla 1.x website
(C) A fresh Joomla 1.5 Installation
(D) The Joomla 1.5 jomsocial website which you have been working on for weeks



1. Create a copy of your Joomla-Site 1.x (A) (without downloads and external files - too big to handle and test)
2. Install the Migrator Extension + the available ETL-Plugins (Migrator Plugins) into the copy (B)
3. Create the sql-file with the migrator (B)
4. create a fresh new joomla 1.5 site (C)
5. chmod the directors (each) with 777 - there are no security problems here because we'll delete the installation folder after installation/migration
    a) "/installation"
    b) "/installation/sql"
    c) "/installation/sql/migrate"
    d) /tmp
6. Start the installation of the Joomla 1.5 (C)
7. during installation (last step) check the
    a) "use migrator script"
    b) insert the  "jos_" prefix
    c) if your dumfile is big upload it to "installation/sql/migrate" and rename the dumpfile to "migrate.sql" otherwise choose from your harddisk
    d) start the migration with the button at the bottom


Problems during the Migration

I. If you get errors importing the dump and you get a "duplicate entry" error check the dump in UltraEdit (or sth. else) and check the lines which are reported in the error and try to fix the problem. In most cases there are really duplicate entries

II. If you get an error during the migration process with something like "/tmp dir not writeable" or similar - just ignore it - it caused no problems for me

##### AFTER MIGRATION (C) #####

COMMUNITY BUILDER:

8. Install the Community Builder (C)
9. Import the CB Tables from Joomla 1.x (B > C)
10. Restore the config of Community Builder which you've backuped in the first steps (administrator/components/com_profiler/ue_config.php) (C)

DOCMAN:

11. Install the Docman (C)
12. Visit the config of Docman - If you get an error after visiting the config page of docman, try this: http://forum.joomlatools.eu/viewtopic.php?f=22&t=43&p=49
13. set the Path of your downloads to your download folder (set it to the original download folder (A) on the same server for testing purposes)

FIREBOARD:

14. Install Kuena (C)
15. you're done

SEYRET (including migration to hwdvideoshare):

16. Install Seyret (C)
17. Install hwdvideoshare (C)
18. Create the categories in hwdvideoshare (C)
19. import the videos through the "Import Data" tab in "settings" (C)


Problems:

Can't access the video items in the backend in hwdvideoshare? - Look here: http://hwdmediashare.co.uk/forums?func=view&catid=26&id=12662#13275

##### IMPORTING MIGRATED DATA (C > D) #####

NOTE: Now there's the tricky part. I don't know every detail anymore but I'll try to describe it as good as I can. In my case I made a Jomsocial website (D) and prepared it while the live page was still running. Following things were already installed in (D) when I started migration:

- Jomsocial
- Docman
- MybBlog
- JomComment
- jReviews
- hwdvideoshare


The status of your Website (C) should be the following:

- You have your whole content + structure (articles, categories, sections, menu items)
- Your videos should work (in seyret or in hwdvideoshare if you migrated that component)
- Docman should work work
- Kuena recognizes everything automatically - it should work out of the box cause it can work with the old fireboard tables in the db
- Community Builder should work - don't forget to copy the avatars (images/comprofiler/*) from (A/B) to (C)

PREPERATIONS: Content

- Export the db tables "jos_categories", "jos_content" and "jos_sections" and call the dumb "content.sql"

PREPERATIONS:  Community Builder

- Download the CB Migrator (http://www.jomsocial.com/webforum/viewtopic.php?f=22&t=1291)
- Download CB 1.2 (http://www.joomlapolis.com)
- Download latest version of Bookmarks 2.7 is recommend even if it's beta (http://extensions.joomla.org/extensions/162/details)
- Export the CB-Tables from the mysql database and call it "comprofiler.sql" (C)
- Export the "jos_docman" table and call the dumb "docman.sql" (C)
- Export all hwdvideoshare tables and call the dumb "videos.sql" (C)

COMMUNITY BUILDER

20. Delete the tables "jos_categories", "jos_content" and "jos_sections" in (D)
21. Import the dumb "content.sql" (D)
22. Import the dumb "comprofiler.sql" (D)
23. Install CB 1.2 (D)
24. Install the CB Migrator
25. Execute every Database Check from Community Builder (D)
26. Start the CB Migrator - for me it took more than 2 Hours importing 13.000 users with avatars. Id the migrations is stalled just start the migration again, already imported users won't be imported again.

DOCMAN

26. Create the categories in docman (D) like they're in your live site (A)
27. Delete the table "jos_docman" (D)
NOTE: Now we want to import the docman documents, but they have different cat-IDs and parent cat-IDs. You have to adjust the "docman.sql" to reflect the cat/parent-cat-Ids in (D)
28. Import the "jos_docman" (D)
29. Docman should work

hwdvideoshare

30. Delete all hwdvideoshare tables (D)
31. Import the "videos.sql" from (D)
32. Videos should work

MXCOMMENT

33. Import the "comments.sql"
34. Then import the mxcomments through the Jomcomment admin interface
35. Comments should be imported now

BOOKMARKS

36. Install Bookmarks as usual (D)
37. Delete all Bookmarks tables (D)
38. Import the dumb "bookmarks.sql"
39. Bookmarks should work now

FINAL STEP:

40. Now you just have to change the directories of (A) and (D) and edit the configuration.php. If you're fast you can make the downtime to 3 seconds :)

You can see the finished migration live here: youproduce.net

#### NOTES ####

I hope I didn't forget something important. Of course you have to create all the menu items and set the modules to each menu item - the usual setting up stuff. And of course it won't work as described ;) You'll have to do a lot of research but this document should help to give you can idea on how to make the migration process without taking down the live page (A).


Problems which you could encounter:

- timeout while importing database dumps (use a special script, the interface of your webspace or set the timeout higher)
- several problems which you have to try out :) - sorry not to be so clear, it's not possible



TIPS for other 3rd Party Extensions: http://www.alledia.com/blog/joomla-15/migrating-to-joomla-15/

Official Migration Doc:
http://docs.joomla.org/Migrating_from_1.0.x_to_1.5_Stable