Export Shipping & Order Information

[karimm]

Hello everybody,

I would also like like to export the product_id, does anyone know what code i would have to include in shipping_export.php.

My products exist of the product id + attribute, witch i have to emerce together to a new "product model name".

example: product id = 2100 and attribute = -41, new product model name = 2100-41 .

All help will be appreciated.

Thanks alot.

Any one ??? i have tryed to rename prcdcut_model to product_id in the script, but that doesn't work.

I would already be satisfield with only the export of the product_id !!

[growlight]

I just tried to install it (1.2.3) on ZC1.3.8a and am having a problems as well. I am not getting the export button. Instead I am getting the flowing error where I presume that the export button would be:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

Anyone have any ideas?
-Christopher

[denliv]

I just tried to install it (1.2.3) on ZC1.3.8a and am having a problems as well. I am not getting the export button. Instead I am getting the flowing error where I presume that the export button would be:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

Anyone have any ideas?
-Christopher

Check out my 3rd post on page 4 of this forum - you'll replace the html_output file in the admin section only.

[growlight]

denliv,
That did the trick!! THANKS...

[Doodlebuckets]

Hello! I installed this for a customer's website and she's been using it and doing fine until recently when we now get this in the file that is produced when we do an export:

<div class="systemError">1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br />in:<br />[SELECT o.orders_id, customers_email_address, delivery_name, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, date_purchased, ot.value, comments, order_tax, o.orders_status, o.payment_method, cc.countries_iso_code_2, cc.countries_iso_code_3
FROM orders o, orders_status_history os, orders_total ot, countries cc
WHERE o.orders_id = ot.orders_id
AND ot.class = 'ot_shipping'
AND cc.countries_name = o.delivery_country
AND o.orders_id = os.orders_id AND downloaded_ship='no' GROUP BY orders_id ASC]<br />If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br /></div>

Please help!

[Doodlebuckets]

Hello! I installed this for a customer's website and she's been using it and doing fine until recently when we now get this in the file that is produced when we do an export:

Please help!

Any answer on this? Please...

[econcepts]

Any answer on this? Please...

Here are some links that might help you resolve this. My question would be

1) Have they upgraded to a different version of MySQL, and if so what version?

2) Did they install any other mods that affect any of the tables this mod pulls from? It could be that one of them changed the table collation?

Here are the links to look at:

http://bugs.mysql.com/bug.php?id=20123

http://www.vbulletin.com/forum/showt...ations-problem


http://www.google.com/search?hl=en&s...&aq=f&oq=&aqi=



Let me know answers to the above to see if we can narrow down what caused it.

[Briann]

I assume that it wasn't corrected jet, because (at least in the downloads section) there's not a version dated later than my post.

Just a note

This is not meant unfriendly, but just want to help.
Really, this mod is great!

[econcepts]

Ok no problem! I'll put that in this next release (working on it now).

I was working on it anyhow as I just customized it for one of my members at my site to work better with PayPal.

I'm hoping to have this new version up in these forums here within the week.

I've got 3 items (which include 2 bug fixes) that will be included in the new release.

Later versions are slated to revamp a few portions and provide more export file options (XML, etc...)

But that is later.

[Doodlebuckets]

Here are some links that might help you resolve this. My question would be

1) Have they upgraded to a different version of MySQL, and if so what version?

2) Did they install any other mods that affect any of the tables this mod pulls from? It could be that one of them changed the table collation?

Here are the links to look at:

http://bugs.mysql.com/bug.php?id=20123

http://www.vbulletin.com/forum/showt...ations-problem


http://www.google.com/search?hl=en&safe=off&rlz=1G1GGLQ_ENUS271&q=1267+Illegal+mix+of+collations+(lati n1_general_ci%2CIMPLICIT)+and+(latin1_swedish_ci%2CIMPLICIT)+for+operation&aq=f& oq=&aqi=



Let me know answers to the above to see if we can narrow down what caused it.

Sorry, I never got an email saying you had replied to this. No mods were added, I am the only one working on the site. I'll look at the links. It had worked for months and then all of the sudden not.