Difference between revisions of "Plugin: US Zip Code"
From iDempiere en
| Line 15: | Line 15: | ||
*Follow forum guide or watch movie - [http://red1.org/adempiere/viewtopic.php?f=45&t=1838#p8867 Red1 Forum] | *Follow forum guide or watch movie - [http://red1.org/adempiere/viewtopic.php?f=45&t=1838#p8867 Red1 Forum] | ||
*Original file scrubbed for instant import. Broken to 2 files due to 65,000 records limitation per csv. | *Original file scrubbed for instant import. Broken to 2 files due to 65,000 records limitation per csv. | ||
| + | ==How To== | ||
| + | *Install [[Plugin:_RED1_NINJA|Red1 Ninja]] Plugin | ||
| + | *In System Configurator, add a zero to the ZK_MAX_UPLOAD_SIZE = 51200. | ||
| + | *In System Admin, call up Module Designer and at the Model Maker Tab, put in what name you wish your new Zip Code window to be in. | ||
| + | *Paste into Column Set: Q#RecordNumber,Zipcode,ZipCodeType,T#City,T#State,T#LocationType,Lat,Long,Xaxis,Yaxis,Zaxis,T#WorldRegion,T#Country,T#LocationText,T#Location,T#Decommisioned,Y#TaxReturnsFiled,T#EstimatedPopulation,T#TotalWages,T#Notes | ||
| + | **You can remove the Q# if you wish RecordNumber to be just String datatype. | ||
| + | *Attach the CSV file (one at a time) at the top attachment icon. | ||
| + | *Copy the tab and attach the second CSV in the new Model Maker Tab. | ||
| + | *Return to Model Header tab and at the process icon, run Generate Module. | ||
| + | *It takes about 20 minutes. Watch the console log prompts and take note of errors. If the tabs do not grey out (made inActive) it means there is some error in the console log. Only a deactivated tab shows it is 100% successfull. | ||
| + | ==Big Test Case== | ||
| + | *I welcome any similar big test case that is of major use. | ||
| + | *Send case details to red1(a)red1(.)org | ||
== Feedback == | == Feedback == | ||
Revision as of 00:51, 23 March 2017
- Creator: Red1 (talk) - RED1.org
- Current Version: 3.1
- License: GPLv2 - Free as in Freedom not Free Lunch (There is no warranty for production use and you need to pay a consultant to provide it.)
- US Zip Code Files: FreeZipCodeUS-1/2.csv
- Ninja Plugin: SourceForge
- Movie: YouTube Demo
Description
- To import 82,000 US Zip Codes from http://federalgovernmentzipcodes.us/free-zipcode-database.csv
- Use Red1 Ninja Plugin
- Follow forum guide or watch movie - Red1 Forum
- Original file scrubbed for instant import. Broken to 2 files due to 65,000 records limitation per csv.
How To
- Install Red1 Ninja Plugin
- In System Configurator, add a zero to the ZK_MAX_UPLOAD_SIZE = 51200.
- In System Admin, call up Module Designer and at the Model Maker Tab, put in what name you wish your new Zip Code window to be in.
- Paste into Column Set: Q#RecordNumber,Zipcode,ZipCodeType,T#City,T#State,T#LocationType,Lat,Long,Xaxis,Yaxis,Zaxis,T#WorldRegion,T#Country,T#LocationText,T#Location,T#Decommisioned,Y#TaxReturnsFiled,T#EstimatedPopulation,T#TotalWages,T#Notes
- You can remove the Q# if you wish RecordNumber to be just String datatype.
- Attach the CSV file (one at a time) at the top attachment icon.
- Copy the tab and attach the second CSV in the new Model Maker Tab.
- Return to Model Header tab and at the process icon, run Generate Module.
- It takes about 20 minutes. Watch the console log prompts and take note of errors. If the tabs do not grey out (made inActive) it means there is some error in the console log. Only a deactivated tab shows it is 100% successfull.
Big Test Case
- I welcome any similar big test case that is of major use.
- Send case details to red1(a)red1(.)org
Feedback
Please rate this plugin:
{{#w4grb_rate:Plugin:_US_Zip_Code}}
<w4grb_ratinglist pagevotes idpage="Plugin:_US_Zip_Code"/>
If you want to provide additional comments, please use the Discussion page.
