RadioReference on Facebook   RadioReference on Twitter   RadioReference Blog
 

Go Back   The RadioReference.com Forums > Site Administration Forums > Database Discussion Forum


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.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-05-2013, 9:02 PM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default 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
Reply With Quote
Sponsored links
  #2 (permalink)  
Old 03-06-2013, 5:44 AM
mciupa's Avatar
Member
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Nov 2002
Posts: 4,495
Default

Have you contacted the software authors?
Reply With Quote
  #3 (permalink)  
Old 03-06-2013, 7:42 AM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default

Quote:
Originally Posted by mciupa View Post
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
Reply With Quote
  #4 (permalink)  
Old 03-06-2013, 8:11 AM
Wiki Admin Emeritus
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jul 2002
Location: Bowie, Md.
Posts: 16,276
Default

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!
Reply With Quote
  #5 (permalink)  
Old 03-06-2013, 8:18 AM
kc0wkp's Avatar
Member
  Shack Photos
Shack photos
RadioReference Database Admininstrator
Database Admin
Audio Feed Provider
Audio Feed Provider
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2009
Location: Wisconsin
Posts: 422
Default

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"
Reply With Quote
Sponsored links
  #6 (permalink)  
Old 03-06-2013, 9:19 AM
Wiki Admin Emeritus
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jul 2002
Location: Bowie, Md.
Posts: 16,276
Default

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..
Reply With Quote
  #7 (permalink)  
Old 03-06-2013, 11:28 AM
Chauffeur6's Avatar
DB Admin
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
Default

Quote:
Originally Posted by RonnieUSA View Post
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?
Reply With Quote
  #8 (permalink)  
Old 03-06-2013, 1:24 PM
loumaag's Avatar
Moderator
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Oct 2002
Location: Katy, TX
Posts: 12,895
Default

Quote:
Originally Posted by ka3jjz View Post
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 View Post
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.
Reply With Quote
  #9 (permalink)  
Old 03-06-2013, 1:52 PM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default

Quote:
Originally Posted by loumaag View Post
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
Reply With Quote
Sponsored links
  #10 (permalink)  
Old 03-06-2013, 2:02 PM
Chauffeur6's Avatar
DB Admin
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
Default

Quote:
Originally Posted by RonnieUSA View Post
Correct, it sets it to FM.
You still haven't answered the question: What is "it"? What software program? What county?
Reply With Quote
  #11 (permalink)  
Old 03-06-2013, 2:09 PM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default

Quote:
Originally Posted by Chauffeur6 View Post
You still haven't answered the question: What is "it"? What software program? What county?
FreeSCAN, Carter County, Kentucky (KY) Scanner Frequencies and Radio Frequency Reference, The E911 Center frequencies.
__________________
Radio Shack Pro-197 - Uniden BCT15X
Win500 - ARC500 - FreeScan - ARC-XT-PRO - ID Tracker III
Reply With Quote
  #12 (permalink)  
Old 03-06-2013, 2:10 PM
Highpockets's Avatar
Member
  Shack Photos
Shack photos
Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2003
Location: Toms River, New Jersey
Posts: 3,709
Send a message via AIM to Highpockets
Default

Quote:
Originally Posted by Chauffeur6 View Post
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
Reply With Quote
  #13 (permalink)  
Old 03-06-2013, 2:14 PM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default

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
Reply With Quote
  #14 (permalink)  
Old 03-06-2013, 2:16 PM
Highpockets's Avatar
Member
  Shack Photos
Shack photos
Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2003
Location: Toms River, New Jersey
Posts: 3,709
Send a message via AIM to Highpockets
Default

Quote:
Originally Posted by RonnieUSA View Post
I just imported those using FreeScan 2 import as FM the rest NFM.
__________________
Steve
BC785D ~ BCD396XT ~ BCD996XT ~ PSR600
Reply With Quote
  #15 (permalink)  
Old 03-06-2013, 2:19 PM
Highpockets's Avatar
Member
  Shack Photos
Shack photos
Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2003
Location: Toms River, New Jersey
Posts: 3,709
Send a message via AIM to Highpockets
Default

Quote:
Originally Posted by RonnieUSA View Post
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
Reply With Quote
Sponsored links
        
  #16 (permalink)  
Old 03-06-2013, 2:29 PM
loumaag's Avatar
Moderator
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Oct 2002
Location: Katy, TX
Posts: 12,895
Default

Quote:
Originally Posted by RonnieUSA View Post
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?
Reply With Quote
  #17 (permalink)  
Old 03-06-2013, 2:43 PM
Chauffeur6's Avatar
DB Admin
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
Default

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.
Reply With Quote
  #18 (permalink)  
Old 03-06-2013, 2:58 PM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default

Quote:
Originally Posted by Chauffeur6 View Post
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
Reply With Quote
  #19 (permalink)  
Old 03-06-2013, 3:02 PM
Chauffeur6's Avatar
DB Admin
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Oct 2007
Location: Metro NY
Posts: 4,266
Default

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?
Reply With Quote
  #20 (permalink)  
Old 03-06-2013, 3:08 PM
RonnieUSA's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Aug 2005
Location: Rowan County,KY (Morehead)
Posts: 940
Default

Quote:
Originally Posted by Chauffeur6 View Post
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 10:42 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
All information here is Copyright 2012 by RadioReference.com LLC and Lindsay C. Blanton III.Ad Management by RedTyger
Copyright 2011 by RadioReference.com LLC Privacy Policy  |  Terms and Conditions