Uploading audiences

Multiple audiences can be uploaded from a CSV (comma separated values) text file by an administrator if they go to Administration > Site administration > Users > Accounts > audiences > Upload audiences. You can create an audiences at either the site-wide (system) context or in the course category context.

Upload audience process

To upload an audience follow these steps:

1. Create audience CSV text file for uploading (must include a namecolumn with the name of each new audience on a new line).
2. Go to Administration > Site administration > Users > Accounts > Audiences > Upload audiences.
3. Add file to upload.
4. Upload audience preview; review settings and check for any errors. If errors are reported with the file, correct as needed.
5. Upload audiences, click Upload audiences.
6. Upload audiences results, shows how many audiences were created.
7. Upload audiences results, click Continue.
8. Returns to Upload users

Settings

File format for the upload audiences file

The upload audiences CSV text file has fields separated by a comma (or other delimiter). The first line contains valid field names (preferably lower case). The rest of the lines (records) contain information about each new audience.

Avoid special characters in field information like quotes or other commas. Test a file with only one record before a large upload.

You can use a spreadsheet program to create the file with the required columns and fields. Then save the file as CSV (comma delimited). These files can then be opened with simple text editors for verification.

Valid upload file for testing

Here is an example of a simple valid upload audiences file: (Column headers on the first line of the file are only highlighted in bold in this example to distinguish it from the rest of the of the data/user details).

name,idnumber,descriptionClass of 2019,2019,Members of the Class of 2019Class of 2020,2020,Members of the Class of 2020

Fields that can be included

Required fields

Optional fields

To provide values other than the default include one or more of the following optional fields.

Additional fields

If needed, there are some additional fields that while not normally used can be utilised. Additional fields typically require looking up information in other tables (such as the course categories or context tables). The additional fields provide an alternative way of finding the course category context id. A bit of extra caution is recommended in using these additional fields. The list of additional fields includes: