If you're just getting started with Workforce or if you're an existing customer that receives jobs in bulk via a spreadsheet, you can import a batch of jobs via an .XLS template.

How to download the job .xls template file

You can download the file here


you can also download the .xls template from within the jobs section by follow the steps below:

1. Go to the Jobs section and select the Import Jobs option from the top drop-down menu and Apply.

2. The "Import your jobs via Excel" pop-ul will be displayed. Here you will need to access the "sample file (click here)" link to download the template .xls file.

.XLS file format

After downloading the .XLS file you will need to open it and paste or manually input the information for each header. The job details will be reflected on Workforce FM under the general Jobs list.

The header contains information about what should be updated in each column:
job_name - this is a mandatory field, the job will not be imported without a job name;
job_status - if the status doesn't exist in Workforce, a new status will be created;
job_description
job_duration
job_duration_type
customer_email
customer_name - customer must already exist in Workforce;
schedule_date_from - users can add the start date and time of the job;
schedule_date_to - users can add the end date and time of the job;
assigned_to
site_name - if multiple sites addresses are added the site name must be unique for each site address;
site_first_line_address
site_second_line_address
site_city
site_state
site_post_code
site_contact_first_name
site_contact_last_name
site_phone_number
site_email
custom_field - you can add as many extra column headers with the names of your custom fields as you want. All extra headers added after the "site_email" header will be considered custom fields.

IMPORTANT NOTE! The custom fields and preset values (in the case of drop-down custom fields) added to them are case sensitive. If you add an existing custom field name or preset value you must add it exactly as it has been added in the system, otherwise the system will generate a new custom fields or preset value e.g. if the custom field is added in all caps in the system it should be added in all caps in the .xls import file as well.

Importing  jobs 

After adding all of the information to the file and saving it in .XLS  format (remember to ensure its saved in the correct format), go to the Jobs section > access the top drop-down menu > select the Import Jobs option and click Apply. When the import box is displayed you will need to click the "Choose file" option and load the .XLS template in. once this is done you can then click "import now"


ATTENTION!
If you add new custom fields you will have the option to "Add unmatched custom fields as new ones" this will create new custom fields in the system for you. Alternatively you can select "Ignore unmatched custom fields" to simply ignore them and not add them as new custom fields.

Did this answer your question?