User export csv full of random stuff!!

Hi all, I was training with a client yesterday and when I showed them the user export feature the file just opened containing about 15 rows of complete gobbledy-gook!! Just lots of random characters…

Any ideas how to sort this? I’ve tried it in a couple of different browsers and get the same issue…

Cheers!

Hi Zoe,

It sounds like it might related to GZIP compression or chunked file delivery. Please see the following KB article and try the various suggestions explained there:

Knowledge Base » Resolving Problems with File Downloads

Hi Raam, I’ve tried all of those with no luck – could it be related to the issue I was having with the secure file downloads here http://www.s2member.com/forums/topic/protected-pdfs-downloading-corrupt/

If so does another hack similar to Jason’s last one need putting in place?

Thanks,

Zoe

Zoe,

The hack that Jason suggested is also used to solve csv export issue so is it still active on your installation or has it been over written by an upgrade?

Zoe,

I suggest trying the hack that Jason mentioned in that other post. If you’re using the same web host as you were for that problem, there’s a good chance that will fix it.

Hi Raam, its the same website! So Jasons hack is already in place as per the other post…!

??

Zoe,

When you upgraded to v120622 that hack would have been overwritten, did you redo it then?

ahhh, possibly not, will take a look and report back!

Thanks :)

I’ve put Jason’s code back in place and my secure downloads are working fine still by my user export file is still full of random characters…

Any more ideas guys??

can you try changing

/s2member-pro/includes/classes/exports-in.inc.php

at line #239 find this:

header ("Content-Encoding:");

and change it to

header ("Content-Encoding: none");

Awesome, thanks Philly – its working now.

One quick Q (that I think my client will ask) – the “First Payment Date” column is populated with things like:
a:2:{s:5:\level\”;s:10:\”1339775909\”;s:6:\”level3\”;s:10:\”1339775909\”;}”

Why is that?

Cheers :)

Glad its working :)

Its a serialized associative array in no specific order. Each *paying* customer will have the “level” array element, indicating the first paid registration time, at whatever Membership Level they paid for initially. The values are stored as a Unix Timestamp.

So what use is that column in its current form in the CSV? My client will be downloading and using this spread sheet and it will just look like useless random characters to them…!

Cheers :)

If he doesn’t have a use for the first payment time, he can just ignore that column.

You can customize the CSV format in the export code, if you want.

When you upgraded to v120622 that hack would have been overwritten, did you redo it then?

One thing you can do is make a copy of the file and put it in your /wp-content/mu-plugins/ dir and edit that instead, it won’t be overwritten on update.

Lovely! Thanks :)

No problem. :)

Hi Cristian, what file do I need to alter the user export code? My client wants it to include the number of times logged in as per the “users” section in the admin.

Cheers :)

That’d be s2member-pro\includes\classes\exports-in.inc.php :)