anoop.john
MD & CTO
Anoop started Zyxware Technologies in 2006. He is passionate about technology and about using technology for the betterment of the society. Anoop completed his MS from Penn State University.
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
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.
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.