Community Support Forums

Re: Having trouble with import and custom fields

2011-06-16T17:02:36-05:00

Statistics: Posted by Cristián Lávaque — June 16th, 2011, 5:02 pm

Re: Having trouble with import and custom fields

2011-06-16T14:15:15-05:00

Ah, I see. I guess I got confused when I read it. Thanks for that. Count this as vote to change it in future releases!

Statistics: Posted by lindseytyner — June 16th, 2011, 2:15 pm

Re: Having trouble with import and custom fields

2011-06-16T11:19:33-05:00

Thank you. I see...

Read the documentation for the Import tool at WP Admin -> s2Member -> Import / Export -> User/Member Import Files. You'll find how to format the custom fields.

Additional extended information can also be included; even Custom Fields:
"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Level[0-4] or Role ID","Custom Capabilities","Registration Date ( mm/dd/yyyy )","First Payment Date ( mm/dd/yyyy )","Last Payment Date ( mm/dd/yyyy )","Auto-EOT Date ( mm/dd/yyyy )","Custom Value ( starts w/domain )","Paid Subscr. ID","Paid Subscr. Gateway","Custom Field ID #1","Custom Field Value #1","Custom Field ID #2","Custom Field Value #2", ...

So your custom fields would go in pairs of ID (name) and value, and you only need to have in each row those fields with a value, if the field is empty you can skipt that pair.

... ,"text_updates","TRUE","terms","TRUE"

This format may change in a future release, but for now that's how it is.

I hope that helps.

Statistics: Posted by Cristián Lávaque — June 16th, 2011, 11:19 am

Re: Having trouble with import and custom fields

2011-06-16T09:12:57-05:00

Sure, it looks like this:

"","MeredithSchneider","","Meredith","Schneider","","mlschneider@xxxxxxx.com","","s2member_level2","","7/31/09","","","","","","","Donna Zxxxxx","Specialist","111 Main St. #111","","Austin","TX","12345","USA","512-xxx-xxxx","","F","","TRUE","TRUE","","","TRUE"

Here is the column list showing the custom fields:
"id","Username","Password","First Name","Last Name","Display Name","Email","Website","Role","Custom Capabilities","Registration Date","First Payment Date","Last Payment Date","Auto-EOT Date","Custom Value","Paid Subscr. ID","Paid Subscr. Gateway","business_name","title","street_address1","street_address_2","city","state","zip_code",
"country","phone_number","fax_number","gender","birthdate","email_list","text_updates",
"committee_interest","other_orgs","terms"

Thanks for your help.

Statistics: Posted by lindseytyner — June 16th, 2011, 9:12 am

Re: Having trouble with import and custom fields

2011-06-15T21:08:28-05:00

Hi Lindsey.

Could you please show me a row with custom fields from your CSV file? (x'ing out any private information)

Statistics: Posted by Cristián Lávaque — June 15th, 2011, 9:08 pm

Having trouble with import and custom fields

2011-06-15T17:07:50-05:00

I am having trouble importing users into the system with the custom fields. I've made a CSV, with double-quotes and the import works fine except that the custom fields don't come through. I'm not getting any errors, it's just that when I view any of the users all of the custom fields are blank. When I export, no custom fields come through. Has anyone had this issue and found a solution?

Thanks for your help.

Statistics: Posted by lindseytyner — June 15th, 2011, 5:07 pm