Arrow Home arrow Forums
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Joomlapolis Forums  


Boardwalk :: Forum List Important Content Community Builder Article Discussions
Re:How to populate a CB Field with a Country List
Date: 2008/05/08 19:58 By: ubertramp Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 8
graphgraph
ryurage wrote:
Alright, this is the second time and last time I'll try to post this. This joomlapolis.com site totally rules except the session time on here blows. Nothing like typing out a post and it not getting posted. [/rant]

Moving on. I have a host (bluehost) and they have several built in programs to input sql. They have PHPMyAdmin and it's a piece of cake to use without being a guru. However, they do NOT have that option built in with it to 'insert data from a text file'. Crap!! Here's what to do:

1. Download my file from this post and open in in a text editor to change the line that says 'var fieldid'. Make the fieldid equal to your number. Save the file.

2. Open the file in a browser. Copy all of it.

3. Next, go to your PHPMyAdmin and click the '_joom2' database and then the 'jos_comprofiler_field_values' table.

4. Now click the 'SQL' tab at the top. Paste. Don't touch anything else except click the 'Go' button. Done.

You now have a decent country list. Apostrophes in the country name won't mess things up either.

Thanks, ryurage, you made the whole process 1000 times easier. Kudos!

http://www.ubertramp.com
Click here to see the profile of this user The administrator has disabled public write access.


      Topics Author Date
    thread link
How to populate a CB Field with a Country List
Onlyeyes 2005/12/20 01:16
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
comenius 2006/01/22 02:45
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
mischa 2006/06/26 15:36
    emo
thread linkthread link Re:How to populate a CB Field with a Country List
vdean 2006/02/23 12:03
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
hrefna 2006/03/19 16:35
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
hansmeiser 2006/03/22 00:54
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
smeallum 2006/07/31 05:59
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
heymcd 2006/07/31 06:21
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
moomola 2007/03/03 09:41
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
mvines 2006/04/01 12:20
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
stodd 2006/04/08 06:49
    emo
thread linkthread link Re:How to populate a CB Field with a Country List
Aloga 2006/04/10 07:22
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
petschni 2006/04/21 21:25
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
Bink 2006/04/24 09:24
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
mikko 2006/04/24 12:42
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
Bink 2006/04/25 14:21
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
nant 2006/04/25 15:01
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
Bink 2006/05/03 01:07
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
nant 2006/05/03 04:05
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
Bink 2006/06/02 10:33
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
dsendecki 2006/05/03 12:53
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
ryurage 2008/04/11 17:57
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
ryurage 2008/04/11 19:51
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
ubertramp 2008/05/08 19:58
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
Spydey 2006/04/27 14:39
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
meisay 2006/04/29 07:10
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
Notexa 2006/04/30 09:43
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
meisay 2006/05/01 14:10
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
nant 2006/05/01 16:07
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
amellie 2006/05/20 18:48
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
Bink 2006/06/02 10:28
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
parth 2006/06/19 21:05
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
pakito1 2006/05/22 17:40
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
bzn 2006/05/28 00:11
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
chucktrukk 2006/06/04 18:03
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
jimcintosh 2007/05/21 23:30
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
MikeDLA 2006/06/04 05:26
    emo
thread linkthread link Shame on whoever created the country list !
madcat 2006/06/27 22:16
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
heymcd 2006/07/09 18:38
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
heymcd 2006/07/09 19:19
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
joseph 2007/02/20 11:02
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
joseph 2007/02/20 11:25
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
joseph 2007/02/20 11:28
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
madcat 2006/07/09 19:29
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
heymcd 2006/07/09 19:56
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
madcat 2006/07/09 20:42
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
heymcd 2006/07/09 19:57
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
madcat 2006/07/09 20:23
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
sunny 2006/07/24 13:12
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
Chaos 2006/07/27 20:36
    emo
thread linkthread link Yes i've noticed this problem.
madcat 2006/07/31 06:19
    thread link
thread linkthread linkthread link Re:Yes i've noticed this problem.
smeallum 2006/07/31 06:32
    thread link
thread linkthread linkthread linkthread link Re:Yes i've noticed this problem.
madcat 2006/07/31 06:43
    thread link
thread linkthread linkthread linkthread linkthread link Re:Yes i've noticed this problem.
smeallum 2006/07/31 10:11
    thread link
thread linkthread linkthread linkthread linkthread link Re:Yes i've noticed this problem.
smeallum 2006/07/31 10:11
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Yes i've noticed this problem.
heymcd 2006/07/31 10:32
    emo
thread linkthread linkthread linkthread linkthread linkthread link Re:Yes i've noticed this problem.
madcat 2006/07/31 10:49
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
heymcd 2006/07/31 11:05
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
madcat 2006/07/31 11:26
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
panter011 2007/07/18 05:06
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
panter011 2007/07/18 19:15
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
nzimas 2007/08/27 03:21
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
nzimas 2007/08/27 03:23
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
nzimas 2007/09/13 22:56
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
nzimas 2007/09/13 23:03
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
agouldtdc 2007/09/13 16:38
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
alek 2006/10/18 16:28
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
BlueFightingCat 2006/11/01 21:01
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
Dukessa 2008/06/05 21:27
    thread link
thread linkthread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
alibak 2008/10/20 07:05
    emo
thread linkthread link Re:How to populate a CB Field with a Country List
Tdoc 2006/11/27 23:00
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
spacewalk 2007/04/13 15:44
    thread link
thread linkthread linkthread link Re:How to populate a CB Field with a Country List
dartagnan 2007/05/17 05:27
    thread link
thread linkthread linkthread linkthread link Re:How to populate a CB Field with a Country List
dartagnan 2007/05/17 06:45
    thread link
thread linkthread link Re: Como llenar un campo de CB con lista de paises
nachocano 2007/09/16 22:00
    emo
thread linkthread linkthread link Country list - Can't it be more easier?
baijianpeng 2007/11/11 12:55
    thread link
thread linkthread linkthread linkthread link Re:Country list - Can't it be more easier?
beat 2007/11/11 13:00
    thread link
thread linkthread linkthread linkthread linkthread link Re:Country list - Can't it be more easier?
baijianpeng 2007/11/12 06:33
    thread link
thread linkthread linkthread linkthread linkthread link Re:Country list - Can't it be more easier?
royce 2007/11/12 20:57
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Country list - Can't it be more easier?
beat 2007/11/16 00:59
    thread link
thread linkthread linkthread linkthread linkthread link Re:Country list - Can't it be more easier?
sjnims 2008/05/05 17:42
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
mbacou 2007/11/29 07:14
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
mbacou 2007/11/29 07:18
    thread link
thread linkthread link Re:How to populate a CB Field with a Country List
MzT 2008/03/09 23:55
Boardwalk :: Forum List Important Content Community Builder Article Discussions

Joomlaboard Forum Component 1.1.3 Stable
Two Shoes M-Factory

Documentation

Documentation Subscription Service
(updated for CB 1.2 RC2)

What?

Why?

Where?

Just click here for answers!

Click here for a yearly subscription: subscribe now

Download Latest Release

The latest stable Community Builder Release is version 1.1 for Joomla 1.0 and Mambo.
You need to be a registered member of Joomlapolis to download.

The latest release candidate of Community Builder is version 1.2 RC3, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers at this time.

CB Login