Solved

mobile app for entering contact info using spech recognition

Posted on 2014-03-24
2
264 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 39957091
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
ID: 40083713
thanks for all your help. very good ideas to consider
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

697 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