CloudOnex business suites provides you to import data from your old iBilling.

To get started, create a file inside your iblling directory- application/controllers/
name it jsonexport.php with 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;

}


Now Go to Settings - > API Access in your old iBilling and generate an API key

Next, 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 sute.
Was this article helpful?
Thank you!