2. Load in a City, State, Zip data file. I use the US Census files because they are free and updated every year.
You will have to manipulate this file in Excel to pull out the information. A format like this will go straight into Odoo:
ID,Zip,City,State,Country 00501,00501,Holtsville,NY,United States 01001,01001,Agawam,MA,United States 01002,01002,Amherst,MA,United States 01003,01003,Amherst,MA,United States 01004,01004,Amherst,MA,United States 01005,01005,Barre,MA,United States 01007,01007,Belchertown,MA,United States 01008,01008,Blandford,MA,United States 01009,01009,Bondsville,MA,United States 01010,01010,Brimfield,MA,United States 01011,01011,Chester,MA,United States 01012,01012,Chesterfield,MA,United States 01013,01013,Chicopee,MA,United States 01014,01014,Chicopee,MA,United States
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/26/15, 2:43 PM|
|Seen: 658 times|
|Last updated: 5/21/16, 4:05 PM|