Orders Exporter Module

Hmm yes, I got the <?php echo bit too, didn't think about it much. I will have to see what is missing from the HTML for this page (first created in 2008 or maybe even 2005) compared to a modern ZC admin page.

I don't have the keepalive timer so have not seen that behavior. I presume something about the way the file is created allows that to become part of the output. Again, the whole file creation section is untouched from the original... but you are using the old version without incident, right? Thanks for digging up these issues before wider release.

gjh42:

I don't have the keepalive timer so have not seen that behavior. I presume something about the way the file is created allows that to become part of the output. Again, the whole file creation section is untouched from the original... but you are using the old version without incident, right? Thanks for digging up these issues before wider release.

Yes, I am using the version compatible with v1.39.h daily.

I'll check it in my v1.5.1 sandbox tomorrow.

I just checked the 1.5.1 sandbox. I had already installed the current orders export code.

It is functional but the keepalive code is at the beginning of the orders data when making the following selection

...ordered products with attributes (only) WITHOUT DELIVERED ORDERS.

The < ?php echo... was from a debug tweak made necessary by the orders_export.php file structure, which I forgot to reverse after debugging was complete. Just find at the start of the HTML page code ```php

You say the keepalive code appears when you select the onlyAttribs link; does it appear for other selections? I wouldn't think that would make a difference, as apparently the keepalive code/script is being prepended to whatever file is generated. Does it happen for downloads or saved files, or both? The v1.5.1 example is with the v1.6 Orders Exporter, right?

OE1.6 was used in the ZC1.5.1 test

OE2.0_rc1 was used in the ZC1.5.3 test

Orders downloaded have the keepalive code prepended
Orders saved to the OExport folder on the server do not have the keepalive code prepended.

I made the mistake of clicking "All orders - full export" without changing any default filtering and timed it out, both download and save to server. I'm assuming that there was just too much data involved.

Same results in the top 8 list choices.

Debug tweak removed: TNX

I did not take the time to do any further tests on the OE1.6 installation. Not a problem if it will help.

Thanks for clarifications. So now the question is, whether there is something peculiar about the way OEX performs downloads that allows the keepalive script to sneak in, or something about the keepalive code that injects itself into downloads in general. How many people use the keepalive script who also have something that downloads from admin? I haven't seen any such complaints, but it should be simple enough to test.

Re: timeout, there is a line from the original version of orders_export.php which attempts to set a 5 minute timeout limit. Either that is not being allowed by your server, or even that was not enough. ```php
@set_time_limit(300); // if possible, let's try for 5 minutes before timeouts

gjh42:

Thanks for clarifications. So now the question is, whether there is something peculiar about the way OEX performs downloads that allows the keepalive script to sneak in, or something about the keepalive code that injects itself into downloads in general. How many people use the keepalive script who also have something that downloads from admin? I haven't seen any such complaints, but it should be simple enough to test.

That's way above my pay grade.

It's above mine too. Going to refer this to the experts.

DrByte says that there is nothing in Keepalive Timer that could cause this, unless header.php was being called (that is the only thing that runs Keepalive). He also reports installing both on a test site and having them function correctly and independently. So maybe there is something unique about your setup? I will have to try it myself, but time is short for me, in last-minute preparations for a major business trip next week.

I'll compare my installed files against the installer zip. I know there were issues as installed in the first instance. It acted differently than expected and AJEH fixed it for me while she was peeking around the site for other issues.

When I installed on the 2nd site, it acted up the same way. AJEH had labeled the file she changed and when I replaced that file, all functioned as expected.

Ditto here on a trip next week. Unexpected family emergency, so things will wait.

File compare tomorrow. It is possible that I missed something in another plugin file compare.

More digging needed on my part.

\admin\includes\header.php is unmodified from zen1.5.3 distribution set

Hello Glenn,
I have to leave town on a family emergency for a week.

I just installed a vanilla v1.5.3 with OE2.0_RC1 and works fine.
Install keepalive and OE no longer functions as intended. V1.5.3 login becomes squirrelly too.

Upload the keepalive file that AJEH edited and V1.5.3 admin login at least begins to function better.

I cannot install v1.5.3 in my other sandbox because the shared server settings do not like v1.5.3 at all.

I will perform more tests when I return the following week and have time to concentrate.

I installed Keepalive on my v1.5.1 local site and found that admin login became squirrelly. OEX downloads still gave the correct output, but displayed onscreen instead of downloading.

In unrelated news, when I tried RC1 on my live site (where payments actually happen) I discovered that the order comments were not working correctly, doubling or tripling every line of the output. In the absence of a SQL wizard who can construct a reliable query to get the desired results (if that is even possible), I will have to pull the comments query into a separate stream and merge the resulting arrays. This is irrelevant to anyone who does not need to output the order comments, as it does function perfectly without them in the query.

gjh42:

I installed Keepalive on my v1.5.1 local site and found that admin login became squirrelly.

See if the Attached copy of the file edited by AJEH makes any difference if I zipped it correctly. I don't know the difference because I cannot see any in WinMerge. I did get some message saying something to the effect that the "Carriage Return format" was different but it was a really quick flicker, never to appear again.

admin/includes/keepalive_module.php

[Attachment no longer available]

Hi Glenn,

I removed the latest version of the KeepAlive plugin (by Numinix) and installed the original version by DrByte.

The garbage that was prepended to the file is no longer there on the first file download so it is looking good.

Hi Glenn,

When you get around to it....

Now, after running the export on our live site, all data appears twice in the export.

...ordered products with attributes (only) WITHOUT SHIPPED ORDERS

Results are the same for downloaded file or file saved to OExport folder

Just got back from 2 1/2 weeks offline. Will have to try DrByte's original Keepalive as I think I installed the latest (numinix) version before. I will see if I can duplicate your doubled results. I did run into an issue with order comments causing doubled or tripled lines in my live site where payments are made, and that may be what you are seeing. Do you have comments turned on in the exporter? I rewrote the SQL code to look up comments separately if enabled and fold them into the output, but haven't gotten to testing it yet.

No keepalive related issues since using DrByte's original version instead of the Numinix version.

I didn't see an option for enable/disable comments, so not sure about that being enabled or disabled.

I am seeing things that don't make sense because I had edited the installation of the 1.3.9 version so that only datafields that I needed were exported.

Those same datafields are in the RC you sent instead of everything. I am still looking for what is causing that. Could be the change in filenaming between the versions and an older file carrying over instead of being overwritten by the new. Latest inserts an underscore orders_export instead of ordersexport

That issue is also affecting exported file column labels.

One nagging issue is that once an export file is generated, it doesn't seem to change upon subsequent exports. ie: new order arrives a few minutes after generating an export file. Generate a new export file and there is no change. Since filenames do not change except hourly, even after waiting until the next hour rolls over, the file is the same. The only way I found to see the new data added is to use the Order ID range and include the latest order numbers.

Just noticed today when we had a list of 3 dozen plus line items, that there appears to be a change in sorting of the output file product names/options which puts them in a very different order that listed on the printed invoice.

As mentioned earlier, once a file is generated for a day, none of the subsequent changes are included with the export file if regenerated with a different default timestamp.

This is definitely above my paygrade to troubleshoot but am willing to do whatever is needed to help.