Help converting TinySA csv file for Wireless Workbench
Hey
I recently purchased a TinySA Ultra for use with IEM's. I am struggling to clean the CSV files and format them in a way that Wireless Workbench will accept. I've spent many hours poking around online and trying stuff, but nothing so far has worked and many of the resources I assume are out of date at this point. Here are some more details and what I have tried so far, any guidance would be greatly appreciated.
SEESII TinySA Ultra+
Tried exporting csv to SD card and putting straight into WWB, didn't work (didn't expect it to either but have heard reports that for some people it does, so just wanted to rule it out).
I tried connecting the TinySA Ultra via USB to RForAll and scanning via the app. This worked just fine, but then I exported a file formatted for WWB, and WWB did not accept it.
I've tried using SoundBase to clean the csv, but after filling out the relevant fields from the upload popup, clicking "Preview and Upload" does nothing. No error, just doesn't seem to process at all.
I got a free trial of Excel and tried to use a macro I found online to convert the csv to one WWB would accept, but I get a "type mismatch" error. The macro is from 2023 from a user "Jason Glass," who posted the macro around a few different places. Folks in the replies say it works but it was from a while ago now so not sure.
I've tried running a powershell script to convert it. This didn't work either but I am almost certainly doing something wrong. I am on Mac and have never done this before.
After examining the WWB guidelines for what is an accepted format, it looks like the main things tripping it up are the title, periods instead of commas, and decimal points in the second column. Just as an experiment I loaded one of the csv's into Numbers, took the first 10 rows, got rid of the title, split columns by comma and axed all decimals in the second column, and even that was rejected by WWB.
This is all pretty new to me - is there something glaringly obvious that I'm misunderstanding? Does anyone have guidance for one or multiple of the above approaches for getting WWB to read this file?
Thanks