Solved

mobile app for entering contact info using spech recognition

Posted on 2014-03-24
2
249 Views
Last Modified: 2014-05-22
We have a CRM database where Salespeople have to type in history regarding customer meetings and phone calls. I am looking to create a mobile app with a simple form. Select the contact's name or search for contacts name. Then enter the history text (paragraph)
This would be entered using voice recognition similar to voice to text message. Then user would submit to save it to our database. The database back-end is SQL server 2008.
Should work on iPad, iPhone and android. Is this possible if so whats the easiest method to get this done. I may want to add a button to attach a file.

select contact __________
Enter history __________________
Attach file (button)
0
Comment
Question by:paul_techy
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
You could use Google for Android
https://play.google.com/store/apps/details?id=com.nll.asr


and Apple iSpeech for IOS
https://www.ispeech.org/developers/iphone

to generate the recording that will be stored in the database on the same row with all the rest of your "history text (paragraph)" and other details into a SQL Database table.

I suggest use varchar(max) for history (or Nvarchar if you use UNICODE chars) and varbinary(max) for your voice recording files.

"Storing Images and BLOB files in SQL Server Part "
http://www.databasejournal.com/features/mssql/article.php/3724556/Storing-Images-and-BLOB-files-in-SQL-Server-Part-2.htm


You could also store the voice recorded files somewhere on the file system and save just the path into a varchar table column.

OR...use even new FILESTREAM feature in SQL 2008 but please consider its caveats if you enable it.
0
 

Author Closing Comment

by:paul_techy
Comment Utility
thanks for all your help. very good ideas to consider
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now