[Vtigercrm-developers] Outlook Plugin Problem with activity synchronisation
nicolas GASNIER
nicolas.gasnier at holdisgroup.fr
Wed Dec 12 07:49:10 PST 2012
Hi,
I finally got a descent testing environment for .net apps and made some tests using the latest source code on the tracker.
I figured out the following :
- The problem seems to appears on some outlook 2010, but not on all, only on windows 7 64 bits I think.
- 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...
- 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.
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 ?
The file to modify is Utils.cs and replace the filter format in the following two functions :
public string getFilterCondition(DateTime lastSyncTime)
{
//return "[LastModificationTime] > '" + lastSyncTime.ToLocalTime().ToString("MM/dd/yyyy hh:mm tt") + "'";
return "[LastModificationTime] > '" + lastSyncTime.ToLocalTime().ToString("yyyy/MM/dd hh:mm") + "'";
}
public string getFilterCondition(DateTime lastSyncTime,string module)
{
//string filter = "[LastModificationTime] > '" + lastSyncTime.ToLocalTime().ToString("MM/dd/yyyy hh:mm tt") + "'";
string filter = "[LastModificationTime] > '" + lastSyncTime.ToLocalTime().ToString("yyyy/MM/dd hh:mm") + "'";
Thank you for any advice.
Regards
Nicolas GASNIER
Développeur
HOLDIS AGRIDIS
1 rue des MORELLES
ZA Euro Val de Loire
41330 FOSSE
Tél : 02 54 81 48 44
De : vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] De la part de nicolas GASNIER
Envoyé : lundi 26 novembre 2012 16:46
À : vtigercrm-developers at lists.vtigercrm.com
Objet : Re: [Vtigercrm-developers] Outlook Plugin Problem with activity synchronisation
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...
The problem is user or computer related because it work for me but not for some users.
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.
(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)
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 :
return "[LastModificationTime] > " + "'" + lastSyncTime.ToString("yyyy-MM-dd HH:mm") + "'";
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.
What do you think ? No one has experienced this problem ?
Any advice would be appreciated.
Regards
Nicolas GASNIER
Développeur
HOLDIS AGRIDIS
1 rue des MORELLES
ZA Euro Val de Loire
41330 FOSSE
Tél : 02 54 81 48 44
De : vtigercrm-developers-bounces at lists.vtigercrm.com<mailto:vtigercrm-developers-bounces at lists.vtigercrm.com> [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] De la part de nicolas GASNIER
Envoyé : mardi 20 novembre 2012 15:15
À : vtigercrm-developers at lists.vtigercrm.com<mailto:vtigercrm-developers at lists.vtigercrm.com>
Objet : [Vtigercrm-developers] Outlook Plugin Problem with activity synchronisation
Hi there,
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.
Tested with Vtiger 5.4.0, Outlook 2007 & 2010.
I cleared my synchronization cache in the config dialog box & restarded outlook before testing.
Has anyone had this trouble with the outlook plugin 2.3 synchronizing activities ?
I prefer to ask before filling a bug report...
Regards
Nicolas GASNIER
Développeur
HOLDIS AGRIDIS
1 rue des MORELLES
ZA Euro Val de Loire
41330 FOSSE
Tél : 02 54 81 48 44
________________________________
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é.
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.
________________________________
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é.
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.
________________________________
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é.
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20121212/e6d3e21e/attachment-0001.html
More information about the vtigercrm-developers
mailing list