Has anyone found a fairly easy way to convert the SDR# frequencies.xml file to .xlsx or .csv, edit it, and then convert it back to .xml so that SDR# can use it?
SDR# convert "frequencies.xml" to spreadsheet, and back to .xml
- Thread starter W4KRR
- Start date
- Status
I carefully used an xml editor a while back to edit a bunch of stuff in my sdr#. Have you tried an xml editor? It's a good idea to back up the xml prior to any editing.
Ubbe
Member
I use Notepad in Windows. It's difficult to simplify more than it already are and I feel it's easy to edit in a text editor, if I want the frequencies in a different order or add some extra by doing copy&paste and then edit the frequency. Notepad++ has a xml editor but to me it takes a longer time to edit and feels more complicated.
/Ubbe
/Ubbe
Yes, I have used an xml editor to convert the xml file. But what about converting it back into xml? Is it as easy as just changing the file extension?
If your editing the xml there is no conversion.
If you hit save, it saves it in the format it was opened in. If you hit save as, these are the choices.
I always just hit save.
If you hit save, it saves it in the format it was opened in. If you hit save as, these are the choices.
I always just hit save.
Correct; I can use Notepad or Notepad++ to edit "frequencies.xml". But if I want to add a long list of new frequencies, or change a group of settings, the Notepad or Notepad++ method is no good. This is why I asked about converting to a spreadsheet, where the data would all be in columns for easy editing. Notepad is only good for editing small amounts of data at a time.
- Joined
- Aug 2, 2013
- Messages
- 2,567
- Reaction score
- 1,653
I don't have any sample XML, but what about something online?
For adding a bunch of freqs, I see your point. I had used it to change a ton of bandwidth settings a while back and used the replace feature.
Searched the desired value and set the desired one. For stuff like that the editor was a breeze.
I will poke around as I have a ton of radio id's in Unitrunker v2 that I would like to get into Sentinel/Proscan, sdrtrunk and DSDPlus radio files.
Searched the desired value and set the desired one. For stuff like that the editor was a breeze.
I will poke around as I have a ton of radio id's in Unitrunker v2 that I would like to get into Sentinel/Proscan, sdrtrunk and DSDPlus radio files.
That might work. I will try playing around with it and see if it will do what I'm after.
Just back up the original file before trying to edit. I learned the hard way a few years ago.
Ubbe
Member
It works converting to csv and use in Excel and edit and then convert back to xml using belvdr's link.
You will have to find&replace the lines that says "root" to "ArrayOfMemoryEntry" and the lines with "row" to "MemoryEntry"
/Ubbe
You will have to find&replace the lines that says "root" to "ArrayOfMemoryEntry" and the lines with "row" to "MemoryEntry"
/Ubbe
After fiddling around with this for a while, I found a method that seems to work.
Open "frequencies.xml" in Excel. You will get a pop-up box with three options. Select "Open as an xml table".
You will see a spreadsheet with all the data in columns, which you can then edit as desired.
When done, click "Save As" and "Save as type", and choose "xml data" as the type. Ignore any messages about losing worksheet features.
This seems to work, and it's fairly simple.
Open "frequencies.xml" in Excel. You will get a pop-up box with three options. Select "Open as an xml table".
You will see a spreadsheet with all the data in columns, which you can then edit as desired.
When done, click "Save As" and "Save as type", and choose "xml data" as the type. Ignore any messages about losing worksheet features.
This seems to work, and it's fairly simple.
- Status
