Migrate RSMail! from Joomla! 2.5 to 3.x
Different portions of RSMail! can be migrated in different manners. Here's what you need to do to transfer RSMail! data from Joomla! 2.5 to 3.x:
Messages
No export feature was included for importing/exporting the email messages, as you can easily migrate them by simply copying the HTML and plain text versions to a TXT file and manually adding them, from there, in your Joomla! 3.x website.
Things will get a little more complicated if you have referenced, in your messages, Joomla! Content articles or Joomla! Registration information (through the use of placeholders). In this case, you need to make sure to also transfer the database tables that are related to these default Joomla! functionalities.
Make sure to install the latest RSMail! version on both websites before performing any of the steps described below.
Subscribers
Unlike the email messages, RSMail! subscribers can be exported and imported using the component's default features. To migrate them correctly, please follow these steps:
Export
- head to Components >> RSMail! >> Subscribers.
- in the search filter, select Subscribers in the Show field and a list in the From field. Then click on Filter.
- Click on the green Select filtered subscribers button. It is recommended to use this button instead of the checkbox found in the listing's header as, if multiple pages of subscribers are found, the checkbox only selects the visible subscribers, whereas the Select filtered subscribers button selects the entire listing.
- Click on Export to the top side of the screen. You will be prompted to choose a location for the CSV file to be saved in.
The process described above needs to be repeated for each of the lists you wish to migrate.
Import
Now, head to the Joomla! 3.x website's backend area, in Components >> RSMail! >> Import and:
- provide the delimiter used for separating the data in the exported file
- select a list to which the subscribers will be added in the - Select List - dropdown
- click on Browse and provide the path to the exported file
RSMail! will now prompt you to associate each column found in the exported file with a field contained in the previously selected list.
Other data
RSMail!'s default import / export feature is limited to only performing these actions for subscribers. Migrating the rest of the data associated with RSMail! can only be done by directly exporting the database tables. A database manager like phpMyAdmin provides the necessary tools for this. The following tables need to be migrated:
- dbprefix_rsmail_ar_details
- dbprefix_rsmail_ar_messages
- dbprefix_rsmail_ar_message_details
- dbprefix_rsmail_autoresponders
- dbprefix_rsmail_bounce_emails
- dbprefix_rsmail_config
- dbprefix_rsmail_cron_logs
- dbprefix_rsmail_cron_logs_emails
- dbprefix_rsmail_debug
- dbprefix_rsmail_emails
- dbprefix_rsmail_errors
- dbprefix_rsmail_files
- dbprefix_rsmail_lists
- dbprefix_rsmail_list_fields
- dbprefix_rsmail_log
- dbprefix_rsmail_messages
- dbprefix_rsmail_reports
- dbprefix_rsmail_sessions
- dbprefix_rsmail_session_details
- dbprefix_rsmail_session_filters
- dbprefix_rsmail_subscribers
- dbprefix_rsmail_subscribers_clicks
- dbprefix_rsmail_subscribers_opens
- dbprefix_rsmail_subscriber_details
- dbprefix_rsmail_templates
Migrating from Joomla 1.5 to 2.5
This is done in the same manner as described above, with the only difference being that you need to first update RSMail! on the Joomla! 1.5 website to the latest version available for Joomla! 1.5 - rev. 18.