WiaRep2? By Steve Ireland VK2MD 'Sept 2013 Added support for UV6 Commander 'Version 1.4 Sept 2013 Callsign filtering bug. 1 call area filter now works 'Version 1.3 Feb 2013 Script now ignores blank lines 'Version 1.2 July 2012 Added the /f filter to limit output to a list of states 'Version 1.1 June 2012 Fixed mismatched header columns and repeater columns, Added another sections 'Version 1.0 March 2012 - Original Copyright (c) Steve Ireland 2012 Technical enquiries regarding the operation of these scripts should be sent to vk2md(at)wia.org.au. Replace the (at) with @. 1 Nutshell. In a nutshell these scripts allow you to import the WIA Repeater csv file into you radio without having to rekey all the information. You can update your radio every time a new file is released. The scripts have been designed for hobbyists to be able to easily change and modify. The choice of VB Script was solely for this purpose. A great blog on how to set up Visual Studio for VB Script development can be found at http://krestenm.blogspot.com.au/2007/12/vbscript-projects-in-visual-studio2.html This was how these scripts were developed. The output directory that is included in this zip file contains pre-cooked data files that can be used straight away. 2 Intro. This zip file contains 4 vb script files that load and manipulate the WIA Repeater csv file. This file contains an updated list of all repeaters in Australia and it can be downloaded from http://www.wia.org.au/members/repeaters/data. The file name is usually "Repeater Directory YYMMDD.csv" and is usually at the absolute bottom of the page. To run all of this scripts the general command line is cscript WiaRep2???.vbs "Repeater Directory YYMMDD.csv" + Extra commands as per script You can pipe the output to a text file by adding >wiarep.txt to the end 3 The Utilities. WiaRep2Text.vbs A training script to show how to access the in memory structure that is created in all of the scripts The main goal is not really to understand how I create the structure, though it is there for all to see, but to access the information held in the memory structure. The example shows access via enumeration (For Each) and classic For loops. The output on the screen or in the piped text file is not very pretty :-) If you understand this file then you should be able to write your own utilities. A recent addition has been the /f filter that limits the output to a list of states. You can reduce the number of entries displayed by using /f:vk1,vk2,vk3 Make sure that there are NO spaces as shown. Example command line cscript WiaRep2Text.vbs "c:\Wia\Repeater Directory 120311.csv" To filter cscript WiaRep2Text.vbs "c:\Wia\Repeater Directory 120311.csv" /f:vk1,vk2,vk3 WiaRep2Verify.vbs In creating the scripts it was quickly found that sometimes the "Repeater Directory YYMMDD.csv" file has a few inconsistancies. These include wrong repeater offsets, spaces in wrong places, Bad Tone values etc etc. This script inspects the "Repeater Directory YYMMDD.csv" file and reports any inconsistancies. Hopefully the WIA will use this script as a final QA before publishing a csv file :-) Again a good training script. Example command line cscript WiaRep2Verify.vbs "c:\Wia\Repeater Directory 120311.csv" WiaRep2ID880.vbs (Top utility for ICOM ID880 owners) This script converts "Repeater Directory YYMMDD.csv" into a number of csv files that are able to be imported into an ICOM ID880. It doesn't create an icf file, but Icoms free CS80 software at last allows the import from csv file into a bank. The files produced cover vhf, uhf and dstar repeaters. Important. Make sure that you get the current configuartion from the radio and save as an icf file. Import the data from the csv into this configuration and then write to the radio. This ensures that the manual settings in the radio are not overwritten with junk. Each ID880 file can contain a maximum of 100 entries so the software will create files like id880vhf0.csv, id880vhf1.csv, id880uhf0.csv and id880dstar0.csv. Additionally the script, by default, only fills 90 places in each output csv file and leaves 10 spaces for manual editions. You have the script file so you can change it to totally fill up the space if you like. This script also has a /c option. By adding this only 3 files are created id880vhf0.csv, id880uhf0.csv and id880dstar0.csv that contain all entries for each band. You can then open each file in your favorite spreadsheet and manipulate the entries how you like. One common use would be to prune out all of the states that you are not interested in loading into the radio. The radio has plenty of memory so I always add the whole of Australia. If you do prune remember to renumber the list (look up the =Line() command in Excel) or just tailor your script to say output only the VK5 entries into the csv file. Easy! A recent addition has been the /f filter that limits the output to a list of states. This means if you only travel up and down the eastern states or have a limited memory in your radio you can reduce the number of entries by using /f:vk1,vk2,vk3 Make sure that there are NO spaces as shown. The final thing you need to do manually is to go into CS80 and reassign banks to memories. This takes me about 15 minutes but it is a pain. I have asked ICOM to add the bank into the CSV file so we will see if this happens. Hint I leave the lowest bank of 100 memories on my ID880 for the manual entry (actually spreadsheet import) of all the repeaters in my local area. I get the information for this lower bank by harvesting all of the generated csv files. Example command lines cscript WiaRep2ID880.vbs "c:\Wia\Repeater Directory 120311.csv" id880.csv To concatanate files use cscript WiaRep2ID880.vbs "c:\Wia\Repeater Directory 120311.csv" id880.csv /c To filter cscript WiaRep2ID880.vbs "c:\Wia\Repeater Directory 120311.csv" id880.csv /f:vk1,vk2,vk3 You can filter /f and /c at the same time /f:vk1,vk2,vk2 /c in any order WiaRep2Chirp.vbs (Top utility for owners of radios that Chirp supports) The "Pièce de résistance" is this script. This produces a file that can be imported into chirp (http://chirp.danplanet.com/) From the Chirp Website CHIRP is a FREE cross-platform, cross-radio programming tool. It works on Windows and Linux (and MacOSX with a little work). It supports a growing list of radios across several manufacturers and allows transferring of memory contents between them. Any radio that is supported by chirp can load this file. A recent addition has been the /f filter that limits the output to a list of states. This means if you only travel up and down the eastern states or have a limited memory in your radio you can reduce the number of entries by using /f:vk1,vk2,vk3 Make sure that there are NO spaces as shown. Example command lines cscript WiaRep2Chirp.vbs "c:\Wia\Repeater Directory 120311.csv" chirp.csv To filter cscript WiaRep2Chirp.vbs "c:\Wia\Repeater Directory 120311.csv" chirp.csv /f:vk1,vk2,vk3 WiaRep2UV6DCommander.vbs This script produces a CSV file that is supported for import by the UV6Commander software. See http://www.kc8unj.com/kguv6.html 4. Licence Copyright (c) Steve Ireland 2012 WiaRep2????.vbs and all other variants that start with WiaRep2 were originaly written by Steve Ireland VK2MD (vk2md(at)wia.org.au) This application can be freely distributed, modified and used by anybody for both private and commercial purposes. If you make changes to the software please add the statements above to your source code to achnowledge Steve Ireland VK2MD as the original author and to freely distribute your software. Please Please Please do not use the file name prefix WiaRep2 or WiaRepTo as I use this prefix on software that I maintain. In essance the naming convention is the only intellectual property that I assert purely for maintenance purposes. Have fun. Steve March 2012 Enjoy Steve Ireland VK2MD July 2012