Re: [Flexradio] Editing the database -- a little progress
Ray, K9DUR wrote: Chuck, You not only have to add a record for the frequency you want to label, but you also have to split the range of frequencies that the labeled frequency is in into 2 separate records so that they do NOT include the labeled frequency. Thanks, Ray. 73, Chuck AA5J ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
Re: [Flexradio] Editing the database -- a little progress
Chuck, You not only have to add a record for the frequency you want to label, but you also have to split the range of frequencies that the labeled frequency is in into 2 separate records so that they do NOT include the labeled frequency. Clear as mud? Maybe an example will help. In your case, instead of 1 record for 80m CW as follows: 3.525 -- 3.57 -- 80M CW -- True you will need the following 3 records: 3.525 -- 3.551999 -- 80M CW -- True 3.552 -- 3.552 -- TEX CW Net -- True 3.552001 -- 3.57 -- 80M CW -- True Otherwise, there would be 2 records trying to define the text for 3.552 MHz, which record will be used is determined by rules that are known only to the programmer. The table is sorted by the low frequency, and my bet is that the 1st record found that includes the current frequency will be the one that will be displayed. If that is the case, then the 3.25 - 3.57999 record will win every time. 73, Ray, K9DUR p.s. -- If someone has already given you this answer, I apologize for wasting the bandwidth. Monday night we were hit by several severe thunderstorms, each packing winds of 60-80 mph. We are still without power probably will be for another day or so. However, I have a generator running the refrigerator, the rig, the PC (You know, the important stuff!) the phone company just got DSL service going again. I am wading through 100 e-mail messages that have built up since the power went out. ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
Re: [Flexradio] Editing the database -- a little progress
On 07/21/08 10:29 pm Ray, K9DUR wrote: Tim, You must be correct about Open Office causing a problem. Alan's statement that, ...the database is defined to permit only two decimal places... is absolutely not correct. The Low High fields in the BandText table are double-precision floating-point numbers, with at least 14 significant digits. With a maximum frequency of 65 MHz, this means that the values stored can have up to 12 digits after the decimal point. Typical values in these fields are entered to the nearest Hz, or 6 digits after the decimal point. Any limitation to only 2 digits must be either a limitation in or a setting of Open Office. Perhaps I jumped to the wrong conclusion based on what I observed: I could enter 14.236, but as soon as I moved over to the next field, what was displayed was 14.24. 73 Alan NV8A ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
Re: [Flexradio] Editing the database -- a little progress
Tim Ellison wrote: I believe the OO tool is mucking up the Access database. Obviously it is truncating the precision of the field value which is probably why you are receiving the error. The data is there, but OO is not showing it. Maybe if you can provide a detailed band plan for digital modes on all bands for region II, I can create a small database table that is updated and you could import it with Ray's DB table import tool. -Tim After you open the table in OO, you can adjust the displayed decimal points, etc. by r-clicking the title and selecting format. There you can increase the number of decimal points shown among many other format changes. However, I entered 3.552 TEX CW Net and the database shows it is there in the database, but in PowerSDR when I select the frequency, it still shows 80m CW. Chuck ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
Re: [Flexradio] Editing the database -- a little progress
OK, so far I have discovered that some changes using OO Base do change PowerSDR.mdb as well, but the only change I have so far been able to make that does anything like what I have in mind is to edit the text for 14.070 to read 20M RTTY/Digital instead of just 20M RTTY: that change then displays in PowerSDR. I was able to create a new entry for 14.24 (rather than 14.236, since the database is defined to permit only two decimal places) as 20M Digital Voice, but it does not display with this label in PowerSDR, probably because the range 14.23 to 14.35 is already defined as 20M SSB and overrides the new entry. in an effort to overcome the preceding problem I have tried to create new entries defining 14.23 to 14.24 and 14.24 to 14.35 as 20M SSB, but an error message claims that I have generated a duplicate entry (which is certainly not apparent to me) or otherwise violated some existing restriction(s). Some changes I have made have been able to be saved, but every frequency from there on up is labeled Out of band. Alan NV8A On 07/19/08 06:57 pm I wrote: Yes, but I don't have Micro$$$oft Acce$$$ and don't intend to buy it. The KB item to which I was referred purports to tell how to use OpenOffice Base to do it. On 07/19/08 06:37 pm Larry W8ER wrote: Alan ... Microsoft Access works fine here! In response to my feature request for the ability to append our own labels for frequencies; e.g., 20M Digital Voice for 14.236, I was pointed to http://kb.flex-radio.com/article.aspx?id=10346 which purports to show how to edit the database -- a poor substitute for being able to RMB on the frequency display and being offered the option to Label this Frequency, but anyway... OK, I use OpenOffice Base to link to PowerSDR.mdb, figure out how to add an entry to the BandText table (only at the end, not in numerical order), discover that the existing format allows only two decimal places so that 14.236 gets rounded to 14.24, change the format to allow three decimal places, add the new entry, and save the database -- as an OpenOffice file, which is the only format option I am offered. How do I get the changes into PowerSDR.mdb? Color me frustrated. Alan NV8A (who has designed and used databases using dBase II and DataPerfect on microcomputers and DB2/SQL on minicomputers) ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
Re: [Flexradio] Editing the database -- a little progress
I believe the OO tool is mucking up the Access database. Obviously it is truncating the precision of the field value which is probably why you are receiving the error. The data is there, but OO is not showing it. Maybe if you can provide a detailed band plan for digital modes on all bands for region II, I can create a small database table that is updated and you could import it with Ray's DB table import tool. -Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan NV8A Sent: Monday, July 21, 2008 5:07 PM To: Flex Group Subject: Re: [Flexradio] Editing the database -- a little progress OK, so far I have discovered that some changes using OO Base do change PowerSDR.mdb as well, but the only change I have so far been able to make that does anything like what I have in mind is to edit the text for 14.070 to read 20M RTTY/Digital instead of just 20M RTTY: that change then displays in PowerSDR. I was able to create a new entry for 14.24 (rather than 14.236, since the database is defined to permit only two decimal places) as 20M Digital Voice, but it does not display with this label in PowerSDR, probably because the range 14.23 to 14.35 is already defined as 20M SSB and overrides the new entry. in an effort to overcome the preceding problem I have tried to create new entries defining 14.23 to 14.24 and 14.24 to 14.35 as 20M SSB, but an error message claims that I have generated a duplicate entry (which is certainly not apparent to me) or otherwise violated some existing restriction(s). Some changes I have made have been able to be saved, but every frequency from there on up is labeled Out of band. Alan NV8A On 07/19/08 06:57 pm I wrote: Yes, but I don't have Micro$$$oft Acce$$$ and don't intend to buy it. The KB item to which I was referred purports to tell how to use OpenOffice Base to do it. On 07/19/08 06:37 pm Larry W8ER wrote: Alan ... Microsoft Access works fine here! In response to my feature request for the ability to append our own labels for frequencies; e.g., 20M Digital Voice for 14.236, I was pointed to http://kb.flex-radio.com/article.aspx?id=10346 which purports to show how to edit the database -- a poor substitute for being able to RMB on the frequency display and being offered the option to Label this Frequency, but anyway... OK, I use OpenOffice Base to link to PowerSDR.mdb, figure out how to add an entry to the BandText table (only at the end, not in numerical order), discover that the existing format allows only two decimal places so that 14.236 gets rounded to 14.24, change the format to allow three decimal places, add the new entry, and save the database -- as an OpenOffice file, which is the only format option I am offered. How do I get the changes into PowerSDR.mdb? Color me frustrated. Alan NV8A (who has designed and used databases using dBase II and DataPerfect on microcomputers and DB2/SQL on minicomputers) ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/ ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
Re: [Flexradio] Editing the database -- a little progress
Tim, You must be correct about Open Office causing a problem. Alan's statement that, ...the database is defined to permit only two decimal places... is absolutely not correct. The Low High fields in the BandText table are double-precision floating-point numbers, with at least 14 significant digits. With a maximum frequency of 65 MHz, this means that the values stored can have up to 12 digits after the decimal point. Typical values in these fields are entered to the nearest Hz, or 6 digits after the decimal point. Any limitation to only 2 digits must be either a limitation in or a setting of Open Office. 73, Ray, K9DUR ___ FlexRadio Systems Mailing List FlexRadio@flex-radio.biz http://mail.flex-radio.biz/mailman/listinfo/flexradio_flex-radio.biz Archives: http://www.mail-archive.com/flexradio%40flex-radio.biz/ Knowledge Base: http://kb.flex-radio.com/ Homepage: http://www.flex-radio.com/
