This is a software package written by an SCA herald, for the use of SCA heralds. That said, anyone can download and use it, if they wish ... it is "freeware". Please keep in mind the phrase "You get what you pay for ..." -- in this case, I hope that you won't be disappointed, but I cannot 100% guarantee that everything will work the way you want it to, or expect it to; I cannot guarantee it is completely bug free (although lord knows, I've tried!). Note that I am interested in usability suggestions -- if there's something you think could be done in an easier to use way, please feel free to drop me a note (Email address is at the bottom of the page ...).
The purpose of this program is to provide a means of searching the SCA's Ordinary and Armorial (OandA) database in a fashion that makes some sense with a more intuitive interface than GREP or other UNIX based commands ... If you would like to see some screen shots, click here ... Screen Shots.
The current version is in dBASE Plus, which is a Windows-based database software package (some more detail at the bottom of this page). It can run in most versions of Windows after Windows XP.
Most Recent Version: 14.01, Updated: July, 2019
Included in the previous releases (the following are from 13.09 through 14.00):
Version 14.01 (July, 2019)
This software will not work on Windows XP -- it should be fine on Windows 7, 8 and 10 (see below for Windows 7 and 8 concerns). The underlying software (dBASE) has been upgraded several times, and the last few iterations do not work with Windows XP -- there are some major differences in aspects of the software, and backward compatibility can only go so far. Apologies for any inconvenience!
This version was written completely in dBL, the programming language of dBASE Plus.
There may be other improvements down the road, but unless people tell me areas that need work, I won't know about them (hint, hint!).
You need to have data for the OANDA system -- you can get it from a few places, but the one that is most up-to-date is the site maintained by the Morsulus Herald of the SCA's College of Arms. There are two files you need, and you must follow the directions carefully -- otherwise your browser may add ".htm" or ".html" to the filename as an exension, which is not real useful.
NOTE: The Morsulus herald has decided to release the data on a monthly basis starting in February, 2014. I will update the data here, and if you are on my mailing list, you will receive an email every time the data has been updated, in case you want the update.
OandAData.exe (Dated August 2, 2019 (Covering LoARs up to May, 2019))
This installer is set up to work with the version 11.00 and later of the OandA program (see above), setting specific registry keys so that the program knows where the data is.
The data: http://oanda.sca.org/oanda.db
On a Windows 7 (or Windows 8) computer this will be:
On a Windows 10 computer, this will be:
Where "username" above is YOUR windows username. To see this path in the File Explorer, you may need to modify a setting in the File Explorer:
Doing this will allow you to see the "AppData" folder under your username folder.
Kolfinna Hrafnkelsdottir sent me the following, which may be of use, if you wish to use this application on a Linux machine (with the WINE emulator):
"... I tested the OandA software on my Linux install and fiddled until I got it working.
"This was tested under LinuxMint Release 8 (Helena), using Wine version 1.1.43. It requires that Winetricks be installed, and the packages vcrun2005 and vcrun2005sp1 installed through Winetricks. (Mint is a fork of Ubuntu, which is one of the more widely-used versions of Linux, so it's a fairly good representative distro. I can't speak for the umpteen-zillion other *nix derivatives.)
"If the data is installed from the .exe: In order for OandA to 'read' the oanda.db and my.cat files (and start normally), it is necessary to copy everything except the doc file and oanda.exe from the C: drive it is automatically installed to into the user's "/home/(username)/.wine/dosdevices/z:/home/(username)" file. I don't know enough about how Linux functions to venture a guess why, or how to fix it.
From Hirsch: My guess is that the Linux/Wine combination does not emulate the Windows Registry in the same way as a "pure" Windows computer would. The data installer looks in the registry for the location to store the files. -- HvH
"The program works much better if the oanda.db and my.cat files are saved off the oanda.sca.org website instead. There's still four or five error messages to click through, but it works! (Which is everything you can ask when running a Windows program on a Linux install, really.)" -- Kolfinna Hrafnkelsdottir
From Hirsch: If you choose this method of working with the data files, be sure to save them in the folder with the OandA.exe file, and for the Oanda.db file -- do not forget to add the .db file extension -- it is not automatically there, and if the extension is not part of the filename, the program will not recognize it.
Again, not sure where the files would be installed for the Wine/Linux installation, but for version 11.00 and later you will want to find where the tables are stored. Look for "armorial.dbf" for example. There should be a "Data" folder, which is the "live" data -- that is the one to place Oanda.DB and My.Cat into. There is also an "EmptyTables" folder, which is exactly what it sounds like. This is for the (hopefully) rare occurance where the data has been totally screwed up ... don't place the files from Morsulus there. -- HvH
A couple of notes ...:
First, I make no claims that the software is perfect, but I did put a lot of work into it. If you have a problem with it, please drop me an email (address below) with details -- preferably with exact steps to reproduce the problem.
Second, I am always interested in suggestions for ways to improve the software. I may think you have a great idea and run with it, I may ask a bunch of questions if you toss an idea at me, but ... I am interested.
Contact/About the AuthorEMail: , author of this software ...
Hirsch von Henford is a companion of the Orders of the Laurel and the Pelican in the West Kingdom, a Baron of the Court of the West, and holds a variety of other honors and awards over the 30+ years he has been in the SCA. In addition, during his career in the SCA he has been a herald most of that time, and has held positions including Principality Herald (Stellanordica and Sea Wolf) for two of the West's Principalities, a variety of Kingdom staff positions, including a tenure as Vesper Principal Herald. Currently he is the Golem Herald for the West Kingdom (handling the Herald's website, award list, and a variety of other computer oriented things). At the March, 2019 West Kingdom heralds' meeting, Hirsch was named an Herald Extraordinary, and is working on registering a title ...
Ken Mayer (Hirsch's real-world alter-ego) was a Software Quality Assurance Engineer for dBASE, Inc., testing the software for flaws. Many projects written for the SCA have helped find bugs in the software, so in the process of writing this software, I was actually doing my job as well (nice trick, eh?). Currently I am looking for work, and still tinker with dBASE as a hobbiest, and an author (having written The dBASE Book, now in its third edition; The dBASE Reports Book, now in its second edition, and The dBASE Book Plus).
If you really want more info about me, see: http://www.goldenstag.net.