Knowledge Base

Mass uploader

Do you have a batch of files to upload and do you want to populate them with specific metaproperties during the upload process? Use our Mass Uploader and upload and tag your files all at once.

The Mass Uploader helps you to upload multiple files. Your files need to be accompanied by a CSV file, in which your metaproperties and their values are listed. The Mass Uploader links the files to metaproperties, and populates the metaproperties automatically. Also, whenever there are tags in your CSV file that do not yet exist in the system, they will be created during upload.

Depending on your system settings, also new metaproperty options can be created automatically. Additionally, the Mass Uploader can extract EXIF/XMP/IPTC information. If the metaproperties in the CSV have values filled in, they take precedence, however if the values are missing, then the EXIF/XMP/IPTC information is retrieved.

To use the Mass Uploader, mapping needs to be set up by Bynder. After that you can prepare your CSV file and then upload it together with your files.

Note

  • The Mass Uploader does not take into account required fields and dependencies. If the CSV file does not contain all the required metaproperties and fields, the files will still be uploaded.

  • The normal uploader does not allow you to upload a file tagged with a metaproperty option for which the dependencies are not met. The Mass Uploader ignores these dependencies. This means that if your CSV file contains certain files tagged with metaproperty options for which the dependencies are not listed in your spreadsheet, the files will be uploaded nonetheless.

In order to link the CSV data to the uploaded files correctly, mapping needs to be set up. By mapping the Bynder metaproperty and metaproperty options with the corresponding columns in the CSV file, the system can tag the uploaded files correctly. Contact your Customer Success Manager, who can help you identifying your needs and setting up the mapping.

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.

Note

The mapping names used in the steps below are the default values we use. The implementation consultant or support agent you're in contact with will always provide you with the mapping values that apply to your portal setup.

  1. Have a look at this example spreadsheet and base your own CSV file on this.

  2. (Optional) If you're still making use of the old discontinued Brands structure, enter Brand in the first row of column A.

    Tip

    Note

    Remove the complete column if only one Brand has been set up for the portal. Since our legacy Brands structure is discontinued, this column does not have to be included for most portals.

  3. Enter 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.

  4. Enter name in the first row of column C, where you can later enter the names you want to assign to the assets.

  5. Enter tags in the first row of column D. In this column you can enter the tags you want to add to the assets.

  6. Enter description in the first row of column E. In this column you can enter the descriptions you want to add to the assets.

  7. (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.

  8. List all the file names in column B including the file extension.

  9. (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.

  10. In the rows of column C enter the name you want the files to have within Bynder.

  11. 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.

  12. In the rows of column E enter the descriptions for your assets.In the rows of column E enter the descriptions for your assets.

  13. In the rows of column F-XFD enter 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.

  14. Save your file as a semi-colon separated CSV file in UTF-8 encoding. Download a CSV example file here.

    Tip

Once your CSV file is prepared and the mapping has been set up by Bynder, you can start batch uploading your files.How to use the mass uploader?

  1. Click your name in the right top corner of the screen and click Mass Uploader.

  2. Drag and drop your CSV file to the left side bar or click Add files to upload your CSV file.

  3. If your CSV file is processed correctly, you will get to see the message "Your CSV file was successfully parsed". If not, read the error message, adjust your CSV file and submit it again.

  4. Drag and drop your files to the left side bar or click Add files. They will automatically start uploading and tagged with the metadata from the CSV file. Once a file is uploaded correctly, the status will change to Successful.

    Tip

    Click on a file name after a successful upload to directly go to that asset.

    mass_uploader.gif

    Click for a visual walkthrough

No hard limit is in place, but we recommend uploading in batches of 500 files.

The Mass Uploader does not take into account required fields that are set up for your portal. If the CSV file does not contain all the required metaproperties and fields, the files will still be uploaded.

The Mass Uploader does not take into account dependencies. Files with metaproperties that during the normal upload process would require a dependency will still be uploaded even if this dependency is not filled in.

Only if you're still making use of the old discontinued Brands structure. You can easily check this by going to Settings > Taxonomy > Brands and checking how many brands are listed. If you have more than one brand set up, you are making use of the old brands structure. If only one brand is listed, remove the Brand column from your CSV file. Contact your Customer Success Manager if you're still not sure which structure is used.

  1. Save the spreadsheet as a Tab Delimited Text (.txt) file.

  2. Open this .txt file in a text editor, such as TextWrangler.

  3. Copy the tab separating two of the items.

  4. Press Ctrl+F (Windows) or Cmd+F (Mac) to open the search function. Paste the tab into the Find box and fill in a ; in the Replace box.

  5. Save this now semicolon delimited file as .csv manually (by adding .csv to the filename).

  6. 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 individual success message.

If the error messages do not provide enough information to fix your file, make sure your CSV file meets the following requirements:

  • Do not use trailing spaces. Make sure 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.

  • Make sure your spreadsheet is saved as a semi-colon separated CSV file in UTF-8 encoding.

  • Make sure all mapped fields and metaproperties have their own separate column in the CSV file.