RadioReference on Facebook   RadioReference on Twitter   RadioReference Blog
 

Go Back   The RadioReference.com Forums > Scanners and Receivers Forums > Uniden Forums > Uniden Software Discussion

Uniden Software Discussion Topics shall be specific to Uniden produced software though third party non-programming software is permitted. Please see the Software category for all third-party programming software.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-07-2014, 10:28 AM
theaton's Avatar
Member N7VU
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2004
Location: A mountaintop
Posts: 611
Arrow Free software: BCDx36HP WAV Header Reader

BCD436HP WAV Header Reader

I wrote an Excel workbook that reads the headers of WAV files generated by BCDx36HP scanners and lists the most useful fields in worksheets. It will read the files in multiple folders--starting with a selected file and reading that and all files with later dates. Included in this version are some test sheets that list the raw header data and a full complement of fields.

Feel free to try this out and report any problems or suggestions. Future versions will rename the files and sort them into a useful directory structure for easier review.

Thanks goes to Jay911 for troubleshooting the program and providing a lot of the fields listed on the Main page.

Enjoy!

-Tim
__________________
Scanning Mountaintop to Mountaintop...
Reply With Quote
Sponsored links
        
  #2 (permalink)  
Old 03-07-2014, 9:05 PM
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: May 2003
Location: Chester County, PA
Posts: 143
Default Audio Metadata

Great news. Will give it a try! Thank you!
Reply With Quote
  #3 (permalink)  
Old 03-08-2014, 7:00 AM
rjdj2000's Avatar
Member
  Audio Feed Provider
Audio Feed Provider
 
Join Date: Jan 2011
Location: Homer, NY
Posts: 70
Default

theaton - Just tried your little excel spreadsheet on some recordings I did awhile back when I first got the 536. Worked great and is a nifty little thing. Puts everything that I can think of right into a sheet.
__________________
Scanners: BCD536HP
3 R820T Dongles for Online Stream - Cortland County Public Safety
Reply With Quote
  #4 (permalink)  
Old 03-08-2014, 8:30 AM
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2002
Location: ZZV - Ohio
Posts: 702
Default

Can you save it as an .xls rather than xlsb ? I'm an Oppenoffice user and it refuses to load it.

Thanks
__________________
HP-1 x2 , BC780, BCD996, Pro 2005, 2006, AT803,R5000
and other RF capture devices
-Remember Bill Cheek -
Reply With Quote
  #5 (permalink)  
Old 03-08-2014, 6:42 PM
theaton's Avatar
Member N7VU
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2004
Location: A mountaintop
Posts: 611
Default

Quote:
Originally Posted by phask View Post
Can you save it as an .xls rather than xlsb ? I'm an Oppenoffice user and it refuses to load it.

Thanks
Sure, here it is: http://apps.usd.edu/esci/programs/BC...der Reader.xls

It is five times bigger than the xlsb version.

-Tim
__________________
Scanning Mountaintop to Mountaintop...
Reply With Quote
Sponsored links
  #6 (permalink)  
Old 03-08-2014, 9:21 PM
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2002
Location: ZZV - Ohio
Posts: 702
Default

Quote:
Originally Posted by theaton View Post
Sure, here it is: http://apps.usd.edu/esci/programs/BC...der Reader.xls

It is five times bigger than the xlsb version.

-Tim
Thanks - but the macro fails on OO.

I have a couple older machines withe Excel I'll need to try.
__________________
HP-1 x2 , BC780, BCD996, Pro 2005, 2006, AT803,R5000
and other RF capture devices
-Remember Bill Cheek -
Reply With Quote
  #7 (permalink)  
Old 03-09-2014, 7:27 PM
t_shuffle's Avatar
Member
   
Join Date: Jan 2006
Location: Fair Oaks, CA
Posts: 90
Default

I wanted to try this and see if it worked with HP1 created WAV files, but like phask, I'm an Open Office user, and I get a script error when when I press the Import button.
__________________
Wanted: Scan button for my HP-1. Willing to trade Atten button in like-new condition.
Reply With Quote
  #8 (permalink)  
Old 03-09-2014, 7:32 PM
theaton's Avatar
Member N7VU
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2004
Location: A mountaintop
Posts: 611
Default

I don't know enough about Open Office to help. Are any macro or VBA functions supported?
__________________
Scanning Mountaintop to Mountaintop...
Reply With Quote
  #9 (permalink)  
Old 03-09-2014, 9:36 PM
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2002
Location: ZZV - Ohio
Posts: 702
Default

It has some scripting/Macro - but I've never explored them. I've used spreadsheets since Lotus123 days, but since I retired I have no desire to do any more than necessary with it
__________________
HP-1 x2 , BC780, BCD996, Pro 2005, 2006, AT803,R5000
and other RF capture devices
-Remember Bill Cheek -
Reply With Quote
Sponsored links
        
  #10 (permalink)  
Old 03-09-2014, 9:51 PM
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jan 2003
Location: Tucson, AZ
Posts: 283
Default

I've tried it in Office 2010 and Office 2013 and I get an invalid procedure call error when I click on Import as well. Everything is configured properly in References.

This is the line that is highlighted in Debug: "ImportForm.Show 'Open internal Common Dialog Box -- returns only filename (not directory) if in directory from previous selection"
__________________
Uniden BCD436HP
Reply With Quote
  #11 (permalink)  
Old 03-10-2014, 12:59 AM
theaton's Avatar
Member N7VU
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2004
Location: A mountaintop
Posts: 611
Default

Quote:
Originally Posted by kd7eir View Post
I've tried it in Office 2010 and Office 2013 and I get an invalid procedure call error when I click on Import as well. Everything is configured properly in References.

This is the line that is highlighted in Debug: "ImportForm.Show 'Open internal Common Dialog Box -- returns only filename (not directory) if in directory from previous selection"
Odd. That's the first line in the routine--an instruction to open the only form in the program. Were you using the xls or xlsb version?

-Tim
__________________
Scanning Mountaintop to Mountaintop...
Reply With Quote
  #12 (permalink)  
Old 03-10-2014, 3:48 PM
Member
  Amateur Radio Operator
Amateur Radio
 
Join Date: Jan 2003
Location: Tucson, AZ
Posts: 283
Default

Quote:
Originally Posted by theaton View Post
Odd. That's the first line in the routine--an instruction to open the only form in the program. Were you using the xls or xlsb version?

-Tim
I have tried both versions and got the exact same debug return.
__________________
Uniden BCD436HP
Reply With Quote
  #13 (permalink)  
Old 03-13-2014, 5:29 PM
troymail's Avatar
Member
   
Join Date: Dec 2002
Location: Anne Arundel County, MD.
Posts: 3,667
Default

I'm getting Runtime Error '5'
__________________
PSR800 x 2 | PSR500 | PRO96!
BCD536 | BCD436 | BCD396T | BC296D | BC245XLT | BC600XLT | BCIV | VX-8R
Not a Radio Shack fan.....
Reply With Quote
  #14 (permalink)  
Old 03-13-2014, 7:23 PM
Ghstwolf62's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: May 2006
Location: Clifton Forge Virginia
Posts: 521
Default

I don't know if it will be any help but when I opened the program and tried to click on Import it wouldn't work. It took me a few minutes to see a small line at the top of the data fields saying that Excel has prevented the working of the button with an allow or protect me choice for options.

Once I clicked allow it worked great. Until I saw the little writing it didn't work at all. And its really little and has nothing to make it stand out for visibility.
__________________
KJ4KFW
One of the few in the world apparently with radios & scanners that actually work like they're supposed to.
Reply With Quote
  #15 (permalink)  
Old 03-15-2014, 7:26 PM
theaton's Avatar
Member N7VU
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2004
Location: A mountaintop
Posts: 611
Default

Quote:
Originally Posted by Ghstwolf62 View Post
I don't know if it will be any help but when I opened the program and tried to click on Import it wouldn't work. It took me a few minutes to see a small line at the top of the data fields saying that Excel has prevented the working of the button with an allow or protect me choice for options.

Once I clicked allow it worked great. Until I saw the little writing it didn't work at all. And its really little and has nothing to make it stand out for visibility.
Thanks for this observation. Security notifications are browser-specific, but I will add a note about this in the instructions for the next version.

-Tim
__________________
Scanning Mountaintop to Mountaintop...
Reply With Quote
Sponsored links
  #16 (permalink)  
Old 03-16-2014, 7:17 PM
Ghstwolf62's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: May 2006
Location: Clifton Forge Virginia
Posts: 521
Default

Quote:
Originally Posted by theaton View Post
Thanks for this observation. Security notifications are browser-specific, but I will add a note about this in the instructions for the next version.

-Tim
NP
One thing though. I was not running it in a browser of any kind. When I double clicked the program it opened automatically in MS Excel.

Going back into it just now I can give you more info.

It says "Security Warning" "Macros have been disabled" then an "Options" box which has protect me or allow in it.

Sorry my first wasn't as informative as it should have been. It was from memory rather than actually checking it again. I also notice it does it each time you open the program.

I don't know for sure but it seems to be an Excel thing rather than a problem or anything with your program.
__________________
KJ4KFW
One of the few in the world apparently with radios & scanners that actually work like they're supposed to.
Reply With Quote
  #17 (permalink)  
Old 04-28-2014, 3:24 PM
Steve2003's Avatar
Member
  Shack Photos
Shack photos
Premium Subscriber
Premium Subscriber
 
Join Date: Dec 2002
Location: Colorado
Posts: 610
Default

Theaton,
I am having problems when I click "import files" and get the following error:

Run-time error '5':
Invalid procedure call or argument

I have checked my references per the instructions and have the following checked:

(click to enlarge)

Here is the line giving the error when I debug:

(click to enlarge)

Any thoughts?
__________________
MNN-077
Reply With Quote
  #18 (permalink)  
Old 04-28-2014, 4:31 PM
theaton's Avatar
Member N7VU
  RadioReference Database Admininstrator
Database Admin
Amateur Radio Operator
Amateur Radio
 
Join Date: Sep 2004
Location: A mountaintop
Posts: 611
Default

Steve2003,

The problem seems to be with the "Microsoft Forms 2.0 Object Library" reference since it crashes on the first line of code that invokes that library. I wrote my own file browser to avoid these sorts of problems, but I guess nothing can compensate for Microsoft.

I have that library set as the lowest priority (the lowest checked box). You could search your reference options for another version. I don't know what else to suggest.

-Tim
__________________
Scanning Mountaintop to Mountaintop...
Reply With Quote
  #19 (permalink)  
Old 08-09-2014, 1:43 AM
Member
   
Join Date: Feb 2004
Posts: 176
Default

I'm way late to this thread. I couldn't get open office working either. However, I put together a simple bash script (linux) that could probably be made to work in windows. I may not have all the field widths done correctly, but the code is trivial to rewrite. No compiler is needed.

Put all the wav files in one directory. The script will find all the files and create a csv file called "out". You can then sort the list in open office.

Reading the code is trivial. DD is set up to copy specific sections of the file based on "skip" and "count". Obviously "skip" that number then copy the "count". "TR" removes the unprintable chafacters. Echo just inserts the commas.

-------------------------------------------------------
#!/bin/bash
touch out
for i in *.wav; do

# IART-System name begins in position 33 and is 64 characters wide
dd skip=32 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# IGND - Department name
dd skip=104 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# INAM - Channel name
dd skip=176 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# ICMT - Mystery number
dd skip=248 count=8 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# IPRD - Scanner name
dd skip=320 count=16 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# IKEY - realted to system name
dd skip=346 count=16 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# ICRD - Closing date/time
dd skip=376 count=12 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# ISRC - Tone or NAC
dd skip=400 count=16 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# ITCH - Unit ID
dd skip=424 count=16 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# ISBJ - Favorite List Name
dd skip=497 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# ICOP
dd skip=568 count=16 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# Favorite List block
dd skip=592 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# System Block
dd skip=657 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# Department block
dd skip=722 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# Channel Block
dd skip=787 count=64 bs=1 if=$i | tr -cd '\40-\176' >>out
echo -n "," >>out
# Site block
dd skip=852 count=64 bs=1 if=$i| tr -cd '\40-\176' >>out
echo -n "," >>out
# TGID
dd skip=917 count=16 bs=1 if=$i| tr -cd '\40-\176' >>out
echo " " >>out

done
--------------------------------------
Reply With Quote
  #20 (permalink)  
Old 08-09-2014, 12:27 PM
joeuser's Avatar
Member
  Shack Photos
Shack photos
Premium Subscriber
Premium Subscriber
 
Join Date: Feb 2014
Location: North Central Kansas
Posts: 651
Default

Anyone tried Libre Office?
__________________
-BCD436HP,BCD996XT,BC780XLT(x2),UBC780XLT -DX-440,Pro-21A -Pro-197(x4),Pro-164(x2) -Trident TRX-100XLT | UV-5R w/ NA-771(x2) | R820T(x2), UniTrunker, DSD+ | -RG-8/U -Discone & ST2 @ ~1600ft elevation
Reply With Quote
Reply

Tags
wav header reader excel

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 5:10 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2014, 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