WordPress.org

Ready to get started?Download WordPress

Forums

Import Users from CSV
[resolved] How to import values of the check box and drop down menu? (14 posts)

  1. queeneve
    Member
    Posted 1 year ago #

    Thanks for the great plugin ,

    Actually the plugin works great with the text fields but I am trying to import values for a drop down menu , like for example country user should choose one of the countries from a drop down menu( also the same for the check box )

    when I create the CSV with the header "country" it doesnt choose the country in the user profile

    I am attaching 3 images for the following:

    1) shows the settings of the profile

    http://blue-bug.com/csv/1-import%20users%20from%20csv.png

    2) shows the csv file

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

    3) how the user profile should appear if it was imported properly

    http://blue-bug.com/csv/3-after%20import.png

    Thanks a looooooooot

    http://wordpress.org/extend/plugins/import-users-from-csv/

  2. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

    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?

  3. queeneve
    Member
    Posted 1 year ago #

    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

  4. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

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

  5. queeneve
    Member
    Posted 1 year ago #

    :( :(

    it was messed up

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

  6. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

    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)

  7. queeneve
    Member
    Posted 1 year ago #

    Thanks for your reply

    Yes I know how to access the PHPMyAdmin

    Please tell me how can i add the "on"

  8. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  9. queeneve
    Member
    Posted 1 year ago #

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

  10. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

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

  11. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

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

  12. queeneve
    Member
    Posted 1 year ago #

    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

  13. Ulrich Sossou
    Member
    Plugin Author

    Posted 1 year ago #

    Great. I'm glad you found the solution. :)

  14. seville76
    Member
    Posted 1 year ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.