Skip to Content Skip to Menu

CBSubs Plan Invoice: Pre-Populating Information

  • cagoffice
  • cagoffice
  • OFFLINE
  • Posts: 478
  • Thanks: 27
  • Karma: 4
9 years 4 months ago #266148 by cagoffice
When my user is prompted to pay for their plan, parts of the invoice are pre-populated and some are not which makes me think that I have my fields set up incorrectly.

Specifically:
First Name
Last Name
State/Province (I currently have it as a text field but I think it should be a drop down)

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 4 months ago #266159 by krileon
There's a bug with Name mapping. It only maps the last name if it maps at all. It'll work fine if you use single name field, but if you use first and last name usage like most then only last name maps properly.

State/Province will only map if the value stored in CB matches the exact value that CBSubs expected. In most causes this is the 2 or 3 character country or state code for example. Being a text field users are likely supplying the full country text so it won't map.


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.

  • cagoffice
  • cagoffice
  • OFFLINE
  • Posts: 478
  • Thanks: 27
  • Karma: 4
9 years 4 months ago #266170 by cagoffice
Replied by cagoffice on topic CBSubs Plan Invoice: Pre-Populating Information
Is there a way for my field to match what CBSubs is expecting? Like, am I presenting the field incorrectly? Or is a text field okay and then the person will just have to fill in the missing information for the invoice?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 4 months ago #266176 by krileon
You'd need to use a select fieldtype that has the same values that CBSubs provides. Best way to do this is a CB Query Field and its Query Select fieldtype then use a database query to grab CBSubs exact values from its _comprofiler_provinces and _comprofiler_countries tables. See the below for an example of this usage.

www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin

Note you don't need the SQL file in the above tutorial as you'd just be using CBSubs already existing tables. So for example you'd have a query select field with the below.

Query:
Code:
SELECT a.`province_iso_code` AS code, a.`province_name` AS province, b.`country_name` AS country FROM `#__comprofiler_provinces` AS a LEFT JOIN `#__comprofiler_countries` AS b ON b.`country_iso_code2` = a.`country_iso_code2`
Value Column: code
Label Column: province
Group Column: country


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.

9 years 4 months ago #266609 by zacmarshall
Replied by zacmarshall on topic CBSubs Plan Invoice: Pre-Populating Information

krileon wrote: There's a bug with Name mapping. It only maps the last name if it maps at all. It'll work fine if you use single name field, but if you use first and last name usage like most then only last name maps properly.


Hi, Just wondered if there was a plan for when a fix for the name mapping would be available? I have looked but couldn't find anything.

Zac

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 4 months ago #266619 by krileon
Yes, a fix is still planned. No, I don't know when. The ticket is currently scheduled for next bug fix release.


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.

Moderators: beatnantkrileon
Powered by Kunena Forum