Page 1 of 1

exporting users to excel

PostPosted: October 5th, 2011, 3:33 am
by carblanco
Hi all,

I'm a pro user and I'd like to know how I can export all member easily to open the file with excel.
I mean, if I select the "Easy-Read" option I get a csv file which when opening with excel (or openoffice) has all columns wrong formatted because some fields in some users are not filled in, so some columns are moved to the left.

How can I open the csv with all the columns well placed even if some field are empty?

Thanks.

Re: exporting users to excel

PostPosted: October 7th, 2011, 8:31 am
by carblanco
nobody?
I think that s2member doesn't export fields without data instead of exporting but with null value.

Re: exporting users to excel

PostPosted: October 8th, 2011, 3:13 pm
by Cristián Lávaque
Yeah, that's correct. Not at the moment, at least. Right now it exports custom registration fields that do have a value and does it in pairs of field label and value, instead of a column per existing field. This is something we plan to change, it's in the to-do. :)