Back up Everything
If importing from your live Clientexec installation, stop the cron job for Clientexec, put the installation into maintenance mode, and back up all files and the database.
This importer was introduced in Blesta 4.1. If you are running an earlier version, or would like to see additional information about getting this importer to work with <4.1, see https://www.blesta.com/forums/index.php?/topic/10244-clientexec-importer/
If you prefer, you can create a copy of your Clientexec database and import from that instead of your live system.
Importing from Clientexec
Preparing Clientexec (If importing from your live Clientexec installation)
- Make sure you have completed the Initial Steps for Migrating to Blesta.
- Stop the cron job running for your Clientexec installation.
- Put Clientexec into maintenance mode to prevent client logins by visiting [Setup] > [General Settings] > [General].
- Back up your Clientexec files. You can do this via an FTP program, or via a shell by running: zip -r backup.zip /path/to/installation/*
- Back up your Clientexec database. You can do this through a database manager like PHPMyAdmin using the "Export" feature, or with the mysqldump shell command by running: mysqldump -u database_username -p database_name > backup.sql and entering your database password when prompted.
Performing the Import
- Visit [Settings] > [Company] > [Plugins] > Installed and click "Manage" for the Import Manager.
- Click the "5.5" link next to the platform Clientexec.
- Fill out all of the requested fields
- Database Host: Enter your Clientexec database server name. If MySQL is running on the same server, use localhost
- Database Name: Enter the name of your Clientexec database.
- Database User: Enter the user name for your Clientexec database.
- Database Password: Enter the password associated with your Clientexec database user.
- CC Passphrase: Enter the CC Passphrase as found in Clientexec under Settings > Security > CC Passphrase. This is necessary to import credit card numbers.
- Double check that the data is all correct, and click the "Continue" button.
- You will be prompted to allow the importer to import your packages into Blesta, or match them up. It's recommended that you go with the default setting and import the packages, however, advanced users may wish to create their packages in Blesta first and match them up.
- Submit the form to start the import.
Importing can take a while
Importing your data can take several minutes or more, please be patient. When the importer has finished, it will display a green success message.
Enabling Legacy Passwords
PHP 5.5 Required
In order for legacy passwords to work, you must be running PHP 5.5 or greater on your server.
Passwords stored in Clientexec exceed the 64 character size of the users.password field in the Blesta database. In order to import passwords from Clientexec, update users.password to something like VARCHAR(255)
In order for clients to log into Blesta after being imported, you must enable legacy passwords in Blesta. When a client logs in, their password will be converted automatically to a more secure hash.
To enable support for these passwords edit the /config/blesta.php configuration file within your Blesta installation and change
Then save the file. After a sufficient amount of time has passed, you may change this setting back.
Do you have any active PayPal Subscriptions?
If you have any active PayPal Subscriptions in Clientexec, they will not automatically work with Blesta. Beginning with Blesta 3.5, PayPal Subscriptions can be maintained by creating a redirect in your .htaccess file. At the beginning of the file, add the following:
This redirect may need to be adjusted depending on your path to callback.php in your Clientexec and your Blesta installation directory. Also, the 1 in /callback/gw/1/paypal_payments_standard/ references the company ID in Blesta. If you do not have any addon companies, then the company ID is 1.
Return to complete the Final Steps.