Export File Custom Fields are a mess

[craigjb12]

My export file works fine except for custom fields. It appears that they are being exported, but not in an orderly fashion.

All the custom fields are represented across the top row, but when moving down the column, rows are a combination of seemingly random field labels and values.

I can't paste a screenshot because it's sensitive data, but to illustrate I'm seeing something like this:

Phone Number
1
orange
17
Business Address
Street
126 Something Street

I'd expect to see a phone number in each of the fields below "Phone Number" in this column, but instead I'm getting a random collection of various values and labels.

Thanks!

[craigjb12]

This thread: viewtopic.php?f=4&t=14093&p=28828&hilit=export#p28828

Got me most of the way there, but for some reason my top row (column labels) is only showing the first 40 or so of about 80

[Cristián Lávaque]

Sorry, only custom profile fields with a value get exported in each row, and there isn't a column for each field, instead they go in pairs of field and value. The Import documentation explains this. WP Admin -> s2Member -> Import/Export -> Users Import

[craigjb12]

Thanks for the response, but I'm a bit confused

All I see in either the import or export sections vaguely related to custom fields is the following:

If you supply Custom Fields, your Custom Field IDs need to match up with the Custom Field IDs you've configured with s2Member. See: s2Member -> General Options -> Custom Fields. If you have a Custom Field that contains an array of multiple values, you can import the array using PHP's serialize() function. This allows you to convert the array into a string representation. s2Member will automatically unserialize the value during importation. If you have any trouble, please perform an export first. s2Member's export files are already formatted for easy re-importation. In other words, you can use them as a guideline for building your own import files.

Are you saying that it's not possible to export the data in custom fields? Or is a customization to exports-in.inc.php likely to do this?

Any tips on how I can effectively export custom fields would be great. It's really hard for me to recommend this plugin to clients in the future if there is effectively no built in support for exporting all their profile data.

Thanks again for your help!

[Cristián Lávaque]

Custom profile fields are exported by s2Member. I was talking about the format the are exported in.

From the Import documentation:

Additional extended information can also be included; even Custom Fields:
"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Level[0-9]+ 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", ...

Here is a full example with all fields filled in, including extended details; and two Custom Fields:
"","johnsmith22","mY!passwrD","John","Smith","John Smith","john.smith@example.com","http://www.example.com/","2","music,videos","12/31/2000","01/10/2001","12/31/2020","12/31/2021","www.example.com|123.357.125.654","I-2342934SSER243","paypal","interests","fishing,biking,computers","t_shirt_size","xx-large"

[craigjb12]

OK, I follow what your saying, but do you have any idea how I can get that into a table format?

[Cristián Lávaque]

You'd need to do it either manually or with a script.