User export not working properly

I use the export feature on a regular basis to create reports about new users on the system and it has worked great for over a year until December when it stopped working as expected. The system tells me that there are 5020 users in the system but when I try to export beyond 4955, I get a subset of users that does not go beyond 4955. It appears that all of the user data is actually in the DB, it is just not ordered the way the export script expects it to be so it is not pulling out the requested information.

Do you have any type of updated script I can use to resolve this issue (maybe pull users by registration date or the like)?

Hi Chris.

I’m going to forward this to Jason. Could you please send us the site info for him to review your installation? s2Member® » Private Contact Form

@ Chris Frishe

Thanks for reporting this important issue. I’m not aware of any limitations in this regard, so I would like to see this problem, as it occurs on your installation; so we can provide you with a resolution. Please submit a Dashboard login and FTP access privately using this form: s2Member® » Private Contact Form

Thanks. I have sent through the information as requested. Let me know if you need anything else.

Thanks for your patience.

~ Details received, but we were unable to access your Dashboard for the purpose of running diagnostics.

It looks like the account did not take when I set it up initially. I have it set now but I think the PW is different from what I sent previously. How do you want me to get you the new PW?

Thanks for the follow-up :-)

Please submit the updated information privately through this form.
See: s2Member® » Private Contact Form

Thanks!

The form has been submitted. Let me know if you have any other issues getting in.

Details received. Thank you!

~ Investigating.

Thanks for your patience.

I’ve taken a look at your server and found the following issue.
GZIP is great, but it’s not applicable when s2Member is delivering a file via PHP.

I’ve had your s2Member® installation updated to prevent this from occurring, by editing the following line inside: /s2member-pro/includes/classes/exports-in.inc.php at line #239

Changed:

header ("Content-Encoding:");

To:

header ("Content-Encoding: none");

---

This is really a hack to get it working with your server. It’s a common hack, but a hack still. There really is NOT a valid none token for this header, and that’s why s2Member® does not send it by default (it’s invalid). However, in scenarios where it’s absolutely required in order to bypass GZIP filters on your server, a value of none will do the job here. Unfortunately, you will need to make this change upon each update of the software. Or, configure your web server to interpret an empty Content-Encoding header as none.

I’m going to see if we can do something more, by accommodating this scenario dynamically in a future release. Please keep an eye on our Changelog for any improvements in this area.

Related discussion: http://www.pimcore.org/board/viewtopic.php?f=5&t=460#p1628

Thanks for the help. Were you able to export beyond line 4955? I just tried and the export result is as it was before. I see 4955 as the last item in a list but it does not contain any records beyond that line. Should I be exporting a different way now?

Thanks for the follow-up :-)

I just took another look at your installation. Yes, I can export all 5,053 Users on your installation without issue.

However, I see why there is confusion about this. If you attempt to match up the User IDs that come in the export file, with the database table row numbers that you’re exporting, it will not make sense. This is because MySQL database table rows are not always the same as User IDs.

If you export starting at table row #4955, you end up with 98 Users, which is correct. In the database, that is table row 4955 – 5053. In that particular export on your installation, the last User ID listed in the database is User ID 4955, which can be really confusing from a certain perspective.

In short, there’s not a bug or problem here. However there is a major point of confusion that I think we can resolve in the next maintenance by simply ordering the export query by User ID. I’m making a note of this, so we can have it updated in the next release.

Please let us know if any other questions/concerns :-)

Great, thanks. I will keep an eye out for the update.