Export Shipping & Order Information

[rbobzin]

Don't know if this helps, but after installing Dr. Byte's AIM_UPDATE patch (to fix an "apostrophe in name" problem with Authorize.net transactions) in my test site, the correct (original) comment did indeed download for the test orders I placed. Maybe there's something in that new AIM file that changes the way the mod works?

[dhcernese]

I see the cause. I'll put out a bug fix here for that. I have yet to see it come from others, but it looks like the info passed back to you in the note field (from your cc processor) contains some information that has characters (the quote) which push your data to the next cell.

Again, thanks for the heads up. I'll get this out in a bug fix. Thanks!

Did you release a bug fix somewhere?
By the way, it doesn't appear to be caused by a quote. My cell in broken right in the middle of a string, one of many quoted strings.

[econcepts]

Don't know if this helps, but after installing Dr. Byte's AIM_UPDATE patch (to fix an "apostrophe in name" problem with Authorize.net transactions) in my test site, the correct (original) comment did indeed download for the test orders I placed. Maybe there's something in that new AIM file that changes the way the mod works?

This doesn't actually change the export mod. It does address the issue though (which is the way apostrophes are handled).

[econcepts]

Did you release a bug fix somewhere?
By the way, it doesn't appear to be caused by a quote. My cell in broken right in the middle of a string, one of many quoted strings.

No bug fix yet. I was working on a few projects here.

It is coming soon. From the sample files I got here with users that mention this problem (there are only a few), it is indeed due to the way the quoted strings are passed back by the processor.

[vitalchip]

I have an odd problem with this mod..

It was all working great last week, now it's not! When I go to the export page in admin, it shows orders to be exported but when I export them all I get is the headers.

I've tried exporting in test mode, csv only has headers, tried it for real, still only headers and the order is maked up as having been exported. It all seems fine except for the empty csv file.

I've tried re installing all of the original files, uninstalling the sql and then putting it back in.

Can anyone suggest something else to try?

Thanks.

[econcepts]

I have an odd problem with this mod..

It was all working great last week, now it's not! When I go to the export page in admin, it shows orders to be exported but when I export them all I get is the headers.

I've tried exporting in test mode, csv only has headers, tried it for real, still only headers and the order is maked up as having been exported. It all seems fine except for the empty csv file.

I've tried re installing all of the original files, uninstalling the sql and then putting it back in.

Can anyone suggest something else to try?

Thanks.

Please address all questions on this mod to the original thread found at:

http://www.zen-cart.com/forum/showthread.php?t=65715

That question has been addressed in a number of posts one shown below for example.

http://www.zen-cart.com/forum/showpo...5&postcount=94

[vitalchip]

Hi Eric, yes, I'd read the other thread and tried the suggestions but it still doesn't work.

It's quite odd because it used to. I made some changes to export_shipping.php before, to include some static text between the exported fields, even these don't show up, it's as if it's not actually assembling the export file.

I tried removing the while( !$order_details->EOF ) { and the closing bracket, just to see what happened.. it exported one instance of all the static text when that statement was removed.

here's what I changed things to:

$str_export = "\"" . $order_details->fields['delivery_name'] . "\"" .
",\"" . $order_details->fields['delivery_name'] . "\"" .
",\"" . $order_details->fields['delivery_name'] . "\"" .
",\"". $order_details->fields['delivery_street_address'] . "\"" .
",\"". $order_details->fields['delivery_suburb'] . "\"" .
",\"". " " . "\"" .
",\"". $order_details->fields['delivery_city'] . "\"" .
",\"". $order_details->fields['delivery_state'] . "\"" .
",\"". $order_details->fields['delivery_postcode'] . "\"" .
",\"". "GB" . "\"" .
",\"" . $order_details->fields['customers_telephone'] . "\"" .
",\"". " " . "\"" .
",\"" . $order_details->fields['customers_email_address'] . "\"" .
",\"". " " . "\"" .
",\"". "1" . "\"" .
",\"". " " . "\"" .
",\"". " " . "\"" .
",\"". " " . "\"" .
",\"". " " . "\"" .
",\"" . $order_details->fields['date_purchased'] . "\"" .
",\"". $order_details->fields['orders_id'] . "\"" .
",\"" . $order_details->fields['delivery_name'] . "\"" .
",\"". $order_details->fields['delivery_postcode'] . "\"" .
",\"". $order_details->fields['order_total'] . "\"" .
",\"". $order_details->fields['value'] . "\"";


as i say, if i remove the eof checking it will export the GB and the 1 etc, in the correct places but nothing from the database.

I don't know if any of that helps.

[vitalchip]

Ok, got it sorted, i'd failed to realise that there was more than one instance of

AND ot.class = 'ot_shipping' in the file shipping_export.php

I'd only deleted one. Now I have deleted them all I'm back in business,

Thanks Eric.

[econcepts]

Glad you got it working.

The new release I am finishing up here (1.2.3) will address that issue as well as some new features that others have requested.

[japanophyle]

I'm having a similar issue and was encouraged when I read this thread. However, you post from 2007 indicates you were about to release version 1.2.3 of this module, yet I cannot find it anywhere. Did it ever come out?

I just installed the module today. I have ZenCart 1.3.7.1 running PHP 4.4.8. I could (and probably should) upgrade to ZC 1.3.8, but I would really like to take care of some business before doing so. Is it necessary to do so before trying to use this module?