Bulk Upload Contributor Details

It is possible within the system to bulk upload your contributor details. It's recommended that you also include a column with the Contributor Role. You can use the ONIX codes for Contributor roles when uploading your file.

To upload your file, follow the steps listed below: 

1. Navigate to Contacts in the main left-hand menu of your system. 

2. Click onto the second occurrence of Contacts. 

You should then click the upload button on the top right-hand side of the screen.

Step 1, choose the file to upload. Select an xls, csv or text file. Please note that the system will not upload xlsx files. 

Step 2, adjust the mapping. Each column heading in blue is clickable to change the column mapping. Choose "ignore this column" if you do not wish for the information in a particular column to be uploaded. 

Be sure to choose the correct encoding. Windows will generally work with Windows 1252.

When you are happy with the mapping, click the "Process File" button. Your contributor information should be on your system now. Go back into each item and click on the 'contributor' button so that the information will link through to the contributor tab in a title record.

Whilst the majority of the column mappings on upload of your contributor spreadsheet are self-explanatory, there are a few that you may find a bit of guidance useful for. For a full list of the types of information that you can upload about your contributors, please see here.

Assigning a 'Contact Type'

When bulk uploading, you can also indicate that this contact is a Contributor (essential), and if you wish them to be accessible in the royalties module.

To do so, you will need to include the following columns in your spreadsheet:

Addresses

Column Header	Required Data
Address Type	Billing; Delivery; Home; Alternative; Work
Address Line 1	Eg Flat 1
Address Line 2	Eg Example Street
Address Line 3	Eg Example Village
Address Line 4	City / Town Eg London
County / Province / State	Eg Greater London
Country	Eg United Kingom

Here is a full example of what we have described above: