Importing users to Buddypress with custom fields

I ended up writing a bunch of MySQL statements. My process went:

  1. Add users into wp_users.
  2. Add first name into wp_usermeta.
  3. Add last name into wp_usermeta.
  4. Add nickname into wp_usermeta.
  5. Add last activity into wp_usermeta. (This is important for BuddyPress; otherwise, users won’t show up in the members-loop)
  6. Add name to BuddyPress.
  7. Add custom “phone” field to BP.
  8. Add custom “fax” field to BP.
  9. Add custom “company” field to BP.

If anybody doing something similar comes across this question and would like the SQL I used, feel free to message me. After half a dozen people requested the SQL code I have, I’ve written a blog post that includes the full SQL I used, plus a basic importer script. See: http://aendrew.com/content/importing-proprietary-user-database-buddypress-boss

Related Posts:

  1. Importing data for advanced custom fields plugin?
  2. importing data from non-wordpress mysql db
  3. Create Posts using Import>RSS/WXR/XML and pass values to Custom Fields
  4. Inserting data into MagicFields using mysql queries
  5. With WordPress Importer, why can’t I import post meta containing a multi-dimensional array, in which value(s) of that array contain line breaks?
  6. Remove old custom field after import
  7. Query meta field using between
  8. Insert post without actions/hooks
  9. Move value of one custom field to another
  10. Programatically import custom fields using wp all import [closed]
  11. Get multiple custom field values in a $wpdb query [duplicate]
  12. Difference between ‘LIKE’ and ‘IN’ in meta queries
  13. little help with a mySQL query to wp database
  14. BuddyPress – Hook to Update Custom Profile Fields [closed]
  15. MySQL query to set wp_postmeta using term_taxonomy_id value
  16. Redirect users based on custom field
  17. Importing from XML is ignoring serialized custom field
  18. Buddypress Add unserialized Profile Fields in Members Loop [closed]
  19. MySQL Query that looks for post with Custom Field, then changes Category
  20. Unique Post Meta Values
  21. Excluding Specific Fields from Profile Builder Registration Form
  22. Custom Profile Fields move from BBpress to BuddyPress
  23. Add custom field to all posts in specific post_type
  24. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  25. Importing WordPress Posts With Custom Meta Data As CSV Files Through PHPMyAdmin
  26. Copy price categories to custom field
  27. If I update WordPress my custom data will be deleted from the wp_users table?
  28. Update post meta data (custom field) by post link
  29. Help setting up a sql query
  30. wpdb function insert doesn’t work
  31. How to improve my non-unique metadata MySQL entries?
  32. Very large list of options for BuddyPress profile fields
  33. Delete a custom field in mysql for all posts with specific category id
  34. Featured image from custom to WordPress database
  35. use mysql to replace one custom field value with another custom field value
  36. Copy url from post_content to custom field
  37. Import data from arbitrary CSV to WPAlchemy meta fields
  38. Convert many posts from having a specific meta_key to use a post_format
  39. Custom Search, MySql Query Gone Wrong?
  40. Can running a WP-Cron to update_post_meta cause performance issues?
  41. How to hide a field on the frontend of a Buddypress page by field ID according to user roles and login status?
  42. Contact Form 7 List Building
  43. author global display format
  44. Link fields in User Admin list
  45. register_form, custom field not submitted on first try
  46. How to use a custom field with add_rewrite_rule()?
  47. what would be a good example of a php dynamic code to display contents of textarea?
  48. want to add video upload option for front end user
  49. 4 Unique Random Posts based on Custom Field Values
  50. Populate custom post type/custom fields from an external database
  51. to create a custom post type with additionnal url field such as link to social network and an email field
  52. Create Meta boxes dynamically
  53. Custom field group on page
  54. How to save array option as text and not integer?
  55. Outputting custom field on home.php not outside of blog list
  56. Custom Fields Not Working In Footer
  57. How to delete attachments associated with custom field type when post property changes? [closed]
  58. How to repeate custom field group with bulk image field
  59. Importing URLs of Audio Enclosures
  60. Load one page with parent and child pages
  61. Output Custom Field value to shortcode
  62. Update custom table on metabox POST
  63. Why can’t I get the correct post permalink
  64. Get link picker custom field to show only if field exists
  65. PHP and Shortcode Combination
  66. Use a different catalog image than the featured image
  67. Sub Field of File Field
  68. ACF – Compare user and post data
  69. Login Api with Meta_key and Meta_value
  70. ACF plugin and field update
  71. Theme page headers and rotator images not assigned after website migration
  72. Advanced Custom Fields deleting some code and adding code for a slider
  73. Save input form on custom field
  74. Retrieving and inserting data in custom fields
  75. How to add custom fields to images for image source text and URL
  76. Counting number of images from loop
  77. Include a custom field in mysql query
  78. Page template is missing fields or is invalid when I updating the template
  79. User custom meta delete by serialised key value
  80. Metabox value for post loop?
  81. Adding fields to attachment – only shows when inserting new attachments
  82. Order categories by sum of custom fields
  83. how to modify a field’s size in a metabox : ROWS height, and scroll control?
  84. Add commentmeta custom field to every published comment with SQL
  85. Saved Post Meta Array Returns as String
  86. How to add content with a filter when there’s no content in the editor
  87. Login_form add to top of form rather then bottom
  88. meta_query ‘compare’ => ‘!=’ not working
  89. Weird characters displayed when importing WordPress MySQL db
  90. Advanced Custom Fields from Category – IF statement
  91. Check for meta data before it is published
  92. Query Multiple meta
  93. If metabox fields has content display content
  94. I have a form with a custom button ,i want to add the field data to an database when clicking the custom button
  95. Stop truncation of shortcodes in custom text fields?
  96. Delete custom meta
  97. custom field images do not display until page save
  98. How to check custom fields from functions.php
  99. Save custom post data outside of default post form
  100. display custom media folders to wordpress media popup
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)