8.6.2.2c Import Format for Property Values
Level of expertise required for this Chapter: Expert; specifically for LUPMIS @ TCPD
Data | Essential ? | Format / Remark | Example | Excel column |
UPN | ESSENTIAL | xxx-yyyy-aaaa format, as string | 678-0789-0123 | A |
SubUPN | | xxx-yyyy-aaaaA format as string or blank or single letter | 678-0789-0123E | B |
Property rateable value | ESSENTIAL | as figure in GHc, no comma as 1000 separator | 15000 | C |
|
'value' | ESSENTIAL | word 'value' | value | D |
-99 | ESSENTIAL | control variable, as number | -99 | E |
In total, there should be 5 columns (last column in Excel: E).
File name should contain 'field_data' (e.g. STMA_field_data_landvalues_area1.csv)
General requirements:
- All cells have to be filled, except SubUPN.
- If UPN subunit is entered, it has to be unique (UPN + 1 or 2 or 3 letters), e.g. 678-0789-0012A.
- Observe the number -99 at the right-most column as control variable.
- No commas or and-signs (&) or quotations (" or ') are allowed anywhere in your Excel data, as they work as delimiters in the CSV file. Delete or replace them in Excel.
- Data from the CSV file will always overwrite any existing data.