Import contracts from a spreadsheet
The short answer
Click the Cog, click Contracts, and download the template. Fill in one complete row for each item in a contract, repeat the contract details on every row, then drag the file in and click Upload. A banner shows whether the import succeeded or failed. The customer must already be in Zigaflow.
Steps
Click on the Cog

Click "Contracts"

Download the template here

More than one contract can be imported at a time
The template has three areas: header, section name, and item details.
Prepare the import file

For each item in a contract, there needs to be a complete row
For each item in a contract, there needs to be a complete row. This means that the master contract details, such as the customer name or note, need to be repeated on each line. Similarly, the section name (if given) needs to be repeated for all the items in the sections.
Use the column "Linked Asset Reference" to connect a line to a client asset.
Upload the file

Drag and drop the import file here

Click "Upload"

The banner shows the success or failure of the import

The original ID/Reference from the previous system is appended to the description
Learn more: contracts in Zigaflow

Before you import
Before importing, the customer/company and contact at the company (if set in the import) need to be in Zigaflow. Otherwise, the import will fail.
These columns are compulsory in the import file:
- ID - this is just the reference from the previous system, such as the job number
- Status (the Zigaflow status)
- Company
- Assigned User Email - the user the job will be assigned to in Zigaflow
- Initial Assigned User Email - the initial user the job will be assigned to in Zigaflow
- Start Date
- End Date
Client Assets
When importing this file, the reference/serial number automatically links the items to any client assets.
Download the template
Frequently asked questions
Was this helpful?