Import your data
Download the template, fill it in Excel, then upload it and review its rows before importing; valid rows are imported and you get a file with the rows that have errors so you can fix them.
An import goes through four steps shown at the top of the screen: File, Review, Import and Result. Nothing changes in your account until you confirm the import yourself.
Step 1: File
- Open the import screen with Import on the list you want to import into — so far properties, assets, maintenance contracts, customers, users, service categories, services, asset types, vendor categories and vendors and inventory items — or with Import in the Import & Export Center, which is also where you import the question library, as it has no list of its own.
- Select Download template and fill it in Excel without changing the column headers. The template's Instructions sheet explains each column and the values it accepts.
- Drag the file onto the upload area or select Choose a file; the upload and the check start right away and a Checking the file… card appears. If you change your mind, select Cancel import on it to stop it. If you cancel just as the upload completes, you may find a draft of this import when you come back; you can cancel it from there. Excel .xlsx files up to 10 MB and up to 5,000 rows are accepted.
If your account uses branches, a Branch choice can appear before uploading data kept per branch, such as properties, assets and customers: new records are added to it unless the file's Branch column names another one. Service categories, services, asset types, vendor categories, vendors and inventory items belong to the whole account, so no branch choice appears for them. If the columns do not match the template or the file is too large, the reason appears right under the upload area and no import is created; fix the file and select Choose another file. If the file is the template of other data, the message says so (for example "This is the Assets template, not the Properties template.") and Import as Assets opens that import so you can upload the file there.
Tip: To change existing records, export them first from Export your data, edit the file and upload it. A row with a record ID updates that record, and a blank cell in an update row keeps the current value; type
[CLEAR]to empty a field.
Step 2: Review
The screen lists the file's rows with a count for each group: All, New, Update, No change and With errors, plus Warnings when there are any. Select a count to show only those rows. When the file has errors, the screen opens on With errors, and each error is written inside the cell it belongs to.
- Delete all rows with errors: removes them from this draft; they are not imported.
- Download rows with errors (in the More options ⋮ menu): a file with the same rows plus an "Error reason" column; fix it and upload it as it is.
- Replace file (in the same menu): upload a corrected copy instead of the current file.
- Sheets: a file with several sheets, such as maintenance contracts, shows one tab per sheet above the counts, each with its number of rows and, when there are any, its rows with errors. The counts and the rows follow the selected sheet, while the bar at the bottom and the import button count records (contracts, for example) across every sheet. A record and its rows on the other sheets are imported together or not at all: while one of them has an error, the others are marked Blocked, and Show … rows under their status opens the sheet that holds the error.
Fix rows on the screen
- Edit row: open the actions menu (⋮) at the end of the row and choose Edit row. The row's fields appear with the template's column names, and some are lists of your account's values, such as the category and the status. The record ID is shown for reference only and cannot be edited here. Fix the cells and select Save and recheck; we check the row again together with every row of the file linked to it, so fixing one of two duplicate rows clears the duplicate error on the other too. The result of the save shows above the rows, a pencil marks every cell you edited, and the file of rows with errors carries your edited values.
- Unknown values: when the file names a value your account does not have, such as a service category called "Pipes", the Unknown values panel above the rows groups it with the number of rows that carry it. Choose what it matches among your account's values and select Apply to rows: all those rows are fixed at once. The panel never creates a value; if you need a new one, add it first on its own screen, such as Tenant Categories in Account settings for service categories, then refresh the review page and choose it in the panel. There is no need to upload the file again.
- Switch to update: for data that supports it, a row with no ID that matches a record already in your account shows a message that names the matching record and invites you to switch it (for properties it is a warning: the row is still added as a new property unless you switch it; for assets the match is the serial number, for inventory items the SKU, and for vendor categories the name). Select Switch to update under that message or in the row's menu (⋮), or Switch all matching rows to update and confirm, and each row updates its matching record instead of creating a new one. This needs the permission to edit that data. Service categories, services and asset types do not show this option: a row that carries the name of an existing record already updates it. Customers do not show it either: their import only adds new customers.
- Warnings: when you upload a file you exported from Nabeeh and one of its records was changed in Nabeeh after the export, its row appears under Warnings with "This … was changed in Nabeeh after the export". A warning does not stop the import, but the file's values will replace that change, so check the row before you import.
Note: Only the draft's owner can fix its rows, and only while it is a draft. An account admin sees a colleague's draft without editing it.
When you are ready, select Import valid rows, check the counts in the confirmation window and confirm. Rows with errors are excluded, and an import cannot be undone automatically. A draft you do not import is deleted after 14 days, and you can discard it at any time with Discard import.
On a phone, the review shows a summary with the counts and the import, download and delete buttons; use a larger screen for a detailed review and to edit rows.
Step 3: Import
The import starts and the counts update as it goes, with Last progress. You can leave the page; you will get a notification when it finishes.
- To pause it, select Stop import; imported records stay, and you then choose Continue import or Discard remaining rows.
- If it makes no progress for 30 minutes, Retry the remaining rows appears; it picks up from the first row not imported and never repeats what was imported. After 2 hours without progress the import stops automatically; the remaining rows wait for your decision: Retry the remaining rows or Discard remaining rows.
- Two imports of the same data cannot run in one account at once; if a colleague is importing, the screen shows their name and the reference.
An account admin can stop, continue or discard the remaining rows of a colleague's import, and its owner is notified.
Step 4: Result
The result shows what was created, updated, left unchanged and what could not be imported, with the reason, plus the list of imported records. Download the error file to fix the remaining rows and import them again, then continue with the suggested next step if one appears. To see the imported records in their list, select Show them in next to the "Imported records" heading; the button names the screen it opens, such as Show them in Tenant Services. The list opens on the records this import created or updated only, and Show all brings back the whole list. If you select Export while the list is like this, choose the "shown in the list" option so the file holds this import's records only. The original file and the error file stay available for 30 days; the import summary is kept permanently.
What's next
- Import & Export Center — the suggested import order and the history of your runs.
- Export your data — export a list to edit and import it back.
- Import properties — properties with the floors and units under them, and updates from an export.
- Import assets — assets with their custom fields, and updates from an export.
- Import maintenance contracts — contracts with their services, materials, conditions, SLA and disputes sheets, each contract imported whole.
- Import customers — new customers, one mobile number each.
- Import users — new colleagues in the account, within your plan's seats.
- Import service categories — the first type to import, before services.
- Import services — services in your account's categories.
- Import the question library — questions and their options on two sheets; a question imports with all of its options.
- Import asset types — the types your assets are classified by.
- Import vendors and vendor categories — vendor categories first, then vendors, and updates from the exported files.
- Import inventory items — inventory items with their initial stock, and updates from an exported file.
- Branches — how the branch decides where new records go.
- Notifications — the import-finished notification.