Match audio to text project

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.


[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


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


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,1.10,1.31,”Bütün”)

insert into timed_text (seq,time_from,time_thru,text_foreign) values (2,1.32,1.40,”blank”)

insert into timed_text (seq,time_from,time_thru,text_foreign) values (3,1.41,1.54,”insanlar”)

insert into timed_text (seq,time_from,time_thru,text_foreign) values (4,1.55,1.61,”blank”)

insert into timed_text (seq,time_from,time_thru,text_foreign) values (5,1.62,1.72,”rüya”)



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

Skills: Audio Services, C++ Programming, Python, Ruby on Rails

See more: transcript services, speech written, write some sql for a project, transcript audio, sql commands, mp3 to text, match, audio to text, insert txt, whitespace project, write text attached, database sqlite program, database sqlite, unix project, insert txt file database, linux insert text file, text speech project, text sql, insert text file database, speech written word, audio written text, services project bidding, audio text mp3, word text database, ruby sql

About the Employer:
( 11 reviews ) Geneve, Switzerland

Project ID: #2467244