Get a new IP without router reset, VPN or connection reset

How to change ip address without proxy or vpnIn the past, there were more and more – the websites on which a specific action was allowed to run only X times a day. Today, it’s more like geo-blocking – locking out certain users based on their country of origin. However, both variants are based on the same technique: the evaluation of the IP address. In the first case, accesses from an IP address are counted (in addition to cookies) – in the second case, a database is used to evaluate where in the world the user behind a specific IP address is staying. Both locks can often be bypassed by changing the IP address.
There are several ways to change the IP address. To bypass a “count lock”, disconnecting the Internet connection […]

Update: WordPress2Doc

WordPress2Doc - ReleaseRound about 8 months ago, I release the last WordPress2Doc update. Some may have thought that the project has fallen asleep. But that is not the case.
There is always something going on/changing on the codebase (available on GitHub) and today there is also a new “real” release.
From now on WordPress2Doc is available in version In addition to a new feature, the release also includes a bugfix (that fixes a problem with images coming from blogs with SSL / https support). So let’s do it quick today …
WordPress2Doc – what is new?
The following points have changed/are new:

Feature: From now on, the document header can be formatted via the application settings. On request, the title, the author, date of the article as well as tags and categories can be displayed.
Bugfix: For blogs running on TLS / SSL / https, […]

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

Change Logitech FN-key behaviour without software

Change standard FN-key behaviourToday there is once again a short tip – this time for all owners of Logitech keyboards with a FN-key. Some time ago I was looking for a new keyboard. Criterion: Parallel usage of several devices – usually via Bluetooth. In the end the choice fell on the Logitech K375s. Stylish design, support for up to 3 devices that can be connected via Bluetooth or Logitech Unifying receiver. Only one small problem remained: the FN key.
[aawp box=”B01N5BVUGS” template=”list”]
By pressing the FN key, the second assignment of individual keys can be activated. For example: You can control the volume by pressing the F12 key while holding down the FN key. So that’s the way I would prefer it at least. In practice, the FN key is active the […]

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