{"id":243,"date":"2010-08-14T22:04:00","date_gmt":"2010-08-15T05:04:00","guid":{"rendered":"http:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/?p=243"},"modified":"2016-03-02T21:57:38","modified_gmt":"2016-03-03T04:57:38","slug":"how-to-bulk-upload-member-details-from-a-csv-file","status":"publish","type":"post","link":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243","title":{"rendered":"How to Bulk Upload\/Import Member Details from a CSV File"},"content":{"rendered":"<div class=\"custom_yellow_box\">\n<p><strong>Update:<\/strong> You should use the <strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/bulk-member-data-importer-addon-853\">bulk member data importer addon<\/a><\/span><\/strong> to import member data.<\/p>\n<\/div>\n<p>You can use the <strong><a href=\"https:\/\/www.tipsandtricks-hq.com\/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116\" target=\"_blank\">WP CSV to DB plugin<\/a><\/strong> to upload member details from a CSV file into the WP eMember&#8217;s database.<\/p>\n<p>Before you use this method please note that if you want to import your WordPress users into eMember then there is an easier option for you. Simply browse to the &#8220;Import WP Users&#8221; tab from the &#8220;Members&#8221; menu and you will be able to import all your WordPress users into eMember.<\/p>\n<h3>Setup\/Preparation<\/h3>\n<ul>\n<li>Install the <strong><a href=\"https:\/\/www.tipsandtricks-hq.com\/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116\">WP CSV to DB<\/a><\/strong> plugin.<\/li>\n<li>Download the <strong><a href=\"http:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-content\/uploads\/2010\/08\/members.csv\">members.csv<\/a><\/strong> template file and open it using Microsoft Excel.<\/li>\n<li>Fill up the member details; One member per row (There are two example entries in that file so replace them with actual details).<\/li>\n<li>Once you are done entering all your member details then save the file as a CSV file.<\/li>\n<\/ul>\n<h3>Specify the General Options<\/h3>\n<ul>\n<li>Enter 2 in the &#8220;Starting Row&#8221; field. This is the row number in the CSV file where you want the plugin to start reading from (the first row is the column titles so you want to read from the 2nd row)<\/li>\n<li>Enter &#8220;wp_wp_eMember_members_tbl&#8221; in the &#8220;Database Table Name&#8221; field (this is the database table name for the WP eMember&#8217;s\u00a0member table given you haven&#8217;t change the default database prefix of wordpress)<\/li>\n<li>Enter the content of this <strong><a href=\"http:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-content\/uploads\/2010\/08\/eMember_column_names.txt\" target=\"_blank\">text file<\/a><\/strong> in the &#8220;Column Names&#8221; field:<\/li>\n<\/ul>\n<h3>Specify the Input CSV file<\/h3>\n<p>Use the upload option to upload the CSV file created in the setup\/preparation step.<\/p>\n<h3>Import into the Database<\/h3>\n<p>Hit the &#8220;Import to DB&#8221; button which will dump the member details from the CSV file into the database.<\/p>\n<p>Now if you browse to the &#8220;Member&#8221; menu of WP eMember, you should see all the new members that you just added.<\/p>\n<h2>Note<\/h2>\n<p>This tool can&#8217;t handle importing of eMember custom fields.\u00a0The\u00a0primary purpose of this tool is to allow importing of some core member data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Update: You should use the bulk member data importer addon to import member data. You can use the WP CSV to DB plugin to upload member details from a CSV file into the WP eMember&#8217;s database. Before you use this method please note that if you want to import your WordPress users into eMember then [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[14],"tags":[34,59,83,5],"class_list":{"0":"post-243","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-additional-resources","7":"tag-bulk-upload","8":"tag-emember-addon-2","9":"tag-import","10":"tag-wp-emember","11":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Bulk Upload\/Import Member Details from a CSV File - WordPress Membership<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#\/schema\/person\/d68b2ffa792aeb141f10f910dacccfdd\"},\"headline\":\"How to Bulk Upload\/Import Member Details from a CSV File\",\"datePublished\":\"2010-08-15T05:04:00+00:00\",\"dateModified\":\"2016-03-03T04:57:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243\"},\"wordCount\":339,\"commentCount\":8,\"keywords\":[\"Bulk Upload\",\"emember addon\",\"import\",\"WP eMember\"],\"articleSection\":[\"Additional Resources\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243\",\"url\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243\",\"name\":\"How to Bulk Upload\/Import Member Details from a CSV File - WordPress Membership\",\"isPartOf\":{\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#website\"},\"datePublished\":\"2010-08-15T05:04:00+00:00\",\"dateModified\":\"2016-03-03T04:57:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#\/schema\/person\/d68b2ffa792aeb141f10f910dacccfdd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Bulk Upload\/Import Member Details from a CSV File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#website\",\"url\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/\",\"name\":\"WordPress Membership\",\"description\":\"Easy to use WordPress Membership plugin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#\/schema\/person\/d68b2ffa792aeb141f10f910dacccfdd\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/3a21ab4072e533cf470d80fc2f0fd3639872824ade4e23709397e109b24f8857?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3a21ab4072e533cf470d80fc2f0fd3639872824ade4e23709397e109b24f8857?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3a21ab4072e533cf470d80fc2f0fd3639872824ade4e23709397e109b24f8857?s=96&d=identicon&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Bulk Upload\/Import Member Details from a CSV File - WordPress Membership","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#article","isPartOf":{"@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243"},"author":{"name":"admin","@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#\/schema\/person\/d68b2ffa792aeb141f10f910dacccfdd"},"headline":"How to Bulk Upload\/Import Member Details from a CSV File","datePublished":"2010-08-15T05:04:00+00:00","dateModified":"2016-03-03T04:57:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243"},"wordCount":339,"commentCount":8,"keywords":["Bulk Upload","emember addon","import","WP eMember"],"articleSection":["Additional Resources"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243","url":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243","name":"How to Bulk Upload\/Import Member Details from a CSV File - WordPress Membership","isPartOf":{"@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#website"},"datePublished":"2010-08-15T05:04:00+00:00","dateModified":"2016-03-03T04:57:38+00:00","author":{"@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#\/schema\/person\/d68b2ffa792aeb141f10f910dacccfdd"},"breadcrumb":{"@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/how-to-bulk-upload-member-details-from-a-csv-file-243#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/"},{"@type":"ListItem","position":2,"name":"How to Bulk Upload\/Import Member Details from a CSV File"}]},{"@type":"WebSite","@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#website","url":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/","name":"WordPress Membership","description":"Easy to use WordPress Membership plugin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/#\/schema\/person\/d68b2ffa792aeb141f10f910dacccfdd","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3a21ab4072e533cf470d80fc2f0fd3639872824ade4e23709397e109b24f8857?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3a21ab4072e533cf470d80fc2f0fd3639872824ade4e23709397e109b24f8857?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3a21ab4072e533cf470d80fc2f0fd3639872824ade4e23709397e109b24f8857?s=96&d=identicon&r=g","caption":"admin"},"url":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/comments?post=243"}],"version-history":[{"count":0,"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/posts\/243\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/media?parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/categories?post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tipsandtricks-hq.com\/wordpress-membership\/wp-json\/wp\/v2\/tags?post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}