Jump to:


Downloading the Bulk Work Template


Tips for Completing Your Bulk Work Document

Uploading Your Bulk Work Document

Error Messages

 


Downloading the Bulk Work Template


After you've logged into The MLC Portal and selected your Member, follow the steps below to download the template:

  • From the menu along the left-hand side, click Register Bulk Works 
  • On the next screen, click the blue Download template button on the right to download the template to your computer.
  • Once the document has downloaded, open the file. Save a copy to your computer by selecting Save on your preferred spreadsheet software.  
    • Please note: You will be prompted to Enable Saving in order to save the document to your computer. (See example below.)



------------------------------------------------------------------------------------------------------------------------------------------


 Tips for Completing Your Bulk Work Document

Before completing a Bulk Work upload, please note that publishing information should only be entered for shares you control. Please do not enter publishing and shares information for publishers you do not represent.



Required Fields


Not every column is required – you can tell which are required by the asterisk (*) next to the column title. Skip to the "Required Fields" section below to review these columns.

 

However, some columns are dependent – this means if you enter information in one column, you must enter information in its dependent column or you will get an error when you upload. These columns are not required, but both must be filled in if you choose to add this information. These columns are:

  • AKA Title and AKA Title Type Code (Columns E and F)
  • Administrator Name and Administrator IPI Number (Columns O and P)
  • Recording Title and Recording Artist (Columns R and S)

 

Required Fields:

  • Primary Title (Column A)
  • Writer Last Name (Column G)
  • Writer Role Code (Column J)
  • Publisher Name (Column L)
  • Publisher IPI Number (Column M)
    • Note: If you are a self-administered songwriter that does not have a publisher IPI, you will not be able to do bulk work upload - you will need to upload works individually.
  • Collection Share (Column Q)
    • Note: You may not enter zero. If you have zero shares in a work, you do not need to register that work. 




Column Definitions


If you do not know what a column title means or what information to enter for that column, please review the Field Definitions tab at the bottom of the document.

  • Please note: The columns should not be moved or deleted – they must be in the same location as the template to successfully upload.

 


Document Size


There is a maximum of 300 rows for upload. If your document requires more rows than 300, you will need to create another document for upload with those additional rows.

  •  Please note: 300 rows do not equal 300 works. If there are multiple writers on a work, each writer must have their own row, which may mean multiple rows for a single work. 

 


Entering Multiple Writers on the Same Work


The example below shows how to enter multiple writers on a single work:



  • The work title is entered in Cell 2 under Column A.
  • The first writer’s information is entered in Cell 2 under Columns G, H, and I
  • The information for the second writer on that same work goes below in Cell 3 of Columns G, H, and I - but the work title does not need to be repeated in cell 3 of Column A.

 


Document Format for Upload


The file must save as an .xlxs format or as a .csv format to upload. 

  • If you have an older file format version, you will need to upgrade before uploading the document.


------------------------------------------------------------------------------------------------------------------------------------------


Uploading Your Bulk Work Document


Once your document is completed and saved in an .xlxs or .csv format, follow these steps:

  • Navigate back to the Bulk Work Upload section through your Member account. 
  • Click the blue Browse Files button and select your document from where it's saved on your computer.
  • If you accidentally select the wrong document, simply click the blue Remove button to clear the file and click the Browse Files button to select the correct file.
  • Once the correct document is selected, click the blue Upload button at the bottom right-hand corner. 
  • If there are no errors in the document, you will see a message that your works have been submitted.



If you see an error message upon upload, please find the message you're seeing in the next section for steps on how to resolve the issue.


------------------------------------------------------------------------------------------------------------------------------------------



Error Messages


Please note: Error messages are based only on issues with on data validation. Any disputes or discrepancies in the data will be found in the matching process. 


If you receive an error message, click the blue Continue button to be taken to the File Review screen. Here you will see which works are ready to submit, and which require attention. You now have a few options:


If there are only a few errors to resolve:

  • Scroll below in this article to the applicable error message below for information on how to resolve.


If there are many errors to resolve:

  • We suggest selecting the blue Cancel and Start Over text at the very bottom of your screen to remove your current file, then revising the errors on your document and re-uploading as a new file.

If you prefer to submit the works that are ready and resolve any works with errors later:

  • Click the blue Submit [X] Works button in the bottom right corner. This will submit the works that do not have errors.



  • In the upper left corner, you will see text showing in red how many works with errors remain.



  • Select the blue Done button in the bottom right corner. 
  • A pop-up screen will ask if you want to save incomplete works as drafts. Click the blue Save to Drafts button.



  • You will be taken to the Registration Drafts page where you can see these incomplete works. You can edit them individually at a later time.
    • Please note: Works are saved as a draft here for up to three months.



 


Missing Data Error Message

This message means there is information missing from required or dependent fields in your file. The message will show the missing field - in the example above, there is a work that is missing the Writer Role Code.


To resolve the issue:

  • Click the blue OK button to exit the pop-up message. 
  • You will need to review your bulk work document to input the missing required data, then you can upload the corrected document again.

 


Data Validation Error Message


This message means there is an issue with the data on one or more of your works, such as too many numbers in an IPI field. The message will show how many works have an issue - in the example above, there are 2 works with issues. 


To resolve the error:

  • Click the blue Continue button to be taken to the File Review screen.
  • On the File Review screen, you will see the works that need attention in red
  • Click the blue Resolve Errors text on the right-hand side. You will be taken to the Work Details page for that work. 
  • A red error ! icon will show on the right-hand side of the section, and the pieces of data that need attention will show in red. 
    • In the example below, you can see that the Writers section has an error and IPI is in red to indicate that information needs to be fixed. 



  • Click the blue Edit button next to that section. You will be taken to a screen to edit the information from that section.
  • To edit, click the underlined Edit text to make your changes.
  • A pop-up will appear along the right-hand side of your screen with details. In the pop-up, enter changes in any field you need, then click the blue Edit button at the bottom. 
  • Once all edits have been made, click the blue Next button in the bottom right-hand corner.

 


File Is Too Large Error Message

300 rows are the maximum amount of rows that can be accepted on a bulk works document. 

  •  Please review the information under the Document Size section of this article for more information.