Moving MySQL data from 4.0 to 5.x
I needed to move date from one database to another.The source DB was MySQL 4.0 and the destination was MySQL 5.1. And all the problems was with UTF-8 symbols. I couldn’t get it to work on MySQL 5.1. I search on the internet and figured out that MySQL 4.0 does not support UTF-8 and it is supported only from MySQL 4.1.
You can store UTF-8 date on MySQL 4.0 but it’s not encoded using UTF-8. The data is encoded using the default encoding ‘Latin1′, so the only thing what you need is to make an export file and upload using PhpMyAdmin, but dont forget to select that the data is encoded ‘Latin1′ and not UTF-8.
Another FedEx class update
FedEx supports only 150 pound per package, so if you are trying to calculate rates for package which weight more than 150 you get an error. The fix was made and now PackageCount is automatically counted by given weight.
You can download updated FedEx class from this post.
PHP: FedEx shipping rates calculator updated
One user was using my FedEx class and could not get rates for Ground service. I have just figured out what was the problem. First of all Ground and Home delivery are ground services and you must set Carrier code to FDXG.
After this I found few bugs witch I fixed and now you can download updated FedEx class from this post.
PHP: FedEx shipping rates calculator
FedEx Ship Manager (FSM) Direct was designed to allow customers to connect directly to the FedEx back end systems using their own communications protocol. Welcome to FSM Direct!
You can compose FedEx XML Transactions to interface between your e-commerce application and the FedEx server and vice versa.
This solution is applicable only to those customers that have the development resources and knowledge to develop their own FedEx interface.
Before you begin:
FSM Direct Site Registration: To register in the FSM Direct program, go to http://www.fedex.com/us/solutions/wis/. Register and complete the brief registration form.
Steps for developing your own communications protocol and integrating it into your application are listed below.
- Read and accept the FedEx Ship Manager Direct license agreement.
- Review the FedEx Direct Documentation: Determine if this alternative or FedEx API is appropriate for your application.
- Develop your application.
- Send an email to websupport@fedex.com. Request to be set up for testing. Attach FedEx Express and/or FedEx Ground account number(s).
- Test your application.
All documentation can be found here:
http://www.fedex.com/us/solutions/wis/pdf/fsm_directmanual.pdf
http://www.fedex.com/us/solutions/wis/pdf/xml_transguide.pdf
Here’s more about this class
(more…)
PHP: USPS rates calculator
The USPS Web Tools allow developers of web-based and shrink-wrapped applications access to the on-line services of the United States Postal Service (USPS). They provide easy access to shipping information and services for your customers. Your customers can utilize the functions provided by the USPS without ever leaving your web site. Once the Web Tools are integrated, your server communicates through the USPS Web Tools server over HTTP using XML (eXtensible Markup Language).
Rates Calculators
Everything in details can be found here:
http://www.usps.com/webtools/htm/Rates-Calculatorsv1-0.htm
First steps:
- Register online (You will get your own user name)
- Test this script (You can use only test data)
- Contact ICCC and go live.
When you have completed your testing, email the USPS Internet Customer Care Center (ICCC). They will switch your profile to allow you access to the production server and will provide you with the production URL. (more…)