UpdateSelectFields(data, data, data, data, data, data, data, strEmailSenderEmailId) This method prevents overwriting past data with empty fields
How to use onenote ocr update#
If it does, update and overwrite selected data. SqlConnection connection = new Source=.\SQLEXPRESS AttachDbFilename=C:\Users\Prashanth\Desktop\CAPSTONE JPMORGAN\OutlookAddIn1\OutlookContacts.mdf Integrated Security=True User Instance=True") Ĭommand.CommandText = "select * from New_Contacts where Email_ID = '" + strEmailSenderEmailId + "'" Ĭommand.CommandText = "insert into New_Contacts VALUES('" + data + "', '" + data + "', '" + data + "', '" + data + "', '" + data + "', '" + data + "', '" + data + "', '" + data + "', '" + data + "', '" + strEmailSenderEmailId + "', '" + data + "')" String strEmailSenderEmailId = Convert.ToString(item.SenderEmailAddress) SkipTextReader = true //Bool variable if email has image signatureĭata = parseImageSignature(signature) //Parse signature block If (((signature.ToLower()).Contains(".png") || (signature.ToLower()).Contains(".gif") || (signature.ToLower()).Contains(".jpg")) & signature.Length < 20)
String signature = extractSignature().Replace(" ", " ") //Extract signature block If (skipTextReader = false) //If no image signature, parse email bodyįile.AppendAllText(mydocpath + sb.ToString()) Return // If no email body, exit function. SkipTextReader = true //Skip parsing email body if email has image signatureĭata = parseOCRSignature(bodyText) // Parse body into fieldsĮlse //If no attachment, extract email body Image imageToParse = + ) īodyText = bodyText.Replace(" ", " ") bodyText = bodyText.Replace(" ", " ") īodyText = bodyText.Replace(",", "") bodyText = bodyText.Replace("|", "") If (ReadImageFromEmail(item) = 1) // If email has an attachment, read the attachment- Assuming this is E-business card String mydocpath = Environment.GetFolderPath() //Path to My Documents OnenoteOcrEngine ocr = new OnenoteOcrEngine() SkipTextReader = false // Reinitialize variable back to false