Category Archives: Software

How to select/display all rows with duplicate values in MySQL

Posted on December 3, 2017 by Robert

(This should be a fub, but the description is too long.) One of the most frequent uses of database tables is to identify duplicate values in your data. Assume you have a table with a list of names, and you … Continue reading →

Posted in Programming, Software | Comments Off on How to select/display all rows with duplicate values in MySQL

Zotero to Endnote: part III

Posted on September 26, 2017 by Robert

This is the latest update of a note I first posted four years ago. Below is a summary of what I’m trying to do, then the revised solution. I use both Zotero and Endnote to do bibliographies. References that I … Continue reading →

Posted in Research methods, Software | Comments Off on Zotero to Endnote: part III

Updating WordPress

Posted on April 21, 2016 by Robert

I finally got around to updating this site’s wordpress installation. The reason for the long delay was that the online updating process from wordpress was broken.  I had originally thought this was because I had used non-standard permissions in the … Continue reading →

Posted in Software | Comments Off on Updating WordPress

Fixing textwidth in vim

Posted on August 1, 2015 by Robert

I have had several problems with my program editor Vim recently.  Here is how I fixed one of them. There are two directories that I had to mess with: c:\program files\vim [vim directory] c:\users\rabbit [user directory] the vim directory is … Continue reading →

Posted in Programming, Software | Comments Off on Fixing textwidth in vim

Xmarks profiles not syncing right

Posted on June 16, 2014 by Robert

A quick note for myself and anyone else who is having headaches with this. Xmarks is a very useful bookmark synchronizing service, but I have had problems with it lately. If you are using the Firefox version of Xmarks, first … Continue reading →

Posted in Software | Comments Off on Xmarks profiles not syncing right

Zotero to Endnote: part II

Posted on November 20, 2013 by Robert

As I noted before, I use both Zotero and Endnote to do my bibliography work. For works that I have pdfs of, I keep these in a folder on D: drive. I use the same pdfs for both my Zotero … Continue reading →

Posted in Software | Comments Off on Zotero to Endnote: part II

Moving references from Zotero to Endnote: Part I

Posted on October 21, 2013 by Robert

how to export zotero references with file links, without actually copying the files as well. Continue reading →

Posted in Research methods, Software | Comments Off on Moving references from Zotero to Endnote: Part I

Push comes to shove

Posted on May 26, 2013 by Robert

Have finally thrown up my hands and begun to prepare my home desktop computer for Windows 7, and like all donkeys I’m doing it because of the carrot and the stick. The stick is the fact that our school’s computers, … Continue reading →

Posted in Software | Comments Off on Push comes to shove

Backing up and recovering Endnote libraries

Posted on December 20, 2012 by Robert

I try to back up every file that gets changed in my working directory every day or two. This is not a problem except for one program: Endnote, still my main bibliography manager. Unlike 99% of all programs, even if … Continue reading →

Posted in Research methods, Software | Comments Off on Backing up and recovering Endnote libraries