CBSub importing baskets from CRM
- activha
- OFFLINE
-
Platinum Member
- Posts: 2279
- Thanks: 113
- Karma: 13
8 years 4 months 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
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 to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68555
- Thanks: 9098
- Karma: 1434
8 years 4 months ago #275623
by krileon
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.
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 to join the conversation.
- activha
- OFFLINE
-
Platinum Member
- Posts: 2279
- Thanks: 113
- Karma: 13
8 years 4 months 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 ?
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 to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68555
- Thanks: 9098
- Karma: 1434
8 years 4 months ago #275996
by krileon
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.
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.
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.
The following user(s) said Thank You: activha
Please Log in to join the conversation.
- activha
- OFFLINE
-
Platinum Member
- Posts: 2279
- Thanks: 113
- Karma: 13
8 years 3 months 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 :
This seems to hang the offline payment and we cannot get to the pay slip.
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> <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> <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> <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> <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 to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68555
- Thanks: 9098
- Karma: 1434
8 years 3 months ago #276259
by krileon
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.
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.
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 to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.389 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- CBSub importing baskets from CRM