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!

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.

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...

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.

Post edited by: chucktrukk, at: 2006/06/04 12:05

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...

Attachment country_list.txt not found

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

Attachment CB_time_zones_import_file.txt not found

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

Thanks in advance!!!