How to use »find« on macOS to get files NOT containing a specific filename extension

In our case we have had a couple of videos we created and some of them were accidentially saved without a filename extension. Most files has been saved with the

*.mov

*.mp4

extensions. To get all files that have been saved without any extension we used the find-command in terminal to get all the names. The command was

find . -type f -not -name "*.mov" -not -name "*.mp4"

The parameter »-type f« searched for files only and the negeation »-not -name« excluded all files with a specific extension. We needed to exclude only two types of filename extensions so the command is pretty simple.

After that we wanted to rename all those files to add the filename extension »*.mp4«. We used the command

find . -type f -not -name "*.mov" -not name "*.mp4" -exec mv {} ./{}.mp4 \;

With the parameter -exec we executed the mv (move) command for each file. The first brace »{}« takes the filename that the command returns and the second one »./{}.mp4« moves the file with the existing filename and adds the extension ».mp4«. The backslash escapes the semicolon which ends the command. If you forget to escape the semicolon the command would not be executed because the commands expects additional commands or parameters. So don't forget to escape the semicolon.

I Hope that helps!

Use Visual Studio Code to edit LibreOffice Macros

During the development of macros in LibreOffice it is very useful to use an IDE like Microsoft Visual Studio Code to be able to use all the features of the environment.But unfortunately the use of external editors in LibreOffice needs some additional help

The first step to reach this target is to install the APSO-Extension. This Extension gives you the ability to configure an external editor for your python macros and a shell to the python installed with LO.

Just download the extension from the website (apso.oxt) to your pc or mac. Then open LibreOffice and install the extension (screenshot is MacOs):

Use the «Add» button and choose the extsion from the destination folder of your download.

Update Nextcloud 11 to Version 12

There are some circumstances that makes an update from Nextcloud 11 to Nextcloud 12 more complicated than it was before. In our case we are and were not able to execute the necessary shell commands because php-cli is not implemented by our provider. We also tried to update it using a fresh side-by-side installation, copy the config files to the new installation and choose the updater from the webbrowser. This procedure worked in all prior releases like a charm.

The new release brings a lot benfits. One very important one: Installed Apps in Nextcloud will not be lost, they will be updated during the upgrade process. This benefit brought some difficulties to us. We were not able update our sandbox and qa environment because the update of the apps needed a too large amount of time. The process ran into a timeout and broke the entire installation.

The solution for this issue is to deactivate all installed apps, run the side-by-side installation of Nextcloud 12 (including copy of the config files) and manually activate the apps after the upgrade was successful (which it was). This process was pretty easy: After the successful update all apps could be easily reactivated (and updated in place) in the Apps menu which needed just twenty minutes. There was only one app that could not be reactivated because it was not compatible with version 12.