Vendor Submission Spreadsheets

Slingshot will attempt to convert values on the spreadsheet into the type of data that Shotgrid expects for each field.

For example:

  • Numbers 0000 will be converted to strings "0000" to be stored on text fields
  • Correct Capitalization will be detected for list field values
  • Status names ('Pending Review') will be correctly mapped to their code ('rev'), case insensitive
  • Dates will be converted to strings ('2000-01-01'), while timestamps will be converted to datetimes (2000-01-01 01:10:20)
  • Checkbox fields can use t, true, x, y, yes, or 1 to indicate checked

TODO:

Detail here how Slingshot can import metadata from Vendor submitted .csv, .xls, .xslx, or .ods files.

Only column required is version name. Any other column can be ingested into that version in shotgrid.

One row per version (not one row per codec/format) - duplicate version rows will be ignored

Show a screenshot of an example document. Maybe even link to a good template that they can download and use.

When matching column headers to Shotgrid fields, any Link/Entity columns will be ignored.