Menu

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;

}
By continuing to use this site you consent to the use of cookies in accordance with our Cookie policy. close notification