Closed

Web database populate via spreadsheet.

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.


Example:

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.

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.

*** Note: This employer will not accept upfront payment milestones.

Skills: PHP, Software Architecture

See more: what are the types of data structure, web assigns, types of data structure, template tool price, spreadsheet script, software milestones, price structure template, need music composer, need a music composer, music composer work, milestones software, file validation tool, dashboard architecture, web forms, web database, row spreadsheet, report an employer, filling database, Database collection, composer audio sound, Asset store, spreadsheets data collection, music web script, database music store, forms update example

About the Employer:
( 1 review ) Pleasanton, United States

Project ID: #5460494

6 freelancers are bidding on average $361 for this job

coolguyinus2004

10+ years of experiance in programming PHP/MYSQl. I had done much programming into development and also bug fixing all these years. You can check my profile for my reputation and ranking . I can work on this project an More

$252 USD in 5 days
(296 Reviews)
7.5
fattahaabdul

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level Please see my reviews [url removed, login to view] Ce More

$1030 USD in 3 days
(13 Reviews)
6.3
Churaliya

Hello Sir, I have good experiences in these kind of work. I can do this job for you ASAP. Please check my feedback and award me the project. Thanks.

$138 USD in 3 days
(27 Reviews)
5.6
vijaywebsol

lets start.............. PHP [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] htt More

$185 USD in 3 days
(24 Reviews)
4.9
maxpl

Hi, We can discuss price and time frame for this project. I have 5+ years of experience in webdesign/ development, Mobile Development, SEO, Data Scrapping and I have done number of projects. I can handle pro More

$480 USD in 5 days
(8 Reviews)
4.6
vandyimp

I understand the requirements. I'll work on it. Please come on chat for further discussion, so that I can start the work right away. Features: 1. 2 months post delivery tech support free of cost. 2. My code will More

$144 USD in 3 days
(8 Reviews)
4.5
anuyadav1

A proposal has not yet been provided

$155 USD in 3 days
(12 Reviews)
3.9
huitrd

we already work on its [url removed, login to view] why you chose us have 5/5 rating with 100% complete rate with here have a little company too so you can depend on us . We provide you industry standard M More

$113 USD in 6 days
(8 Reviews)
3.2
goswamiarpit475

Hi Sir, I am ready to work for you.I have 4 years of experience in php/mysql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Pleas More

$111 USD in 7 days
(7 Reviews)
2.8
i0ri

HI, listen, some people bid with 144 or 555 which is default in system and totally a fake estimate and they increase amount after you knock them lol .....Before hiring someone, check completion rate and portfolio from More

$200 USD in 4 days
(11 Reviews)
0.8