Nov 7 2017
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.
XlsToCsv.vbs 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>" Wscript.Quit End If csv_format = 6 Set objFSO = CreateObject("Scripting.FileSystemObject") src_file = objFSO.GetAbsolutePathName(Wscript.Arguments.Item(0)) dest_file = objFSO.GetAbsolutePathName(WScript.Arguments.Item(1)) Dim oExcel Set oExcel = CreateObject("Excel.Application") Dim oBook Set oBook = oExcel.Workbooks.Open(src_file) oBook.SaveAs dest_file, csv_format oBook.Close False oExcel.Quit
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); P.WaitForExit(); //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 Assert.AreEqual(0, result);
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-817ND
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. 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:
- Yeasu FT-817ND (semi-duplex mode)
- Laptop with Airspy Mini and SDR-Console v3 software. I have tried a Windows Tablet (Lenovo Miix, see below) and I think it was no option compared with an regular laptop.
Lenovo Miix 320 Windows 10 tablet. Tested with RTL-SDR v3. Have not got it to work with Airspy mini.
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.
Why SDR and Windows laptop 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. But, there seems to be a lot to carry around. Shame the FT-817 is not full duplex…
- 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… Maybe try one of the Moxon designs.
- Duplex filter if needed.
DIY EFLW (End Feed Long WIre) dipole via a 9:1 UNUN, aprox. 16,5 meter long. Will need an ATU for this antenna.I haved tried a homemade EFHW without success and will in the future maybe try one of the SOTA Beams antenna designs.
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.