connect user to k2 group

I have done what the tutorial says but I get see screen shot
Am I supposed to do some thing with the country_info.sql file?

Dose it have any more uses or is it just a field that you can select rather than have to type out the country name?

It's just a normal CB field that gets its values from a database query, nothing more. If you've followed the tutorial correctly then in profile edit your Country field should display all the countries and you can select 1 from it.

Yes Thanks but I m not sure what a database query is.
I think it is a php myadmin thing can you tell me where to put it and how?
could it call up a k2 category?

I think I have followed the tutorial correctly?
Am I supposed to do some thing with the country_info.sql file?
Thanks

could it call up a k2 category?

I suppose it could if you wrote a database query to pull the K2 categories the setup the value and label column parameters as needed.

I think I have followed the tutorial correctly?
Am I supposed to do some thing with the country_info.sql file?

You import the SQL file into your Joomla database using phpMyAdmin. The query provided in the tutorial is the query needed to use it with a query field (see Step 5). If you have any further questions I suggest contacting a contract web developer and having them implement it for you as this is advanced usage involving database queries (not simple and could be damaging if done wrong).

I highly suggest hiring someone to help you with all of this or grab some good SQL, PHP, and phpMyAdmin books or tutorial sites and start learning. I'm not a teacher so I don't know how to explain to you basic phpMyAdmin or SQL usages and can only provide you with example as I've already done as well as the tutorial has already done. The below site has some great tutorials to get going.

www.w3schools.com/

You can find the MYSQL documentation below, which is very helpful for learning function usages.

dev.mysql.com/doc/refman/5.6/en/index.html

You can find the phpMyAdmin documentation below, which can help you with import usage and navigation.

www.phpmyadmin.net/home_page/docs.php

Please understand your original K2 usage needs are still going to require custom development. This will not provide what you're wanting as 500 actions is too much to execute all at once.

I have imported the (country_info.sql (1).zip) and I got this message

Import has been successfully finished, 258 queries executed.
what does the 258 queries executed mean? is the 258 queries the country's?

The country_info.sql does it connect to www.geonames.org externally and look up its database or is it copied to mine?

How can I get CB Query field plugin to connect to www.geonames.org and get the post codes of Australia or towns of Australia is that possible?

The country and the auto join field see attached has a little white gap at the top that stops the country being displayed properly can that be fixed?
Can I display the hole country name instead of au ?

matthewdavey wrote: I have imported the (country_info.sql (1).zip) and I got this message

Import has been successfully finished, 258 queries executed.
what does the 258 queries executed mean? is the 258 queries the country's?

The country_info.sql does it connect to www.geonames.org externally and look up its database or is it copied to mine?

How can I get CB Query field plugin to connect to www.geonames.org and get the post codes of Australia or towns of Australia is that possible?

The country and the auto join field see attached has a little white gap at the top that stops the country being displayed properly can that be fixed?
Can I display the hole country name instead of au ?

We really have no experience with geonames.com service - you need to ask them for support.

I also had some issues getting country data for this tutorial:

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

that's why I posted my own sql file in the tutorial.