Website database populated via spreadsheet. (three days max)
$250-750 USD
Dibayar saat pengiriman
Job must be completed in three days.
My 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 selecting an asset, using web forms to assign some of the attributes and then using a tagging tool for other attributes, mostly keyword tags.
WHAT I NEED:
I need the option to bypass those forms and tagging tools, and instead tag via imported spreadsheet; and also do the reverse, export populated spreadsheets from the database, per user account.
Example:
User uploads 100 audio assets. System says, “upload complete,” and assigns system filenames to assets.
User visits user dashboard page and 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.
We need to figure out how our script will match the correct tags with the correct audio files. We may need to dictate the structure of the spreadsheet, providing a template file as a starting point. This might be a blank template. Or, since we will have spreadsheet exporting, users can tag ONE file the hard way, using our 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.
Example:
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.
ID Proyek: #5538504
