/// <summary> /// Matches outlook and google note by a) google id b) properties. /// </summary> /// <param name="sync">Syncronizer instance</param> /// <returns>Returns a list of match pairs (outlook note + google note) for all note. Those that weren't matche will have it's peer set to null</returns> public static List <NoteMatch> MatchNotes(Syncronizer sync) { Logger.Log("Matching Outlook and Google notes...", EventType.Information); var result = new List <NoteMatch>(); //string duplicateGoogleMatches = ""; //string duplicateOutlookNotes = ""; //sync.GoogleNoteDuplicates = new Collection<NoteMatch>(); //sync.OutlookNoteDuplicates = new Collection<NoteMatch>(); //for each outlook note try to get google note id from user properties //if no match - try to match by properties //if no match - create a new match pair without google note. //foreach (Outlook._NoteItem olc in outlookNotes) var outlookNotesWithoutOutlookGoogleId = new Collection <Outlook.NoteItem>(); #region Match first all outlookNotes by sync id for (int i = 1; i <= sync.OutlookNotes.Count; i++) { Outlook.NoteItem oln; try { oln = sync.OutlookNotes[i] as Outlook.NoteItem; if (oln == null || string.IsNullOrEmpty(oln.Subject)) { Logger.Log("Empty Outlook note found. Skipping", EventType.Warning); sync.SkippedCount++; sync.SkippedCountNotMatches++; continue; } } catch (Exception ex) { //this is needed because some notes throw exceptions Logger.Log("Accessing Outlook note threw and exception. Skipping: " + ex.Message, EventType.Warning); sync.SkippedCount++; sync.SkippedCountNotMatches++; continue; } //try //{ if (NotificationReceived != null) { NotificationReceived(String.Format("Matching note {0} of {1} by id: {2} ...", i, sync.OutlookNotes.Count, oln.Subject)); } // Create our own info object to go into collections/lists, so we can free the Outlook objects and not run out of resources / exceed policy limits. //OutlookNoteInfo olci = new OutlookNoteInfo(oln, sync); //try to match this note to one of google notes Outlook.ItemProperties userProperties = oln.ItemProperties; Outlook.ItemProperty idProp = userProperties[sync.OutlookPropertyNameId]; try { if (idProp != null) { string googleNoteId = string.Copy((string)idProp.Value); Document foundNote = sync.GetGoogleNoteById(googleNoteId); var match = new NoteMatch(oln, null); //Check first, that this is not a duplicate //e.g. by copying an existing Outlook note //or by Outlook checked this as duplicate, but the user selected "Add new" // Collection<OutlookNoteInfo> duplicates = sync.OutlookNoteByProperty(sync.OutlookPropertyNameId, googleNoteId); // if (duplicates.Count > 1) // { // foreach (OutlookNoteInfo duplicate in duplicates) // { // if (!string.IsNullOrEmpty(googleNoteId)) // { // Logger.Log("Duplicate Outlook note found, resetting match and try to match again: " + duplicate.FileAs, EventType.Warning); // idProp.Value = ""; // } // } // if (foundNote != null && !foundNote.Deleted) // { // NotePropertiesUtils.ResetGoogleOutlookNoteId(sync.SyncProfile, foundNote); // } // outlookNotesWithoutOutlookGoogleId.Add(olci); // } // else // { if (foundNote != null) { //we found a match by google id, that is not deleted yet match.AddGoogleNote(foundNote); result.Add(match); //Remove the note from the list to not sync it twice sync.GoogleNotes.Remove(foundNote); } else { ////If no match found, is the note either deleted on Google side or was a copy on Outlook side ////If it is a copy on Outlook side, the idProp.Value must be emptied to assure, the note is created on Google side and not deleted on Outlook side ////bool matchIsDuplicate = false; //foreach (NoteMatch existingMatch in result) //{ // if (existingMatch.OutlookNote.UserProperties[sync.OutlookPropertyNameId].Value.Equals(idProp.Value)) // { // //matchIsDuplicate = true; // idProp.Value = ""; // break; // } //} outlookNotesWithoutOutlookGoogleId.Add(oln); //if (!matchIsDuplicate) // result.Add(match); } // } } else { outlookNotesWithoutOutlookGoogleId.Add(oln); } } finally { if (idProp != null) { Marshal.ReleaseComObject(idProp); } Marshal.ReleaseComObject(userProperties); } //} //finally //{ // Marshal.ReleaseComObject(oln); // oln = null; //} } #endregion #region Match the remaining notes by properties for (int i = 0; i < outlookNotesWithoutOutlookGoogleId.Count; i++) { Outlook.NoteItem oln = outlookNotesWithoutOutlookGoogleId[i]; if (NotificationReceived != null) { NotificationReceived(String.Format("Matching note {0} of {1} by unique properties: {2} ...", i + 1, outlookNotesWithoutOutlookGoogleId.Count, oln.Subject)); } //no match found by id => match by subject/title //create a default match pair with just outlook note. var match = new NoteMatch(oln, null); //foreach google contact try to match and create a match pair if found some match(es) for (int j = sync.GoogleNotes.Count - 1; j >= 0; j--) { Document entry = sync.GoogleNotes[j]; string body = NotePropertiesUtils.GetBody(sync, entry); if (!string.IsNullOrEmpty(body)) { body = body.Replace("\r\n", string.Empty).Replace(" ", string.Empty).Replace("�", string.Empty); } string outlookBody = null; if (!string.IsNullOrEmpty(oln.Body)) { outlookBody = oln.Body.Replace("\t", " ").Replace("\r\n", string.Empty).Replace(" ", string.Empty).Replace("�", string.Empty); } // only match if there is a note body, else // a matching google note will be created at each sync if (!string.IsNullOrEmpty(outlookBody) && !string.IsNullOrEmpty(body) && outlookBody.Equals(body, StringComparison.InvariantCultureIgnoreCase) ) { match.AddGoogleNote(entry); sync.GoogleNotes.Remove(entry); } } #region find duplicates not needed now //if (match.GoogleNote == null && match.OutlookNote != null) //{//If GoogleNote, we have to expect a conflict because of Google insert of duplicates // foreach (Note entry in sync.GoogleNotes) // { // if (!string.IsNullOrEmpty(olc.FullName) && olc.FullName.Equals(entry.Title, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olc.FileAs) && olc.FileAs.Equals(entry.Title, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olc.Email1Address) && FindEmail(olc.Email1Address, entry.Emails) != null || // !string.IsNullOrEmpty(olc.Email2Address) && FindEmail(olc.Email1Address, entry.Emails) != null || // !string.IsNullOrEmpty(olc.Email3Address) && FindEmail(olc.Email1Address, entry.Emails) != null || // olc.MobileTelephoneNumber != null && FindPhone(olc.MobileTelephoneNumber, entry.Phonenumbers) != null // ) // } //// check for each email 1,2 and 3 if a duplicate exists with same email, because Google doesn't like inserting new notes with same email //Collection<Outlook.NoteItem> duplicates1 = new Collection<Outlook.NoteItem>(); //Collection<Outlook.NoteItem> duplicates2 = new Collection<Outlook.NoteItem>(); //Collection<Outlook.NoteItem> duplicates3 = new Collection<Outlook.NoteItem>(); //if (!string.IsNullOrEmpty(olc.Email1Address)) // duplicates1 = sync.OutlookNoteByEmail(olc.Email1Address); //if (!string.IsNullOrEmpty(olc.Email2Address)) // duplicates2 = sync.OutlookNoteByEmail(olc.Email2Address); //if (!string.IsNullOrEmpty(olc.Email3Address)) // duplicates3 = sync.OutlookNoteByEmail(olc.Email3Address); //if (duplicates1.Count > 1 || duplicates2.Count > 1 || duplicates3.Count > 1) //{ // if (string.IsNullOrEmpty(duplicatesEmailList)) // duplicatesEmailList = "Outlook notes with the same email have been found and cannot be synchronized. Please delete duplicates of:"; // if (duplicates1.Count > 1) // foreach (Outlook.NoteItem duplicate in duplicates1) // { // string str = olc.FileAs + " (" + olc.Email1Address + ")"; // if (!duplicatesEmailList.Contains(str)) // duplicatesEmailList += Environment.NewLine + str; // } // if (duplicates2.Count > 1) // foreach (Outlook.NoteItem duplicate in duplicates2) // { // string str = olc.FileAs + " (" + olc.Email2Address + ")"; // if (!duplicatesEmailList.Contains(str)) // duplicatesEmailList += Environment.NewLine + str; // } // if (duplicates3.Count > 1) // foreach (Outlook.NoteItem duplicate in duplicates3) // { // string str = olc.FileAs + " (" + olc.Email3Address + ")"; // if (!duplicatesEmailList.Contains(str)) // duplicatesEmailList += Environment.NewLine + str; // } // continue; //} //else if (!string.IsNullOrEmpty(olc.Email1Address)) //{ // NoteMatch dup = result.Find(delegate(NoteMatch match) // { // return match.OutlookNote != null && match.OutlookNote.Email1Address == olc.Email1Address; // }); // if (dup != null) // { // Logger.Log(string.Format("Duplicate note found by Email1Address ({0}). Skipping", olc.FileAs), EventType.Information); // continue; // } //} //// check for unique mobile phone, because this sync tool uses the also the mobile phone to identify matches between Google and Outlook //Collection<Outlook.NoteItem> duplicatesMobile = new Collection<Outlook.NoteItem>(); //if (!string.IsNullOrEmpty(olc.MobileTelephoneNumber)) // duplicatesMobile = sync.OutlookNoteByProperty("MobileTelephoneNumber", olc.MobileTelephoneNumber); //if (duplicatesMobile.Count > 1) //{ // if (string.IsNullOrEmpty(duplicatesMobileList)) // duplicatesMobileList = "Outlook notes with the same mobile phone have been found and cannot be synchronized. Please delete duplicates of:"; // foreach (Outlook.NoteItem duplicate in duplicatesMobile) // { // sync.OutlookNoteDuplicates.Add(olc); // string str = olc.FileAs + " (" + olc.MobileTelephoneNumber + ")"; // if (!duplicatesMobileList.Contains(str)) // duplicatesMobileList += Environment.NewLine + str; // } // continue; //} //else if (!string.IsNullOrEmpty(olc.MobileTelephoneNumber)) //{ // NoteMatch dup = result.Find(delegate(NoteMatch match) // { // return match.OutlookNote != null && match.OutlookNote.MobileTelephoneNumber == olc.MobileTelephoneNumber; // }); // if (dup != null) // { // Logger.Log(string.Format("Duplicate note found by MobileTelephoneNumber ({0}). Skipping", olc.FileAs), EventType.Information); // continue; // } //} #endregion // if (match.AllGoogleNoteMatches == null || match.AllGoogleNoteMatches.Count == 0) // { // //Check, if this Outlook note has a match in the google duplicates // bool duplicateFound = false; // foreach (NoteMatch duplicate in sync.GoogleNoteDuplicates) // { // if (duplicate.AllGoogleNoteMatches.Count > 0 && // (!string.IsNullOrEmpty(olci.FileAs) && !string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Title) && olci.FileAs.Equals(duplicate.AllGoogleNoteMatches[0].Title.Replace("\r\n", "\n").Replace("\n", "\r\n"), StringComparison.InvariantCultureIgnoreCase) || //Replace twice to not replace a \r\n by \r\r\n. This is necessary because \r\n are saved as \n only to google // !string.IsNullOrEmpty(olci.FileAs) && !string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Name.FullName) && olci.FileAs.Equals(duplicate.AllGoogleNoteMatches[0].Name.FullName.Replace("\r\n", "\n").Replace("\n", "\r\n"), StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.FullName) && !string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Name.FullName) && olci.FullName.Equals(duplicate.AllGoogleNoteMatches[0].Name.FullName.Replace("\r\n", "\n").Replace("\n", "\r\n"), StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.Email1Address) && duplicate.AllGoogleNoteMatches[0].Emails.Count > 0 && olci.Email1Address.Equals(duplicate.AllGoogleNoteMatches[0].Emails[0].Address, StringComparison.InvariantCultureIgnoreCase) || // //!string.IsNullOrEmpty(olci.Email2Address) && FindEmail(olci.Email2Address, duplicate.AllGoogleNoteMatches[0].Emails) != null || // //!string.IsNullOrEmpty(olci.Email3Address) && FindEmail(olci.Email3Address, duplicate.AllGoogleNoteMatches[0].Emails) != null || // olci.MobileTelephoneNumber != null && FindPhone(olci.MobileTelephoneNumber, duplicate.AllGoogleNoteMatches[0].Phonenumbers) != null || // !string.IsNullOrEmpty(olci.FileAs) && string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Title) && duplicate.AllGoogleNoteMatches[0].Organizations.Count > 0 && olci.FileAs.Equals(duplicate.AllGoogleNoteMatches[0].Organizations[0].Name, StringComparison.InvariantCultureIgnoreCase) // ) || // !string.IsNullOrEmpty(olci.FileAs) && olci.FileAs.Equals(duplicate.OutlookNote.Subject, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.FullName) && olci.FullName.Equals(duplicate.OutlookNote.FullName, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.Email1Address) && olci.Email1Address.Equals(duplicate.OutlookNote.Email1Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email1Address.Equals(duplicate.OutlookNote.Email2Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email1Address.Equals(duplicate.OutlookNote.Email3Address, StringComparison.InvariantCultureIgnoreCase) // // ) || // //!string.IsNullOrEmpty(olci.Email2Address) && (olci.Email2Address.Equals(duplicate.OutlookNote.Email1Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email2Address.Equals(duplicate.OutlookNote.Email2Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email2Address.Equals(duplicate.OutlookNote.Email3Address, StringComparison.InvariantCultureIgnoreCase) // // ) || // //!string.IsNullOrEmpty(olci.Email3Address) && (olci.Email3Address.Equals(duplicate.OutlookNote.Email1Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email3Address.Equals(duplicate.OutlookNote.Email2Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email3Address.Equals(duplicate.OutlookNote.Email3Address, StringComparison.InvariantCultureIgnoreCase) // // ) || // olci.MobileTelephoneNumber != null && olci.MobileTelephoneNumber.Equals(duplicate.OutlookNote.MobileTelephoneNumber) || // !string.IsNullOrEmpty(olci.FileAs) && string.IsNullOrEmpty(duplicate.GoogleNote.Title) && duplicate.GoogleNote.Organizations.Count > 0 && olci.FileAs.Equals(duplicate.GoogleNote.Organizations[0].Name, StringComparison.InvariantCultureIgnoreCase) // ) // { // duplicateFound = true; // sync.OutlookNoteDuplicates.Add(match); // if (string.IsNullOrEmpty(duplicateOutlookNotes)) // duplicateOutlookNotes = "Outlook note found that has been already identified as duplicate Google note (either same email, Mobile or FullName) and cannot be synchronized. Please delete or resolve duplicates of:"; // string str = olci.FileAs + " (" + olci.Email1Address + ", " + olci.MobileTelephoneNumber + ")"; // if (!duplicateOutlookNotes.Contains(str)) // duplicateOutlookNotes += Environment.NewLine + str; // } // } // if (!duplicateFound) if (match.GoogleNote == null) { Logger.Log(string.Format("No match found for outlook note ({0}) => {1}", match.OutlookNote.Subject, (NotePropertiesUtils.GetOutlookGoogleNoteId(sync, match.OutlookNote) != null ? "Delete from Outlook" : "Add to Google")), EventType.Information); } // } // else // { // //Remember Google duplicates to later react to it when resetting matches or syncing // //ResetMatches: Also reset the duplicates // //Sync: Skip duplicates (don't sync duplicates to be fail safe) // if (match.AllGoogleNoteMatches.Count > 1) // { // sync.GoogleNoteDuplicates.Add(match); // foreach (Note entry in match.AllGoogleNoteMatches) // { // //Create message for duplicatesFound exception // if (string.IsNullOrEmpty(duplicateGoogleMatches)) // duplicateGoogleMatches = "Outlook notes matching with multiple Google notes have been found (either same email, Mobile, FullName or company) and cannot be synchronized. Please delete or resolve duplicates of:"; // string str = olci.FileAs + " (" + olci.Email1Address + ", " + olci.MobileTelephoneNumber + ")"; // if (!duplicateGoogleMatches.Contains(str)) // duplicateGoogleMatches += Environment.NewLine + str; // } // } // } result.Add(match); } #endregion //if (!string.IsNullOrEmpty(duplicateGoogleMatches) || !string.IsNullOrEmpty(duplicateOutlookNotes)) // duplicatesFound = new DuplicateDataException(duplicateGoogleMatches + Environment.NewLine + Environment.NewLine + duplicateOutlookNotes); //else // duplicatesFound = null; //return result; //for each google note that's left (they will be nonmatched) create a new match pair without outlook note. for (int i = 0; i < sync.GoogleNotes.Count; i++) { Document entry = sync.GoogleNotes[i]; if (NotificationReceived != null) { NotificationReceived(String.Format("Adding new Google note {0} of {1} by unique properties: {2} ...", i + 1, sync.GoogleNotes.Count, entry.Title)); } //string googleOutlookId = NotePropertiesUtils.GetGoogleOutlookNoteId(sync.SyncProfile, entry); //if (!String.IsNullOrEmpty(googleOutlookId) && skippedOutlookIds.Contains(googleOutlookId)) //{ // Logger.Log("Skipped GoogleNote because Outlook note couldn't be matched beacause of previous problem (see log): " + entry.Title, EventType.Warning); //} //else if (string.IsNullOrEmpty(entry.Title) && string.IsNullOrEmpty(entry.Content)) { // no title or content sync.SkippedCount++; sync.SkippedCountNotMatches++; Logger.Log("Skipped GoogleNote because no unique property found (Title or Content):" + entry.Title, EventType.Warning); } else { Logger.Log(string.Format("No match found for google note ({0}) => {1}", entry.Title, (NotePropertiesUtils.NoteFileExists(entry.Id, sync.SyncProfile) ? "Delete from Google" : "Add to Outlook")), EventType.Information); var match = new NoteMatch(null, entry); result.Add(match); } } return(result); }
/// <summary> /// Matches outlook and google note by a) google id b) properties. /// </summary> /// <param name="sync">Syncronizer instance</param> /// <returns>Returns a list of match pairs (outlook note + google note) for all note. Those that weren't matche will have it's peer set to null</returns> public static List<NoteMatch> MatchNotes(Synchronizer sync) { Logger.Log("Matching Outlook and Google notes...", EventType.Information); var result = new List<NoteMatch>(); //string duplicateGoogleMatches = ""; //string duplicateOutlookNotes = ""; //sync.GoogleNoteDuplicates = new Collection<NoteMatch>(); //sync.OutlookNoteDuplicates = new Collection<NoteMatch>(); //for each outlook note try to get google note id from user properties //if no match - try to match by properties //if no match - create a new match pair without google note. //foreach (Outlook._NoteItem olc in outlookNotes) var outlookNotesWithoutOutlookGoogleId = new Collection<Outlook.NoteItem>(); #region Match first all outlookNotes by sync id for (int i = 1; i <= sync.OutlookNotes.Count; i++) { Outlook.NoteItem oln; try { oln = sync.OutlookNotes[i] as Outlook.NoteItem; if (oln == null || string.IsNullOrEmpty(oln.Body)) { Logger.Log("Empty Outlook note found. Skipping", EventType.Warning); sync.SkippedCount++; sync.SkippedCountNotMatches++; continue; } } catch (Exception ex) { //this is needed because some notes throw exceptions Logger.Log("Accessing Outlook note threw and exception. Skipping: " + ex.Message, EventType.Warning); sync.SkippedCount++; sync.SkippedCountNotMatches++; continue; } //try //{ if (NotificationReceived != null) NotificationReceived(String.Format("Matching note {0} of {1} by id: {2} ...", i, sync.OutlookNotes.Count, oln.Subject)); // Create our own info object to go into collections/lists, so we can free the Outlook objects and not run out of resources / exceed policy limits. //OutlookNoteInfo olci = new OutlookNoteInfo(oln, sync); //try to match this note to one of google notes Outlook.ItemProperties userProperties = oln.ItemProperties; Outlook.ItemProperty idProp = userProperties[sync.OutlookPropertyNameId]; try { if (idProp != null) { string googleNoteId = string.Copy((string)idProp.Value); Document foundNote = sync.GetGoogleNoteById(googleNoteId); var match = new NoteMatch(oln, null); //Check first, that this is not a duplicate //e.g. by copying an existing Outlook note //or by Outlook checked this as duplicate, but the user selected "Add new" // Collection<OutlookNoteInfo> duplicates = sync.OutlookNoteByProperty(sync.OutlookPropertyNameId, googleNoteId); // if (duplicates.Count > 1) // { // foreach (OutlookNoteInfo duplicate in duplicates) // { // if (!string.IsNullOrEmpty(googleNoteId)) // { // Logger.Log("Duplicate Outlook note found, resetting match and try to match again: " + duplicate.FileAs, EventType.Warning); // idProp.Value = ""; // } // } // if (foundNote != null && !foundNote.Deleted) // { // NotePropertiesUtils.ResetGoogleOutlookNoteId(sync.SyncProfile, foundNote); // } // outlookNotesWithoutOutlookGoogleId.Add(olci); // } // else // { if (foundNote != null) { //we found a match by google id, that is not deleted yet match.AddGoogleNote(foundNote); result.Add(match); //Remove the note from the list to not sync it twice sync.GoogleNotes.Remove(foundNote); } else { ////If no match found, is the note either deleted on Google side or was a copy on Outlook side ////If it is a copy on Outlook side, the idProp.Value must be emptied to assure, the note is created on Google side and not deleted on Outlook side ////bool matchIsDuplicate = false; //foreach (NoteMatch existingMatch in result) //{ // if (existingMatch.OutlookNote.UserProperties[sync.OutlookPropertyNameId].Value.Equals(idProp.Value)) // { // //matchIsDuplicate = true; // idProp.Value = ""; // break; // } //} outlookNotesWithoutOutlookGoogleId.Add(oln); //if (!matchIsDuplicate) // result.Add(match); } // } } else outlookNotesWithoutOutlookGoogleId.Add(oln); } finally { if (idProp != null) Marshal.ReleaseComObject(idProp); Marshal.ReleaseComObject(userProperties); } //} //finally //{ // Marshal.ReleaseComObject(oln); // oln = null; //} } #endregion #region Match the remaining notes by properties for (int i = 0; i < outlookNotesWithoutOutlookGoogleId.Count; i++) { Outlook.NoteItem oln = outlookNotesWithoutOutlookGoogleId[i]; if (NotificationReceived != null) NotificationReceived(String.Format("Matching note {0} of {1} by unique properties: {2} ...", i + 1, outlookNotesWithoutOutlookGoogleId.Count, oln.Subject)); //no match found by id => match by subject/title //create a default match pair with just outlook note. var match = new NoteMatch(oln, null); //foreach google contact try to match and create a match pair if found some match(es) for (int j = sync.GoogleNotes.Count - 1; j >= 0; j--) { Document entry = sync.GoogleNotes[j]; string body = NotePropertiesUtils.GetBody(sync, entry); if (!string.IsNullOrEmpty(body)) body = body.Replace("\r\n", string.Empty).Replace(" ", string.Empty).Replace("�", string.Empty); string outlookBody = null; if (!string.IsNullOrEmpty(oln.Body)) outlookBody = oln.Body.Replace("\t", " ").Replace("\r\n", string.Empty).Replace(" ", string.Empty).Replace("�", string.Empty); // only match if there is a note body, else // a matching google note will be created at each sync if (!string.IsNullOrEmpty(outlookBody) && !string.IsNullOrEmpty(body) && outlookBody.Equals(body, StringComparison.InvariantCultureIgnoreCase) ) { match.AddGoogleNote(entry); sync.GoogleNotes.Remove(entry); } } #region find duplicates not needed now //if (match.GoogleNote == null && match.OutlookNote != null) //{//If GoogleNote, we have to expect a conflict because of Google insert of duplicates // foreach (Note entry in sync.GoogleNotes) // { // if (!string.IsNullOrEmpty(olc.FullName) && olc.FullName.Equals(entry.Title, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olc.FileAs) && olc.FileAs.Equals(entry.Title, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olc.Email1Address) && FindEmail(olc.Email1Address, entry.Emails) != null || // !string.IsNullOrEmpty(olc.Email2Address) && FindEmail(olc.Email1Address, entry.Emails) != null || // !string.IsNullOrEmpty(olc.Email3Address) && FindEmail(olc.Email1Address, entry.Emails) != null || // olc.MobileTelephoneNumber != null && FindPhone(olc.MobileTelephoneNumber, entry.Phonenumbers) != null // ) // } //// check for each email 1,2 and 3 if a duplicate exists with same email, because Google doesn't like inserting new notes with same email //Collection<Outlook.NoteItem> duplicates1 = new Collection<Outlook.NoteItem>(); //Collection<Outlook.NoteItem> duplicates2 = new Collection<Outlook.NoteItem>(); //Collection<Outlook.NoteItem> duplicates3 = new Collection<Outlook.NoteItem>(); //if (!string.IsNullOrEmpty(olc.Email1Address)) // duplicates1 = sync.OutlookNoteByEmail(olc.Email1Address); //if (!string.IsNullOrEmpty(olc.Email2Address)) // duplicates2 = sync.OutlookNoteByEmail(olc.Email2Address); //if (!string.IsNullOrEmpty(olc.Email3Address)) // duplicates3 = sync.OutlookNoteByEmail(olc.Email3Address); //if (duplicates1.Count > 1 || duplicates2.Count > 1 || duplicates3.Count > 1) //{ // if (string.IsNullOrEmpty(duplicatesEmailList)) // duplicatesEmailList = "Outlook notes with the same email have been found and cannot be synchronized. Please delete duplicates of:"; // if (duplicates1.Count > 1) // foreach (Outlook.NoteItem duplicate in duplicates1) // { // string str = olc.FileAs + " (" + olc.Email1Address + ")"; // if (!duplicatesEmailList.Contains(str)) // duplicatesEmailList += Environment.NewLine + str; // } // if (duplicates2.Count > 1) // foreach (Outlook.NoteItem duplicate in duplicates2) // { // string str = olc.FileAs + " (" + olc.Email2Address + ")"; // if (!duplicatesEmailList.Contains(str)) // duplicatesEmailList += Environment.NewLine + str; // } // if (duplicates3.Count > 1) // foreach (Outlook.NoteItem duplicate in duplicates3) // { // string str = olc.FileAs + " (" + olc.Email3Address + ")"; // if (!duplicatesEmailList.Contains(str)) // duplicatesEmailList += Environment.NewLine + str; // } // continue; //} //else if (!string.IsNullOrEmpty(olc.Email1Address)) //{ // NoteMatch dup = result.Find(delegate(NoteMatch match) // { // return match.OutlookNote != null && match.OutlookNote.Email1Address == olc.Email1Address; // }); // if (dup != null) // { // Logger.Log(string.Format("Duplicate note found by Email1Address ({0}). Skipping", olc.FileAs), EventType.Information); // continue; // } //} //// check for unique mobile phone, because this sync tool uses the also the mobile phone to identify matches between Google and Outlook //Collection<Outlook.NoteItem> duplicatesMobile = new Collection<Outlook.NoteItem>(); //if (!string.IsNullOrEmpty(olc.MobileTelephoneNumber)) // duplicatesMobile = sync.OutlookNoteByProperty("MobileTelephoneNumber", olc.MobileTelephoneNumber); //if (duplicatesMobile.Count > 1) //{ // if (string.IsNullOrEmpty(duplicatesMobileList)) // duplicatesMobileList = "Outlook notes with the same mobile phone have been found and cannot be synchronized. Please delete duplicates of:"; // foreach (Outlook.NoteItem duplicate in duplicatesMobile) // { // sync.OutlookNoteDuplicates.Add(olc); // string str = olc.FileAs + " (" + olc.MobileTelephoneNumber + ")"; // if (!duplicatesMobileList.Contains(str)) // duplicatesMobileList += Environment.NewLine + str; // } // continue; //} //else if (!string.IsNullOrEmpty(olc.MobileTelephoneNumber)) //{ // NoteMatch dup = result.Find(delegate(NoteMatch match) // { // return match.OutlookNote != null && match.OutlookNote.MobileTelephoneNumber == olc.MobileTelephoneNumber; // }); // if (dup != null) // { // Logger.Log(string.Format("Duplicate note found by MobileTelephoneNumber ({0}). Skipping", olc.FileAs), EventType.Information); // continue; // } //} #endregion // if (match.AllGoogleNoteMatches == null || match.AllGoogleNoteMatches.Count == 0) // { // //Check, if this Outlook note has a match in the google duplicates // bool duplicateFound = false; // foreach (NoteMatch duplicate in sync.GoogleNoteDuplicates) // { // if (duplicate.AllGoogleNoteMatches.Count > 0 && // (!string.IsNullOrEmpty(olci.FileAs) && !string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Title) && olci.FileAs.Equals(duplicate.AllGoogleNoteMatches[0].Title.Replace("\r\n", "\n").Replace("\n", "\r\n"), StringComparison.InvariantCultureIgnoreCase) || //Replace twice to not replace a \r\n by \r\r\n. This is necessary because \r\n are saved as \n only to Google // !string.IsNullOrEmpty(olci.FileAs) && !string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Name.FullName) && olci.FileAs.Equals(duplicate.AllGoogleNoteMatches[0].Name.FullName.Replace("\r\n", "\n").Replace("\n", "\r\n"), StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.FullName) && !string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Name.FullName) && olci.FullName.Equals(duplicate.AllGoogleNoteMatches[0].Name.FullName.Replace("\r\n", "\n").Replace("\n", "\r\n"), StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.Email1Address) && duplicate.AllGoogleNoteMatches[0].Emails.Count > 0 && olci.Email1Address.Equals(duplicate.AllGoogleNoteMatches[0].Emails[0].Address, StringComparison.InvariantCultureIgnoreCase) || // //!string.IsNullOrEmpty(olci.Email2Address) && FindEmail(olci.Email2Address, duplicate.AllGoogleNoteMatches[0].Emails) != null || // //!string.IsNullOrEmpty(olci.Email3Address) && FindEmail(olci.Email3Address, duplicate.AllGoogleNoteMatches[0].Emails) != null || // olci.MobileTelephoneNumber != null && FindPhone(olci.MobileTelephoneNumber, duplicate.AllGoogleNoteMatches[0].Phonenumbers) != null || // !string.IsNullOrEmpty(olci.FileAs) && string.IsNullOrEmpty(duplicate.AllGoogleNoteMatches[0].Title) && duplicate.AllGoogleNoteMatches[0].Organizations.Count > 0 && olci.FileAs.Equals(duplicate.AllGoogleNoteMatches[0].Organizations[0].Name, StringComparison.InvariantCultureIgnoreCase) // ) || // !string.IsNullOrEmpty(olci.FileAs) && olci.FileAs.Equals(duplicate.OutlookNote.Subject, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.FullName) && olci.FullName.Equals(duplicate.OutlookNote.FullName, StringComparison.InvariantCultureIgnoreCase) || // !string.IsNullOrEmpty(olci.Email1Address) && olci.Email1Address.Equals(duplicate.OutlookNote.Email1Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email1Address.Equals(duplicate.OutlookNote.Email2Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email1Address.Equals(duplicate.OutlookNote.Email3Address, StringComparison.InvariantCultureIgnoreCase) // // ) || // //!string.IsNullOrEmpty(olci.Email2Address) && (olci.Email2Address.Equals(duplicate.OutlookNote.Email1Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email2Address.Equals(duplicate.OutlookNote.Email2Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email2Address.Equals(duplicate.OutlookNote.Email3Address, StringComparison.InvariantCultureIgnoreCase) // // ) || // //!string.IsNullOrEmpty(olci.Email3Address) && (olci.Email3Address.Equals(duplicate.OutlookNote.Email1Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email3Address.Equals(duplicate.OutlookNote.Email2Address, StringComparison.InvariantCultureIgnoreCase) || // // olci.Email3Address.Equals(duplicate.OutlookNote.Email3Address, StringComparison.InvariantCultureIgnoreCase) // // ) || // olci.MobileTelephoneNumber != null && olci.MobileTelephoneNumber.Equals(duplicate.OutlookNote.MobileTelephoneNumber) || // !string.IsNullOrEmpty(olci.FileAs) && string.IsNullOrEmpty(duplicate.GoogleNote.Title) && duplicate.GoogleNote.Organizations.Count > 0 && olci.FileAs.Equals(duplicate.GoogleNote.Organizations[0].Name, StringComparison.InvariantCultureIgnoreCase) // ) // { // duplicateFound = true; // sync.OutlookNoteDuplicates.Add(match); // if (string.IsNullOrEmpty(duplicateOutlookNotes)) // duplicateOutlookNotes = "Outlook note found that has been already identified as duplicate Google note (either same email, Mobile or FullName) and cannot be synchronized. Please delete or resolve duplicates of:"; // string str = olci.FileAs + " (" + olci.Email1Address + ", " + olci.MobileTelephoneNumber + ")"; // if (!duplicateOutlookNotes.Contains(str)) // duplicateOutlookNotes += Environment.NewLine + str; // } // } // if (!duplicateFound) if (match.GoogleNote == null) Logger.Log(string.Format("No match found for outlook note ({0}) => {1}", match.OutlookNote.Subject, (NotePropertiesUtils.GetOutlookGoogleNoteId(sync, match.OutlookNote) != null ? "Delete from Outlook" : "Add to Google")), EventType.Information); // } // else // { // //Remember Google duplicates to later react to it when resetting matches or syncing // //ResetMatches: Also reset the duplicates // //Sync: Skip duplicates (don't sync duplicates to be fail safe) // if (match.AllGoogleNoteMatches.Count > 1) // { // sync.GoogleNoteDuplicates.Add(match); // foreach (Note entry in match.AllGoogleNoteMatches) // { // //Create message for duplicatesFound exception // if (string.IsNullOrEmpty(duplicateGoogleMatches)) // duplicateGoogleMatches = "Outlook notes matching with multiple Google notes have been found (either same email, Mobile, FullName or company) and cannot be synchronized. Please delete or resolve duplicates of:"; // string str = olci.FileAs + " (" + olci.Email1Address + ", " + olci.MobileTelephoneNumber + ")"; // if (!duplicateGoogleMatches.Contains(str)) // duplicateGoogleMatches += Environment.NewLine + str; // } // } // } result.Add(match); } #endregion //if (!string.IsNullOrEmpty(duplicateGoogleMatches) || !string.IsNullOrEmpty(duplicateOutlookNotes)) // duplicatesFound = new DuplicateDataException(duplicateGoogleMatches + Environment.NewLine + Environment.NewLine + duplicateOutlookNotes); //else // duplicatesFound = null; //return result; //for each google note that's left (they will be nonmatched) create a new match pair without outlook note. for (int i = 0; i < sync.GoogleNotes.Count; i++) { Document entry = sync.GoogleNotes[i]; if (NotificationReceived != null) NotificationReceived(String.Format("Adding new Google note {0} of {1} by unique properties: {2} ...", i + 1, sync.GoogleNotes.Count, entry.Title)); //string googleOutlookId = NotePropertiesUtils.GetGoogleOutlookNoteId(sync.SyncProfile, entry); //if (!String.IsNullOrEmpty(googleOutlookId) && skippedOutlookIds.Contains(googleOutlookId)) //{ // Logger.Log("Skipped GoogleNote because Outlook note couldn't be matched because of previous problem (see log): " + entry.Title, EventType.Warning); //} //else if (string.IsNullOrEmpty(entry.Title) && string.IsNullOrEmpty(entry.Content)) { // no title or content sync.SkippedCount++; sync.SkippedCountNotMatches++; Logger.Log("Skipped GoogleNote because no unique property found (Title or Content):" + entry.Title, EventType.Warning); } else { Logger.Log(string.Format("No match found for Google note ({0}) => {1}", entry.Title, (NotePropertiesUtils.NoteFileExists(entry.Id, sync.SyncProfile) ? "Delete from Google" : "Add to Outlook")), EventType.Information); var match = new NoteMatch(null, entry); result.Add(match); } } return result; }