Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember General Questions › Bulk Upload Members with Custom Fields
Tagged: bulk upload, csv, custom fields
- This topic has 9 replies, 7 voices, and was last updated 8 years, 9 months ago by wzp.
March 3, 2012 at 10:06 pm #5743apeterkaSpectator
Is there a way to upload my custom fields during the bulk upload process? I thought I might find the custom fields as part of the eMember_members_tbl, and then just append my custom fields to the end of the column string as found on this page, http://www.tipsandtricks-hq.com/wordpress-membership/wp-content/uploads/2010/08/eMember_column_names.txt
In looking at the table, I am not finding any custom fields. Are they in a different table that I can target?
Thanks!March 4, 2012 at 5:25 am #42670adminKeymaster
You can do bulk upload with custom fields but that will be a little complex as the custom fields are not plain fields like the others. It is an object which is serialized and placed in a table called “wp_members_meta_tbl”. You should be able to do one test registration to see how the custom data of a member is stored in this field and then reverse engineer your CSV data structure from there.June 6, 2012 at 7:09 pm #42671web_adminMember
I have the same issue. I would like to upload custom fields along with my bulk upload. Is there a link on how to do this?June 7, 2012 at 4:55 am #42672adminKeymaster
No, we don’t have any option to bulk upload the custom fields of a member unfortunately. Custom fields are a little complex to handle because different users have different sets of custom fields so we have no way of knowing the format a particular user needs.July 6, 2013 at 5:31 pm #42673BjeddMember
Would you please clarify this: “see how the custom data of a member is stored in this field and then reverse engineer your CSV data structure from there”. I have done a test registration, and I can see the data imported into the 2 fields in phpMyAdmin. But what exactly am I looking for to reverse engineer this? I know the names of the 2 custom fields, I know the structure of the members.csv file, but what do I need to do next?
Or would this be any easier from the WordPress database side of the fence, and then just turn on the setting to sync with eMember? The Cimy User Extra fields and Cimy User Manager plugins allow creating custom fields and bulk importing into those fields in WordPress.July 7, 2013 at 4:19 am #42674nurMember
Bulk upload through phpmyadmin will not work for custom fields. because custom fields require additional processing to make it work correctly. we are planning to release an addon to handle this feature.July 8, 2013 at 10:54 pm #42675BjeddMember
Thanks. Any idea on an ETA for this functionality?July 9, 2013 at 2:07 am #42676nurMember
we should have an addon ready in about a week.September 5, 2014 at 10:37 am #42677mliotardMember
This famous addon is https://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853 ?
Cause I don’t know how use the CSV import file to import members with custom fields…September 5, 2014 at 11:16 pm #42678wzpModerator
Unfortunately, as described earlier in this thread; Custom fields cannot be bulk uploaded.
- You must be logged in to reply to this topic.