Orders Exporter Module

[RixStix]

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.

[RixStix]

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

[gjh42]

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.

[RixStix]

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.

[RixStix]

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.

[RixStix]

I had a DUH moment today. I didn't realize that I needed to edit the sort orders in the /admin/includes/language/english/orders_export.php file to align the proper datafields. I found the 'v_orders_comment' setting that you mentioned, changed to 0 and the duplicates disappeared.

Now to figure out how to prevent sorting so that the order attributes appear in the download file in the same order they appear on the printed invoice.

Looking good now. Knowing where and how to edit will make this very useful for almost anyone.

[gjh42]

I will make the editing instructions a bit more explicit in the readme, to help people understand how to customize their reports. The attributes are output in the same order that the SQL query retrieves them, which probably has nothing to do with the way they are sorted for display in product pages or official invoices. It may be possible to add to the query to sort by attribute sort order where relevant... not something I had planned on doing, but I will keep it in mind as a future enhancement.