<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1036078954;
mso-list-type:hybrid;
mso-list-template-ids:-1269138800 655366902 67895299 67895301 67895297 67895299 67895301 67895297 67895299 67895301;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I finally got a descent testing environment for .net apps and made some tests using the latest source code on the tracker.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I figured out the following :<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="color:#1F497D"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="color:#1F497D">The problem seems to appears on some outlook 2010, but not on all, only on windows 7 64 bits I think.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="color:#1F497D"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="color:#1F497D">The problem is due, as I suspected, to the date format passed to the restrict function. For whatever reason, on some versions or sessions, the format outlook expects is not the same as
the one defined in the regional settings of the windows user. These date issues are unfortunately not well documented and I don’t have a lot experience with that kind of development…<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span lang="EN-US" style="color:#1F497D"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN-US" style="color:#1F497D">If I use the date format yyyy/MM/dd HH:mm, I don’t have sync problem on different outlook anymore. It seems that this format is commonly accepted.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Can someone please make some tests to confirm that this solution is working everywhere (below is the code to modify) ? Vicas, you have maybe a clue on this ?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">The file to modify is Utils.cs and replace the filter format in the following two functions :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas;color:blue"> public</span><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:blue">string</span> getFilterCondition(<span style="color:#2B91AF">DateTime</span> lastSyncTime)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"> {<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:green">//return "[LastModificationTime] > '" + lastSyncTime.ToLocalTime().ToString("MM/dd/yyyy hh:mm tt") + "'";</span><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:blue">return</span> <span style="color:#A31515">"[LastModificationTime] > '"</span> + lastSyncTime.ToLocalTime().ToString(<span style="color:#A31515">"yyyy/MM/dd hh:mm"</span>) +
<span style="color:#A31515">"'"</span>;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"> }<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:blue">public</span> <span style="color:blue">string</span> getFilterCondition(<span style="color:#2B91AF">DateTime</span> lastSyncTime,<span style="color:blue">string</span> module)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"> {<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:green">//string filter = "[LastModificationTime] > '" + lastSyncTime.ToLocalTime().ToString("MM/dd/yyyy hh:mm tt") + "'";</span><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:blue">string</span> filter = <span style="color:#A31515">"[LastModificationTime] > '"</span> + lastSyncTime.ToLocalTime().ToString(<span style="color:#A31515">"yyyy/MM/dd hh:mm"</span>) +
<span style="color:#A31515">"'"</span>;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Thank you for any advice.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Nicolas GASNIER<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Développeur<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">HOLDIS AGRIDIS<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">1 rue des MORELLES<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ZA Euro Val de Loire<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">41330 FOSSE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Tél : 02 54 81 48 44<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> vtigercrm-developers-bounces@lists.vtigercrm.com [mailto:vtigercrm-developers-bounces@lists.vtigercrm.com]
<b>De la part de</b> nicolas GASNIER<br>
<b>Envoyé :</b> lundi 26 novembre 2012 16:46<br>
<b>À :</b> vtigercrm-developers@lists.vtigercrm.com<br>
<b>Objet :</b> Re: [Vtigercrm-developers] Outlook Plugin Problem with activity synchronisation<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Sorry, I may look like talking to myself with that problem, and you developers are probably busy with the migration to 6.0, but it is really an annoying problem and I don’t find any logical answer.
I hope you can at least points me to any advice…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">The problem is user or computer related because it work for me but not for some users.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I first thought of something related to the timezone but I’ve cross checked all the settings and still the newly created appointements in outlook are not selected for creation in vTiger.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">(user timezone : Europe/Brussels, system timezone Europe/Paris Brussels Madrid, config.inc.php’s default timezone : UTC, plugin cleaned, reinstalled, database cleared and outlook restarted)
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I tried to dig in the plugin source code but it is an old 2.1.( is there a more up to date repository in trac.vtiger.com ?) For me, the main reason that the events doesn’t appears is something with
the outlook restrict() function. It uses a filter to select the appointments after the last sync time, with the condition in the following line :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas;color:blue">return</span><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas">
<span style="color:#A31515">"[LastModificationTime] > "</span> + <span style="color:#A31515">
"'"</span> + lastSyncTime.ToString(<span style="color:#A31515">"yyyy-MM-dd HH:mm"</span>) +
<span style="color:#A31515">"'"</span>;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:9.5pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="color:#1F497D">I’m not sure (can’t compile dot net code…) but there is something with the last sync time. The restrict() function requires a date formatted as string, but I’m wondering
how it is interpreted, because I’ve seen various examples with various exotic date format. Does this function requires the format to be the same as the windows user’s regional settings ? If this is the case then it may make sense that it doesn’t work, despite
the fact that I tried to change the regional settings for a test.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="color:#1F497D">What do you think ? No one has experienced this problem ?<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="color:#1F497D">Any advice would be appreciated.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Nicolas GASNIER<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Développeur<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">HOLDIS AGRIDIS<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">1 rue des MORELLES<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ZA Euro Val de Loire<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">41330 FOSSE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Tél : 02 54 81 48 44<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com">vtigercrm-developers-bounces@lists.vtigercrm.com</a> [<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com">mailto:vtigercrm-developers-bounces@lists.vtigercrm.com</a>]
<b>De la part de</b> nicolas GASNIER<br>
<b>Envoyé :</b> mardi 20 novembre 2012 15:15<br>
<b>À :</b> <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
<b>Objet :</b> [Vtigercrm-developers] Outlook Plugin Problem with activity synchronisation<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi there,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">When I create activity in the vtiger side, it is imported in outlook, but when I create it in Outlook calendar, it doesn’t create in vTiger. It does never appears in the synchronization dialog box.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Tested with Vtiger 5.4.0, Outlook 2007 & 2010.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I cleared my synchronization cache in the config dialog box & restarded outlook before testing.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Has anyone had this trouble with the outlook plugin 2.3 synchronizing activities ?
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I prefer to ask before filling a bug report…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Nicolas GASNIER<o:p></o:p></span></p>
<p class="MsoNormal">Développeur<o:p></o:p></p>
<p class="MsoNormal">HOLDIS AGRIDIS<o:p></o:p></p>
<p class="MsoNormal">1 rue des MORELLES<o:p></o:p></p>
<p class="MsoNormal">ZA Euro Val de Loire<o:p></o:p></p>
<p class="MsoNormal">41330 FOSSE<o:p></o:p></p>
<p class="MsoNormal">Tél : 02 54 81 48 44<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p> </o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:navy">Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le détruire et d'en avertir immédiatement l'expéditeur. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet
ne permettant pas d'assurer l'intégrité de ce message, notre société décline par ailleurs toute responsabilité dans l’hypothèse où il aurait été modifié.<br>
<br>
This message and any attached files (the "message") are intended solely for the addressees and are confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except if there is formal approval. The Internet cannot guarantee the integrity of this message, our company shall not therefore be liable for the message if modified.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p> </o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:navy">Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le détruire et d'en avertir immédiatement l'expéditeur. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet
ne permettant pas d'assurer l'intégrité de ce message, notre société décline par ailleurs toute responsabilité dans l’hypothèse où il aurait été modifié.<br>
<br>
This message and any attached files (the "message") are intended solely for the addressees and are confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except if there is formal approval. The Internet cannot guarantee the integrity of this message, our company shall not therefore be liable for the message if modified.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p></o:p></span></p>
</div>
<br>
<hr>
<font face="Arial" color="Navy" size="1">Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le détruire et d'en avertir
immédiatement l'expéditeur. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'intégrité de ce message,
notre société décline par ailleurs toute responsabilité dans l’hypothèse où il aurait été modifié.<br>
<br>
This message and any attached files (the "message") are intended solely for the addressees and are confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination
or disclosure, either whole or partial, is prohibited except if there is formal approval. The Internet cannot guarantee the integrity of this message, our company shall not therefore be liable for the message if modified.<br>
</font>
</body>
</html>