| Search Log JOOMLA Component, ver.1.2 |  |  |
| Wednesday, 13 December 2006 17:40 |
|
For this Radio Amateur Web site I developed new Joomla component dedicated primarily for station QSO log searching. My implementation for OM1AVK station you can find selecting from main menu Search Ham Logs . Purpose Search Log is primarily oriented for searching in Amateur Radio logs containing informations about performed radio contacts (QSO's). Because of radio amateur rules and gentlement agreement (ham spirit) there is not allowed to gain all important informations about the performed contact via web published log. This Joomla component follows mentioned requirements and allows for each searched callsign to find some important data : contact callsign, band, transmission mode and status of confirming of QSO via QSL card (none as blank, sent, received, confirmed on both sides). Screen example  Station Log QSO log data are stored in database table in MySQL database in the following manner :  As you see in the table is callsign stored in two columns - in the 'call' is allocated full callsign as used during QSO and in the 'radio' column here is basic callsign stripped, without /P or /number (as used by portable operation). This arrangement allows easy searching for all QSO records for the basic callsign as shown on the first figure. During installation of SearchLog component is created the related table with naming 'jos_calls' (when the default table prefix 'jos' is used). Importing data into this table as well as data update and maintainence is necessary to perform by PHPMyAdmin client or other database administration frontend. Installation Upload and install the SearchLog component via Joomla Administrator using the normal procedure (Installers->Components Browse/Upload & Install). Set up your preferencies and description for this component (Components-> SearchLog). For importing QSO log data is used database table 'jos_calls' (when the default table prefix 'jos' is used). Importing data into this table as well as data update and maintainence is necessary to perform by PHPMyAdmin client or other database administration frontend. Then select in Joomla Administrator proper menu set to which you like to assign the SearchLog content (usually is selected Menu->mainmenu). Pressing of 'New' button and then after selecting 'Component' on 'New Menu Item' page we can push 'Next' button. On the coming 'Add Menu Item :: Component' page we assign appropriate name for new menu item and in 'Component' item is here necessary to select 'SearchLog'. Administration Administration of the Search Log component is performed by administrator part of Joomla framework. Here is possible to set the requested title, description, description text as well last valid date of QSOs for displaying part of log search. Each of the SearchLog parameters has on administration page pop-up hint when appointed by mouse cursor. For multilanguage pages is here foreseen to use '*' value of the parameter in which case the proper definition from language definition file is used (valid for _SEARCHLOG_TITLE, _SEARCHLOG_DESC, _SEARCHLOG_TEXT definitions). Download Component SearchLog, ver.1.2., designed for Joomla! framework, ver.1.0.11, is available for download here. |
| Last Updated on Friday, 05 October 2007 16:30 |
