OK1RR DX & Contesting Page

Ham Radio web site dedicated to CW DX operating and contesting
QSL manager database utility

QSL managers database utility

This little utility for Linux (written by Petr, OK2CQR) is an easy to operate tool for maintenance of a database of QSL managers. It provides csv import, conversion to uppercase, sorting, dupe check and cleaning. There is also possible to add, edit or delete any record manually. This version works with Ubuntu 12.04 and utilizes the Firebird database. All files are included, no installation needed – just unpack into any folder and go.

QSL manager database utility

The format is simple CSV (semicolon separated) text in order:

DX_call;Manager_call;Date (YYYY-MM)

example:

TX5CW;ZL3CW;2012-06

6V7S;RK4FF;2012-06

ZQ3M;ZB3M;2012-06

AU50GOA;VU2SMS;2012-06

EH8ITU;EA8ADL;2012-06

The ‘Date’ should be interpreted as “this manager is valid since…”. If a station has more than a single QSL manager, the valid QSL route is the one with the date closest to date of your QSO and BEFORE your QSO.

The dupes can be removed. As dupe is considered a record with the same DX_call and Manager_call. If a dupe is found while clicking the ‘Remove dupes’ option in the upper menu, the “oldest” record is kept, other are removed.

Download the utility here.

Leave a Reply

Your email address will not be published. Required fields are marked *.

*
*
You may use these <abbr title="HyperText Markup Language">HTML</abbr> tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

QSL manager database utility

QSL managers database utility

This little utility for Linux (written by Petr, OK2CQR) is an easy to operate tool for maintenance of a database of QSL managers. It provides csv import, conversion to uppercase, sorting, dupe check and cleaning. There is also possible to add, edit or delete any record manually. This version works with Ubuntu 12.04 and utilizes the Firebird database. All files are included, no installation needed – just unpack into any folder and go.

QSL manager database utility

The format is simple CSV (semicolon separated) text in order:

DX_call;Manager_call;Date (YYYY-MM)

example:

TX5CW;ZL3CW;2012-06

6V7S;RK4FF;2012-06

ZQ3M;ZB3M;2012-06

AU50GOA;VU2SMS;2012-06

EH8ITU;EA8ADL;2012-06

The ‘Date’ should be interpreted as “this manager is valid since…”. If a station has more than a single QSL manager, the valid QSL route is the one with the date closest to date of your QSO and BEFORE your QSO.

The dupes can be removed. As dupe is considered a record with the same DX_call and Manager_call. If a dupe is found while clicking the ‘Remove dupes’ option in the upper menu, the “oldest” record is kept, other are removed.

Download the utility here.