03Apr
Show missing Joomla redirects in admin menu
The menu item "Redirections" is missing in the menu "Components" in the backend, although the plugin is activated. Solution of the problem in this article.
IT & Technology
24Mar
Validated USB power supply adapter for Ubiquiti Unifi Cloud Key Gen 2 Plus
Anyone unpacking the Unifi Cloud Key Gen 2 Plus for the first time will notice that the device does not come with a power cable or power adapter and cannot be used with all USB chargers. I'll show you which power supplies and cables really work.
20Mar
Creating SQL Statements with Excel (Quick and Dirty)
Sometimes, you have to import predefined data supplied as a list, such as personnel numbers, into a database and at the same time provide it with additional (default) values. Creating each statement manually would be very time-consuming, especially for large amounts of data. The function "concatenate" in Excel helps a lot.
20Mar
Import contents of a CSV file into an existing table via SQL (Bulk Operation)
Script to import data from a CSV file into an existing MS-SQL table via bulk operation. Creation of a temporary table, import, transfer to productive table. The assignment of the data to the correct keys takes place via an inner join.
20Mar
Remote support via TeamViewer without active Windows login ends in “this screen cannot be captured at the moment This is due to to fast user switching or a disconnected/minimized remote desktop session”
If you want to access your server with installed TeamViewer Host via TeamViewer with full access rights, you might know the following problem: The user only expects a black screen and the message "this screen cannot be captured at the moment. This is due to to fast user switching or a disconnected/minimized remote desktop session". You might think the solution to this problem is in the TeamViewer settings. Most of the time far from it. The solution is to distinguish between the server ID and the user ID of the running TeamViewer.
20Mar
Activate HRFORMS after Patch (if no authorization exists, activate by report)
If you want to start HRFORMS in payroll accounting after a patch or release upgrade, you may experience the following error as soon as you call up the print output of the remuneration statement.
Runtime error OBJECTS_OBJREF_NOT_ASSIGNED
Exception CX_SY_REF_IS_INITIAL
