Orders Exporter Module

delia:

okay, so I'm simply not able to do this. That's what I suspected. I'm talking with mc12345678 about incorporating this in easy populate.

That will make it a both or nothing plugin. EP doesn't do attributes that I have been able to find. EP doesn't play nice with MS Excel. EP documentation is really sparse. I really, really hope that I am missing something in my interpretation of how EP is intended to function.

Some things are better as 'stand-alone' but that is just my simpleton, non-coder opinion.

well, I need a solution, I don't care how it happens or who does it. This thing has never had options but it has sufficed for the clients who needed this. If someone will get this working, I'll be glad to package it up etc. I don't mind working on this stuff but my php skills have never been strong and transitioning to mysqli and php 5.4+ is just beyond my skill level.

Don't mean to pick at a sore wound but what is it doing or not doing?

Can't say I can help and maybe my needs are too simple because what I am receiving in the daily csv is exactly what I want/need to print product labels. I did use the editing/commenting features to remove unnecessary fields from the download. AND I can use MS Excel.

I have no coding skills other than trial/error in duplicating lines to achieve similar results for similar data.

At this point the attributes are in there 8 times. It was only twice at first.

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.

identical lines inside the order.

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.

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

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.

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

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

[B]//list of fields to not duplicate in multiple rows of an order[/B]
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', 

Okay, I missed that instruction but that's not it.

It is working in that the fields like order_id and such are not duplicating.

The only things that are duplicating are the product id, product model, product names, option names and option values and I'm getting 8 sets. I added those fields in that language file and it had no effect.

8 sets I'm getting. It's looks like two at first because of the way it prints out but it's actually 8 sets.

In this thread it said something about the comments having something to do with the repetitions?

delia:

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. :smile:

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.

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.

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.

gjh42, can I help you get that packaged up?

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!

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.

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.

delia:

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

delia:

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.

delia:

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.

delia:

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?