Import maintenance contracts
Add many maintenance contracts, or update the ones you have, from one Excel file in the Import & Export Center: the contracts sheet and its services, materials, conditions, SLA and disputes sheets, updates from an export, and contracts that are imported whole or not at all.
Use this import to add many maintenance contracts at once, with their scope of services, materials, conditions, SLA and dispute clauses, or to change the contracts you already have from an exported file.
Where to start
- On Maintenance Contracts, open Contract Settings and select Import contracts, or
- open the Import & Export Center and select Import on the Maintenance Contracts row.
Import shows to whoever may import contracts. The import then follows the steps in Import your data: file, review, import and result. Import the properties, customers and services first: a contract line can only name a property, a customer or a service your account already has.
Note: Import contracts now opens this import screen instead of the bulk import page you already know; a batch you had already started on that page stays open for 30 days so you can finish it from Contract Settings › Continue the open import batch. After 30 days the batch page takes you to the new import screen with a message explaining why; the batch's rows are not carried over.
Fill in the template
Select Download template. The workbook has the sheets you know: Contracts, then Services, Materials, Conditions, SLA and Disputes. Its drop-down lists hold your account's values, and every column has a note on what it takes. Save the file as .xlsx. Files made from the old template — with or without the Disputes sheet, with or without the Branch column — are read the same way.
- Contracts: one row per contract. A new contract needs Contract Number, Status, Title, Currency, Start Date and End Date. If your account generates contract numbers, leave Contract Number empty on a new contract and Nabeeh numbers it; such a contract cannot have lines in the other sheets of the same file.
- The other sheets link each line to its contract by Contract Number, exactly as on the Contracts sheet. A line whose number is not on the Contracts sheet stops that line. The Contract Number drop-down on these sheets lists the numbers you wrote on the Contracts sheet.
- Services: Property, Service, Type and Priority are required. Choose the property by its full name, such as Building > Floor. The import never creates a property, a service or a service provider, and a name that matches two of them stops the line until you rename one. Frequency details follow the notes in the template, for example
Sat,Tuefor weekly orday=5for quarterly; Quarterly, Thirdly and Semi-Annually services need the contract's start date. Expected Time of Day: HH:MM. - Materials: an active inventory item and a quantity above zero, each item once per contract. Materials are imported only when Inventory is enabled for your account; otherwise the row shows a warning and is left out.
- SLA: one row per contract, the hours as numbers, notes separated by
|. - Branch (accounts with branches): leave it empty to add a new contract to the branch you choose when you upload the file. A branch name adds it to that branch; an unknown name, or a branch you are not assigned to, stops that contract only.
Tip: Each contract is imported whole or not at all, so the review and the result count contracts, not rows. If one line of a contract has an error — on any sheet — the review marks the contract's other rows Blocked, and the error file holds them with the reason; the result counts that contract under Excluded before the import. The other contracts are still imported. To import a new contract without that line, delete the line in the review. On a contract you already have, the file's lines replace that part of the contract: if you delete a line the contract already has, it is removed from the contract too and the contract shows as Update. To keep it, fix the line instead of deleting it.
Change contracts you already have
- On Maintenance Contracts, open Contract Settings, select Export contracts and download the file (see Export your data). Its first column on the Contracts sheet, Maintenance contract ID (do not edit), ties each row to its contract; the other sheets follow. Only this ID changes a contract: a row without it adds a new contract, and it stops when its contract number is already used in your account.
- Edit the cells you want to change. On the Contracts sheet an empty cell keeps the current value; type
[CLEAR]to empty a field. The number, status, title, currency and dates cannot be emptied. - On the other sheets, the lines of a contract replace that part of the contract: keep every line you want to keep. A sheet with no line for a contract leaves that part as it is.
- Import the file. Rows you did not change are shown as No change, and nothing is written for them.
Updating contracts needs the permission to edit them, and each part you change — the parties, the scope of services, the materials, the SLA, the conditions or the disputes — needs its own edit permission, as on the contract form. Without the edit permission the import only adds new contracts and leaves the exported rows out.
After the import
The result lists the contracts created and updated. Download the error file to fix the remaining rows and import them again as it is: every sheet keeps its own rows.
What's next
- Maintenance contracts — the contract profile, its calendar and its branch.
- Import your data — the four import steps, the sheets of a review and the error file.
- Export your data — export the contracts list to edit it, then import it back.
- Import properties — add the properties your contracts cover.
- Import customers — add the customers your contracts name.
- Import services — add the services of your contracts' scope.