Help keep this site free:

*

(More Info)

Hamlookup Ham Radio Database

This article describes a new Ham Radio Database. The HamLookup database contains mailing addresses and other ham radio related information such as grid square, DXCC country, US county and other which can be used to obtain QSL cards and awards. Several factors set this database apart from the better known ones. This project is purely non-commercial (with an uncluttered presentation). This database offers the capability to store multiple addresses for a given callsign, to reflect the fact that ham radio operators do move and special event callsigns may be reused by different teams at different times and therefore may have multiple, different mailing addresses. The database offers a free and effective API (Application Programming Interface) using the xml language that is free to use without the need to register. Information in the HamLookup database is intended to be maintained primarily by its users.

Đang xem: Bài 9: các hàm xử lý file và upload file trong php

What is it?

The Alpha version of the HamLookup Database is accessible at http://https://www.darkedeneurope.com/hamlookup/index.php

The purpose of the HamLookup Database is to provide address and other information necessary for hams everywhere to obtain awards and QSLs, and to complete log information when participating in contests, no less and no more.

It is a work in progress, and it is done generally under the Open Source spirit, if not the letter for now. Eventually, the code will be released, but it is just too fluid at the moment.

The HamLookup database has basic web-based editing interface capability: lookup, add, modify, delete, what I would call the “management” interface, and an API for XML and ADIF formatted search queries. The XML API seems to work with Logger32 with just the right configuration parameter, however, the existing Logger32 interface does not take advantage of one of the more interesting feature of the database.

The HamLookup database supports multiple entries for each callsign. There are many cases where this is useful, because people move and callsigns are eventually recycled. It is good to be able to lookup someone”s information as of, say, November 5, 2005, to validate an old QSO for which you may need a QSL. You can see an example of that if you look for my callsign: darkedeneurope.com. It will show the two places where I have lived since becoming a ham. The search is not case sensitive, so looking for “darkedeneurope.com” is the same as looking for “darkedeneurope.com”

I anticipate this feature will be also very useful for DX operations where the same callsign may be used by different teams over and over again, and the QSL route may be different each time. Also, many hams move during their ham career and most countries do not require them to change callsign when they do, and this may affect eligibility for awards, so it is important to be able to track the addresses over time. You may use it to record a location where you operated from during a contest or holidays.

Please note that you can also search the database on a name or partial name. This is done automatically if the program does not find a callsign matching your query string. In this case, it will look for a name that contains the search string. For instance, if you search for “juges”, it will return several records (my son and I for now). Unlike the name search, the callsign search requires an exact match (i.e. searching for KO4B will not find a record for darkedeneurope.com). There is no search on other fields for now. If the need comes, that can certainly be added.

There are two ways to enter data into the database.

The user can enter/edit his or her own information one record at a time using the web interface, and/or manage other ham”s information.The user can upload a large amount of data at once using the Upload Log button in the top row.To edit information about a callsign, enter the callsign in the box and click the Search Database button. Once you see what”s there, select the entry you want to edit, then click the Edit button. Please note that while you can select multiple callsigns, only the first selected callsign will be opened for edit.

To create a new entry from scratch, click the Create New Entry button in the top row. You cannot use an existing entry to create a new one.

The Upload Log function is used as follows: if you happen to be using computer logging software, and you have recorded the name and address of at least some of your contacts, you can most probably export and save the entire log as an ADIF file. That file can be uploaded to HamLookup using the Upload Log button. When such a file is uploaded, the program strips all QSO information (date, time, reports, frequency and what not) and only keeps the name, address, grid, county and other geographical information from the standard ADIF (or XML) fields that are available. Records which do not contain at least a name and an address are not used. All other information is optional.

Xem thêm:

The Upload Log function supports two file formats: ADIF and XML. The ADIF format is supported by most amateur logging software. The XML format is more general but less common in ham software.

The Upload Log function rejects identical entries, so there should be no problem (other than a waste of CPU cycles and your time) if you upload the same file again and again (on purpose or by accident).

Since the date feature is not supported (that I know of) by other popular on-line ham databases, the date information is likely not available anywhere and will have to be entered manually by the holder of the callsign or his/her representative, unless someone comes up with a better idea.

All changes are done using the honor system, in the spirit of cooperation, and there is no desire or attempt at keeping someone out of someone else”s record, a la Wikipedia (except that some Wikipedia articles are moderated). Users are of course expected to enter their callsign in the “Your callsign” box when they make a change, but even that is not required. Unlike Wikipedia and most other sites, there is no need to register before being able to make changes. That policy may change later if I find that this service is being abused. When registration is implemented, at least there is a valid email address that can be associated with a log upload or a record modification. For now, the only thing that is always stored is the IP address of whoever makes a change in the database.

As of January 2012, the HamLookup database structure is almost complete. The intent is to support all the main awards, so feel free to make suggestions for additional information that should be recorded.

The date feature uses the fields called “start” and “end”.

These fields are intended to contain the range of dates where the entry is valid. You can see an example with my callsign. I moved in 1994. This is one problem with the existing on-line databases (QRZ.COM, Hamcall, HamQTH) in that they only have the capability of one record for one callsign, so if the callsign is reassigned, or if the operator moves, you get the wrong answer and they is no way to resolve it.

With the HamLookup database, the user has the capability (via the API) to enter a callsign and a specific date and the database will return the record for that date (if that date falls within a range that has been loaded in the database). If no date is specified, it will return the most recent entry for that callsign based on the “start” field, not based on the date when the record was added or revised. If there are several records and they all have a blank “start” field, the first one found is returned, which is not necessarily the first one you see on the screen when doing a query. When you do a query from the web interface, all callsign matching records are returned, and the date range for each record is displayed, so you can choose the address for the date you are interested in.

Xem thêm:

You can see this in action with the following API query (the date format is YYYY-MM-DD).

This query will return something like the following html/xml code (please note that I have listed ALL the fields that could be returned, some with dummy data but in actuality only those field that contain information (not blank) are returned):

darkedeneurope.comDidier Juges47 Magnolia Ave, Shalimar, FL32579USAUNITED STATESOkaloosaEM60ql75NA-234xxxxxxxxxxxxxxxxxxxxxxxxxxdidier

Related Post

Leave a Reply

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