Getting Started
Customers
Accounting
Sales
CRM
Support
Knowledgebase
Orders
Products & Services
Reports
Utilities
Appearance
Settings
Changelog
How to
Troubleshooting

Import Data

Importing Data from Other System

You can export customers from your other system using csv format and import it in Business Suite.

Importing Data from iBilling

If you are migrating from iBilling follow this step to import your iBilling data-

  • Go to Settings → API Access in your old iBilling and generate an API key
  • Go to your New CloudOnex Business Suite & then go to Utilities → Tools
  • On this page, on data import choose iBilling & click import. 
  • Your old data should be available in your new CloudOnex business suite.

If you are using very old version of iBilling, make sure jsonexport.php file is available in application/controllers/ directory. If it does not available, make one with the following contents-

<?php
$apiKey = _post('apiKey');

if($apiKey == ''){
    $resp = [
        'success' => false,
        'message' => 'API Key is empty'
    ];

    api_response($resp);
}

$dataType = _post('dataType');

$check = ORM::for_table('sys_api')->where('apiKey',$apiKey)->find_one();

if($check){
    $resp = [
        'success' => true,
        'message' => 'Authentication Success'
    ];
}

else{
    $resp = [
        'success' => false,
        'message' => 'Authentication Failed'
    ];

    api_response($resp);
}

switch ($dataType){

    case 'auth':

        //

        break;

    case 'customers':

        $customers = ORM::for_table('crm_accounts')->find_array();

        api_response($customers);

        break;

    case 'companies':

        $companies = ORM::for_table('sys_companies')->find_array();

        api_response($companies);

        break;

    case 'invoices':

        $invoices = ORM::for_table('sys_invoices')->find_array();

        api_response($invoices);

        break;

    case 'invoice_items':

        $invoice_items = ORM::for_table('sys_invoiceitems')->find_array();

        api_response($invoice_items);

        break;

    case 'transactions':

        $transactions = ORM::for_table('sys_transactions')->find_array();

        api_response($transactions);

        break;

    case 'groups':

        $groups = ORM::for_table('crm_groups')->find_array();

        api_response($groups);

        break;

    case 'accounts':

        $accounts = ORM::for_table('sys_accounts')->find_array();

        api_response($accounts);

        break;

    case 'appConfig':

        api_response($config);

        break;

    case 'items':

        $items = ORM::for_table('sys_items')->find_array();

        api_response($items);

        break;

    case 'currencies':

        $currencies = ORM::for_table('sys_currencies')->find_array();

        api_response($currencies);

        break;

    case 'categories':

        $categories = ORM::for_table('sys_cats')->find_array();

        api_response($categories);

        break;

    case 'custom_fields':

        $custom_fields = ORM::for_table('crm_customfields')->find_array();

        api_response($custom_fields);

        break;

    case 'custom_field_values':

        $custom_field_values = ORM::for_table('crm_customfieldsvalues')->find_array();

        api_response($custom_field_values);

        break;

    case 'api_keys':

        $api_keys = ORM::for_table('sys_api')->find_array();

        api_response($api_keys);

        break;

    case 'email_logs':

        $email_logs = ORM::for_table('sys_email_logs')->find_array();

        api_response($email_logs);

        break;

    case 'email_templates':

        $email_templates = ORM::for_table('sys_email_templates')->find_array();

        api_response($email_templates);

        break;

    case 'users':

        $i_users = ORM::for_table('sys_users')->find_array();

        api_response($i_users);

        break;

}