This would require a custom script, and be pretty complicated for an existing content base. It would be easier if you were starting from scratch with only one xtra field
It would be an good idea to create a plugin that uses existing code that you can find in many exeetnison such as akeeba subs, to present the list for you, and stuff the value selected into the k2 xtra field.

Thks for the swift answer. I am starting from scratch.
How easier would it be?
I remember doing this for the CB (Community Builder) and the SQL table was just the country fields.
Thank you,

Alek

easy is relative. i know a couple of people who do k2 plugins, i will pass the idea along to them

I can help if you send the csv file of countries.

I will convert it to the appropriate format and send it to insert directly in the database.

Thank you very much. :)
Here is the CSV file with just the country names.
How will add the required infos? :unsure:
Thanks a million.

Alek

Hi Mohamed,
Here is the country fil in ZIP format, the only accepted by the Forum.
Thansk again,
Alek

Hi Alek,

Please find the attached file

1- If you have not added the country extra field, please create it with only one country, it will be enough.
2- Uzip the file and open the txt file.
3- copy the text in the file.
4- go to phpmyadmin.
5- open the '#_k2_extra_fields' table and edit the row of th country extra file.
6- paste the copied text into the 'value' column of this field.
7- Save

Now you have full country dropdown list.

:) Thanks a million! Mohamed!!!
It worked easily and I now have all the countries in my drop down field. How dod you enter the Value number etc... needed??

I'm working on a local server on the next version of my site www.donalek.com about chocolate, which uses K2. So you can't see the result of work yet, but it will be online by end of March latest.
Thanks again,
Alek

No problem Alek ;)

I did it with some sql statements, within 15 mins it was ready.

Looking forward to have a look at your new site.

I'm ready in case you need any help.