|
|
|
|
| Database Discussion Forum This forum is for questions about the database such as how to use it, layout or usability issues or suggestions for improvement. It is not for pointing out wrong information or getting help with programming. |

03-05-2013, 9:02 PM
|
 |
Member
|
|

Premium Subscriber
|
|
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
|
|
FMN vs NFM
There seems to be a problem with some software not importing right because of this.
Where it should be listed as NFM.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
|

03-06-2013, 5:44 AM
|
 |
Member
|
|
 Database Admin
|

Amateur Radio
|
|
Join Date: Nov 2002
Posts: 4,495
|
|
Have you contacted the software authors?
|

03-06-2013, 7:42 AM
|
 |
Member
|
|

Premium Subscriber
|
|
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
|
|
Quote:
Originally Posted by mciupa
Have you contacted the software authors?
|
Yes it has been done.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
|

03-06-2013, 8:11 AM
|
|
Wiki Admin Emeritus
|
|

Amateur Radio
|
|
Join Date: Jul 2002
Location: Bowie, Md.
Posts: 16,276
|
|
But that's really not addressing the issue. In a database, data must be consistently represented (I work with them for a living). If FMN and NFM really describe the same thing, it should be corrected. Likely a PERL script could do the job, along with something in the DBA handbook (if there isn't something in there already)
I suspect this is an Eric issue...Mike
__________________
links editor, Utility Monitoring Central
HF Forum moderator, RadioReference
Friends don't let friends buy Scancat Lite Plus!
|

03-06-2013, 8:18 AM
|
|
|
When we edit the Database, we can only select FMN. There is no option for NFM.
__________________
kc0wkp
"If it don't glow, don't buy it"
|

03-06-2013, 9:19 AM
|
|
Wiki Admin Emeritus
|
|

Amateur Radio
|
|
Join Date: Jul 2002
Location: Bowie, Md.
Posts: 16,276
|
|
That's rather interesting. Then the obvious question is how NFM got in there in the first place. Is it a keyable field, or is there just a pulldown to select the mode? You would expect that field to be limited with constraints. Perhaps it's a remnant from before that field (in DB2 we'd say 'column') had constraints?
If it's both keyable and enterable with a pulldown, then that's a significant issue, data-wise. While I can't get to it, it should be entered into Mantis. Mike
__________________
links editor, Utility Monitoring Central
HF Forum moderator, RadioReference
Friends don't let friends buy Scancat Lite Plus!
Last edited by ka3jjz; 03-06-2013 at 9:28 AM..
|

03-06-2013, 11:28 AM
|
 |
DB Admin
|
|
 Database Admin
|
|
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
|
|
Quote:
Originally Posted by RonnieUSA
There seems to be a problem with some software not importing right because of this.
Where it should be listed as NFM.
|
The RR database format is "FMN" and has been that way for years.
Exactly which software are you having trouble with, and what county/agency are you trying to download that's giving you an error?
|

03-06-2013, 1:24 PM
|
 |
Moderator
|
|
 Database Admin
|
|
Join Date: Oct 2002
Location: Katy, TX
Posts: 12,895
|
|
Quote:
Originally Posted by ka3jjz
That's rather interesting. Then the obvious question is how NFM got in there in the first place. ...
|
I don't think he is saying that the DB has "NFM" in it anywhere, I think he is saying that whatever software he is using is not assigning NFM (in his radio) based on the "FMN" entry in the DB.
Quote:
Originally Posted by Chauffeur6
The RR database format is "FMN" and has been that way for years.
Exactly which software are you having trouble with, and what county/agency are you trying to download that's giving you an error?
|
As Chauffeur6 says, this has been the entry since the beginning of Radio Reference, it has always been "FMN" so I don't think there are any "NFM" entries in the DB.
|

03-06-2013, 1:52 PM
|
 |
Member
|
|

Premium Subscriber
|
|
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
|
|
Quote:
Originally Posted by loumaag
I don't think he is saying that the DB has "NFM" in it anywhere, I think he is saying that whatever software he is using is not assigning NFM (in his radio) based on the "FMN" entry in the DB.
As Chauffeur6 says, this has been the entry since the beginning of Radio Reference, it has always been "FMN" so I don't think there are any "NFM" entries in the DB.
|
Correct, it sets it to FM.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
|

03-06-2013, 2:02 PM
|
 |
DB Admin
|
|
 Database Admin
|
|
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
|
|
Quote:
Originally Posted by RonnieUSA
Correct, it sets it to FM.
|
You still haven't answered the question: What is "it"? What software program? What county?
|

03-06-2013, 2:10 PM
|
|
|
Quote:
Originally Posted by Chauffeur6
You still haven't answered the question: What is "it"? What software program? What county?
|
I just imported Monmouth County NJ (Local Fire/EMS) Monoc conv freq's that are marked FMN in the database and in the software they import as NFM, is he saying they upload to the scanner FM or just importing to the software as FM.
I did this with both Win500 and FreeScan and the freq's show in the software as NFM after importing from the database.
__________________
Steve
BC785D ~ BCD396XT ~ BCD996XT ~ PSR600
|

03-06-2013, 2:14 PM
|
 |
Member
|
|

Premium Subscriber
|
|
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
|
|
They go to the radio as FM.
I think I should have stayed quit about this subject.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
|

03-06-2013, 2:16 PM
|
|
|
Quote:
Originally Posted by RonnieUSA
|
I just imported those using FreeScan 2 import as FM the rest NFM.
__________________
Steve
BC785D ~ BCD396XT ~ BCD996XT ~ PSR600
|

03-06-2013, 2:19 PM
|
|
|
Quote:
Originally Posted by RonnieUSA
They go to the radio as FM.
I think I should have stayed quit about this subject.
|
Glad you mentioned it, I'll have to check my programming now, thank you. Maybe they are not in the scanner like I thought they were. 
__________________
Steve
BC785D ~ BCD396XT ~ BCD996XT ~ PSR600
|

03-06-2013, 2:29 PM
|
 |
Moderator
|
|
 Database Admin
|
|
Join Date: Oct 2002
Location: Katy, TX
Posts: 12,895
|
|
Quote:
Originally Posted by RonnieUSA
They go to the radio as FM.
I think I should have stayed quit about this subject.
|
No you should not have been quiet, you have a legitimate question; however, it is a software problem (I'm thinking). So to just recap: Using FreeScan, when you import the 911 center frequencies they go into the software properly (all as NFM except the 2 listed as FM) but when you send them to the radio (which model by the way) they only show up as FM in the radio. Is that about it?
|

03-06-2013, 2:43 PM
|
 |
DB Admin
|
|
 Database Admin
|
|
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
|
|
I agree with Lou, if you think there's an issue, speak up and let us try to help you figure it out.
The downloading into FreeSCAN went just fine...2 FM and 10 NFM imported from the database, no problems there.
I then uploaded the system to my BC346XT (the handheld version of the BCT15X) and, as expected, I see 2 FM and 10 NFM frequencies.
Everything went fine on my end, I'm unable to reproduce the issue you're having. It would probably be helpful to have someone with a BCT15X see if they are having the same issue.
It goes without saying to make sure your scanner has the latest firmware and that you are using the latest version of FreeSCAN.
|

03-06-2013, 2:58 PM
|
 |
Member
|
|

Premium Subscriber
|
|
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
|
|
Quote:
Originally Posted by Chauffeur6
I agree with Lou, if you think there's an issue, speak up and let us try to help you figure it out.
The downloading into FreeSCAN went just fine...2 FM and 10 NFM imported from the database, no problems there.
I then uploaded the system to my BC346XT (the handheld version of the BCT15X) and, as expected, I see 2 FM and 10 NFM frequencies.
Everything went fine on my end, I'm unable to reproduce the issue you're having. It would probably be helpful to have someone with a BCT15X see if they are having the same issue.
It goes without saying to make sure your scanner has the latest firmware and that you are using the latest version of FreeSCAN.
|
It may be something I'm doing wrong, I'm new to FreeSCAN.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
|

03-06-2013, 3:02 PM
|
 |
DB Admin
|
|
 Database Admin
|
|
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
|
|
Just to verify, after downloading into FreeSCAN, do those 10 frequencies appear as NFM? It's the transfer to the scanner that seems to be the issue?
|

03-06-2013, 3:08 PM
|
 |
Member
|
|

Premium Subscriber
|
|
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
|
|
Quote:
Originally Posted by Chauffeur6
Just to verify, after downloading into FreeSCAN, do those 10 frequencies appear as NFM? It's the transfer to the scanner that seems to be the issue?
|
It worked that time, it had to be operator error.
Thank You everyone for the help on this.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -5. The time now is 10:42 AM.
|
|
|
|
| |
|
|