Click **Download Template** to obtain the Excel file.

### Open the downloaded file and enter job details starting from **line 4**. 

- You can enter one job or multiple jobs in separate rows.
- Fields marked with an **asterisk (\*)** are required.

### **Required Fields for Import:**

- **Job No.** – Enter a job number based on your agency's workflow, or leave it blank to let the system auto-generate one.
- **Job Description** – Provide a brief description of the job.
- **Client Code** – Enter the appropriate client code.
- **Office Code** – Specify the office code.
- **Currency Code** – Input the relevant currency code.
- **Job Type** – Select the job type.
- **Billable?** – Enter "Yes" or "No".
- **Date Opened** – Input the date the job was opened.

Save the completed file on your computer.

Click **SELECT FILE** and upload the saved file.

- If the file is correctly formatted, the **Search Jobs** screen will display the imported job details.
- If errors are detected, the system will highlight the specific issues. These must be corrected before reattempting the import.

If the import fails, check the following:

- Ensure all **required fields** are filled.
- Verify that **date formats** match the system’s requirements.
- Confirm that all **codes (Client, Office, Currency, Job Type)** are valid.
- Remove any **special characters** that may interfere with processing.
- Check for **duplicate job numbers** if manually assigned.

Accountabilityone

The Import Function streamlines job creation by allowing users to add single or multiple jobs via an Excel template. This reduces manual entry errors, ensures consistency, and saves time. Users can input key job details, upload the file, and let the system efficiently handle job creation.

How to Create Jobs Using the Import Function