Orders Exporter Module

[RixStix]

Maybe it is just a simple setting (or two). It has been a year since I looked at the details but I think Glenn built in a few switches.

Our daily csv does not duplicate any specific attribute line. We do get 2 lines per product but each line is for a different attribute. We have half handful of products that have 3 attributes, so those show up in 2 lines.

8 identical lines or 8 lines of different product attributes?

It works for me. It doesn't work for you. Maybe our needs are different. Maybe it is just a setting switch. Can't say without having something to compare.

Just throwing that out as a possible option or opinion.

[delia]

identical lines inside the order.

[RixStix]

Here's the orders_export.php file that I am currently using if you want to compare for differences. I am trying to grasp how we are seeing such drastic differences.

Would I have it do things differently? Yes.
Am I capable of making it do things differently? No
So I modified my daily tasks to adapt but realize that is not always an option for some.

[delia]

I adapt - my clients don't always work with me like that. That is what I have. Are you on php 5.4?

[RixStix]

surface RT or its version of IE doesn't play nice with forum.


php 5.4.42
I expected to see some differences in the file unless I grabbed the wrong file where I customized the datafields to be included in the csv.

[delia]

nope correct file - then maybe the language file which I did edit. I'll play with it.

[RixStix]

I'm going out on a limb and guessing that if you look around line 156 - 182, you might need to comment out a few lines per the first comment line in that grouping. I'll dig a bit more to see what I changed or switched on/off.

Admin\includes\languages\english\orders_export.php

//list of fields to not duplicate in multiple rows of an order
define('OEX_BASE_ORDER_FIELDS', serialize(array(
'v_date_purchased',
'v_orders_status_name',
//'v_orders_id', 
//'v_customers_id', 
//'v_customers_name', 
'v_customers_company', 
'v_customers_street_address', 
'v_customers_suburb',

[RixStix]

I adapt - my clients don't always work with me like that. That is what I have. Are you on php 5.4?

Since I am my own client, I have the luxury of telling the client to like it or stuff it.

OOPS. Brainfart yesterday. Current PHP version is 5.5.25 but used 5.4.xx for 6-8 months until a PCI issue forced an update.

Just went back to make sure that I attached the correct file.

IF your copy of that file is identical to the one that I attached, I would be very surprised. The file attached has several dozen of the original lines commented out because I do not want/need the datafields included within the csv.

Just a suggestion to comment out a few selected lines and see if the duplicates are reduced.

Are you using the download csv or Save to server oexport directory? Not that there should be any difference, I think that I remember a difference somewhere. It's been a year since I fiddled with my customizations, so things are rusty.

[gjh42]

I have been away from programming for the past six months or so, immersed in other facets of life which actually give tangible rewards, and just popped back in to the forum to look around. I don't think I posted the latest version of OEX with the comments output functioning correctly - I will look into doing that. I need to do it for my live site anyway.

The website I need OEX for is only active in May and June, and when it wants the exporter tweaked I am always up to my eyeballs in outdoor projects... I hope this year I can get to updating the site from v1.5.0 in the off season and properly test the latest OEX on a live v1.5.4 site. I'm glad to hear that at least someone is using it on a current ZC version successfully.

My reworking of the original OEX code included moving from explicit mysql functions to the ZC $db functions.

[delia]

I knew you were alive! Thanks so much. This mod has been in my arsenal forever and though I don't have many clients that ask for it, when someone needs it, they really need it.