Technical Solution
| 1
min read
Youtube does not allow audio files to be uploaded. However, you can easily convert any audio file into a video file using the given audio file and a fixed image as a background. The following works on Ubuntu and any variants of GNU/Linux.
For converting a single mp3 file you can use the following.
ffmpeg -v quiet -i "picture.jpg" -i input.mp3 -shortest -acodec copy output.mp4; done
For converting a batch of files in a folder you can use the following
Technical Solution
| 2
min read
If you are looking to move your website from an http protocol to https protocol then you don't necessarily have to go for a paid SSL certificate. You could use the certificate provided by Let's Encrypt, which is a valid certifying authority. Here is a high level outline of what you should do to set up https on your webserver. We have documented how you should do it for nginx but a similar approach should work for other webservers as well.
Technical SolutionPivot Table
| 4
min read
Pivot Table / Data Pilot is a powerful feature in spreadsheet applications that allows you to prepare reports from lists of data very easily. This will allow you to speed up preparation of reports that you have to generate as part of project management. Although the example I have created and the instructions I have listed out is specific to the timesheets from Redmine the concept can be applied for any lists of data. Once you get the hang of it you wouldn't want to prepare reports any other way. If there are questions please ask somebody around you who knows this well. We have at least one person each in each of our offices who knows this well.