Author: Maurice Ruckman

Posted on

Two finger trackpad control

Refer: http://askubuntu.com/questions/186895/how-to-enable-two-finger-scrolling-on-lenovo-thinkpad-t400-w540

It can be enabled also using commands, and they can go in your .bashrc after testing

xinput --set-prop --type=int --format=32 "SynPS/2 Synaptics TouchPad" "Synaptics Two-Finger Pressure" 4
xinput --set-prop --type=int --format=32 "SynPS/2 Synaptics TouchPad" "Synaptics Two-Finger Width" 8
xinput --set-prop --type=int --format=8  "SynPS/2 Synaptics TouchPad" "Synaptics Two-Finger Scrolling" 1 0

Posted on

Create clickable icon in Ubuntu like SQL Developer – Desktop

Refer: http://askubuntu.com/questions/142159/desktop-shortcut-to-create-a-new-desktop-shortcut-doesnt-do-anything

Use the following to create an icon to launch program, put it with your progam and you can then drag it onto the taskbar, but remember it's a link to the launcher

To create Desktop shortcuts in Ubuntu,gnome-panel package is required first.

Open Terminal. To open terminal click the Dash home from Unity launcher. And type terminal in the search field. And click Terminal.

Type the below code in terminal and hit enter.

$ sudo apt-get install --no-install-recommends gnome-panel

Then type below code in terminal and hit enter, but put yourself in the the folder of the application, this allows the icon image to always appear properly

The magic is making sure your BASH script has proper permissions and is executable.

Make a Bash Script Executable, use chmod to do the trick as follows:
$ chmod u+x script-name.sh

Use this:
$ gnome-desktop-item-edit . --create-new

Instead of this
$ gnome-desktop-item-edit ~/Desktop/ --create-new

Updated: https://superuser.com/questions/552959/quickly-create-an-entry-in-the-side-bar-launcher
$ gnome-desktop-item-edit --create-new ~/.local/share/applications

Make sure you delete old items from here for cleanup:
/home/mruckman/.local/share/applications

The create launcher window will pop-up,Type application name in the name field and type application name or path or browse in the command field. And click OK button.

Now check your desktop for the shortcut.

desktop shortcut

If you want your shortcut to appear in the Unity launcher panel (the pop-out one on the left), you can drag it there from the desktop.

Posted on

Oracle Query Using Like

Different databases have different ways of concatenating strings. In Oracle or Postgres, try this:

SELECT SUM(K.Score)
FROM Wreck_it_Ralph WIR, Keyword k
WHERE t_text LIKE '%' || k.word || '%'

Posted on

Convert MP4 to MP3 on Ubuntu 14.04 Trusty and Tag Meta Data Software

There is a program available on Ubuntu youtube-dl, that can download videos from youtube.com or other video platforms. But it stores the file in mp4, since it contains video. But sometimes you do not want the video and only the audio. To extract only the audio part, you can use the pacpl comamnd line tool.

Use "Sound Converter" Application for simple conversion

Usage:

$ youtube-dl -f mp4 --output "yourfilename.%(ext)s" https://youtu.be/your-link-here
$ youtube-dl --extract-audio --audio-format mp3 --audio-quality 256 --output "yourfilename.%(ext)s" https://youtu.be/your-link-here

Older Method:

pacpl --to mp3 -v -r -bitrate 256 targetfile.mp4

Ubuntu Software: EasyTAG to modify MP3 MetaData

Update MP3 tags with the command line:

$ sudo apt-get install id3v2

Some useful commands

List all of the tags or specific for a particular file without wild card
$ id3v2 -l *.mp3

Example of how to update title, album, year
$ id3v2 -t "My Title" file-to-update.mp3
$ id3v2 -a "My Album"
$ id3v2 -y 2016

Posted on

Export Quicktime MOV for Snagit Recorded Session

The issue with recoding Snagit sessions, is it puts the audio on two tracks and when uploading it to YouTube, the audio disappears.  Use VLC to see how the audio would play.  Using QuickTime to convert the video.  iMove does the same thing too, but it takes lots of resources as it imports media into it's library.

Steps to Process with QuickTime 7

  • Open Movie with Quicktime, and you are going to export the MP4 movies as a Quicktime MOV file instead.  Other formats seem to lose quite  a bit of quality
  • Audio Channels: Mono
  • Compression Typ: H.264 with Best quality (Multi-pass)

2015-12-20_10-55-17_1

2015-12-20_10-55-17_4

2015-12-20_10-55-17_2

2015-12-20_10-55-17_3

Steps to Process with iMovie

  • Combine and export audio traces of MP4 Snagit Movie with Audacity
  • Open media for both movie and audio, edit movie clip and drop audio
  • Add audio track and export the entire movie
  • Delete all off the media files and empty trash
Posted on

Fixing VirtualBox Clipboard

# Take a current snapshot

# Start appliance and open a terminal
$ sudo apt-get update
$ sudo apt-get install build-essential

# Reinstall the Guest Editions
Devices, "Insert Guest Editions CD Image..."
Run, Enter your credentials, and let it install
Reboot your Appliance

# See if it works, and if it does
Shutdown, delete snapshot and take new snapshot