usps.com Click-n-ship AutoFill Button Contrib

[sailsport1]

@sailsport:

Try going into your database and manually remove any rows that reference USPS in the configuration and configuration_group tables.

It may be useful to use your browser's "search" function to easily find USPS on the page.

Then, download ses707's copy of the SQL and try running it again.

Tried that again. Still no luck.
I do have Super Orders installed and I'm thinking that may be the problem?

[ses707]

Tried that again. Still no luck.
I do have Super Orders installed and I'm thinking that may be the problem?

Nope, issue was the SQL, please download and run this one. This includes SQL updates for 1.3.9 and 1.5.

[sailsport1]

Nope, issue was the SQL, please download and run this one. This includes SQL updates for 1.3.9 and 1.5.

OK That one ran, but it only gives me 9 configuration settings - and there is no USPS autofill button on the orders page anymore.

That patch only had a blank line added different than the one I ran before.

[ses707]

OK That one ran, but it only gives me 9 configuration settings - and there is no USPS autofill button on the orders page anymore.

That patch only had a blank line added different than the one I ran before.

The key differences are the addition of ; on the last line before the

ALTER TABLE orders DROP total_weight;
ALTER TABLE orders ADD total_weight FLOAT NOT NULL DEFAULT '-1';

And the alters lost the '
Can you confirm those items are different in the sql you are running?
And 9 statements is correct for a 1.3.9, only 1.5 requires additional statements.

[sailsport1]

The key differences are the addition of ; on the last line before the

ALTER TABLE orders DROP total_weight;
ALTER TABLE orders ADD total_weight FLOAT NOT NULL DEFAULT '-1';

And the alters lost the '
Can you confirm those items are different in the sql you are running?
And 9 statements is correct for a 1.3.9, only 1.5 requires additional statements.

Yes those items are in the code that I have.
I still have no button for autofill though.

[jackie.taferner]

@sailsport

You will need to upload the new orders.php file to see the button. If you have Super Orders installed, you will need to merge the changes with your existing file.

Use a program such as winmail.dat to compare and copy over the Auto-fill code to your orders.php file.

[DivaVocals]

@sailsport

You will need to upload the new orders.php file to see the button. If you have Super Orders installed, you will need to merge the changes with your existing file.

Use a program such as winmail.dat to compare and copy over the Auto-fill code to your orders.php file.

Not an easy task.. Though the super_orders.php file is BASED on the default orders.php, the differences are still fairly vast and trying to do a file comparison between the two is NOT for the faint of heart.

This and many other reasons is why in the v1.5 compatible version of Super Orders the Super Orders specific mods will be integrated into the default orders.php versus continuing to maintain all those Super Orders "cousin" files (as I call them ).. That said integration with the v1.3.9 version of Super Order will be a bit of a challenge, but integration with the v1.5 compatible version of Super Orders should present less challenges..

[ses707]

Yes those items are in the code that I have.
I still have no button for autofill though.

Well that would be the order.php page not in the right spot, not related to install sql. I thought you were missing the settings under configuration. For ZC 1.5 the last update did not include a required file to show settings under configuration (though they are not really needed as the defaults are now much better). In the latest attached version I have also removed the return e-mail as it is now a required part of the usps profile.

[ses707]

No responses on this for a week now, can I assume all bugs have been flushed and this is ready to be finalized and added to the contrib download page?

[jackie.taferner]

I believe the latest file is referenced in ses707's Post #654 on March 30, 2012. Here it is again: http://jtwebsitedesign.net/zen/USPS....-fill-v1.5.zip

I'm going to go ahead and post that to the add-ons section so there is no further confusion. ses707, crashwolf, qhome, do you think we're clear to launch? Going once... going twice...