Hi,
Unfortunately there is no automated way to import customers and other stuff from Panel 10.2 into Business Manager. Hope that you've successfully performed import from Billing 6.x and you need to import only a few customers.
Below is detailed instruction how to import them manually:
1. Switch off cron task syncing Panel and Business manager
Open file /etc/cron.d/plesk-billing in any editor and put sign # before line "*/5 * * * * psaadm /usr/local/psa/admin/bin/php /opt/plesk-billing/htdocs/admin/sbin/runevents.php > /dev/null 2>&1"
Then restart cron service:
#service crond restart
2. Determine ID of the panel you will perform import from
Go to CBM, System Configuration > Server Groups, find needed group and server inside it.
Look at the URL under some tool (Log In or Edit for example) find there parameter configGroupID and remember its value. This value is Panel ID in CBM.
3. Create service plans in CBM manually you need to create only service plans which have been sold to customers you want to import. Other service plans in Panel can be skipped;
Note that all values (disk space, traffic, other limits) entered in Business Manager will override Panel ones after synchronization.
If you already have all needed service plans created in CBM and synced, skip steps 3 and 4.
4. Link these service plans with Panel
Retrieve guids from CBM database:
#bash> mysql uadmin p`cat /etc/psa/.psa.shadow` billing
#mysql> select product_id, product_name, guid from products;
Then insert these guids into Panel database:
#bash> mysql uadmin p`cat /etc/psa/.psa.shadow` psa
#mysql> select id, name from Templates;
#mysql> update Templates set external_id = <guid> where id = <plan_id>;
Then go to CBM > Plans, check all created plans and use tool Sync to sync them with Panel. After these actions all linked service plans in Panel must have link Business manager.
5. Create customers in CBM manually pay attention that when all procedures will be finished customer will be able to log in into Panel with username and password entered on this step.
All entered information (name, address and so on) will override the same information in Plesk panel after synchronization.
6. Create subscriptions manually open customers profile and use tool Add New Subscription.
Set there all needed parameters and primary domain name (this domain name is shown in the list of subscriptions for given customer and its marked with bold in the list of his domains in Hosting Panel, tab Websites & domains), select appropriate service plan.
Then open subscriptions settings, click Edit and change status to Active.
Then go to Events menu and cancel event for provisioning find event Process Panel of subscription <id>, expand toolbar (arrow on the left of id column), click Edit and change events status to Canceled.
Find created subscription in the subscriptions list, remember its ID.
7. Link these subscriptions with Panel
Set proper Panel ID for subscription properties:
#bash> mysql uadmin p`cat /etc/psa/.psa.shadow` billing
#mysql> update package_attributes set config_group_id = <Panel_ID> where package_id = <id> and server_group_id <> 0
Here <id> is ID of subscription from step 6, <Panel_ID> is ID of Panel obtained at step 2
8. Sync all imported customers and subscriptions check these objects in corresponding lists and use tool Sync
9. Switch on cron task syncing Panel and Business manager
Open file /etc/cron.d/plesk-billing in any editor and remove # sign before the line */5 * * * * psaadm /usr/local/psa/admin/bin/php /opt/plesk-billing/htdocs/admin/sbin/runevents.php > /dev/null 2>&1, save changes
Then restart cron service:
#service crond restart
Facebook
Twitter
