Solved

mobile app for entering contact info using spech recognition

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

777 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