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 […]

It is possible to trap errors in the loading process. This is handy when we work on a migration project. We simply load a table and trap all possible errors. […]

Oracle has a use that may act as an example user with a series of tables. This example can be used to get acquainted with oracle SQL or data modelling […]