Auteur/autrice : Aymeric

Sharepoint DateRangesOverlap value

(this is a copy of a post that is not available anymore) DateRangesOverlap Value Type I don’t know if any back-end developers have run into this same issue when working with the SPQuery to pull expanded recurrence date, but from here, not all DateRangesOverlap Value types work the way they should. And they’re cryptically-documented, where […]

Interclassement MySQL pour le français

Quel interclassement (dit aussi collation) choisir pour sa base MySQL afin d’y enregistrer des caractères français (entre autres) ? L’interclassement a deux fonctions : Permettre l’ordonnancement correct d’une liste de caractères (pour indiquer que le « é » vient après le « e », ou que les majuscules viennent avant les minuscules, etc) Permettre de savoir quand un caractère […]

Content Security Policy (CSP) blocks scripts from Violentmonkey / Greasemonkey

I wanted to inject some codes on Github, however I received Content Security Policy errors. It’s because Github blocks this kind of injected code. To bypass this restriction I installed the addon Content Security Policy Override (if you have Firefox you can install this Chrome addon using Chrome Store Foxified) then I applied the below […]

Remove custom properties/metadata for an Office document [javascript]

I have this document library on Sharepoint where I have one custom column called Metadata and that is a lookup to another list on my Sharepoint. When the users download an Office document from this library and then re-upload it we could have the below error message: There is at least one lookup column that […]

Émuler Raspberry Pi sous Windows

Depuis que j’ai fait assistant-plugins, j’ai plusieurs utilisateurs qui m’ont demandé comment l’installer sur leur Raspberry. Ce système est censé être similaire à une Debian, cependant ils semblent y avoir des différences… J’ai donc cherché à émuler cet OS sous mon Windows 10. Sources : https://blogs.msdn.microsoft.com/iliast/2016/11/10/how-to-emulate-raspberry-pi/ https://enavarro.me/emuler-un-raspberry-pi-avec-qemu.html Voici les étapes : Télécharger la dernière version […]

How to delete a document locked by another user in Sharepoint using JavaScript

When you open a file from Sharepoint, it will receive a short term lock that will prevent others to change some properties on the file. This protection can be useful, but also very annoying, for example when the file is not closed properly, then the lock could stay « forever ». There are many posts on the […]

How to drag and drop a file into a dropzone in HTML5

We can find plenty of demo and tutorials about it on the web, but it took me a while to understand how to setup something easy and quick. The purpose is to have a zone where we can drop a file from our computer. You need: A zone where the file will be dropped (for […]

Overwrite the Created field for a Sharepoint list item

Sharepoint provides automatic fields, like « Created » that contains the creation date of a list item. It’s a readonly field. You could use a webservice to change the ReadOnly property in order to overwrite its value. Using SharepointPlus the code is: // don’t change the below information // the details about this field are found using […]

Classic ASP to get a remote page with NTLM authenticate

It’s very frustrating to have to work with ASP again, after so many years… I wanted to use an ASP page to get a remote page. However I needed to pass some NTLM authenticate to it. After a few searches I found this solution: <% ‘ I want this page to be accessible for Cross […]