WHMCS is a self-hosted billing platform designed for hosting businesses. You can easily move from WHMCS into Upmind. Note that WHMCS can have many adjustments to databases or custom modules added. We do not import all of this data - we just get the core information we need in order to be able to effectively move your billing and client management to Upmind.
Most core information from WHMCS can be imported into Upmind. This includes:
- Staff users
- Support tickets
- Payment methods
- Affiliate accounts
We automatically attempt to map data (e.g. servers, domains) where possible. If we cannot automatically map data then we will prompt you to create mappings in the interface.
There are a few things to set up before you import from WHMCS.
|Set up your brand name and basic address settings.
|Configure your tax settings if applicable
|Web Servers and Domain Providers
|Add your shared web servers and domain providers, if applicable, under
|Add your payment gateways under
Our WHMCS importer uses the WHMCS API credentials to get data.
You now need to create an API role that has all permissions. If you like, you can tick all of the check boxes under all of the menu items on the left. Alternatively you can search for any allow only the following API commands:
|GetAdminUsers (see note below)
Once done, hit 'Save'.
We need access to the API call 'GetAdminUsers' which sometimes does not appear in the list above. If you get an error saying that this is not enabled, you need to associate it manually. Go into your database and the table
tblapiroles and add
getadminusers to the array.
Now go back to the first API Credentials tab and click 'Create New API Credential'
Make a copy of your Service Identifier and Secret.
You also need to whitelist the IP addresses shown in step 3 below in your WHMCS settings.
This is done through Settings -> General Settings. Then click the 'Security' tab. You need to enter our IP addresses under 'API IP Access Restriction'.
|IP Addresses to add
If your website is behind a proxy server (for instance Cloudflare) or behing a load balancer, then you need to make sure you have followed the below setup.
In Upmind, navigate to Settings, then Import
Now click 'Create New Import' and choose 'WHMCS'. Hit 'Add New Credentials'.
Once you hit Save, your credentials will be tested. If the credentials are invalid, you will see an error and you can correct your data.
Once the data is added you can click 'Create Import'
You can leave the import running and return to the screen at any point. No data will be lost and the import will not be interrupted.
You will now see a screen that looks as follows. Click 'Start Import;
The import will start in progress and we will begin the data export behind the scenes. As you can see we import data in order.
Upmind treats domains and products all as a type of products. We do however only store one record of each TLD -- so if you already have a TLD (e.g. 'com') added then it won't be reimported - we'll just map any records to that existing product.
Once the first import set is done you will see the following happen. You will see an orange notification with the label 'Mappings required'
This is category mapping. If you have set up Upmind categories under
Products and Service you can map that here. This is entirely optional.
Once done you can click 'Confirm mapping(s) and continue'
The products will now import
Once imported the data will show in a list and you can click to view a the imported data. You cannot edit the staged data but you can preview it.
This process continues for the remainder of the import sections.
We automatically map users with the same email address on the system.
The mappings required map levels of permissions which you can set up under User Roles.
This exports your client database and imports it to Upmind. This may take some time. You can leave it to run in the background.
You will be given the option to map custom fields. You can create upmind custom fields in the settings panel.
Once clients records are imported you can go to a client profile and view their staged information.
This imports activated affiliate accounts. Note that we take affiliate activations and balances, but we do not export any affiliate links or ongoing referrals. These will need to be added manually.
You will need to map payment providers with ones you have added in the system.
This is the current subscription and client product data. You will need to map provision configurations (servers, suppliers, domain registrars)
This imports WHMCS support tickets. You can optionally map support ticket departments.
Once data has been mapped, you can preview it. You cannot modify data in preview mode, and the clients cannot log in. This preview mode allows you to test the imported data and ensure it is correct before committing.
If you see any errors you can cancel the import at this point.
You can commit data once you are happy with the staged import.
Obviously, you want to avoid data being out of sync during an import, so we recommend the following process:
Prior to the import, add any servers, domain providers, and payment gateways into Upmind in advance.
- Back up your WHMCS install before any import. We only use GET requests but this is always good practice!
- Turn off any WHMCS crons and put WHMCS into maintenance mode.
- Run the import
- Once happy, you can take your WHMCS offline.
Q. My username and password are not correct.
A. You need to use the service identifier and secret under WHMCS API settings.
Q. The import fails with a malformed character issue ("Malformed UTF-8 characters, possibly incorrectly encoded")
A. This is often due to bad characters in the hosting account password. After taking a backup you could wipe the passwords from the hosting accounts - Upmind does not need them or store them. You can either do through the interface or in the database.
Updated about 1 year ago