Closed

Match audio to text project

This project received 3 bids from talented freelancers with an average bid price of $ USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
3
Project Description

Match audio to text project

Attached to this project is an audio file, and a text file which is the transcript of the audio file. Results to be written as SQL statements. Schema information for SQLite attached.

Attachments
[url removed, login to view] – text transcript of the audio file
[url removed, login to view] – audio file
[url removed, login to view] – schema build commands for sql db


Requirement
Language: Ruby
Code will match transcript to audio, and write out a sql statement for each word
Each word will be separated by whitespace in the transcript and no speech in the audio file.
Start and finish time to 1/100th of a second will be recorded for each word. The word will be inserted into the text_foreign field, and the start and finish times recorded in the time_from and time_thru fields.
Blanks spaces between words are inserted as “blank” in the text_foreign field with timings captured.
Program should log the sql insert statements to a text file only.
Seq is an integer, incremented for each insert

Deliverables
Preference is to be coded in Ruby.
Bids for other languages will be considered so long as the code can run on unix/linux.
Database schema build SQL or attached sqlite db file
Code should be fully documented


Example Log Output (times are made up):

insert into timed_text (seq,time_from,time_thru,text_foreign) values (1,[url removed, login to view],[url removed, login to view],”Bütün”)
insert into timed_text (seq,time_from,time_thru,text_foreign) values (2,[url removed, login to view],[url removed, login to view],”blank”)
insert into timed_text (seq,time_from,time_thru,text_foreign) values (3,[url removed, login to view],[url removed, login to view],”insanlar”)
insert into timed_text (seq,time_from,time_thru,text_foreign) values (4,[url removed, login to view],[url removed, login to view],”blank”)
insert into timed_text (seq,time_from,time_thru,text_foreign) values (5,[url removed, login to view],[url removed, login to view],”rüya”)
etc.

Bidding
Please submit some code that demonstrates you have the relevant skills. Bids without code submission won't be considered.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online