Category Archives: Software

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

(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

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

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

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

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

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

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

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

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