Update Node.js and NPM via commandline

How to update NodeJS and NPM via ShellToday’s article falls into the category “reminder”. Every few months I write smaller projects with Node.js. But before I start, I’d like to update to the latest version, and that’s where the dilemma starts. Every time I forget the command line commands for it.
Therefore, here are the short and concise CMD/Shell/Bash commands for updating Node.js and NPM. Once for macOS (OSX) / Linux and once for Windows.
Update NPM on Linux and macOS (OS X)

sudo npm install -g npm

Whether the update was successful can be tested with the following command.
npm -v
Update NPM on Windows
The following commands have to be set in Powershell (Start -> “powershell” -> right click -> Run as Administrator). Each line corresponds to one command.

Set-ExecutionPolicy Unrestricted -Scope CurrentUser -Force
npm install -g […]

Check Paypal account balance and transactions via C# API

How to use Paypal-API in CsharpAfter we had a look at how to sent push notifications via C# recently, there are plans for the next C# article today. This time it’s about how to read account balance, sales and transactions and other things of a Paypal account.
First some basic information. Although Paypal is an “online account”, in many ways it differs from an online (giro) account of a “classic” bank. For example, Paypal does not support the Homebanking Computer Interface (HBCI) to retrieve account information or send payments. Instead, Paypal offers different APIs (REST, SOAP, + SDKs, …), which differ not only in structure and technology, but especially in the range of functions. For our purposes we will use the so-called “NVP / SOAP API” and connect to it with […]

How to send push notifications in C#

Push-notifications-in C-SharpIn today’s article, we’ll look at how to push notifications out of C# onto smartphones or other devices. It does not matter if it is an Android or an Apple / iOS device. But when do you need such functionality?
For example, I run a few niche sites (affiliate websites) with which I earn monthly through affiliate programs. However, the revenue reports have to be picked up proactively in almost all affiliate programs. So I wrote a small C# client, which regularly downloads the reports and sends me a push notification for new sales. That’s just one of many uses and I’m sure you’ll think of a few more. But now back to the topic.
Selection of push platform
For a quick and easy integration of the push functionality in C#, we […]

Default field lengths for address fields in databases

Standard lengths for address fields in databasesToday, we will dive into some more theoretical stuff. The topic of this article will be field lengths of database fields for addresses. For every second database I create, I am faced with the same problem: How long / “big” do I actually make the database fields for addresses? So fields, such as first name, surname, street, e-mail address, etc.
So far I have oriented myself to given requirements or old databases. But now I wanted to work up the topic once for all right. So the question is: Is there actually a standard for address field lengths?
Looking for standards for address field lengths
A search for “address field lengths for databases” spits a huge amount of hits. Unfortunately there are only opinions and experiences everywhere. […]

How to generate Swiss QR Code in C# and VBA

Swiss QR Code in C-Sharp and VBAToday, we are looking into the field of business computer science. Since end of April, SIX has released the specification for the new Swiss QR Code according to ISO 20022. The Swiss QR Code is an integral part of the new Swiss deposit slip, the so-called QR invoice, which shall be implemented by all companies by mid-2018 at the latest. The Swiss QR code is placed in the so-called “number part with QR code” of the QR invoice.
In the following, we will discuss how the Swiss QR code can be generated using C # or VBA. To do this, we use the free QRCoder library, which I developed almost 4 years ago and to which recently added the Swiss QR Code. One more thing before we […]