Export Shipping & Order Information

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

[econcepts]

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.

No problem. Yes, under the circumstances I listed in my response (if that is indeed the case) then it would work for months (or years) up until MySQL was altered (by possible upgrade, host changes, other means sometimes outside your control.)

Take a look at those links and let me know if they help. It seems as though the answer is in the collation of the tables.

[econcepts]

Ok, for those of you who have been looking for the new release, I just uploaded it (not posted by the zen cart team yet but you can get it now from the link below if you don't want to wait.)

In this release:

- Bugfix: Corrected issues with company name not exporting correctly (field was coming in blank)

- Bugfix: if a product's attributes have a newline in them, the export file also has a line break in it, making the import break. This can occur if there is a text entry field for a product attribute (such as a gift card memo, etc.). This has now been corrected.

- New Addition: Added the ability to export Manufacturers Name

The only thing that was altered was the "/admin/shipping_export.php" file so if you are running any of the versions 1.2.x plus all you need to do is upload this one file and overwrite what you already have. That's it.

If you can't wait for the free downloads area to post it get it at the link below now:

Export Shipping and Order Information v1.2.6


.

[dhcernese]

Ok, for those of you who have been looking for the new release, I just uploaded it (not posted by the zen cart team yet but you can get it now from the link below if you don't want to wait.)

I just uploaded 1.2.6 and tested it out. It does not export any order that is missing shipping information. We get a lot of these, the prior versions exported all the other information for those order (people would put addresses in the notes or attributes), now we don't get any of them.

When I get a chance, I'll take a look at the code and see if its an easy "fix" (or add an option).

[dhcernese]

..those aren't the only orders missing. I have an order from 2-Jan (that has normal shipping information) to GB that is not included. The only oddity might be the word "it's" in the note the customer sent?

[dhcernese]

(fyi - i was last using 1.2.2, I skipped 1.2.4)
Even though the orders show up on the 'left hand side' of the export screen, they are not in the file.

[Doodlebuckets]

No problem. Yes, under the circumstances I listed in my response (if that is indeed the case) then it would work for months (or years) up until MySQL was altered (by possible upgrade, host changes, other means sometimes outside your control.)

Take a look at those links and let me know if they help. It seems as though the answer is in the collation of the tables.

It's all beyond my understanding. No changes have been made unless she was hacked. I am thinking we just won't be able to use this mod...