Introduction

SP Transfer is able to transfer various items between two Joomla! databases. You install SP Transfer on the destination site, and you transfer items from the source database.

In no case an item will overwrite an existing item with the same id during transfer if you choose it. There is also a restriction in Joomla! where you cannot have the same alias of an item under the same parent. Taking these facts into consideration there are two important options you have to decide before the transfer.

  1. If there is duplicate id, whether to transfer the item with new id, replace existing items or not transfer at all.
  2. If there is duplicate alias, whether to transfer the item with different alias, or not transfer at all.

The process of transfer is done in two steps. The first step is the actual process of copy and the second is to link parents in case of items with new ids.

The component keep history of what is already transferred. This is necessary to keep track in case you have a php timeout.

It is strongly recommended to backup your database before proceed with the transfer, just to be on the safe side.

Installation

First Purchase - SP Transfer and download zip file. The Joomla package (zip file) is installed just like any other standard Joomla component from Extensions Manager in back end. It is installed on the destination site and NOT on the source. See below image:

SP Transfer installation


Options

Configuration

SP Transfer configuration

Same IDs Handling: Choose how to treat items with ids that already exist in the destination database.

  • Transfer items and save with new IDs, or
  • Do not transfer item, or
  • Replace existing items.

Duplicate Alias?: Choose whether to transfer items with different alias or not, in case an existing item under the same parent has the same alias.

Existing Files Replace: Choose whether to replace or not existing files.

Database

Those are the database credentials of the source database. Those credentials can be found in your source site configuration.php file.

SP Transfer database

Database Type: Represents the connection type between PHP and a MySQL database. If you have MySQL 4.1.13+ and PHP 5.0.7+, then choose MySQLi, else MySQL.

Host: In case both your databases are on the same host then write localhost. In case of remote transfer here you have to write the remote source host name, or IP. In case you have trouble identify what is this, you should contact your host provider.

Database Name: The source database name.

User Name: The user name of the source database. This is not the Joomla admin user.

Password: Password of the user to the source database.

Database Tables Prefix: The source database tables prefix name. Something like xxxxx_

FTP

Those are the FTP credentials of the source site. They are necessary to enable ability to transfer files, or folder.

SP Transfer FTP configuration

FTP Host: In case both your sites are on the same host then write localhost. In case of remote transfer here you have to write the remote source host name, or IP. In case you have trouble identify what is this, you should contact your host provider.

FTP Port: Usually this is 21. 

FTP User Name: The FTP user name of the source host.

Password: Password of the FTP user to the source site.

FTP Root: That could be / or any other sub-directory that is present on the source site.


Core Transfer

Transfer

Just choose what you want to transfer and press button transfer.

SP Transfer transfer

You have the option to transfer all items of what you choose, or selected items based on their ids. You may choose individual ids, or range, or a combination of both. For example:

3,10-56,68,100-145

Will transfer items with ids: 3 and 68, and range of id's between 10 to 56, and range 100 to 145. If you leave empty the ids field then all items will be transferred.

Also you may press button Clear to clean corresponding field, or Choose to visually choose individual items. The choose button will open a well known window depended on the type of items to choose with search and filtering capabilities. See below of example of choosing articles. Similar dialogues exist for all items.

SP Transfer choose

Finalize

After the transfer of items you just choose all and leave the ids fields empty and press button finalize. This step will fix the links in case you chose to bring items with new ids.


Individual Records

On tab Database Transfer you have the ability to choose individual records from any table in the source database.

Individual Records

Individual Records

It works similarly with the core transfer with below differences.

  • It does not replace existing records,
  • It does not create records with new ids, if already existed,

It just copy the records if they are not present. Also if the table is not present in the destination table it create it with the correct prefix.


Files Transfer

On tab Files Transfer you have the ability to choose any file, or folder to copy to the destination site.

SP Transfer Files Transfer

On the left side table you may view all source site files and folders. You can browse within the folders and choose any file, or folder you wish to transfer.

On the right side table you may view all of the current destination files and folders. You can browse to any folder you wish. The folder showed here is the destination folder. For example if you wish to transfer some files/folder from the source site images folder, to the destination site folder images, then first you must browse in the images folder, then choose the files/folders you wish to transfer and hit button transfer.

In case you choose a folder to copy, and is not present on the destination site, then the folder will be created and transfer all it's sub-folders and files.

Remember that if you choose in general options to avoid overwriting existing files, then that will be the case!


Monitoring Log

With this view you are able to monitor the status of the transfer. The monitoring log will refresh every 15 seconds.

SP Transfer Monitoring Log

It is recommended to open this view on a new browser window before, or during the operation of transfer. Note that depended of the number of items (e.g. thousands) you choose to transfer this could be a long operation.


History Log

From this view you have the ability any notes, and whether everything is transferred successfully.

SP Transfer History Log

After you complete with the transfer and the finalize it is recommended to delete this log in order to save space in your database. Do not delete it before you finish with finalize.