[french]Bienvenue sur le site de Pierrekiroule Consulting ! Je partage ici avec vous mon expérience et mes découvertes en matière de Business Intelligence (BI), Document Management ou autres humeurs, découvertes et expériences. Pour me contacter, écrivez un commentaire, ou envoyez moi un email à consultant (à) pierrekiroule (point) com Vous pouvez consulter mon profil Linkedin […]
Javascript conversions
Celcius Fahrenheit conversion °C = °F Kilograms Pounds conversion Kg = Lb Km/h Noeuds (knots) Km/h = Nds © 2017 Pierrekiroule Inc. Better and more conversions using javascript here
eDOCS document number <--> file name converter
Proof of concept using HTML5, Javascript and CSS. ! Javascript is not enabled. Convert an eDOCS document number to file name eDOCS Document Number: Version Number: Extension (2 to 4 characters): File name (enhanced, “!”): File name (UNIX, “_”): Type or paste a file name: More advanced converter here
Fast switching users in Content Server demo site
In Content Server, some settings are applied at a user level by the administrator. For instance, the access controls on the content, or the ability to create more or less type of objects in the system. In order to quickly test or demonstrate this, it is convenient to switch from one user (with administrative rights) […]
Recursive queries with hierarchical result using SQL Server
Recursive queries are not commonly used, yet they are very useful to display hierarchical data stored in flat tables. Unlike the “Connect by” statement in Oracle, SQL Server doesn’t provide an easy answer to build them. Here is a way to solve this with SQL Server, found after a bit of reading. Lets use a flat […]
Excel macro n00b
I just got tired and lazy while formating a report in Excel. Instead of manually clean the same rows more than 1100 times, I thought I’d better use my time creating a macro to automate the process… All I wanted to do was to cut and paste a cell, and delete 3 rows, then repeat: […]
Creating cascading attributes with Open Text Content Server
“Categories and Attributes” in Open Text Content server is a nice way to add customized metadata to your content stored in the system. If you want to have “cascading” attributes, for instance “Country >> City”, where you will only display the list of cities within the selected country, you need to use some look-up tables […]