Orders Exporter Module

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.

Quote:

---

Originally Posted by 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 14311

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.