Mediagraph allows you to import a spreadsheet of metadata to match with files based on the asset's filename, Mediagraph GUID, or Externally Imported ID (if available from migration). This is a useful tool when editing metadata in bulk or migrating content from another system. You can map the data in a particular column of the spreadsheet to a metadata field of your choice. Continue reading to learn how to import metadata.
Preparing your data for import
You need a column to match with. If using a filename, these need to be an exact match to the names of the files in Mediagraph, including file extension.
Each column needs to have a header to use in the metadata field mapping.
It’s okay for cells to be blank if there is no entry for that file in a particular field. Blank entries will not overwrite data that already exists in the account.
Keywords and multi-value Custom Metadata fields can be delimited by a comma to import multiple terms. Each one will come in as an individual item.
Uploading your data to Mediagraph
- Go to the Manage tab.
- Select Meta Imports from the sidebar on the left.
- Click the blue New Import button in the top right corner.
- Click Select File to open your computer’s upload dialog, where you can select a metadata file to upload. Supported file types are .csv, .tsv, .xls, and .xlsx.
- Choose a metadata type to match metadata to your files. GUID is the best way to match, since every asset in Mediagraph is assigned a unique one, even if the filename is the same.
- Mediagraph will analyze your spreadsheet and match each row to a corresponding asset in your account. The Matches field will show you how many successful matches have been found. There should be at least one more row than match. If you are matching on filename without the filename extension, checking "Enable Partial Matches?" will match on the filename root.
- In the Headers section, the column header from your spreadsheet will be listed. Choose a metadata field for the data from each column to map to. If your header name matches a standard IPTC metadata field, it will be preselected automatically. You can change this to a different field if you wish.
- Click Process Import.
- Once the entry in the status column reads "Processed," your metadata has been successfully added to the matched files.
- Make sure you examine the files to see that you had all the settings configured correctly.
Pro Tip: You can also create a free text Custom Metadata field, however it's generally better to create the fields you need before the import.
Troubleshooting
Duplicates
If the Duplicates field shows a number higher than 0, then you have more than one file with the same name as one of the matches. This could be caused by having a second copy of the matching file in the account. It could also be caused by a "name collision," where two different files have the same name.