8.5.2.6 Permit data import - LUPMISManual

Go to content

Main menu:

8. LUPMIS Tools > 8.5 Permit Tools > 8.5.2 Entry

8.5.2.6 Permit Data Import


Permit data exist already in many Districts in table forms, mainly in Excel. These can be imported easily into LUPMIS, but data structure (arrangement of columns in Excel) have to be in pre-defined structure, such as application number in column A, applicant name in column I etc (see Chapter 8.5.2.6a), and saved as CSV file with '_permits_' in the file name (see Annex 20.1 for CSV files). Existing tables, which don't have this structure, have to be re-arranged (cut and paste columns in Excel).

Select this CSV file. It can reside anywhere in your computer. Be sure, you select it before you proceed with the next steps.


If this table has already all the permit data with the UPN for each permit, following steps 2 and 3 can be left with the 'No need...' option and no selection is required there.

In some cases indeed, the UPN is not know at this stage and the table can not be filled in column B (UPN).

One or two more references have to be created. The first one is the link to the Local Plan ('Sector Layout') with all parcels and their UPN, which were generated earlier through the 'UPN assignment' Processing Tool (see Chapter 8.3.1). Select the layout in step 2. The layout has to reside in the LP folder of your District.

If the permit table has x/y coordinates of any point within the parcel of each permit,  following step 3 can be left with the 'No need...' option and no selection is required there.

Again, in some cases indeed, x/y coordinates are not easily available and the table can not be filled in columns C (x) and D (y). This is not necessary if the application number is filled. If not, another reference has to be created. This is a small point file of the concerned parcels with the application number in the
label field in the DRA file. Select this point file in step 3. This point file has to reside in the LP folder of your District.

  




 
Back to content | Back to main menu