Difference between revisions of "How to migrate JReviews data from Joomla 1.5"

From JReviews Documentation
Jump to: navigation, search
 
(21 intermediate revisions by 2 users not shown)
Line 1: Line 1:
There are two Joomla extensions available for migrating the data from Joomla 1.5 to Joomla 1.7, '''jUpgrade''' and '''SP Upgrade'''. This article will show instructions for both and you can choose which solution is better for you.
+
There are two Joomla extensions available for migrating the data from Joomla 1.5 to Joomla 2.5 or 3.x, '''jUpgrade''' and '''SP Upgrade'''. This article will show instructions for both and you can choose which solution is better for you.
  
 
Some of the differences between jUpgrade and SP Upgrade:
 
Some of the differences between jUpgrade and SP Upgrade:
*jUpgrade is free, SP Upgrade is commercial (€19.95).
+
*jUpgrade is free, SP Upgrade is commercial.
 
*jUpgrade changes the IDs of Joomla categories which makes the upgrade process more difficult, while SP Upgrade retains the same IDs.
 
*jUpgrade changes the IDs of Joomla categories which makes the upgrade process more difficult, while SP Upgrade retains the same IDs.
*jUpgrade must be installed on your Joomla 1.5 site and it will create Joomla 1.7 site for you with Joomla 1.5 data. SP Upgrade must be installed on exiting Joomla 1.7 site and you can use it to migrate the data from Joomla 1.5 site.
+
*jUpgrade must be installed on your Joomla 1.5 site and it will create Joomla 2.5 site for you with Joomla 1.5 data. SP Upgrade must be installed on exiting Joomla 2.5 or 3.x site and you can use it to migrate the data from Joomla 1.5 site.
 
+
  
 
jUpgrade extension is available here:
 
jUpgrade extension is available here:
*http://matware.com.ar/downloads/joomla/jupgrade.html
+
*http://matware.com.ar/downloads.html
 
+
  
 
SP Upgrade extension is available here:
 
SP Upgrade extension is available here:
 
*http://cyend.com/extensions/extensions/components/5-upgrade-joomla-from-15-to-16
 
*http://cyend.com/extensions/extensions/components/5-upgrade-joomla-from-15-to-16
 
  
 
'''Notes:'''  
 
'''Notes:'''  
*These instructions will show you how to migrate Joomla core data and JReviews data to Joomla 1.7. For data migration of other Joomla extensions that you have on your Joomla 1.5 site, refer to their documentation for instructions.
+
*These instructions will show you how to migrate Joomla core data and JReviews data to Joomla 2.5. For data migration of other Joomla extensions that you have on your Joomla 1.5 site, refer to their documentation for instructions.
 
*It is a good idea to backup the database before proceeding with the migration.
 
*It is a good idea to backup the database before proceeding with the migration.
 
  
 
== Migrating data using jUpgrade extension ==
 
== Migrating data using jUpgrade extension ==
  
*First make sure your main site uses the latest Joomla 1.5.23 and the latest version of JReviews.
+
=== Video Tutorial ===
*Install jUpgrade extension (com_jupgrade-1.2.0.zip) on your Joomla 1.5 site using Joomla installer.
+
 
*Go to Components -> jUpgrade to start the migration process (the extension will ask you to enable MooTools Upgrade plugin if it's disabled)
+
<youtube>Wv6U1vwFyfk</youtube>
*Click on "Start upgrade" button. jUpgrade will then download the latest Joomla 1.7 release, install it and migrate all Joomla core data. The new site will be located inside the /jupgrade subfolder of your main site and it will use the same database, but with different table prefix (j17_ instead of jos_).
+
 
*Next step is to transfer JReviews database tables for the new site (that needs to be done before installing JReviews on Joomla 1.7). Since the new site is installed in the same database, you could just rename all jos_jreviews_ tables to j17_jreviews_, but it is probably safer to create copies of the tables. To do that, go to phpMyAdmin, select the database you are using and click on the Export tab. Select all jos_jreviews_ tables and export them into .sql file.  
+
[http://www.youtube.com/watch?v=Wv6U1vwFyfk&hd=1 Watch in HD on YouTube]
 +
 
 +
=== Steps ===
 +
 
 +
*It is recommended to first upgrade Joomla to the latest 1.5 release that was available (v.1.5.26)
 +
*If your Joomla 1.5 site uses JReviews 2.3 or older, you must upgrade to '''JReviews 2.4.9.1''' before you can do the Joomla migration. The download package for JReviews 2.4.9.1 is available in the [[Where can I download the latest version|Client Area]]. Read [[How to upgrade JReviews|how to upgrade to JReviews 2.4 from earlier versions]].
 +
*Install jUpgrade extension (com_jupgrade-2.5.2.zip) on your Joomla 1.5 site using Joomla installer.
 +
*Go to '''Components -> jUpgrade''' to start the migration process (the extension will ask you to enable MooTools Upgrade plugin if it's disabled)
 +
*Click on "Start upgrade" button. jUpgrade will then download the latest Joomla 2.5 release, install it and migrate all Joomla core data. The new site will be located inside the <span style="color: blue">/jupgrade</span> subfolder of your main site and it will use the same database, but with a different table prefix (j25_ instead of jos_).
 +
*Next step is to transfer JReviews database tables for the new site (that needs to be done before installing JReviews on Joomla 2.5). Since the new site is installed in the same database, you could just rename all jos_jreviews_ tables to j25_jreviews_, but it is safer to create copies of the tables. To do that, go to phpMyAdmin, select the database you are using and click on the Export tab. Select all jos_jreviews_ tables and export them into .sql file.  
 
[[File:ExportJReviewsTables.png]]
 
[[File:ExportJReviewsTables.png]]
*Edit the sql file using a text editor (i.e. Notepad++) and do a "Search and replace" to replace jos_ to j17_ everywhere in the file. Save the file, go back to phpMyAdmin and import the file. Click on the database name to refresh the tables and you should see JReviews tables together with core Joomla 1.7 tables:
+
*Edit the sql file using a text editor (i.e. Notepad++) and do a "Search and replace" to replace jos_ to j25_ everywhere in the file. Save the file, go back to phpMyAdmin and import the file. Click on the database name to refresh the tables and you should see JReviews tables together with core Joomla 2.5 tables:
 
[[File:JReviewsDatabaseTables.png]]
 
[[File:JReviewsDatabaseTables.png]]
 
+
*Now you can install JReviews on the Joomla 2.5 site, but it must be the same version that was installed on the Joomla 1.5 site - '''JReviews 2.4.9.1'''. Read [[Installing JReviews component|Installing JReviews]].
*Go to Joomla Menu Manager on the new site and delete all JReviews menu items that jUpgrade transferred, you will need to create all menu items again after you install JReviews.
+
*Next go to Installer/Updater menu in JReviews administration and install MigrationHelper add-on:
*Now you can install JReviews on the Joomla 1.7 site. Read [[Installing JReviews component|Installing JReviews]].
+
[[File:MigrationHelper.jpg]]
*jUpgrade makes the migration process difficult because it changes the IDs of all Joomla categories. You will need to go to j17_jreviews_categories database table, click on Browse, select all rows and delete (drop) them. Then go to JReviews Categories Manager and setup categories again. Make sure you read [[Using JReviews with unlimited levels of categories in Joomla 1.6]].
+
*Reload the page and click on the Migrationhelper link in the menu to access the add-on, you should see this screen:
*Joomla 1.7 uses a new system for user groups and because of that all global Access Settings and View/Submit Access parameters for custom fields will be deselected. You will need to set all global Access Settings again and edit all custom fields to select users groups that will be allowed to access them.
+
[[File:MigrationHelper2.jpg]]
*Next step is to fix the listing images. The "stories" folder is no longer used in Joomla 1.7, so you need to move the "jreviews" folder which contains all listing images from /images/stories to /images folder.
+
*Click on the '''Reset Category Manager''' button. Then go to JReviews Categories Manager and setup categories again. Make sure you read [[Using JReviews with unlimited levels of categories]].
*As the last step, recreate JReviews menu items. Your Joomla 1.7 site should now have all your JReviews data from the old Joomla 1.5 site.
+
*Click on '''Reset Access Settings''' button. After that, you can adjust Access Settings how you want.
 +
*Click on '''Move Images''' button.
 +
*Old JReviews menu items will no longer work, we need to edit them and configure again.
 +
*Run this url to make sure database tables are updated:
 +
**<span style="color: blue">/administrator/index.php?option=com_jreviews&url=install&sql=1</span>
 +
*Your Joomla 2.5 site should now have all your JReviews data from the old Joomla 1.5 site.
 +
*Now you can upgrade JReviews to the latest available v2.4 release.
 +
*If you want to upgrade Joomla from 2.5 to latest 3.x, this can be done using the Joomla Update component.
  
  
 
== Migrating data using SP Upgrade extension ==
 
== Migrating data using SP Upgrade extension ==
  
*First make sure your main site uses the latest Joomla 1.5.23 and the latest version of JReviews.
+
*It is recommended to first upgrade Joomla to the latest 1.5 release that was available (v.1.5.26)
*Download the latest version of Joomla 1.7 and install it in a new database. During the installation, Joomla will suggest a randomly generated database table prefix (i.e. hx31_), but you should change that to jos_ to make the migration process easier. '''Important:''' don't install the sample data.
+
*If your Joomla 1.5 site uses JReviews 2.3 or older, you must upgrade to '''JReviews 2.4.9.1''' before you can do the Joomla migration. The download package for JReviews 2.4.9.1 is available in the [[Where can I download the latest version|Client Area]]. Read. [[How to upgrade JReviews|how to upgrade to JReviews 2.4 from earlier versions]].
*After the installation is completed, login to the Joomla 1.7 administration, go to Extensions Manager and install SP Upgrade extension.
+
*Download the latest version of Joomla 2.5 or 3.x and install it in a new database. During the installation, Joomla will suggest a randomly generated database table prefix (i.e. hx31_), but you should change that to jos_ to make the migration process easier. '''Important:''' don't install the sample data.
*After SP Upgrade installation, it will ask you to enter Joomla 1.5 database information and select the data you want to upgrade. Select everything you want and click the Migrate button.
+
*After the installation is completed, login to the Joomla Administration, go to Extensions Manager and install SP Upgrade extension.
*Next step is to transfer JReviews database tables to the new site (that needs to be done before installing JReviews on Joomla 1.7). Go to phpMyAdmin, select the Joomla 1.5 database and click on the Export tab. Select all jos_jreviews_ tables and export them into .sql file.
+
*After SP Upgrade is installed, it will ask you to enter Joomla 1.5 database information and to select the data you want to migrate. Select everything you want and click the Migrate button.
 +
*Next step is to transfer JReviews database tables from the old site's database to the new database (that needs to be done before installing JReviews on the new Joomla installation). Go to phpMyAdmin, select your Joomla 1.5 database and click on the Export tab. Select all jos_jreviews_ tables and export them into .sql file.
 
[[File:ExportJReviewsTables.png]]
 
[[File:ExportJReviewsTables.png]]
*Next go to the Joomla 1.7 database and import the file. Click on the database name to  refresh the tables and you should see JReviews tables together with core Joomla 1.7 tables:
+
*Next go to the new Joomla installation database and import the file. Click on the database name to  refresh the tables and you should see JReviews tables together with core Joomla tables:
 
[[File:JReviewsDatabaseTables2.png]]
 
[[File:JReviewsDatabaseTables2.png]]
 
+
*Now you can install JReviews on the Joomla 2.5 site, but it must be the  same version that was installed on the Joomla 1.5 site - '''JReviews 2.4.9.1'''. Read [[Installing JReviews component|Installing JReviews]].
*Go to Joomla Menu Manager on the new site and delete all JReviews menu items if you transferred them with SP Upgrade, you will need to create all menu items again after you install JReviews.
+
*Next go to Installer/Updater menu in JReviews administration and install MigrationHelper add-on:
*Now you can install JReviews on the Joomla 1.7 site. Read [[Installing JReviews component|Installing JReviews]].
+
[[File:MigrationHelper.jpg]]
*Go to JReviews Categories Manager and setup your ex Sections which are now categories. For those categories select "This category will not have listings" instead of a listing typel Read [[Using JReviews with unlimited levels of categories in  Joomla 1.6]] for more details.
+
*Reload the page and click on the Migrationhelper link in the menu to access the add-on, you should see this screen:
*Joomla 1.7 uses a new system for user groups and because of that all global Access Settings and View/Submit Access  parameters for custom fields will be deselected. You will need to set all global Access Settings again and edit all custom fields to select users groups that will be allowed to access them.
+
[[File:MigrationHelper2.jpg]]
*Next step is to fix the listing images. The "stories" folder is no longer used in Joomla 1.7, so you need to move the "jreviews" folder which contains all listing images from /images/stories to /images folder.
+
*With SP Upgrade it is not necessary to click on '''Reset Category Manager''' button, just go to the JReviews Categories Manager and setup your ex Sections which are now categories. For those categories select "This category will not have listings" instead of a listing type. Read [[Using JReviews with unlimited levels of categories]] for more details.
*As the last step, recreate JReviews menu items. Your Joomla 1.7 site should now have all your JReviews data from the old Joomla 1.5 site.
+
*Click on '''Reset Access Settings''' button. After that, you can adjust Access Settings how you want.
 
+
*Click on '''Move Images''' button.
 +
*Old JReviews menu items will no longer work, we need to edit them and  configure again.  
 +
*Run this url to make sure database tables are updated:
 +
**<span style="color: blue">/administrator/index.php?option=com_jreviews&url=install&sql=1</span>
 +
*Your Joomla 2.5/3.x site should now have all your JReviews data from the old Joomla 1.5 site.
 +
*Now you can upgrade JReviews to the latest available v2.4 release.
  
  

Latest revision as of 14:23, 3 December 2013

There are two Joomla extensions available for migrating the data from Joomla 1.5 to Joomla 2.5 or 3.x, jUpgrade and SP Upgrade. This article will show instructions for both and you can choose which solution is better for you.

Some of the differences between jUpgrade and SP Upgrade:

  • jUpgrade is free, SP Upgrade is commercial.
  • jUpgrade changes the IDs of Joomla categories which makes the upgrade process more difficult, while SP Upgrade retains the same IDs.
  • jUpgrade must be installed on your Joomla 1.5 site and it will create Joomla 2.5 site for you with Joomla 1.5 data. SP Upgrade must be installed on exiting Joomla 2.5 or 3.x site and you can use it to migrate the data from Joomla 1.5 site.

jUpgrade extension is available here:

SP Upgrade extension is available here:

Notes:

  • These instructions will show you how to migrate Joomla core data and JReviews data to Joomla 2.5. For data migration of other Joomla extensions that you have on your Joomla 1.5 site, refer to their documentation for instructions.
  • It is a good idea to backup the database before proceeding with the migration.

Migrating data using jUpgrade extension

Video Tutorial

Watch in HD on YouTube

Steps

  • It is recommended to first upgrade Joomla to the latest 1.5 release that was available (v.1.5.26)
  • If your Joomla 1.5 site uses JReviews 2.3 or older, you must upgrade to JReviews 2.4.9.1 before you can do the Joomla migration. The download package for JReviews 2.4.9.1 is available in the Client Area. Read how to upgrade to JReviews 2.4 from earlier versions.
  • Install jUpgrade extension (com_jupgrade-2.5.2.zip) on your Joomla 1.5 site using Joomla installer.
  • Go to Components -> jUpgrade to start the migration process (the extension will ask you to enable MooTools Upgrade plugin if it's disabled)
  • Click on "Start upgrade" button. jUpgrade will then download the latest Joomla 2.5 release, install it and migrate all Joomla core data. The new site will be located inside the /jupgrade subfolder of your main site and it will use the same database, but with a different table prefix (j25_ instead of jos_).
  • Next step is to transfer JReviews database tables for the new site (that needs to be done before installing JReviews on Joomla 2.5). Since the new site is installed in the same database, you could just rename all jos_jreviews_ tables to j25_jreviews_, but it is safer to create copies of the tables. To do that, go to phpMyAdmin, select the database you are using and click on the Export tab. Select all jos_jreviews_ tables and export them into .sql file.

ExportJReviewsTables.png

  • Edit the sql file using a text editor (i.e. Notepad++) and do a "Search and replace" to replace jos_ to j25_ everywhere in the file. Save the file, go back to phpMyAdmin and import the file. Click on the database name to refresh the tables and you should see JReviews tables together with core Joomla 2.5 tables:

JReviewsDatabaseTables.png

  • Now you can install JReviews on the Joomla 2.5 site, but it must be the same version that was installed on the Joomla 1.5 site - JReviews 2.4.9.1. Read Installing JReviews.
  • Next go to Installer/Updater menu in JReviews administration and install MigrationHelper add-on:

MigrationHelper.jpg

  • Reload the page and click on the Migrationhelper link in the menu to access the add-on, you should see this screen:

MigrationHelper2.jpg

  • Click on the Reset Category Manager button. Then go to JReviews Categories Manager and setup categories again. Make sure you read Using JReviews with unlimited levels of categories.
  • Click on Reset Access Settings button. After that, you can adjust Access Settings how you want.
  • Click on Move Images button.
  • Old JReviews menu items will no longer work, we need to edit them and configure again.
  • Run this url to make sure database tables are updated:
    • /administrator/index.php?option=com_jreviews&url=install&sql=1
  • Your Joomla 2.5 site should now have all your JReviews data from the old Joomla 1.5 site.
  • Now you can upgrade JReviews to the latest available v2.4 release.
  • If you want to upgrade Joomla from 2.5 to latest 3.x, this can be done using the Joomla Update component.


Migrating data using SP Upgrade extension

  • It is recommended to first upgrade Joomla to the latest 1.5 release that was available (v.1.5.26)
  • If your Joomla 1.5 site uses JReviews 2.3 or older, you must upgrade to JReviews 2.4.9.1 before you can do the Joomla migration. The download package for JReviews 2.4.9.1 is available in the Client Area. Read. how to upgrade to JReviews 2.4 from earlier versions.
  • Download the latest version of Joomla 2.5 or 3.x and install it in a new database. During the installation, Joomla will suggest a randomly generated database table prefix (i.e. hx31_), but you should change that to jos_ to make the migration process easier. Important: don't install the sample data.
  • After the installation is completed, login to the Joomla Administration, go to Extensions Manager and install SP Upgrade extension.
  • After SP Upgrade is installed, it will ask you to enter Joomla 1.5 database information and to select the data you want to migrate. Select everything you want and click the Migrate button.
  • Next step is to transfer JReviews database tables from the old site's database to the new database (that needs to be done before installing JReviews on the new Joomla installation). Go to phpMyAdmin, select your Joomla 1.5 database and click on the Export tab. Select all jos_jreviews_ tables and export them into .sql file.

ExportJReviewsTables.png

  • Next go to the new Joomla installation database and import the file. Click on the database name to refresh the tables and you should see JReviews tables together with core Joomla tables:

JReviewsDatabaseTables2.png

  • Now you can install JReviews on the Joomla 2.5 site, but it must be the same version that was installed on the Joomla 1.5 site - JReviews 2.4.9.1. Read Installing JReviews.
  • Next go to Installer/Updater menu in JReviews administration and install MigrationHelper add-on:

MigrationHelper.jpg

  • Reload the page and click on the Migrationhelper link in the menu to access the add-on, you should see this screen:

MigrationHelper2.jpg

  • With SP Upgrade it is not necessary to click on Reset Category Manager button, just go to the JReviews Categories Manager and setup your ex Sections which are now categories. For those categories select "This category will not have listings" instead of a listing type. Read Using JReviews with unlimited levels of categories for more details.
  • Click on Reset Access Settings button. After that, you can adjust Access Settings how you want.
  • Click on Move Images button.
  • Old JReviews menu items will no longer work, we need to edit them and configure again.
  • Run this url to make sure database tables are updated:
    • /administrator/index.php?option=com_jreviews&url=install&sql=1
  • Your Joomla 2.5/3.x site should now have all your JReviews data from the old Joomla 1.5 site.
  • Now you can upgrade JReviews to the latest available v2.4 release.