Export User DB to Excel issue

I use s2member pro for exporting my user list into MS Excell. The custom profile field titles all end up in thier own colum instead of going into row 1 of the spreadsheet. Those cells in row 1 remain blank. The regular profile fields display correctly. Is there a way to fix this issue?

Hi,

You may want to try this plugin
http://wordpress.org/extend/plugins/cimy-user-manager/

I found the export and import function in S2 a bit hit and mis to be fair it was probably me so found the above plugin and works a treat for basic information not sure about the the extra S2Member profile questions

Regards

Stuart

Hi Sean,

Could you post an example CSV entry here so we can better understand what’s happening? You can open the export file with any plain text editor (such as Notepad) and copy/paste one of the rows.

What I would like is to see the column names appear as a column name for the cusyum profile fields. Here ananumber, restriction_level, and state are placed in thier own column insted of listed as the title of the column.

1,shodgson,administrator,2282013,6/24/2012,"a:2:{s:5:\level\"";s:10:\""1341021862\"";s:6:\""level4\"";s:10:\""1341021862\"";}""",,,,,,amaexpiration,12/31/2012,amanumber,926381,restriction_level,UF,state,VA,

I’m setting up a program in MS Access to help track my clubs members and to be able to print id cards for current members. Right now I have to manually alter the table in Excell. I would like to not have to do that. thanks

Hi Sean.

Here ananumber, restriction_level, and state are placed in thier own column insted of listed as the title of the column.

Right, that’s how s2Member exports the custom profile fields. It doesn’t export every custom profile field configured in s2Member, only the fields the user has a value for, so the number of fields for each row will vary and the way Jason did it was using pairs of field name and field value for those. If every user has all the fields, then they’ll be consistent in the CSV, but if the number of filled out fields varies from member to member, so will the custom profile field columns for their rows.

I hope that helps understand it.

Sorry for any inconvenience. We’ll be changing this in the new s2Member to a more standard format, with a column for each field, regardless or it being empty or not.

Ok thanks.