Export user data sequence of fields issue

Hi guys, i’ve purchased PRO for mainly the quick export function but to my horror found out that the custom fields when exported will not follow the sequence in which we arrange them in our form, but it arranges by the latest field added to the form.

I do hope I’m missing something, otherwise it would be disastrous.

Please advice on this matter. Thanks.

Hi Joseph.

Right, I think the fields would be exported in the order they were created. I’ll check with Jason.

You can rearrange the columns in OpenOffice Calc, I’m guessing MS Excel can do it too. http://www.oooninja.com/2008/03/drag-drop-move-copy-link-cells-calc.html

I had to ask Jason because these columns were added recently when I was away. Here’s the documentation that explains the custom fields order: http://www.s2member.com/kb/importing-updating-users/#custom-registration-profile-fields

They have to be sorted alphabetically by ID for the import to work. So my suggestion about rearranging them is not correct, since the import won’t be right. Sorry about that.

Your Custom Registration/Profile Field values should be listed in alphabetical order, based on your Custom Registration/Profile Field IDs (i.e. values listed in the order of your alphabetized Custom Registration/Profile IDs). This is based on the Custom Registration/Profile Field IDs you’ve configured with s2Member®. See: [hilite path]s2Member -> General Options -> Registration/Profile Fields[/hilite].

We’ll keep improving this tool and I made a note of your question, added it to our features requests list. :)