Nov 7 2017
About Lars Thunberg
Posts by Lars Thunberg:
Sep 4 2017
In my current assignment / project we are running regression tests of text, csv and excelfiles. The system is based on .NET / C# and daily builds. Every night the checked in developed code is built and the system is built up from scratch. A number of output files should be the same as the day before i.e. regression test.
For C# there are a lot of ready solutions for comparing (diffs) excel files but we had no such at hands. We needed to built this on our own.
First I needed to convert excel files to csv files in order to make an easy compare/diff. For this I’m using a Visual Basic script that has been published on many sites.
if WScript.Arguments.Count < 2 Then
WScript.Echo "Please specify the source and the destination files. Usage: ExcelToCsv <xls/xlsx source file> <csv destination file>"
csv_format = 6
Set objFSO = CreateObject("Scripting.FileSystemObject")
src_file = objFSO.GetAbsolutePathName(Wscript.Arguments.Item(0))
dest_file = objFSO.GetAbsolutePathName(WScript.Arguments.Item(1))
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Open(src_file)
oBook.SaveAs dest_file, csv_format
To use it just ”Please specify the source and the destination files. Usage: ExcelToCsv <xls/xlsx source file> <csv destination file>”. You can call it from C# in the same way as you diff files (see below).
In order to diff files I use the FC tool in windows and call this from C# with Process.start. Here is a sample code:
string strCmdText = "/C c:/Windows/system32/fc /L ";
Process P = Process.Start("CMD.exe", strCmdText + fileno1todiff + fileno2todiff);
//Exit codes from the differ
// -1 – Your syntax is incorrect.
// 0 – Both files are identical.
// 1 – The files are different.
// 2 – At least one of the files can’t be found.
int result = P.ExitCode;
//Make an assert check
So this is a simple way to regression test excel files in C# with simple scripts.
Aug 24 2017
I used to very good software WXtoImg and the RX with my tracking VHF yagis for 145 MHz are perfect! Also it is possible with my Crossed Yagi for 145 MHz.
This is the WXtoImg software:
Below is a picture received with my Yagis from NOAA-18:
Below is a picture received with my Crossed Yagi from NOAA-19:
Aug 8 2017
I’m planning to upgrade my current RX satellite setup to include a portable equipment for making satellite QSOs while going on road trip. Please feel free to comment – anything that should be changed or added? One very good link/article about a portable setup is this one from Ivo Klinkert, PA1IVO.
- Yeasu FT-817(ND)
- Bluetooth CAT interface to be able to control the radio from PC or Android
Why the FT-817? It seems to be the only all-mode transceiver that you could use and carry a couple of hours without a big and heavy battery. My plans are to control the frequency direct via the radio or via an Android app or via PC (see receiver). If I skip the receiver part (see below) I can run semi-duplex.
Same useful add-ons for the FT-817 that I would like to have:
- CHUWI Hi12 Tablet or Hi10 Plus tablet, both Windows 10 with good battery life. Hi10 has only USB-C so an adapter is needed but is smaller then the Hi12.
- Airspy Mini
- SDR Console V3
Why SDR and Windows Tablet as receiver? Because I love the SDR functions, I can listen with full duplex, use the doppler correction and satellite function in SDR Console V3. The CHUWI Tablets seems to be OK to carry around.
- DIY Arrrow-style hand-held yagi with both VHF and UHF. I guess I will use the WA5VJB design as I have built these antenna before. Or I just buy one new Arrow…
- No duplex filter as I have separate RX and TX (se above…)
- DIY EFHW (End Feed Half Wave) dipole via a 9:1 UNUN, aprox. 16,5 meter long.
Why this antenna? I have seen many articles about this antenna as a very good low-cost portable HF longwire. Will try it…
And a simple FM sat setup…
- My current Baofeng UV-5R
- DIY Arrrow-style hand-held yagi
- A duplex filter as the UV-5R only have one antenna jack.
Dec 5 2016
Virtual Radar Server is a great software for ADSB airplane tracking. It is possible to install and run Virtual Radar Server on RaspberryPi, but the following has to be noted:
- Do not install Mono via RaspberryPi default package manager. This will not work (read more here).
- Install via the Mono Linux installation instructions.
- Now, continue the setup according to Virtual Radar Server setup page.
Feb 8 2016
Jag har haft besök från KTHs MIST-projekt. Läs mer här: