Orders Exporter Module

[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.

[delia]

gjh42, can I help you get that packaged up?

[delia]

At this point, I think I can definitely say this does not work with attributes. I went back every bit of this from scratch and the same thing is happening. The cart is a 1.5.4 cart running on php 5.5.24. I haven't tried it on anything else but I don't see how the problems I'm seeing can be tied the versions.

1) if I ask for orders without attributes, it does not exclude the orders with attributes.

2) Every product line and attribute line is being repeated 3 times.

As this is the only existing mod that exports the orders with attributes, this is the most important part and what I have to have. There are other ways to export the orders.

So when you were saying the comments line was repeating and causing the problems - I turned off comments. still happening.

I definitely don't see what's happening. I don't actually even understand how this is supposed to work. Mainly because I see no way for filtering for those options of with or without attributes. In the old mod there was different sql queries that were tagged with the noAttribs and onlyAttribs filter. Now I see no mention anywhere of those filters except as define statements in the language file. So I don't see how it can filter the report. If I've missed something, that's okay. I just need to know what I'm missing in this!

[mc12345678]

While something like this is almost entirely in EP4 (other priorities got in the way of completion), did discover the need to add distinct into the query to eliminate such duplicate results.

[delia]

No, that doesn't help. I gather if you have no attributes the resulting report is correct. When you add in the attributes, everything starts multiplying. Nice thought though. I've sent a pm to gjh42 as well. But if his code is good otherwise, it makes sense to fix this rather than you do a whole new section for easy populate. If you want to go ahead with that though, I would not be adverse. Relying on only one mod for this has really created problems in this case.

[RixStix]

At this point, I think I can definitely say this does not work with attributes.

I can say that it definitely does work (for me) with attributes. zc1.5.3 and after upgrade to zc1.5.4

1) if I ask for orders without attributes, it does not exclude the orders with attributes.

You are correct but that was not an issue for me since all I care about is orders with attributes. I had not even tested that option until this morning.

2) Every product line and attribute line is being repeated 3 times.

In my case, I receive a separate line for each option name with its option value. If for some reason, the option value is not included with the csv, I can see that each line would appear to be repeated identical times.

I definitely don't see what's happening. I don't actually even understand how this is supposed to work. Mainly because I see no way for filtering for those options of with or without attributes. In the old mod there was different sql queries that were tagged with the noAttribs and onlyAttribs filter. Now I see no mention anywhere of those filters except as define statements in the language file. So I don't see how it can filter the report. If I've missed something, that's okay. I just need to know what I'm missing in this!

Have you set the sort orders for data fields which are included in the csv?
Have you set the data fields to include (or exclude) from the csv?
Have you edited the

//list of fields to not duplicate in multiple rows of an order

in /admin/includes/languages/english/orders_export.php

granted..... documentation is somewhat lacking.

Is there any merit to comparing what my csv download for orders containing products with attributes contains with one of your csv for orders containing products with attributes to see where they differ which may help figuring out the why?

[delia]

Yes, without the attributes being specifically included it happens but if I add in the attributes then I can see what actual repititions I'm getting.

[RixStix]

Here's an example of today's csv with attributes.