Our site sells licenses for audio assets similar to the manner in which Getty Images sells rights to use images. Those music and sound effects are tagged with keywords and phrases and prices, and various other attributes. This is currently achieved by calling up an asset, filling out web forms for some attributes and then using a tagging tool we've built for keyword types of tags. What we want:
Bypass the forms and tagging tools and tag via imported spreadsheet; and also be able to do the reverse, export populated spreadsheets from the database, per user.
User uploads all audio assets. System says, “upload complete,” and assigns system filenames to assets.
User visits user dashboard page. Sees all audio files have “Incomplete” status, because they’re not tagged yet and can’t be moved into the storefront without attribution. User is invited to tag the assets individually via the forms and tag tool OR via spreadsheet.
User uploads a spreadsheet populated with all the relevant file attributes and tags; keywords, descriptions, genre, mood, instruments, prices, composer names, etc. Everything we use to describe files.
Database imports all the associated data.
System “processes” all the files once the data has been absorbed, upgrading them to “visible” status. And then they’re live on the store front.
Currently there is a collection of 30 or so audio assets in the database with no attributes and no tags. That’s what we will test on.
We need to figure out how our script will match the correct tags with the correct audio files. We will also need to dictate the structure of the spreadsheet. We will provide a template file as a starting point, either a blank template, or users can tag ONE file via web forms and tag tool and then export the resultant spreadsheet. User gets a template with one row filled in and they can just fill out the rest of the spreadsheet and upload.
We need validation and error report.
This process must work as a way to update the database as well.
I want to raise all prices of all songs by 10%.
I export my current spreadsheet.
I change all the prices in the price column by 10%.
Re-upload the file.
All prices are updated.
*** Note: This employer will not accept upfront payment milestones.