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/06/02 10:28 By: Bink Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 5
graphgraph
I'm getting a 404 error message when I try to access this file. Does anyone have this file or a fix to how to use this list? My host removed the "Insert data from a text file into the table" link in myphpadmin so I don't have that as an option and do not want to enter each country manually.

Help is appreciated. Thanks!
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/06/02 10:33 By: Bink Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 5
graphgraph
I missed your comment about starting the myphpadmin. That I know how to start so I don't have problems. The posts after your post state that many hosting providers do not have that option of Insert data from a text file into the table that the directions state. Others are having the same problems. Maybe these text files or any text files going forward for any fixes or hacks should be written in a SQL format so that it can be universally used.
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/06/04 05:26 By: MikeDLA Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 8
graphgraph
My version of myphpAdmin (2.8.0.2 at my web host) does not have the "insert data from a text file into the table" link.
So I guess I'm at a dead end...
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/06/04 18:03 By: chucktrukk Status: User  
Karma: 11  
Junior Joomlapolitan

Posts: 31
graphgraph
I have attached a version of the statelist for people using older versions of PHPMyAdmin.

Instructions for Use:
1. Download the file
2. Open File with Notepad (or whatever text editor)
3. Replace Your-Fieldid-Number-Here with your field id
4. Save
5. in PHPMyAdmin, go to jos_comprofiler_field_values
6. Click Import
7. Choose this file

This worked for me.

Chuck

DISCLAIMER
This may not work for you. I make no guarantees and give no warranties for this. I am not liable for anything good or bad that may happen when you use this file.
File Attachment:
File name: SQL_Import_For_Dist_cb_statelist.txt
File size:5325 bytes


Post edited by: chucktrukk, at: 2006/06/04 12:05
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/06/19 21:05 By: parth Status: CB Doc subscriber  
Karma: 1  
Senior Joomlapolitan

Posts: 53
graphgraph
Hello the file in question is not on the server anymore...
Can u please re attach it??

Parth


amellie wrote:
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
Php-Nuke to Mambo to Joomla...
My Evolution goes on!
Need Joomla Development?
Drop me a mail!
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/06/26 15:36 By: mischa Status: User  
Karma: 7  
Senior Joomlapolitan

Posts: 78
graphgraph
comenius wrote:
Here's the same thing, but for time zones. You'll need to follow the same directions for creating the country list.

-David
File Attachment:
File name: CB_time_zones_import_file.txt
File size:3251 bytes


Would it be possible to re-upload/re-attach this file again, because it's already deleted from the server...

Thanks in advance!!!
Projectmember of the BirthDays Module Project
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 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