Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Contributor Ulrich Sossou

    (@sorich87)

    This may or may not be possible depending on the plugin you are using to add the fields to the user’s profile. Which plugin are you using?

    Thread Starter queeneve

    (@queeneve)

    Thanks for the reply

    http://wordpress.org/extend/plugins/wp-crm/

    and I think it is possible but it needs to be customized in the csv file , as it is working fine with the text fields

    Thanks Thanks Thanks

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    Try exporting the users with the export feature of the WP CRM plugin and look at how the data is organised in these column.

    Thread Starter queeneve

    (@queeneve)

    🙁 🙁

    it was messed up

    http://blue-bug.com/csv/csv/

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    Yes, it’s very messed up. 🙁

    Looking at it though, I think to add the checkboxes, you need to add ‘on’ as value in the corresponding columns in the CSV.

    Do you know how to view the database content in your hosting control panel? (via PHPMyAdmin or something like that)

    Thread Starter queeneve

    (@queeneve)

    Thanks for your reply

    Yes I know how to access the PHPMyAdmin

    Please tell me how can i add the “on”

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    By example, if the country column was a checkbox, instead of putting “Egypt” (or something else) in that column, put “on” for each users for whom the box should be checked and leave empty for other users.

    Thread Starter queeneve

    (@queeneve)

    that means i have to create a new column for every country??then i put the word “on” same row of the user and under the row of the name of required country ??

    did i understand it properly??

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    Can you export the usermeta table from the database via PHPMyAdmin and show it to me?

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    I didn’t get any further reply from you. Can I consider this solved?

    Thread Starter queeneve

    (@queeneve)

    Thanks for for your reply

    I know that it should use( _option_ ) between the slug and the entry

    so if i want to select Egypt from the country , the column name should be (country_option_Egypt) and use the “on” option for the users in Egypt

    Thanks alot

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    Great. I’m glad you found the solution. 🙂

    Hey Ulrich,

    I’m using your awesome Plugin with WP-Members http://wordpress.org/extend/plugins/wp-members

    Everything works fine. Except I created to select /dropdown fields to add information to the user: sprache and ausbildung. When I import the csv file, the value is entered into the field, but on the backend in WordPress nothing is selected in the dropdown menü. It just says: Bitte Wählen Sie (Please choose).

    This is in the table of wp_options column wpmembers_fields
    a:8:{i:0;i:24;i:1;s:7:”Sprache”;i:2;s:7:”sprache”;i:3;s:6:”select”;i:4;s:1:”y”;i:5;s:1:”n”;i:6;s:1:”n”;i:7;a:3:{i:0;s:30:”<—- Bitte wählen Sie —->|”;i:1;s:8:” Deutsch”;i:2;s:8:”Englisch”;

    in wp-usermeta table I find the following in the columns meta_key and meta_value:
    meta_key: ausbildung meta_value: Experte
    meta_key: sprache meta_value: Deutsch

    Anything else I have to put into the CSV-file to show up the actual selected option in the dropdown menü?

    BTW, when I select another language (sprache) or education (ausbildung) then the entrie are gone in meta_value and the field is empty.

    Also, normal textfields I added via the wp-members plugin are showing up and everything works fine.

    Otherwise great job!

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘How to import values of the check box and drop down menu?’ is closed to new replies.