|
<< Click to Display Table of Contents >> Navigation: Through the Menus > Functions > Import or Export > Import and add Units |
Use this option to add units to an existing Property.
The import will not import where there is an existing unit with the same unit number as the unit being imported. The various fields will be validated as they would be when being entered using the Unit Maintenance Screen.
This import uses the copy and paste method used to import and create system batches. Click here to view a brief tutorial on using the facility.
The Excel import template is as follows:
Import and add Units |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Prop |
Unit |
Door |
Sort Name |
Address- Name |
Address1 |
Address2 |
Address3 |
Address4 |
Address5 |
Address - Sal |
Contact - Name |
Contact - Tel W |
Contact - Tel H |
Contact - Tel NoK |
Contact - Fax |
Contact - Cell |
ID |
RegNo |
First names |
Gender |
LangE/A |
Marital Stat |
DOB |
Income Tax No |
NoK - relat |
NoK-Surname |
Nok-Title |
Contact2 - Name |
Contact2 - Tel W |
Contact2 - Tel H |
Contact2 - Tel NoK |
Contact2 - Fax |
Contact2 - Cell |
Email2 |
ID2 |
RegNo2 |
First names2 |
Gender2 |
LangE/A2 |
Marital Stat2 |
DOB2 |
Income Tax No2 |
NoK - relat2 |
NoK-Surname2 |
Nok-Title2 |
FS1-Descr |
FS1-Amt |
FS1-From |
FS1-To |
FS1-VAT |
FS1-Nnla |
FS2-Descr |
FS2-Amt |
FS2-From |
FS2-To |
FS2-VAT |
FS2-Nnla |
OccDate |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
891D |
1 |
A1 |
SMITH, MR A |
Mr A Smith |
PO Box 123 |
Westlake |
7945 |
|
|
Alan |
James Anderson |
0217020055 |
0215554444 |
0114533111 |
08601234444 |
0824562222 |
royk@uuuu.co.za |
1232512541214 |
James |
M |
E |
M |
12-Jul-95 |
55441122 |
Father |
Smith |
Mr |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Levy |
120000 |
|
|
|
5067 |
|
|
|
|
|
|
1.12.2012 |
|
891D |
2 |
A2 |
JONES, MR A |
Mr A Smith |
PO Box 123 |
Westlake |
7945 |
|
|
Alan |
James Anderson |
0217020055 |
0215554444 |
0114533111 |
08601234444 |
0824562222 |
royk@uuuu.co.za |
1232512541214 |
James |
M |
E |
M |
12-Jul-95 |
55441122 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Levy |
120000 |
|
|
|
5067 |
Rates |
25000 |
1.1.2012 |
31.12.2013 |
N |
601A |
1.12.2012 |
|
891D |
3 |
A3 |
JONES, MR A |
Mr A Smith |
PO Box 123 |
Westlake |
7945 |
|
|
Alan |
James Anderson |
0217020055 |
0215554444 |
0114533111 |
08601234444 |
0824562222 |
royk@uuuu.co.za |
1232512541214 |
James |
M |
E |
M |
12-Jul-95 |
55441122 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Levy |
120000 |
|
|
|
5067 |
Water |
12500 |
|
|
|
|
1.12.2012 |
|