|
⇤ ← Revision 1 as of 2008-01-21 02:48:44
Size: 2011
Comment:
|
Size: 2064
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| Now can input post code in sieat and draad to automaticly get a list of city and states, pick one , then the city and state field in the screen will be filled with the picked one. |
Now can input a post code in sieat and draad to automatically get a list of city and states, pick one, then the city and state field in the screen will be filled with the picked one. |
| Line 6: | Line 5: |
| but to have this feature , we will need the postcode.idx index file, it can be copied from /u/ccdev/standard, or generated using fcreate -> 0 prefix , 0 surfix, 40 key size ,40 element size, max no of key = 18000, no leading zeros. then import the data into the idx using /u/ccdev/std/utbinx11/imppcmin, run imppcmin then select a file call pc-full_20071128.csv(a csv file download from australia post with all the postcode and city pairs) you can find pc-full_20071128.csv under /u/ccdev/std/ut/, or download it again from australian post. if the postcode.idx does not exist in the user's directory , sieat and draad will give error and not run, so must create or copy the '''postcode.idx''' under the client's directiory, before up load sieat or draad. |
To have this feature , we will need the postcode.idx index file. It can be obtained by: * copying it from /u/ccdev/standard (contains Australian postcodes and suburbs) or * generating using fcreate * prefix=0 * suffix=0 * key size=40 * element size=40 * max no of key=18000 * leading nulls=N Then import the data into the idx using /u/ccdev/std/utbinx11/imppcmin. Run imppcmin then select a file call pc-full_20071128.csv (a csv file download from Australia Post with all the postcode and city pairs). You can find pc-full_20071128.csv under /u/ccdev/std/ut/, or download it again from Australian Post. If the postcode.idx does not exist in the user's directory , sieat and draad will give error and not run. You must create or copy the'''postcode.idx'''under the client's directiory, before up running sieat or draad. |
| Line 18: | Line 18: |
| the imppcmin is expecting a csv imput file , in the formate | the imppcmin is expecting a csv imput file , in the format |
| Line 26: | Line 26: |
| : | . : : The first row is expected to be the heading and will be ignored. Imppcmin will not read this line's data into postcode.idx. If later Australian Post has updated this document, without heading row, just add a dummy first row will do. |
| Line 28: | Line 29: |
| : the dirst row is expected to be the heading will be ignored and imppcmin will not read this line's data into postcode.idx. if later Australian post has updated this docuement, without heading row, just add a dummy first row will do. For the rest of the rows, the fist cloumn is expected to be postcode, second column is the city, the third one is the state. as the example below. |
For the rest of the rows, the fist column is expected to be postcode, second column is the city, the third one is the state. as the example below. |
| Line 39: | Line 33: |
| imppcmin will only read the first three columns, and ignore the rest , since only the first three are needed. if in the future, australian post change the layout of the row, as long as the secquence of the first three column is the same. imppcmin will still work properly. |
imppcmin will only read the first three columns, and ignore the rest , since only the first three are needed. If, in the future, Australian post changes the layout of the row, as long as the sequence of the first three column is the same, imppcmin will still work properly. |
| Line 43: | Line 36: |
| CategoryAllphones | . CategoryAllphones |
Post Code
Now can input a post code in sieat and draad to automatically get a list of city and states, pick one, then the city and state field in the screen will be filled with the picked one.
Admin
To have this feature , we will need the postcode.idx index file. It can be obtained by:
- copying it from /u/ccdev/standard (contains Australian postcodes and suburbs) or
- generating using fcreate
- prefix=0
- suffix=0
- key size=40
- element size=40
- max no of key=18000
- leading nulls=N
Then import the data into the idx using /u/ccdev/std/utbinx11/imppcmin. Run imppcmin then select a file call pc-full_20071128.csv (a csv file download from Australia Post with all the postcode and city pairs). You can find pc-full_20071128.csv under /u/ccdev/std/ut/, or download it again from Australian Post. If the postcode.idx does not exist in the user's directory , sieat and draad will give error and not run. You must create or copy thepostcode.idxunder the client's directiory, before up running sieat or draad.
imppcmin
the imppcmin is expecting a csv imput file , in the format
"entry","entry",.......\n
"entry","entry",.......\n
"entry","entry",.......\n
- : :
The first row is expected to be the heading and will be ignored. Imppcmin will not read this line's data into postcode.idx. If later Australian Post has updated this document, without heading row, just add a dummy first row will do.
For the rest of the rows, the fist column is expected to be postcode, second column is the city, the third one is the state. as the example below.
"0810","JINGILI","NT",,"DARWIN DELIVERY CENTRE","085","NT1","001","DARWIN","Delivery Area "
imppcmin will only read the first three columns, and ignore the rest , since only the first three are needed. If, in the future, Australian post changes the layout of the row, as long as the sequence of the first three column is the same, imppcmin will still work properly.