psychicpet,
In order to upload the data you will need to get the data organized first. The data provided as is from the state of CA will not work as I am sure there are duplicate city names (this happens when a city spans more than one county and therefore may have different tax rates for different parts of the city in each county). The only way you can have duplicate city names is if you are using counties as zones and each city name is linked to a different zone (i.e county). This is not a simple process, but is much more accurate than assigining a single tax rate to a city name.
If you do not want to use the cities by county method then you will have remove all the duplicate city names otherwise you will run into problems with the tax mod.
Once you get the data organized that far I can help you get it into the proper format to upload via mysql.
LadyHLG


Reply With Quote
