usps.com Click-n-ship AutoFill Button Contrib

:frusty:
I've read through the posts and can't quite find the answer ...

Problem:
I don't have the Autofill Button on the Admin > orders page.

I want to believe that I uploaded everything appropriately ... I probably didn't.
I did the over ride thing on the admin> orders ... I copied the orders.USPS and pasted that over the original admin>orders . Is that correct? I saw a line about "remove excess" and don't know what that means.
Any help is appreciated.
Thanks

10000cranes:

:frusty:
I've read through the posts and can't quite find the answer ...

Problem:
I don't have the Autofill Button on the Admin > orders page.

I want to believe that I uploaded everything appropriately ... I probably didn't.
I did the over ride thing on the admin> orders ... I copied the orders.USPS and pasted that over the original admin>orders . Is that correct? I saw a line about "remove excess" and don't know what that means.
Any help is appreciated.
Thanks

Remove excess means to change the name from "orders.php_usps_only" to "orders.php" then overwrite your existing admin/orders.php file.

That alone should add the physical button. Now make sure that there is a file at admin/includes/modules/usps_autofill_button.php

Hey,
I'm trying to use this mod but I'm having trouble setting it up. When i run the sql command i get this error:

1264 Out of range value adjusted for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');]
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.

I'm not sure if this problem has already been addressed. Has this already been fixed or do you have any suggestions?

Andrew

andrewmp:

Hey,
I'm trying to use this mod but I'm having trouble setting it up. When i run the sql command i get this error:

1264 Out of range value adjusted for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');]
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.

I'm not sure if this problem has already been addressed. Has this already been fixed or do you have any suggestions?

Andrew

Are you using a prefix on your database tables? If you are you need to edit the sql file and add the prefix to each table call (IIRC)

so

INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

would become:

INSERT INTO prefix_configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

Same with the other insert command. Possibly even the update commands and from commands.

qhome:

Are you using a prefix on your database tables? If you are you need to edit the sql file and add the prefix to each table call

No, I don't have a prefix. But I seemed to have fixed the problem.

I changed one value in one of the inserts.

Was

INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

changed the first set of empty '' to

INSERT INTO configuration_group VALUES ('NULL', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

That NULL seemed to have done the trick. I'm not sure why that is. I'm using Zen Cart 1.3.8a and PHP Version 5.1.6.

Andrew

andrewmp:

No, I don't have a prefix. But I seemed to have fixed the problem.

I changed one value in one of the inserts.

Was

INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

> 
> changed the first set of empty '' to
> ```
INSERT INTO configuration_group VALUES ('NULL', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

Andrew

Ahh yes. I never updated the sql to be MySql 5 compliant. '' has been replaced by NULL for MySql5. Good find.

As of this morning, clicking on the USPS Autofill number sends me to the USPS website where I just get "Error 500". I haven't made any changes to it.

Is it still working for everyone else?

Yes!

GASP!!! Whats going On!

:ohmy:

milobloom:

Yes!

GASP!!! Whats going On!

Yes it still works for you, or yes it is broken for you?

On a hunch, I went to the config tools and changed the 'X' value for shipping weight ounces that was used to make it work in the past. No difference in the result however.

I've got the same problem. It actually started last night. Nothing obvious is standing out. I think that USPS changed something on their end.

If I can help the author test anything, please let me know.

-Ed

Grrrr. Why must usps keep touching things and breaking them! There should be a law!
I'll take a look

The front page is redone...

Wondering if they are screwing with the whole site...

AAARRGGHHH!!!

Ok Ok everyone calm down. I've got a test form working again and I just need to find out which new field is "required" to not trigger the error.

Stay tuned. We will prevail!

w0w, I too get this error, love this contribution, and it defiantly sucks when it does not work!

thanks for your hard work and help!

-Graham

Thanks so much for taking a look... it definitely reminds me how critical this mod is when it suddenly doesn't work!

qhome:

need to find out which new field is "required" to not trigger the error.

There is a new "Express Mail Hold For Pickup at Post Office" right below the select shipping date.

I wonder if they are losing alot of money regarding this,,,,

qhome:

Ok Ok everyone calm down. I've got a test form working again and I just need to find out which new field is "required" to not trigger the error.

Stay tuned. We will prevail!

Is it the required "shippingDate" field?

Maybe I'm missing it, but I don't see that required field accounted for an any of the mod's files.

craigkendall:

Is it the required "shippingDate" field?

Maybe I'm missing it, but I don't see that required field accounted for an any of the mod's files.

No. The shipping date just defaults to the current date if not specified. On my test form that I got working, it doesn't have it either.

I should have a fix by tomorrow.

OK I figured it out. In fact it may have been the cause of the initial "error" on form load. When they added the new Express hold checkbox, they finally had another non-default value for the submit control. So this tells it explicitly to use continue button now.

Very simple fix:

Need to edit:
admin/includes/modules/usps_autofill_button.php
find:

<input type="hidden" name="submitControl" value="">

change to:

<input type="hidden" name="submitControl" value="Continue">