CBSub importing baskets from CRM

activha
OFFLINE
Posts: 2336
Thanks: 117
Karma: 13

9 years 3 weeks ago #275615 by activha

CBSub importing baskets from CRM was created by activha

Hi

We are moving from zoho CRM to CRMery joomla and will use CBSubs for all invoicing purposes as suggested by Beat

However we have a long history (5 years of annual invoices) for our customers that we would like to keep for information purposes.

Would it be possible to import these in CBsubs basket table so that we will have a history of each customer subscription payment and so that each customer would have old invoices ?

If no can you suggest some other move ?

Thanks

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48674
Thanks: 8313
Karma: 1446

9 years 3 weeks ago #275623 by krileon

Replied by krileon on topic CBSub importing baskets from CRM

Don't think just inserting a basket will work. The payments, payment_baskets, payment_items, payment_totalizers, subscriptions, etc.. tables all work together. It maybe better to provide that information externally somehow. For example generate a PDF with their previous invoice information or something of the sort and make it available for download (file fieldtype?). You can certainly try inserting into the database though to see if it could work.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

activha
OFFLINE
Posts: 2336
Thanks: 117
Karma: 13

9 years 1 week ago #275973 by activha

Replied by activha on topic CBSub importing baskets from CRM

It seems that importing in payment_baskets does show invoices in the user page, and even paying an offline invoice seems to work fine

The only thing would be to link this to payment_items and payment_totalizers

If we insert DB rows in these three tables, would this work for importing both payments and got an pretty good assert of turnover of last years in CB subs statistics ?

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48674
Thanks: 8313
Karma: 1446

9 years 1 week ago #275996 by krileon

Replied by krileon on topic CBSub importing baskets from CRM

Yes, that should work if all the payment data is imported. I would use a row generated by CBSubs as an example on how to format your imports.

The following user(s) said Thank You: activha

Please Log in or Create an account to join the conversation.

activha
OFFLINE
Posts: 2336
Thanks: 117
Karma: 13

9 years 1 day ago #276257 by activha

Replied by activha on topic CBSub importing baskets from CRM

This seems to work except that we have the following error appearing when renewing :

Code:

NOTICE: Trying to get property of non-object in /var/www/html/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php on line 876
Trace:called in class cbpaidErrorHandler::_error_handler_callable(8, "Trying to get property of non-object", "/var/www/html/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php", 876, array("plan" => "45", "userId" => 57, "reason" => "R", "occurrence" => 0, "item" => object(cbpaidPaymentItem), "startTime" => 1452121200, "overridePlansDisplay" => true, "resultTexts" => array(), "_CB_framework" => object(CBframework), "applicablePromotions" => array(), "paymentBasket" => NULL, "isPublished" => true, "alsoPossibleButUnusedCoupons" => true, "promotions" => array(0 => object(cbpaidpromotionTotalizertype)), "cbpaidUser" => object(cbpaidUserExtension), "is_business" => false, "address_country_code" => NULL, "address_state" => NULL, "address_zip" => NULL, "php_errormsg" => "Trying to get property of non-object", "planOwner" => NULL, "couponsAlreadyInBasket" => array(), "promo" => object(cbpaidpromotionTotalizertype), "checkResultTexts" => NULL)) on line 876 in file cbsubs.promotion.php
called in class cbpaidpromotionTotalizertype::getPromotionsApplicableForPlan("45", 57, "R", 0, object(cbpaidPaymentItem), 1452121200, true, array()) on line 1992 in file cbsubs.promotion.php
called in class getcbsubspromotionTab::onCPayAfterDisplayProductPeriodPrice("45", "<span class="cbregRate"><span class="cbregPriceCur"><span class="cbregPint cbregPintwCts">1440</span><span class="cbregPsep">,</span><span class="cbregPcts">00</span>&nbsp;<span class="cbregPcur">EUR</span></span></span><span class="cbregFor"> par </span><span class="cbregTimeframe">an</span>", array(0 => object(cbpaidPaymentItem), 1 => "renderPeriodPrice"), array(0 => "1440.00000", 1 => NULL, 2 => NULL, 3 => false, 4 => NULL, 5 => 1452121200, 6 => "1", 7 => "0", 8 => "R", 9 => 0, 10 => true, 11 => false, 12 => true, 13 => false))
called in function call_user_func_array(array(0 => object(getcbsubspromotionTab), 1 => "onCPayAfterDisplayProductPeriodPrice"), array(0 => "45", 1 => "<span class="cbregRate"><span class="cbregPriceCur"><span class="cbregPint cbregPintwCts">1440</span><span class="cbregPsep">,</span><span class="cbregPcts">00</span>&nbsp;<span class="cbregPcur">EUR</span></span></span><span class="cbregFor"> par </span><span class="cbregTimeframe">an</span>", 2 => array(0 => object(cbpaidPaymentItem), 1 => "renderPeriodPrice"), 3 => array(0 => "1440.00000", 1 => NULL, 2 => NULL, 3 => false, 4 => NULL, 5 => 1452121200, 6 => "1", 7 => "0", 8 => "R", 9 => 0, 10 => true, 11 => false, 12 => true, 13 => false))) on line 880 in file cbPluginHandler.php
called in class cbPluginHandler::call(547, "onCPayAfterDisplayProductPeriodPrice", "getcbsubspromotionTab", array(0 => "45", 1 => "<span class="cbregRate"><span class="cbregPriceCur"><span class="cbregPint cbregPintwCts">1440</span><span class="cbregPsep">,</span><span class="cbregPcts">00</span>&nbsp;<span class="cbregPcur">EUR</span></span></span><span class="cbregFor"> par </span><span class="cbregTimeframe">an</span>", 2 => array(0 => object(cbpaidPaymentItem), 1 => "renderPeriodPrice"), 3 => array(0 => "1440.00000", 1 => NULL, 2 => NULL, 3 => false, 4 => NULL, 5 => 1452121200, 6 => "1", 7 => "0", 8 => "R", 9 => 0, 10 => true, 11 => false, 12 => true, 13 => false))) on line 1293 in file cbPluginHandler.php
called in class cbPluginHandler::trigger("onCPayAfterDisplayProductPeriodPrice", array(0 => "45", 1 => "<span class="cbregRate"><span class="cbregPriceCur"><span class="cbregPint cbregPintwCts">1440</span><span class="cbregPsep">,</span><span class="cbregPcts">00</span>&nbsp;<span class="cbregPcur">EUR</span></span></span><span class="cbregFor"> par </span><span class="cbregTimeframe">an</span>", 2 => array(0 => object(cbpaidPaymentItem), 1 => "renderPeriodPrice"), 3 => array(0 => "1440.00000", 1 => NULL, 2 => NULL, 3 => false, 4 => NULL, 5 => 1452121200, 6 => "1", 7 => "0", 8 => "R", 9 => 0, 10 => true, 11 => false, 12 => true, 13 => false))) on line 174 in file cbpaidItem.php
called in class cbpaidItem::displayPeriodPrice("R", "X", 0, NULL, 1452121200, true, false, false) on line 398 in file cbpaidPaymentItem.php
called in class cbpaidPaymentItem::renderItemRate(true) on line 466 in file cbpaidPaymentItem.php
called in class cbpaidPaymentItem::renderColumn("rate", "html") on line 2221 in file cbpaidPaymentBasket.php
called in class cbpaidPaymentBasket::renderBasketItem(468, "rate", "html") on line 2141 in file cbpaidPaymentBasket.php
called in class cbpaidPaymentBasket::displayBasket() on line 139 in file cbpaidsubscriptions.offline.php
called in class cbpaidoffline::handleOtherResult(object(cbpaidPaymentBasket), array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578"), "showinstructions") on line 142 in file cbpaidHostedPagePayHandler.php
called in class cbpaidHostedPagePayHandler::resultNotification(object(cbpaidPaymentBasket), array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578"), true) on line 686 in file cbpaidControllerCBTab.php
called in class cbpaidControllerCBTab::getTabComponent(NULL, object(CB\Database\Table\UserTable), 1, array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578")) on line 1075 in file cbpaidsubscriptions.php
called in class getcbpaidsubscriptionsTab::getTabComponent(NULL, object(CB\Database\Table\UserTable), 1, array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578")) on line 84 in file cbpaidControllerCBComponent.php
called in class CBplug_cbpaidsubscriptions::getCBpluginComponent(NULL, object(CB\Database\Table\UserTable), 1, array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578"))
called in function call_user_func_array(array(0 => object(CBplug_cbpaidsubscriptions), 1 => "getCBpluginComponent"), array(0 => NULL, 1 => object(CB\Database\Table\UserTable), 2 => 1, 3 => array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578"))) on line 880 in file cbPluginHandler.php
called in class cbPluginHandler::call("538", "getCBpluginComponent", "CBplug_cbpaidsubscriptions", array(0 => NULL, 1 => object(CB\Database\Table\UserTable), 2 => 1, 3 => array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578")), NULL) on line 1369 in file cbTabs.php
called in class cbTabs::_callTabPlugin(NULL, object(CB\Database\Table\UserTable), "CBplug_cbpaidsubscriptions", "getCBpluginComponent", "538", array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578")) on line 1483 in file cbTabs.php
called in class cbTabs::tabClassPluginTabs(object(CB\Database\Table\UserTable), array("cmd" => "showinstructions", "amount" => "868.80000", "currency_code" => "EUR", "custom" => "2578"), "cbpaidsubscriptions", "CBplug_cbpaidsubscriptions", "getCBpluginComponent") on line 710 in file comprofiler.php
called in function tabClass("com_comprofiler", "pluginclass", 57) on line 271 in file comprofiler.php
called in function require_once("/var/www/html/components/com_comprofiler/comprofiler.php") on line 392 in file helper.php
called in class JComponentHelper::executeComponent("/var/www/html/components/com_comprofiler/comprofiler.php") on line 372 in file helper.php
called in class JComponentHelper::renderComponent("com_comprofiler") on line 191 in file site.php
called in class JApplicationSite::dispatch() on line 230 in file site.php
called in class JApplicationSite::doExecute() on line 252 in file cms.php
called in class JApplicationCms::execute() on line 45 in file index.php
$_GET = array (
  'plugin' => 'cbpaidsubscriptions',
  'cbpgacctno' => '7',
  'cbpbasket' => '2578',
  'result' => 'showinstructions',
  'cbpid' => 'cbp5693b2ead36b9274026588',
  'Itemid' => '175',
  'option' => 'com_comprofiler',
  'view' => 'pluginclass',
  'lang' => 'fr-FR',
  'task' => 'pluginclass',
)
$_POST = array (
  'cmd' => 'showinstructions',
  'amount' => '868.80000',
  'currency_code' => 'EUR',
  'custom' => '2578',
)

This seems to hang the offline payment and we cannot get to the pay slip.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48674
Thanks: 8313
Karma: 1446

9 years 1 day ago #276259 by krileon

Replied by krileon on topic CBSub importing baskets from CRM

You need to ensure all the payment tables were populated in the same way CBSubs would. You probably have missing information, which is going to cause problems as CBSubs and its integrations are expecting the information CBSubs would normally set.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon