Posted in Uncategorized | Leave a comment

Sync Photos or Files over wifi Between Android and Linux with rsync and curlftpfs

I’ve had mixed success with transferring files between by Android phone and my Linux computer. I’ve come to prefer using rsync for any file transfer; I grant that copying will often work, but the ease of double-checking that the transfer happened as planned, or of restarting it in the event of a failed transfer is worth a tiny bit of command line work for me. I’m assuming that you know how to install packages and know how to get a terminal.

Install an ftp server on your phone. I use File Manager HD. In File Manager HD, tap on ‘Tools’ at the top. Under File Transfer, click on ‘Transfer to PC.,’ than click ‘Start.’

Install rsync and curlftpfs on your computer.

Create a directory (“Phone” in this example; remember that Linux commands are case-sensitive.) on your computer and mount the phone storage there (Enter the IP address of your phone, displayed in File Manager HD.):

mkdir Phone
curlftps Phone/

Browse and drill down to your desired folder using cd, ls, etc. Don’t forget to tab for auto-complete and double-tab to see what your options are.

cd Phone

Use rsync to perform the sync. I use the -av options. See rsync manpage to help you. If you’re not familiar with rsync, make sure you understand the implications of omitting a trailing forward slash:

rsync -av /Phone/storage_0000-0000/DCIM/Camera/ ~/Pictures/2017-10-12/

After the transfer is finished, here’s the fun: up-arrow reruns the sync, and you can confirm with confidence the success of the transfer. There’s something strangely gratifying about seeing a ridiculously high speed-up (meaning the amount of time you saved over a straight re-copy):

sent 3,311 bytes received 12 bytes 2,215.33 bytes/sec
total size is 3,904,488,112 speedup is 1,174,988.90

Make sure to unmount the ftp directory before you quit:

fusermount -u Phone/


Posted in Uncategorized | Leave a comment

Mail Attachment Downloader on Linux

I’ve been looking for a way to download all attachments from gmail. I tried the Attachment Extractor for Thunderbird, but it apparently isn’t being maintained, and kept throwing error messages. I then found Mail Attachment Downloader for Windows. As of v. 3.1, this needs .NET 4.5 or higher. I naturally checked the AppDB at WineHQ and found a good how-to by scrolling down.

The key to successfully installing the .NET framework is to use Winetricks. However, to make this work on a 64-bit machine, you need to set up a 32-bit Wine environment, called a Wine prefix. Since I had some apps installed on the original 64-bit environment, I needed to set up a separate 32-bit environment. So if you need this, in a terminal window (adjusting your path appropriately):

$ WINEARCH=win32 WINEPREFIX=/home/akn/.wine32 winecfg

Then get Winetricks:

­$ wget

…and use it to install the framework and a core fonts package.

$ WINEARCH=win32 WINEPREFIX=/home/akn/.wine32 bash winetricks dotnet452 corefonts

Note: the installer will ask if you want to install the .NET framework. I initially hit ‘cancel,’ figuring that Winetricks would work its own magic. But I discovered that indeed this is the mechanism for installing the framework, so make sure you let the installer also install the .NET framework.

An important note here is that Wine must use the correct Wine prefix (It needs to be 32-bit.). Hence, the WINEARCH and WINEPREFIX variables on each command.

Now cd to the directory where you’ve downloaded the goal of this endeavor, and execute the following:

WINEPREFIX=/home/akn/.wine32 wine MailAttachmentDownloaderInstall.exe

I’m assuming that you will need to specify the WINEPREFIX each time, so I will set up a new shortcut for this eventually.

I’m testing this on a Linux Mint 17.1, 64-bit machine.

Posted in Uncategorized | Leave a comment

Automatically add suffixes to ordinal numbers in OpenOffice or LibreOffice

A number of responses on the Oo.o/LO forums regarding the question of adding ordinal notation to dates have said that the only way to add the suffixes st, nd, rd, and th to dates is with macros.  I searched for the same question in the Excel [ahem] arena and quickly came up with a solution:

CHOOSE(1*RIGHT(DAY(A1),1),"st","nd ","rd "),"th ")
&TEXT(A1,"mmmm, yyyy")

If you cut/paste, make sure to remove the carriage returns.  This ingenious bit of magic gives the date in this format: “30th June, 2001”.  Note that in the original post (at, there is a space missing after “th”; I have corrected that in my copying of his formula.

I needed a slightly different form to enter via a mail merge field into an official-sounding certificate: “30th day of June, 2001”.  After some trial and error, here is my solution:

=DAY($A$2)&IF(OR(DAY($A$2)={1,2,3,21,22,23,31}),CHOOSE(1*RIGHT(DAY($A$2),1),”st day “,”nd day “,”rd day “),”th day “)&TEXT($A$2,”of mmmm, yyyy”)

Obviously, adjust the cell reference to meet your needs.  In case you’re curious, trying to put ‘day’ into the final TEXT argument didn’t work because Calc read the ‘d’ as a date format, giving me “30th 30ay of June, 2001″.


Posted in Uncategorized | Tagged , , , | 1 Comment

Direct Cursor (aka, Shadow Cursor, Click-and-type) in Libre/OpenOffice

I have cluttered this post with verbosity in the hope that it will snag searches and save someone the frustration I have just experienced: trying to find a feature in LibreOffice or OpenOffice for which I don’t even have a name.  How can you search for it if you don’t know what it’s called?

The feature is one that I knew WordPerfect had, but I have used WP so rarely that I couldn’t remember what it was called.  I tried search terms like ‘insert text at mouse pointer,’ ‘move cursor to mouse pointer,’  ‘WordPerfect features LibreOffice,’ insert text blank page,’ insert text anywhere in document,’ and ‘insert text at cursor’ (well, duh…but I was desperate).  The search term that finally got me there–at the last hit on the second page (Who goes to the second page?!) was, ‘OpenOffice move cursor to mouse pointer position.’

So, for the few out there in my shoes: the feature that you are looking for is called Direct Cursor, and it can be found at Tools|Options| Writer|Formatting Aids. Check the Direct Cursor box, and enjoy.

This really is a useful feature, and one that I encourage you to try if you are unfamiliar with it.  I don’t think it will get in the way for me even when I don’t need it, and for the project I am currently working on (merging two handbooks, and needing to align/compare sections side by side in columns), it really is a grief-saver.

Thanks to Sunshine Coast Computer Club for the tip. Check this post for more details.

Posted in word processing | Tagged , , , , , , , | Leave a comment

Linux Mint 13 MATE, Synapse Launcher, and Missing MATE Applications

When I first started with Mint 13 MATE, I dug around for a launcher (e.g. Synapse, Launchy, Kupfer) to support my keyboard-driven approach to productivity.  I settled on Synapse, and have been generally satisfied with it.  But I’ve never been able to launch the MATE applications like Monitors, Screenshot, and Disk Usage Analyzer.  I’ve finally found a tiny Github Gist script that scratches this itch.

Copy this block of text into a new text file using your favorite text editor (You may need to adjust the tabs or delete whitespaces at the beginning of the lines.):


for file in $(grep -il "^OnlyShowIn=MATE;$" /usr/share/applications/*.desktop); do
  echo "patching $file"
  sed -e "s/OnlyShowIn=MATE;/#OnlyShowIn=MATE;/ig" $file > /tmp/tempfile.tmp
  mv -f /tmp/tempfile.tmp $file

Save the file with whatever name you wish; I called it

Make the script executable; one of the ways is:

 chmod 744

Run the script as sudo:

 sudo ./

Restart Synapse and enjoy!

Posted in Uncategorized | Leave a comment

Linux 13 MATE, XMonad and Marco

Well over a year ago, I decided to give Mint MATE a try, and have been quite pleased with the performance.  When I try a new version/distro, I usually mess around with eye-candy for a bit, then the novelty wears off, and I go back to my utilitarian bent, and trim down for performance.  I’m hooked on XMonad, so, since I’ve never delved deeply into Haskell or XMonad under the hood, how nicely the distro plays with XMonad out of the box is close to a deal-breaker.

Mint 13 MATE passes the test with flying colors.  I imported my xmonad.xs from my previous install on Ubuntu/Gnome 2, and everything just worked.  The only issue I had was very high CPU usage–high enough to make my SATA-modded ThinkPad T43 run very hot.

After a little digging, I came onto this how-to about changing window managers in MATE.  The relevant parts for this are:

  1. In a terminal, type
    mateconf-editor &
  2. In the configuration editor tree go to /desktop/mate/session/required_components/windowmanager and replace “marco” with “xmonad”

For more help, and a slightly different approach to changing the window manager, go here.

Posted in Uncategorized | Leave a comment