Python has Pandas its tool to handle matrices, also known as dataframes in Pyhon speak. It is possible to join dataframes, much like joining tables. I found a nice example […]

Granting privs in SQL Server is done in three steps. As first step, one must create a login to the SQL Server. This can be seen as getting the entrance […]

SQL Server is has several possibilities to calculate elapsed time (such as age). Two approaches are possible. The first idea is to calculate the number of hours and divide this […]

Below, I provide a simple Python programme which allows to add data from an external table to Salesforce. The programme uses simple_salesforce as a library. In the first few lines, […]

Below, I provide a simple programme. The programme is written in Python. With Python, a library “salesforce_api” is used. With this library, one is able to insert records, query records […]

Recently, I discovered a nice trick to check the Email addresses. It uses a check on the setup of Email addresses. They must contain an @ symbol. They must contain […]

I wrote a Python programme to select rows that contain NULLs. Whenever a null was found, it is written to a separate file. The programme uses data frames. This allows […]

I recently added a cgi-bin programme to my website (see van-maanen.com/cgi-bin/test.py). It allows me to add functionality to the website that cannot be achieved with standard html. Most web servers […]

I worked with Salesforce in recent period. A nice feature of this application is the possibility to send requests via the http protocol. Doing so, one may add data to […]

Salesforce is a CRM application that is build upon a set of data. These data may refer to customers, but is is possible to create your own data structures. These […]