This import functionality was introduced to LRS to facilitate Applications relating to Local Authority and Housing Associations housing stock transfers being submitted, the teams dealing with these applications required to input huge amounts of property section schedule entries per title. An alternative to having users manually key in the data was developed.
The format required for these schedules to allow importing is text (tab delimited)(*.txt) with standard agreed headers. Other similar formats can be readily converted and headers corrected using Excel. The import function loads the data from a selected file into a columns list display where it can be inspected and selected for import.
There was also a requirement when creating schedules of removals in these large Local Authority/Housing Association titles to not use the standard header "No. in green on the Title Plan" but instead to specify the colour etc. within the schedule item. To support this a new schedule type was created with the plan number column size increased. From the picklist it appears as "V = Schedule of Removals for Mixed Fees". The plan number column was also added to the schedule of exceptions.
File headers
The following headers should appear in the file irrespective of the Schedule type all columns must be present (See File Examples):
Select a schedule type from the drop down picklist.
Click on "Import (File)".
Locate the folder containing the required file and select "Open".
This will bring forward the following screen where you can select your desired entries. A "Select All" button has been provided to help with multiple selecting where hundreds of entries are available.
Click on "Import" and your selections will appear in the "Title A Section schedule entries" screen.
If the following error message appears when attempting to import a file, you should open the file in Excel and amend the incorrect file header.
Whilst all Columns can in principle be populated for each schedule type only those that will appear in the title sheet extract should be populated and for each type they are as follows;
Schedule of Short Particulars (Schedule Type = P and Short Partc. Type L or S)
SHORT_PARTC_TYPE
ENTRY_NO
TENANT_FEUAR
REGISTER
GA_TERM
Schedule of Exceptions (Schedule Type = E)
ENTRY_NO
PLAN_NO
SUBJECTS
REG_DATE
GA_TERM
FEUDUTY_RENT
Schedule of Removals (Schedule Type = R)
ENTRY_NO
PLAN_NO
SUBJECTS
REG_DATE
Schedule of Leases (Schedule Type = L)
ENTRY_NO
PLAN_NO
PLOT_NO
SUBJECTS
TENANT_FEUAR
REG_DATE
GA_TERM
FEUDUTY_RENT
Schedule of Sub-Leases (Schedule Type = S)
ENTRY_NO
PLAN_NO
PLOT_NO
SUBJECTS
TENANT_FEUAR
REG_DATE
GA_TERM
FEUDUTY_RENT
Schedule of Feus (Schedule Type = F)
ENTRY_NO
SUBJECTS
TENANT_FEUAR
REG_DATE
GA_TERM
FEUDUTY_RENT
DEED_TYPE
Schedule of Separate Tenements (Schedule Type = T)
ENTRY_NO
SUBJECTS
NOTE
Schedule of Removals (Schedule Type = V)
ENTRY_NO
PLAN_NO
SUBJECTS
REGISTER
REG_DATE
Schedule of Coordinates (Schedule Type = C)
ENTRY_NO
SUBJECTS