What is XLS?
A XLS (.xls, .xlsx file extension) is a Excel spreadsheet file which allows data to be saved in a table structured format.
Step 1) Upload a sample XLS file
After you start the ingestion process you will need to select the option for "XLS."
To validate your selection, you will be asked to upload a sample .xls or .xlsx file of your catalog.
Step 2) Validate
MixBANK validates the structure of your XLS file to ensure it aligns with our standards.
Step 3) Get your FTP credentials
After validating your XLS file, the following screen will include your company's unique login to our FTP server. Additionally, a message containing the credentials will be sent to your email address.
What is FTP? FTP is the File Transfer Protocol; it is a standard protocol used by the music industry to exchange files from one server (e.g. your computer or company's server) to another (MixBANK). We use an SFTP server for partners like you to provide their catalogs for use in MixBANK. The "S" simply means that exchanges are done on a secure, protected server.
Step 4) Open your local FTP client
You will need to download an FTP client program to continue ingestion. We recommend using FileZilla.
The left side of the FileZilla window represents your computer, while the right side will represent your company's folder on our FTP server.
Step 5) Enter server details & your credentials
You will need to manually type in the SFTP server information for MixBANK, along with your credentials provided in the previous step. This will allow you to upload your content.
Click "Site Manager" on top left of your FileZilla window. Please note: do not use the "Quick Connect" option.
MixBANK's SFTP server details are as follows:
- SFTP URL: sftp.mixbank.com
- SFTP Port: 2020
- Username: Issued automatically to you on MixBANK during the ingestion process
- Password: Issued automatically to you on MixBANK during the ingestion process
Step 6) Create "date" folder
Publishers need to upload XLS files to a predefined directory.
To create the "date" folder, you must right click in the region of the FTP that represents your company's folder on our FTP server on the right side of the FileZilla window. Select 'Create directory' from the drop down, enter the date in the following format: YYYYMMDDhhmm. YYYY indicates the year in which the file is placed on the FTP server, while MM and DD indicate the month and day, and hhmm indicates the hour (in 24 hours), and minutes.
Step 7) Upload your XLS catalog to FTP
Then drag the file, from the left side (your computer) to the newly created "date" folder on the right. Do not upload your catalog into the "/test" folder as this will create errors.
What your complete catalog includes:
- .xls or .xlsx file containing your catalog's metadata
Step 8) Finished
After you're finished uploading your catalog to the FTP server, return to the MixBANK dashboard: Click "Next", then "Finish".
Note: It can still take several days to weeks for your catalog to populate within the MixBANK dashboard. A member of our team will email the moment your catalog is available.