The project is to provide a script (that can run on OSX Lion) or macro (than can run in Open Office Calc for Mac).
An example file "[url removed, login to view]" is the file that is referenced in"[url removed, login to view]". The licence is also attached that pertains to the attached data.
The processed file needs to be a .csv file with no artifacts (e.g. ' or " or , or [space] or | or -> [tab] any redundant data removed) only the required " and , to generate the .csv file.
The headers must be in conformance with the Metadata file.
There must also be two (2) columns added. the first, a concatenated column with the lot_noplan_no (e.g. 1RP124527) and the second column will be the concatenated address.
With regards to generating a complete address columns these columns shall be used (unit_no|unit_suf|street_no_1|str_no_1_suf|street_no_2|str_no_2_suf|road_name|road_type|road_part|locality_name)
when generating the address for each column there script shall skip any -Empty- fields as not to generate in-valid address records. Where there is an address with a range (street_no_2|str_no_2_suf). The range needs to be split up to and the numbers between generated.
BUP11491 9 9 37 A 39 C
BUP11491 9 9 37 A
BUP11491 9 9 38 B
BUP11491 9 9 39 C
and the address columns will then be
9/37A road_name road_type road_part (if any), locality_name 9BUP11491
9/37B road_name road_type road_part (if any), locality_name 9BUP11491
9/37C road_name road_type road_part (if any), locality_name 9BUP11491
You must also remember that this is just an example where there is a unit_suf this must also be repeated like the lot_no and plan_no above.
I would ask that you test using the provided .gz file and provide an output example for me to validate on my end prior to release of final payment.
N.B. In each file there is up to 1,000,000 rows
Please PM for any extra questions.