Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

Region Field and City Field

  • fduchesne
  • fduchesne
  • OFFLINE
  • Posts: 30
  • Thanks: 4
  • Karma: 0
11 years 9 months ago - 11 years 9 months ago #218482 by fduchesne
Region Field and City Field was created by fduchesne
Hello,

I would like to create in CB profil a field for the french Region (from 1 to 95) and after to link to another field where there is some city of this Region.

I would like to know if there is a simple way to create it, or if there is some liste that I can import ?

Thanks for your response.

Best Regards.

Fred
Last edit: 11 years 9 months ago by fduchesne.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #218525 by krileon
Replied by krileon on topic Re: Region Field and City Field
You'll have to add them 1 by 1 to a new select fieldtype within CB > Field Management or use database queries to insert the values for the field into _comprofiler_field_values.


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.

  • fduchesne
  • fduchesne
  • OFFLINE
  • Posts: 30
  • Thanks: 4
  • Karma: 0
11 years 9 months ago #218558 by fduchesne
Replied by fduchesne on topic Re: Region Field and City Field
Hello,

I don't thinks it's a good solution because for city I have 36 678 items.

For region I have 100 Items, and I have join between region and city. I have a look on the _comprofiler_field_values table, but I just have the possibilité to add on value for each items.

For example my city have a name, a postal code and a region number (who is the fiel can join to my region items).... So you solution is not possible.

Do you know if it's possible to create my own CB field with my personal table ?

Thanks for your response.

Best Regards.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #218561 by krileon
Replied by krileon on topic Re: Region Field and City Field
Your best solution then is to create your own fieldtype plugin that has its own database that it pulls from and builds the select field for. Review existing fieldtype plugins such as Ajax Text, File, Video, etc.. for a starting point to develop your own plugin.


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.

  • fduchesne
  • fduchesne
  • OFFLINE
  • Posts: 30
  • Thanks: 4
  • Karma: 0
11 years 9 months ago #218567 by fduchesne
Replied by fduchesne on topic Re: Region Field and City Field
Ok I will try to develop my personal fieldtype plugin (and I will put on CB site when it will be done). Do you have an example of simple fieldtype pluggin I can use ? I had a look on the Ajax FieldType pluggin but I mean it's not the more easy :).

Thanks you for your help.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #218569 by krileon
Replied by krileon on topic Re: Region Field and City Field
You can review the below fieldtype plugins as examples. All have varying degrees of difficulty. I suggest reviewing each and finding which best fits a starting point for you.

CB Video field plugin version 1.0
CB Template Changer plugin version 2.0.2
CB Query field plugin version 2.0.1
CB Progress field plugin version 2.1
CB Gravatar field plugin version 1.0
CB Database Lookup field plugin version 1.0
CB Ajax Points field plugin version 1.0
CB Rating Fieldtype Plugin v.1.0
CB Ajax Text Fieldtype Plugin v.1.4.8
CB Ajax File Fieldtype Plugin v.1.6


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