Billable Items Import: Rightmove

THIS WILL NOW BE DONE BY FINANCE. PLEASE CHECK THIS HAS BEEN DONE.

This articles details the process for importing the Rightmove billable items CSV into the Nurtur Admin Hub. 

NOTE: there are currently two CSVs - one for Hunters and one for trad brands. These need to be amalgamated into one file prior to import.

Creating the Import File

1. Open the Rightmove mapping spreadsheet Rightmove Import CSV Mappings.xlsx
2. Open the file in Desktop mode
3. Select FIle>Save As. 
4. Name the file "Rightmove <month> <year> Billable Items" (where <month> is the current month and year is the current year e.g. "Rightmove February 2025 Billable Items.")
5. Click Save.
6. Open the Rightmove CSV in Excel
7. Select cell A2 and then press Ctrl+Shift+End to select all populated cells bar the header
8. Copy the selection
9. Paste the selection into cell A2 of the "Rightmove Report" tab of the mapping spreadsheet.
10. Scroll towards the end of the rows in tab "Nurtur Import"
11. Select the second row up until the last column with a header
12. In the bottom right corner of the selection there will be a cross. Drag it down to populate the same number of rows in the "Nurtur Import" tab as there are in the "Rightmove Report" tab.
13. Select *.csv as the file type
14. Close the sheet (you can choose Save to the dialog box that appears)
    
    

Importing the File

1. Navigate to the Billable Items screen in the Admin Hub - https://admin.nurtur.group/billable-items?network_id&q=&page=1&trashed=0
2. Click "CSV Import"
3. Choose "Rightmove" for "Item"
4. Click "Choose FIle" and navigate to the mapped CSV you saved earlier
5. You should receive the message "The Rightmove import process has been queued. You will be notified by email if there are errors.".
6. In a few minutes you should receive an email to the address you logged into the Admin Hub with.

Checking for errors

1. The error log should only contain errors detailing lines that are skipped (e.g. "Line 2 skipped"). If there are other errors please escalate (Stephen / Nurtur).
2. The description of each skipped line will contain the name of the branch to which it relates. If the branch does not have billable items imported against it (e.g. it is closed or is a Hunters owned office) then these can be ignored
3. If there are skipped lines relating to offices that should have billable items imported against them then the ID needs to be added against the office an the file reimported:
   1. The Rightmove ID is the first number after "Line <N>Skipped - ". Copy this.
   2. Search for the office in the Admin Hub and click "Edit"
   3. In the "Rightmove ID" field under the "External IDs" section add the Rightmove ID. If there is already an ID there then add a comma and then the Rightmove ID.
   4. Click Save
   5. Reimport the file via the Billable Items screen as detailed above. The resulting email should no longer contain the line.
4. Check that the billable items have been imported by going into an office in the Admin Hub and clicking "Billable Items". The imported items should be listed with a "Frequency" of "One Off"