Clientexec Importer

[Paul]

We have a new importer for Clientexec 5.5.

To install, download the attached clientexec.zip and unzip the file. Upload the clientexec directory to ~/plugins/import_manager/components/migrators/ and go to Settings > Company > Plugins to install it the Import Manager. Then, manage the plugin and click on the Clientexec 5.5 link to start. Be sure to import into a fresh Blesta install.

clientexec.zip

What's imported?

Quote

Import Users Groups
Import Staff Members
Import Clients
Import Clients Notes
Import Taxes
Import Currencies
Import Invoices
Import Transactions
Import Modules
Import Packages
Import Packages Options
Import Services
Import Support Departments
Import Support Tickets
Import Knowledge Base Articles
Import Coupons
Import Settings

If you want to import user passwords, it's necessary to make a couple changes:

Edit ~/app/models/users.php around line 715, add a new case statement:

            case 'clientexec-sha256':
                $temp = explode(':', $stored_hash);

                $algo = isset($temp[0]) ? $temp[0] : 'sha256';
                $iterations = isset($temp[1]) ? $temp[1] : 1000;
                $salt = isset($temp[2]) ? $temp[2] : null;
                $hash = isset($temp[3]) ? $temp[3] : null;

                $new_hash = hash_pbkdf2($algo, $password, $salt, $iterations, 0, true);
                return substr(base64_encode($new_hash), 0, 32) == $hash;

Edit ~/config/blesta.php and change:

// Set to true to enable support for legacy passwords (plain md5). Set to false for improved security
Configure::set("Blesta.auth_legacy_passwords", false);
// The legacy password algorithm to use if legacy passwords are enabled
Configure::set("Blesta.auth_legacy_passwords_algo", "md5");

to:

// Set to true to enable support for legacy passwords (plain md5). Set to false for improved security
Configure::set("Blesta.auth_legacy_passwords", true);
// The legacy password algorithm to use if legacy passwords are enabled
Configure::set("Blesta.auth_legacy_passwords_algo", "clientexec-sha256");

Then, continue with the import. If you don't care about user passwords, you can import anyway and users can reset their passwords using the password reset feature in Blesta.

Did you give the importer a try? Let us know what you think below. 

[bdacus01]

Paul. 

It works pretty well. I did notice issue with the main "admin" account. 

Lets say on CE admin account is brent@brent.com

new empty Blesta has to have admin account e.g. First account created. 

So I use brent@brent.com

it seems there is no check in the importer. It kept both accounts. Also it seems to add different email. In the email section. 

I will be glad to send yon my CE db. It real small like 3 accounts. 

[Bloory]

Not working with the latest 6.10 Clientexec.  Got the error about passwords and made changes where I could.

[Paul]

23 hours ago, Bloory said:

Not working with the latest 6.10 Clientexec.  Got the error about passwords and made changes where I could.

Did you download the importer from here, or did you use the one that's included in Blesta 4.10? The one that ships with Blesta is most up to date. If you have any trouble importing with the current version, or something changed in CE, we can take a look and update the importer.

[Bloory]

Thanks Paul, I have tried with an updated Blesta and added the output to the ticket I opened.