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
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
Re:How to populate a CB Field with a Country List
Date: 2006/05/03 01:07 By: Bink Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 5
graphgraph
SQL knowledge is needed to use that page. For example, the log in steps to get to MySQL are missing steps. When I stated step by step that is literally what I meant. Some designers are not familiar with MYSQL or PHP. This component is a Joomla add on and it seems more complicated to use than Joomla. These are my experiences with this application.

There are several mods for this comp. but each require work in the db. ex. the Birthday component. Is there a user's manual that is easy to read for this sw?
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to populate a CB Field with a Country List
Date: 2006/05/03 04:05 By: nant Status: Admin  
Karma: 467  
Admin

Posts: 6235
graph
Bink wrote:
SQL knowledge is needed to use that page. For example, the log in steps to get to MySQL are missing steps. When I stated step by step that is literally what I meant. Some designers are not familiar with MYSQL or PHP. This component is a Joomla add on and it seems more complicated to use than Joomla. These are my experiences with this application.

There are several mods for this comp. but each require work in the db. ex. the Birthday component. Is there a user's manual that is easy to read for this sw?

Well ...
We can easily do this by using phpmyadmin to make some additions to the related comprofiler tables.

It is assumed that you know how to start the phpmyadmin application on your host. If not then you have problems.
Nick A.
CB Core Team Member
Support CB Development and Get Detailed Documentation
Developer of Nant's Gallery plugin
CB Gallery Extensions Listing, Rate CB Gallery on Extensions Site
Developer of CB AutoWelcome Plugin
CB AutoWelcome Extensions Listing,Rate CB AutoWelcome on Extensions Site
People ignoring your call for help? Read this!
FAQ you
Joomlapolis Extensions Directory (new)- check it out!
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to populate a CB Field with a Country List
Date: 2006/05/03 12:53 By: dsendecki Status: User  
Karma: 13  
Gold Joomlapolitan

Posts: 386
graphgraph
This goes beyond the kind of support that any developers need necessarily provide.

There are alternatives -- you can enter each country in individually, for example -- if you are unable to use PHPmyADMIN. Alternatively, you could hire someone to do this for you.

If you are around this weekend -- I could help you. PM me your MSN or Google Talk ID and we can chat about it.
Small Press Exchange | Free eBook templates for self publishing | My Blog
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to populate a CB Field with a Country List
Date: 2006/05/20 18:48 By: amellie Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 1
graphgraph
I read the previous posts in this thead and found that a lot of people are getting SQL commands error... (the same thing that happened to me last time). So I edit the file (country_list.txt) so that it's using SQL commands.

Attached is the edited version of the country_list.txt...

If you want to use it, you have to do 2 things:
- change "put-the-table-name-here" to be the table name of the community builder.. in my case is "jos_comprofiler_field_values" (without the quote).
- change "put-the-fieldid-here" to be the fieldid value.

then you can just import the file into phpmyadmin...
File Attachment:
File name: country_list.txt
File size:24399 bytes
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to populate a CB Field with a Country List
Date: 2006/05/22 17:40 By: pakito1 Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 10
graphgraph
Country list in spanish
-Listado de paises en español
File Attachment:
File name: paises_cb.zip
File size:2230 bytes


Post edited by: pakito1, at: 2006/05/22 11:43
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to populate a CB Field with a Country List
Date: 2006/05/28 00:11 By: bzn Status: User  
Karma: 2  
Senior Joomlapolitan

Posts: 69
graphgraph
Some of you guys might have the same problem as I had. My webspace provider disabled this function "Insert data from a text file into the table" because of security issues. I always got the error "#1045 - Access denied for user: 'xxxxxxxx@localhost' (Using password: YES)". I had to change the whole procedure. If somebody is interested, please pm me. SQL knowledge is still needed!
________________________________________
I'm running Joomla v1.5.5 and CB v1.1
Click here to see the profile of this user The administrator has disabled public write access.

<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
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 RC4)

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 RC4, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers and now also to all registered joomlapolitans.

CB Login