Imports
Assemble supports importing users, adding notes or touchpoints, address book entries, tasks and training records from CSV, XLS or XLSX files.
Example files for each import type are available for download below should you be manually generating imports.
Where working with exports from other systems there is no need to match the export files to the examples, i.e. field names or order, as the import process allows for field mapping. However the system will use the first row for column headings (to support mapping), so this should be added if it is not included.
To support import planning please download the excel mapping template. This contains all the available fields and related options for each import type.
Importing data
The process is identical for all imports, but fields and options vary depending on the type of import being run. See below each import type section for more details.
Imports are available from the admin menu under bulk actions. The page will show any running, or previously run imports and you can click on these to view status/history.
As a file is loaded the system will analyse the file, using the first row as column headers for the mapping process. Where an import is being repeated, the system will remember fields that were previously mapped and pre-populate the import tool.
The headers will be listed on the screen with a dropdown beside each for selection of the related Assemble field. Selecting nothing will ignore the field on import.
The unique identifier when selected will use the related field to match the existing record for updates (e.g. User ID). If none is selected the system will perform a basic check for email, or first name/last name before creating a new user.
The final field on the import allows you to name the import if desired. This is just for reference.
Once triggered an import runs as a separate process in the background. While you can monitor from the page (which will live update), this is not required, as the system will trigger a notification email once the import process has finished.
Progress will be shown on the header, and errors (by default) shown on the detail pane. You can change the view to show All, completed or Not processed rows using the filter button.
On completion, each successfully imported item will show a view link allowing you to check the imported data if desired. Please allow up to 24h for the data to be aggregated to the organisation statistics.
Error items can be corrected and re-run in line, or corrected in the original file and re-imported in case of large numbers of issues.
Importing data from XLS or XLSX
Using XLS or XLSX files can cause additional complications as you can format fields and manipulate cells in various different ways within spreadsheet software such as Excel. CSV files are recommended for most imports but when text fields with line breaks are required XLS or XLSX should be used.
For optimal results, the date format YYYY-MM-DD should be used. They also should be marked as not regional specific within their fields/ cells.
Imports cannot be "undone" easily. Please carefully validate import files before loading large volumes of data.
Imported users will be checked against the unique ID, email and first/last name match before a new record is created.
User imports must meet the requirements below to create a user:
- Must include role and role start date, the end date is optional but must be after the start date.
- Must include the related team and manager for the role.
* Note where a role has an end date in the past, users will be made inactive (if no other active role remains) but this may take up to 24 hours to show.
Only one role can be imported with a user, for users with multiple roles add these by repeating the import of the user as an update with the additional role. Each additional import will add another role based on the unique ID. Is best to try to use UserID where possible to ensure a match with additional roles. This can be obtained either in the system or by exporting the imported users to obtain a list for lookup.
General notes:
- Unique Identifier can only be set to User ID, Email Address or any custom field that has been marked in its setup as 'unique'.
- For both custom fields and training, these must be configured manually in the system prior to the import to be available for mapping.
- When importing to a custom field ensure the importing user has access to write to the field and your imported data matches what you have configured as acceptable values for the custom field.
- When importing training you only import completion date (where relevant), as what training is needed is configured by role, not user. Ensure the training mapped is relevant to the role you are importing.
- When importing diversity data for any field containing the word "other" the other category can also be provided. For example, if for "Nationality" column the value provided is "other", then provide a value for "other nationality" column.
Touchpoints can only be imported to existing volunteers and the volunteer needs to be identified by the UserID created by Assemble. This can be seen on a users record or exports of users from Assemble.
- On user - This is the ID of the user you wish to add the touchpoint on/to
- Author - This is the ID of the user who should be shown as writing the touchpoint, if not specified this will default to the user performing the import.
Notes can only be imported to existing volunteers and the volunteer needs to be identified by the UserID created by Assemble. This can be seen on a users record or exports of users from Assemble.
- On user - This is the ID of the user you wish to add the note on/to
- Author - This is the ID of the user who should be shown as writing the note, if not specified this will default to the user performing the import.
The address book import will default to all users, but can also be imported on a per-user basis where specific addresses are limited in use. To limit to a user you must specify the UserID from Assemble in the import.
The name field specifies what can be searched on, for example 'Your Name HQ'. Latitude and longitude (decimal degrees) can be provided in lieu of an address to pinpoint a location. If not supplied the address will be used via google to translate to a location.
Icons
|
Users |
Building |
Sitemap |
Shopping-bag |
University |
|
Bed |
Cutlery |
Industry |
Map-marker |
Paw |
Imported tasks will only import new tasks to Assemble and cannot be used to update existing ones. If the same details as an existing task are entered, the task will simply be duplicated.
Task imports must meet the requirements below to create a new task:
- Either Due date (by) or Due date (on).
- A task title.
- The Assemble ID of the user who will be the owner of the task must be entered into 'Owner ID'.
- An activity category ID.
- Priority exactly matching one of the following:'low', 'normal', 'high', 'urgent'.
General notes:
- Ensure that you only provide IDs for resources in your current organisation. Also, ensure all IDs including Geolocation ID are configured in Assemble before importing.
- If importing Team IDs and Role IDs, we recommend XLS or XLSX files to be used. CSV files should still work, however, you can now import using the equivalent Excel sheet. This means text fields with line breaks are now also supported.
- If a postcode is provided without geo location id, the address will be parsed from the postcode.
Training records can only be imported to existing volunteers using existing training modules. The volunteer needs to be identified by the UserID created by Assemble or by the user's email address. This can be seen on a users record or exports of users from Assemble. The training module needs to be identified by the Training ID created by Assemble or by the Training name. This can be seen by superusers in the training settings. We recommend that the Training ID is used, however, if Training name is to be used without Training ID, the training name must be unique in the system so that it can be imported successfully.
General notes:
- Users, training modules and custom fields (if used) must be configured in the system prior to the import to be available for mapping. This includes the training modules being applied to the user's role in the compliance section of the role profile.
- The unique identifier should be set to User ID, email address or any Custom field ID and Training ID or Training name should also be unique.
- The completion date is required.
- When importing to a custom field ensure the importing user has access to write to the field and your imported data matches what you have configured as acceptable values for the custom field.
Equality, diversity and inclusion (EDI) data is part of the ‘users’ import process and can be imported with the creation of new users or to update existing users.
General notes:
- When importing EDI data each field must exactly match a given variable within Assemble. You can find these variables in the ‘Assemble Import Mapping Template’ above within the ‘Reference’ tab.
- If importing EDI data for existing users, we recommend using the Assemble ID as the unique identifier.
- When importing EDI data for any field containing the word "other" the other category can also be provided. For example, if for "Nationality" column the value provided is "other", then provide a value for "other nationality" column.
- Once imported, following GDPR guidelines, you will not be able to directly see this data per individual, however, it will update and be represented within the analytic reports.