Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip
titleInitial Staff Username

When installing Blesta, you should choose a username that does not exist in your WHMCS installation, or it will result in an error when trying to import your WHMCS staff users.


Tip
titleDatabase Collation

Often times WHMCS has mixed database collations and this can cause issues during import. For this reason we recommend:

  • Cloning your WHMCS database, and updating the collation for all tables to utf8mb4_unicode_ci.
  • Make sure Blesta is also utf8mb4 by going to Tools > Utilities. Updating Blesta from utf8 to utf8mb4 can be accomplished by clicking the "Update to utf8mb4" button. If the Description says "Database already supports utf8mb4" then the collation has already been updated.
  • Import from your cloned utf8mb4_unicode_ci WHMCS database.


Tip
titleTicket Numbers

Blesta uses an int(10) column for ticket codes. If you have any non-numeric characters in your ticket system in WHMCS, you can update them to match the internal ID to prevent any errors during import. Do this to a cloned copy of your WHMCS database, not your production copy.

Code Block
languagesql
UPDATE tbltickets SET tid = id;



Info

If you prefer, you can create a copy of your WHMCS database and import from that instead of your live system.

...

The following data is imported from WHMCS to Blesta:

Affiliates.Calendar events DepartmentsSupport
Import TypeDescriptionImport TypeDescription
Payment AccountsCredit / Debit cards saved in WHMCS.
Admin (Staff)Staff who log into your WHMCS.
Affiliates
CalendarCalendar events.
DomainsDomain Names
EmailsEmails sent to clients.
InvoicesInvoices generated to your clients.
Support DepartmentsSupport departments made on WHMCS.
Taxes
Clients (Active / Inactive)Clients on your WHMCS installation.
Admin (Staff)Staff who log into your WHMCS.ConfigurationWHMCS settings.
Contacts (Client's contacts)Contacts on your clients accountCalendar.
CurrenciesCurrencies on your WHMCS installation.
EmailsEmails sent to clients.Products (Packages)Packages on your WHMCS.
InvoicesInvoices generated to your clients.ServicesServices created on your customers.
Support Support departments made on WHMCS. TicketsSupport tickets created on WHMCS.Taxes

Importing from WHMCS

Preparing WHMCS (If importing from your live WHMCS installation)

...

This redirect may need to be adjusted depending on your path to paypal.php in your WHMCS 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. Note that normally the IPN URL for each client is unique, and look something like /callback/gw/1/paypal_payments_standard/?client_id=12345 where 12345 is the internal ID for the client. If this is ID is missing, Blesta attempts to match the transaction to a client based on the client's email address. If there is no match on the client's email address, the transaction will not be recorded.

Return to complete the Final Steps.

...