Bulk Importing Tasks

You can now bulk import Tasks from a CSV, XLS or XLXS file and assign each Task to the appropriate user(s)


If you have more then 100 tasks you are importing, only the first 100 tasks will be imported.


If you have more then 100 tasks to import please split these into multiple files and import these separately


To bulk import Tasks, you will need to first set up a CSV, XLS or XLXS  file with all of the Task names in one column.

You can also include the Priority of the Task, the Due date and the relevant Time zone of each Task. Please note that these fields are not compulsory.


Task example sheet


Then once you have loaded up all of your Tasks download the file to your PC.


In the SiteConnect web portal, you will then go to Tasks in your main menu


Tasks side menu


This will bring up a list of all the created Tasks from your connected network. To import your Tasks click on the Import Tasks button at the top of this page


Import Tasks button


Then click on Select a File.  This will open up your browser where you can select the CSV, XLS or XLSX file you want to download.


Select a file


Once you have selected your file a sheet selector will appear at the bottom. Click this and select Sheet 1, then click Confirm to start importing.


Exel Sheets


If your file has multiple sheets, then you will need to select the correct Sheet that your Tasks are displayed on


This will then bring up the screen with all of your columns displayed. You will need to map each column to the appropriate dataset by clicking Map Field above each column and selecting the appropriate information set that each column relates to.


Mapping Fields

You will get to choose from the following options when mapping your fields or you can click Ignore to dismiss that column entirely from the import


Field options


Once you have mapped your fields appropriately click Save down the bottom to continue.


If you map more than one column to the same field, the data will be concatenated e.g. first name and last name columns will be combined into one field called contact person if you select contact person for both columns.


Save mapped fields

This will then bring up a screen whereby you can assign the Tasks either in Bulk or separately.


If you have more then 100 tasks you are importing, only the first 100 tasks will be imported.


If you have more then 100 tasks to import please split these into multiple files and import them separately


Use the top line to bulk assign all the Tasks you have imported to specific Sites & Users all at once.


Assigning the Tasks


Or you can use the individual tasks below this to assign each task individually to different Sites or Users respectively.


Assigning the Tasks-1

To assign a Task to a specific Site, click on Sites for that Task (or all Tasks by using the top line) and then select the appropriate Site from the menu which appears.


Selecting Sites


And you can select specific Users, by clicking Users and then selecting them from the list which appears which will show all users in your connected network


Selecting Users


You can also choose to set a particular Task to be an individual task by toggling the Individual option ON (pink) for that Task.


Individual tasks


If Individual is ON (pink), this means that if you have assigned multiple users to this Task they will each get an individual task and all of them need to complete this separately.


If this option is OFF (grey) then if one of the assigned users completes the Task , it completes the task for all users who have been assigned the task, i.e. only one of the assignees needs to complete the task.


Once you are happy with your assignments, click Save down the bottom to complete your import and notify your assignees of the Tasks you have assigned them.


Save Tasks


PLEASE NOTE- Various Import errors can occur if an item (in the Priority or Time zone columns) is misspelt/not entered correctly in the original file or not visible in one of the Tasks you are importing. Also if a Task has no assignees this can also occur.

If a Task does not have anyone assigned to it you will receive a warning message and will be unable to Save your tasks. You will need to go back and assign that Task to a user or Site in order to finalise your import


Users Required


You may also get a message that you need to fill in all relevant time zones




An easy way to fill these in is to select the appropriate time zone in the top line and this will auto fill the rest of your Tasks out automatically.


Timezones confoirmed


If there are any issues with no Task Priorities associated with any of your Tasks you will also get the following message when attempting to Save


Task Priority required


You can either go back and fill in the empty priority for your Task(s) or click Yes to auto default it to the Low Setting.


Once you have Saved and all necessary fields have been filled in, you will get a confirmation message and your Tasks will start importing in the background.


Task created successfully


You will then get an email when the import has been completed and all assignees will also receive an email detailing that they need to go  and complete the Task via the SiteConnect Mobile App


Importing of tasks


If you need any further help or have any questions please contact the support team by email siteconnectsupport@sitesoft.com or Ph: 0800 748 763