I only changed the file extension (.csv to .txt, both flat text files) so it would attach to the forum post.The thing to do then is to just make a small .csv file from, say, the top 5 lines of his file and see if that runs. Can you see his file using Excel just to make sure it's not got corrupted somewhere? When you look at it with Excel all the commas have been changed into blank squares and they must be there or else your R30 will just spit it out. I have one control programme that you have to load the *txt file into Excel and then save it as a *csv - just changing the suffix doesn't work.
Like this....
Note that the entry for squelch varies. It is "0" for the G303 series and "-120" for the G33. It is not possible to make a new entry from the programme into the database, you can only edit an existing one. Therefore it's advisable to make a number of dummy entries in the database. Just enter something in columns A to E and the same data into L, Mand N as already in there. If the date doesn't register properly, check that in "Region and language" the date is set to yyyy-mm-dd. Save the spreadsheet as a TAB delimited text file, then change the *.txt to xls in the RDBM folder.
I assembled a new file based on the first two lines of your file, saved it to the R30 and then exported to csv. Then I compared your file to the one I exported, nothing is in the correct column so that is likely the reason CS-R30 won't read it. I tried just changing the .txt to .csv and also had Excel open the txt file and save it as csv, neither one is accepted by CS-R30. At this point I know how to manually assemble an aero file so that will be next.That's interesting, it is a csv direct from the radio, just renamed so it would post on the forum...
Thanks again, I'll look at that next.I only changed the file extension (.csv to .txt, both flat text files) so it would attach to the forum post.
To be fair, I missed the bit where the OP said they were using the CS-R30 software; I don't and the file provided was exported as a CSV from the radio itself. I have attached a zipped memory channels only file from the radio here...
Hi Mike,You could also try the mailing list at groups.io below and see if folks there are willing to share files
![]()
IC-R30 groups.io Group
This is an interest group for owners of the new Icom IC-R30 handheld receiver, and for those wishing to learn about the product or contribute information about it. **Please note** All individuals involved with, or interested in radio communications are welcome as members. Spam, racism...groups.io
Mike
I can make a small channel export with just one or two in the memories if you like, although what you have should do the job.Thanks again, I'll look at that next.
Been there, done that. Seems like importing, editing and exporting can be fraught with issues with Excel.I can make a small channel export with just one or two in the memories if you like, although what you have should do the job.
one thing to watch out for is that when you import, edit and export a CSV (or text file) in a spreadsheet program you need to be careful about the formats and types it applies to each column of cells. I once had hours of head scratching when it turned out the spreadsheet was exporting 67.0 Hz for a CYCSS tone as 67 even though I had specified one decimal place; getting it to output exact data as text fields fixed that problem.
That’s a common file-locking issue that will occur with most systems and software.The other thing I run into is that CS-R30 does not import the file if it is still open in excel.
one thing to watch out for is that when you import, edit and export a CSV (or text file) in a spreadsheet program you need to be careful about the formats and types it applies to each column of cells.
I thought that's what I said long ago......
I say 'will'! I have done it with files for the Winradio G33 but just make a small file to test it before you go the whole hog with a huge file, but ensure your format is correct. It only takes one small error and it wont work - even something seemingly insignificant like the date in the wrong format.