Solved

mobile app for entering contact info using spech recognition

Posted on 2014-03-24
2
253 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

896 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

16 Experts available now in Live!

Get 1:1 Help Now