If you have a large batch of assets you would like to upload to your Asset Bank you can do so using the Mass Uploader. Your files must be accompanied by a CSV file listing your metaproperties and their values which will then populate the metaproperties and tags automatically. Depending on your settings, new metaproperty options can also be created automatically.
If derivatives are set up for your portal the Mass Uploader will create them upon upload.
If you would like to batch upload new versions to existing assets you can use the Mass Version Updater.
How to enable the Mass Uploader?
Contact your Customer Success Manager who can provide additional information and any associated costs.
Who can use the Mass Uploader
Users with the following permission can use the mass uploader
- Upload Assets
Before Using the Mass Uploader
Before you begin please make sure you map the metaproperty and metaproperty options to the corresponding columns in your CSV file. needs to be set up by Bynder. Once the mapping is in place, you can prepare your CSV file and upload it together with your files.
- The Mass Uploader does not take into account the required fields and dependencies. The files will still be uploaded if the CSV file contains only some of the required metaproperties and fields.
- Additionally, the Mass Uploader can extract EXIF/XMP/IPTC information. If the metaproperties in the CSV file contain values, they take precedence; however, if the values are missing, then the EXIF/XMP/IPTC information is retrieved.
How to Create CSV File
The CSV file needs to contain several required fields. Optionally, you can add columns to upload your metaproperty and metaproperty options. Follow the steps below to set up your CSV file.
View this example spreadsheet and use it to get started.
- If using the Legacy Brand Structure see here.
Enter the filename in the first row of column B. This column will be used to link the data of your CSV file to the corresponding files.
- Include the exact extension in the filename. Extensions are case-sensitive, therefore. JPG and .jpg will not match.
- Enter a name in the first row of column C, where you can later enter the names you want to assign to the assets.
- Enter tags in the first row of column D. In this column, you can enter the tags you want to add to the assets.
- Enter a description in the first row of column E. You can enter the descriptions you want to add to the assets in this column.
- (Optional) Columns F-XFD can be used for your custom metaproperties. Enter the names of the metaproperties in the first row of the designated column.
- List all the file names in column B, including the file extension.
- (Optional) In each row of column A, enter the ID of the brand you want to tag the asset with. To get your Brand ID, go to Settings > Taxonomy > Brands and click on the brand. Copy the ID from the URL in the address bar of your browser.
- In the rows of column C, enter the name you want the files to have within Bynder.
- In the rows of column D, enter the tags you want the assets to have. Tags that do not exist in the system will be created. Use commas to separate tags.
- In the rows of column E, enter the descriptions for your assets. In the rows of column E, enter the descriptions for your assets.
In the rows of column F-XFD, enter the labels of the metaproperty options you want to tag the assets with. You can assign multiple metaproperty options of the same metaproperty by separating them with a comma.
If a metaproperty option includes a comma, either a new metaproperty option will be added, or the asset will fail to upload, depending on your portal configuration.
Multiselect must be enabled on a metaproperty level for Select, Select2, and Autocomplete metaproperties. Read more about this option here.
Save your file as a semicolon-separated CSV file in UTF-8 encoding. Download a CSV example file here.
- If your file is not saving as a semi-colon-separated document please see here.
Important Information on Labeling Your CSV File
Do not use trailing spaces. Ensure all trailing whitespace is removed from your CSV file before submitting it.
Use the metaproperty option labels in your CSV file and not the metaproperty option names
Using diacritics (ë, ç, û, etc.) in filenames could cause issues when reading the
.csvwhile uploading using the mass uploader. This is caused by the multitude of ways these characters can be composed using Unicode.
‘Normalize’ the filenames and use the Latin alphabet without the diacritics.
Thalin.jpg. The diacritics can still be used for titles.
How to Use the Mass Uploader
Once your CSV file is prepared, and metparoperty mapping is complete, you can start batch-uploading your files.
Make sure your CSV file includes at least the data of one asset.
Click your name in the top right corner of the screen and click Mass Uploader.
Drag and drop your CSV file to the left sidebar or click Add Files to upload your CSV file.
If your CSV file is processed correctly, you will see the message "Your CSV file was successfully parsed." If not, read the error message, adjust your CSV file, and submit it again.
Drag and drop your files to the left sidebar or click Add files. They will automatically start uploading and tagging with the metadata from the CSV file.
Once a file is uploaded correctly, the status will change to Successful.
After successfully uploading, you can click on a file name to go directly to that asset.
- You can't mark assets as limited usage, archived, downloadable, or public or add a watermark to them using the Mass Uploader.
- If a derivative is configured with a regex, the uploaded asset's filename must begin with that specified regex for the derivative to be created via the Mass Uploader. The normal uploader does not have this requirement.
- The Mass Uploader doesn't generate automated tags.
- The Mass Uploader won't index the content of digitized documents, such as PDF and Word documents. This means that when you enter their content in the search bar, these documents won't be returned as a search result.
FAQWhy is my CSV file not saving as a semicolon-separated CSV file?Some software, by default, saves your spreadsheets as comma-delimited files. Follow the alternative instructions below to make a semicolon-separated CSV file.
How many files can I upload at once with the Mass Uploader?
Does the Mass Uploader consider the required fields that are set up for my portal?
Does the Mass Uploader take into account the dependencies that are set up for my portal?
Do I need to include the 'Brand' column in my CSV file?
Why is my CSV file not saving as a semicolon-separated CSV file?
- Save the spreadsheet as a Tab Delimited Text (.txt) file.
- Open this .txt file in a text editor, such as TextWrangler.
- Copy the tab separating two of the items.
- Press Ctrl+F (Windows) or Cmd+F (Mac) to open the search function. Paste the tab into the Find box and fill in the Replace box.
- Save this now semicolon delimited file as .csv manually (by adding .csv to the filename).
- Drop this .csv version of the sheet onto the Mass Uploader and wait for a success message. Then, drop the files onto the Mass Uploader and wait for each success message.
Why do I see an error message when uploading my CSV file?
Make sure your CSV file includes at least the data of one asset. If only the columns in the first row of the CSV file are available with another row with actual asset data, the Mass Uploader will respond.
For Customers on Legacy Brand Structure
(Optional) If you're still using the old discontinued Brands structure, enter Brand in the first row of column A
How to find out whether I'm using the old Brand structure?
Go to Settings > Taxonomy > Brands and check how many brands are listed. If you have more than one brand set up, you are using the old brand structure. Remove the Brand column from your CSV file if only one brand is listed.
Remove the complete column if only one Brand has been set up for the portal. Since our legacy brand structure is discontinued, this column can be excluded for only some portals.