RadioReference on Facebook   RadioReference on Twitter   RadioReference Blog
 

Go Back   The RadioReference.com Forums > Computer Aided Monitoring and Programming > Scanner Programming Software


Scanner Programming Software - This is the place to discuss third party scanner programming and control software.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-08-2011, 1:10 AM
AuToGrApHzZz's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2010
Location: Irvine, CA
Posts: 40
Arrow Pro-92 Software to sync with RR DB

Hola Fellows,

I am currently trying to program my Pro-92 scanner with all the conventional frequencies associated with LASD and LAPD but am having a hard time not losing my cool. Currently all programming is being done via hand on Win92 programming software which does not (to my knowledge) have the capability of automatically syncing with RadioReference like Win500 does. I have looked around for clones and such with no success. Halp Pl0x?
Reply With Quote
Sponsored links
  #2 (permalink)  
Old 08-08-2011, 2:15 AM
n5ims's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jul 2004
Posts: 3,634
Default

While you can't directly download the data from the RR database, you can use MS Excel (or many other spreadsheets) to copy the RR database, modify it to match the Win92 format and past the data into Win92. This should save you quite a bit of time and trouble (and nearly eliminate they nearly certain typos from manual entry).

For example, copy the data from "LA County FD Battalion Response Map", which will look like this
Quote:
Frequency License Type Tone Alpha Tag Description Mode Tag
470.56250 KNP331 RM CSQ LAC BLUE 1 CMD LA Basin - Bn 7, 8, 9, 14, 18 (South County & Catalina) FM Fire Dispatch
470.43750 KNP331 RM CSQ LAC BLUE 2 Alt CMD/Tac - LA Basin FM Fire-Tac
470.61250 KNP331 RM CSQ LAC BLUE 3 CMD LA Basin - Bn 1, 3, 5, 13, 20 (West County) FM Fire Dispatch
470.51250 KNP331 RM CSQ LAC BLUE 4 Countywide Admin / Alt CMD FM Fire-Tac
470.66250 WII225 RM CSQ LAC BLUE 5 Alt CMD/Tac - San Gabriel Valley FM Fire-Tac
470.41250 WII225 RM CSQ LAC BLUE 6 CMD San Gabriel Valley - Bn 2, 4, 10, 12, 15, 16, 19 (East County) FM Fire Dispatch
470.46250 KNP331 RM CSQ LAC BLUE 7 Alt CMD/Tac - San Gabriel Valley FM Fire-Tac
470.53750 KNP331 RM CSQ LAC BLUE 8 Countywide Dispatch FM Fire Dispatch
470.63750 KNP331 RM 151.4 PL LAC BLUE 9 Alt CMD/Tac - Antelope Valley ONLY FM Fire-Tac
470.36250 KNP331 RM 151.4 PL LAC BLUE 10 Alt CMD/Tac - Antelope Valley ONLY FM Fire-Tac
470.58750 KNP331 RM CSQ LAC BLUE 11 Alt CMD - Santa Clarita & Antelope Valleys FM Fire-Tac
470.48750 KNP331 RM CSQ LAC BLUE 12 CMD North - Bn 6, 11, 17, 22 (North County) FM Fire Dispatch
453.67500 KBZ726 RM 151.4 PL LAC BLUE 13 CMD La Habra - Bn 21 FM Fire-Tac
453.72500 KRM765 RM 151.4 PL LAC BLUE 14 Crew / Dozer Net FM Fire-Tac
453.77500 KMG240 RM 151.4 PL LAC BLUE 15 Alt Crew / Dozer Net FM Fire-Tac
453.82500 KBZ725 RM 151.4 PL LAC BLUE 16 CMD/Tac FM Fire-Tac
453.97500 KM6542 RM 151.4 PL LAC BLUE 17 CMD/Tac FM Fire-Tac
453.90000 KBN492 RM 151.4 PL LAC BLUE 18 Tac (North County) FM Fire-Tac
478.55000 WQJX500 M CSQ LAC BLUE 19 CMD/Tac Direct FM Deprecated
478.65000 WQJX500 M CSQ LAC BLUE 20 CMD/Tac Direct FM Deprecated
478.75000 WQJX500 M CSQ LAC BLUE 21 CMD/Tac Direct FM Deprecated
478.85000 WQJX500 M CSQ LAC BLUE 22 CMD/Tac Direct FM Deprecated
478.95000 WQJX500 M CSQ LAC BLUE 23 CMD/Tac Direct FM Deprecated
478.98750 WQJX500 M CSQ LAC BLUE 24 CMD/Tac Direct FM Deprecated
478.55000 WQJX521 RM 151.4 PL LAC U-19 Command / Tactical / Portable Repeater FMN Fire-Tac
478.65000 WQJX521 RM 151.4 PL LAC U-20 Command / Tactical / Portable Repeater FMN Fire-Tac
478.75000 WQJX521 RM 151.4 PL LAC U-21 Command / Tactical / Portable Repeater FMN Fire-Tac
478.85000 WQJX521 RM 151.4 PL LAC U-22 Command / Tactical / Portable Repeater FMN Fire-Tac
478.95000 WQJX521 RM 151.4 PL LAC U-23 Command / Tactical / Portable Repeater FMN Fire-Tac
478.98750 WQJX521 RM 151.4 PL LAC U-24 Command / Tactical / Portable Repeater FMN Fire-Tac
Copy the "Frequency", "Tone", and "Alpha Tag" columns into a new area of the spreadsheet. They need to be reordered and an extra column added. The final destination should be "Alpha Tag", "Frequency", (a new column added called) "Rx Mode", and "Tone".

Next, edit the "Tone" column to blank out the "CSQ". For those entries, populate the "Rx Mode" column with the text "FM".

Next, edit the "Tone" column to remove the " PL" from the columns that have this populated (e.g. "151.4 PL" would become simply "151.4"). For those entries, popluate the "Rx Mode" column with the text "PL".

Now that the data has been cleaned up and is ready for loading into Win92, it should look like this:
Quote:
Alpha Tag Frequency RX Mode Tone
LAC BLUE 1 470.56250* FM
LAC BLUE 2 470.43750* FM
LAC BLUE 3 470.61250* FM
LAC BLUE 4 470.51250* FM
LAC BLUE 5 470.66250* FM
LAC BLUE 6 470.41250* FM
LAC BLUE 7 470.46250* FM
LAC BLUE 8 470.53750* FM
LAC BLUE 9 470.63750* PL 151.4
LAC BLUE 10 470.36250* PL 151.4
LAC BLUE 11 470.58750* FM
LAC BLUE 12 470.48750* FM
LAC BLUE 13 453.67500* PL 151.4
LAC BLUE 14 453.72500* PL 151.4
LAC BLUE 15 453.77500* PL 151.4
LAC BLUE 16 453.82500* PL 151.4
LAC BLUE 17 453.97500* PL 151.4
LAC BLUE 18 453.90000* PL 151.4
LAC BLUE 19 478.55000* FM
LAC BLUE 20 478.65000* FM
LAC BLUE 21 478.75000* FM
LAC BLUE 22 478.85000* FM
LAC BLUE 23 478.95000* FM
LAC BLUE 24 478.98750* FM
LAC U-19 478.55000* PL 151.4
LAC U-20 478.65000* PL 151.4
LAC U-21 478.75000* PL 151.4
LAC U-22 478.85000* PL 151.4
LAC U-23 478.95000* PL 151.4
LAC U-24 478.98750* PL 151.4
Next select the 4 columns of data (but not the headings row) in the spreadsheet and copy them (ctrl-c or appropriate). Move to Win92 and select the row where the first of them is to be placed. Plaste the data onto the Win92 screen and check for any errors. Correct any errors and populate any options from the 4 columns we didn't populate.

Repeate this process for the other banks and save the file locally (so you can simply make changes later if needed) and upload the data to your scanner.

Please note that the amount of data you can copy is limited by the Win92 screens (which reflect the scanner limitations). You can only copy up to 50 frequencies per bank. To descide what values to enter in the "Rx Mode" col, simply look at the Win92 values for that field and pick the one that's appropriate. While I didn't provide details, you can populate the talk groups for trunked systems using a similar procedure.

Last edited by n5ims; 08-08-2011 at 2:23 AM..
Reply With Quote
  #3 (permalink)  
Old 08-08-2011, 2:29 AM
AuToGrApHzZz's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2010
Location: Irvine, CA
Posts: 40
Default

Quote:
Originally Posted by n5ims View Post
While you can't directly download the data from the RR database, you can use MS Excel (or many other spreadsheets) to copy the RR database, modify it to match the Win92 format and past the data into Win92. This should save you quite a bit of time and trouble (and nearly eliminate they nearly certain typos from manual entry).

For example, copy the data from "LA County FD Battalion Response Map", which will look like this


Copy the "Frequency", "Tone", and "Alpha Tag" columns into a new area of the spreadsheet. They need to be reordered and an extra column added. The final destination should be "Alpha Tag", "Frequency", (a new column added called) "Rx Mode", and "Tone".

Next, edit the "Tone" column to blank out the "CSQ". For those entries, populate the "Rx Mode" column with the text "FM".

Next, edit the "Tone" column to remove the " PL" from the columns that have this populated (e.g. "151.4 PL" would become simply "151.4"). For those entries, popluate the "Rx Mode" column with the text "PL".

Now that the data has been cleaned up and is ready for loading into Win92, it should look like this:


Next select the 4 columns of data (but not the headings row) in the spreadsheet and copy them (ctrl-c or appropriate). Move to Win92 and select the row where the first of them is to be placed. Plaste the data onto the Win92 screen and check for any errors. Correct any errors and populate any options from the 4 columns we didn't populate.

Repeate this process for the other banks and save the file locally (so you can simply make changes later if needed) and upload the data to your scanner.

Please note that the amount of data you can copy is limited by the Win92 screens (which reflect the scanner limitations). You can only copy up to 50 frequencies per bank. To descide what values to enter in the "Rx Mode" col, simply look at the Win92 values for that field and pick the one that's appropriate. While I didn't provide details, you can populate the talk groups for trunked systems using a similar procedure.
I like your method it seems like it would work wel and yea, ****ing typos. Thanks I will report back on my success =D
Reply With Quote
  #4 (permalink)  
Old 08-08-2011, 2:33 AM
AuToGrApHzZz's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2010
Location: Irvine, CA
Posts: 40
Default

Currently I have only one problem to report. I am having trouble eliminating the channels and frequencies I do not wish to use. On the 201.csv excel sheet I downloaded they are all jumbled together making it hard to just use the LAW-Tac and such channels.
Reply With Quote
  #5 (permalink)  
Old 08-08-2011, 2:41 AM
n5ims's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jul 2004
Posts: 3,634
Default

Quote:
Originally Posted by AuToGrApHzZz View Post
Currently I have only one problem to report. I am having trouble eliminating the channels and frequencies I do not wish to use. On the 201.csv excel sheet I downloaded they are all jumbled together making it hard to just use the LAW-Tac and such channels.
Use the sort features in the spreadsheet if that'll help or simply build a new section and copy/paste the desired lines in one at a time to get things like you want. The advantage of the spreadsheet method is you can play with the data all you want (so long as you keep the rows intact) and then copy only the final set over to Win92.

Good luck and hopefully this'll get you running with much less effort (and grief) than the manual typing method.
Reply With Quote
Sponsored links
  #6 (permalink)  
Old 08-08-2011, 2:46 AM
AuToGrApHzZz's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2010
Location: Irvine, CA
Posts: 40
Default

Ok so far I have everything organized and found I just need to move columns around in spreadsheet which I am not exactly a pro at >.> I'll figure it out though. Thanks so much for ur halp. I wish I could like +rep you or something cuz yea you just saved me from rage quitting on this. I guess I was a little spoiled with my Pro-197 scanner automatically programming lol
Reply With Quote
  #7 (permalink)  
Old 08-08-2011, 2:50 AM
n5ims's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jul 2004
Posts: 3,634
Default

If you know Excel rather well, you may try using the "Filter" function to hide the rows you're not interested in. It's not the easiest option to figure out or understand what it does just from the name, but it is really useful once you work with it a bit.

This option has moved around a bunch version to version (and somewhat changed how it displays), but on my version it's part of the Data menu and about mid-screen on the ribbon-bar. With the filter option active, you have an arrow box on each column heading. Clicking this arrow you can select to display only rows that match the values you have checked. It should help you remove the junk and only show the LAW-Tac or other desired channel types.
Reply With Quote
  #8 (permalink)  
Old 08-08-2011, 3:06 AM
AuToGrApHzZz's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2010
Location: Irvine, CA
Posts: 40
Default

Yea I'm running like 2010 version or something-one of those things that I have but never use. And I just copied it directly from the RR DB and pasted it in. all the columns and what not are in tact but I just need the alpha tag column to be on the far left. Ill chekc out that feature in a second here.
Reply With Quote
  #9 (permalink)  
Old 08-08-2011, 3:17 AM
AuToGrApHzZz's Avatar
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2010
Location: Irvine, CA
Posts: 40
Default

My god. I have done it. I feel...AMAZING. Thank you so much.
Reply With Quote
  #10 (permalink)  
Old 02-05-2013, 3:01 AM
Member
   
Join Date: Feb 2013
Location: Birmingham, AL
Posts: 1
Default

I just want to say thank you for this information. It's accurate and it works. Instead of excel I used Kingsoft's Office suite 6 and Win92, both free, and the files from the premium access...best darn money I've spent in a while.

I'll try to u/l the .xls files when I get through working on them. Could be a while, but that's ok.
Reply With Quote
Reply

Tags
lapd, lasd, pro-92, programming software, syncing

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:20 PM.


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