- Forums
- Community Discussions
- Community Builder
- General
- What is the Correct Excel format for Region, Country, and State
What is the Correct Excel format for Region, Country, and State
- Xlym
- OFFLINE
-
Junior Member
- Posts: 38
- Thanks: 5
- Karma: 0
6 months 6 days ago #335526
by Xlym
What is the Correct Excel format for Region, Country, and State was created by Xlym
I am studying how to reproduce user’s location fields using CB Query (see attached image).
Your videos were very helpful.
Based on your demo, I understand there are 3 columns: (1) “Region”, (2) “Country”, and (3) “State”.
However, the only information I am missing is the format of the Excel sheet to import the data to the database.
Is the format on the attached image correct?
Your videos were very helpful.
Based on your demo, I understand there are 3 columns: (1) “Region”, (2) “Country”, and (3) “State”.
However, the only information I am missing is the format of the Excel sheet to import the data to the database.
Is the format on the attached image correct?
Please Log in to join the conversation.
krileon
Team Member- ONLINE
- Posts: 68537
- Thanks: 9093
- Karma: 1434
6 months 6 days ago #335528
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 What is the Correct Excel format for Region, Country, and State
That example is using the database provided by CB Paid Subscriptions. Below is an example using an independents database, but only supports US state and city.
www.joomlapolis.com/documentation/345-cb-query-field/tutorials/18533-configuring-dynamic-usa-state-city-zip-fields-with-cb-query-field-plugin
What your database looks like is entirely up to you. There's thousands of examples across the web for such a database. Below is another example for a Country field that uses geonames.org data.
www.joomlapolis.com/documentation/345-cb-query-field/tutorials/18377-configuring-a-country-field-with-cb-query-field-plugin
www.joomlapolis.com/documentation/345-cb-query-field/tutorials/18533-configuring-dynamic-usa-state-city-zip-fields-with-cb-query-field-plugin
What your database looks like is entirely up to you. There's thousands of examples across the web for such a database. Below is another example for a Country field that uses geonames.org data.
www.joomlapolis.com/documentation/345-cb-query-field/tutorials/18377-configuring-a-country-field-with-cb-query-field-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 to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Community Discussions
- Community Builder
- General
- What is the Correct Excel format for Region, Country, and State
Time to create page: 1.470 seconds
-
You are here:
- Home
- Forums
- Community Discussions
- Community Builder
- General
- What is the Correct Excel format for Region, Country, and State