Title: How to load Region, City and ZIP code into Compiere for a particular Country.
Autor: Marco LOMBARDO
Lucca, Italy.
Note: The contents of this file are subject to the Compiere License. You may
obtain a copy of the License at
Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
express or implied. See the License for details. Code: Compiere ERP+CRM
Copyright (C) 1999-2004 Jorg Janke, ComPiere, Inc.
Copyright (C) 2004 Marco LOMBARDO.
All Rights Reserved.
Version: 1.0, 2004-03-11
Tested on Compiere version 2.5.0d
Section 1: Overview
With this small project you can load, as fast as calling a script, Regions and Cities
into Compiere. The example is given for Italy, you can find in zip_sample.txt some
italian City and ZIP code.
You have two scripts.
- LoadCap.sql create a table for import data with SQL Loader,
then make Italy the default Country, then load Region and then City with ZIP code.
- UnLoadCap.sql, remove all Cities and Regions for a particular
Country. It do not distinguish between records loaded by LoadCap.sql and records
that were already present before loading, so take care. After removing it set
USA as the default Country, as in the original Compiere.
Section 2: The italian case.
I had only one list, with just Cities. Due to our particular ZIP code numbering
I'm able to read Regions from the same list. For others Countries probably you
have to customize the script.
Loading my 15000 Cities and 104 Regions is matter of seconds. The complete ZIP
code list is not included because you can easily find one.
Section 3: Comments.
This is my little aid to the Compiere Project. Hope this help, at least in Italy,
developers to customize and understand Compiere internals.
I apologize for my english :-)
End.
阅读(1309) | 评论(0) | 转发(0) |
