New CSV Memory Tool (Excel) for AR-DV10

Status
Not open for further replies.

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
Please try the attached. I added an option when writing both the channels and banks files to write ALL rows or just the rows with data.
Was this version also meant to get rid of the error 2015? I didn't change any data, including the firmware version, in your spreadsheet this time. Unfortunately the first line in membk.csv is still Error 2015.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
Actually, I forgot about that. Thanks for the reminder. I'll check that now. Re: having all channels in one bank, I'm stumped on that one. I'll try to load that same file into my radio to see what happens.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
This fixes the error 2015 in the bank file.
 

Attachments

  • AOR AR-DV10 CSV Formatter - Writer (V0.1).zip
    440.1 KB · Views: 67

digiman1

Member
Joined
Aug 9, 2018
Messages
127
Actually, I forgot about that. Thanks for the reminder. I'll check that now. Re: having all channels in one bank, I'm stumped on that one. I'll try to load that same file into my radio to see what happens.
Cheers.. :)
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I tested it. After writing the generated memch.csv and membk.csv to the radio I couldn't scroll through the memory channels by rotating the DIAL selector. By rotating it, sometimes the channel wasn't changed, and sometimes the channel changed from 3 to 7 for example.
This happened again with the latest version. I restored the membk.csv first and after that I restored memch.csv.
I attached both files.
 

Attachments

  • memfiles.zip
    1.8 KB · Views: 34

digiman1

Member
Joined
Aug 9, 2018
Messages
127
Great, so that definitely fixed the Banks filled with blank channels on the DV10.

Came across another issue with banks.
You will see here I have named 2 Banks for Tetra and Marine:
View attachment 148598

I have created the following Channels for bank 00 Tetra:
View attachment 148599

And the following Channels for bank 01 Marine:
View attachment 148600

On My DV10, All the channels go into bank 00 Tetra, there is no Bank 01 in the radio.
I will post my filles in the next post as it wont allow me to upload anything else here.
I should mention, I am clicking No when saving Channels and Banks. Just in case that helps figure out the issues.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I tested it. After writing the generated memch.csv and membk.csv to the radio I couldn't scroll through the memory channels by rotating the DIAL selector. By rotating it, sometimes the channel wasn't changed, and sometimes the channel changed from 3 to 7 for example.
I opened the memch.csv file, generated with your spreadsheet, in AR Memory Data Editor and saved it as mc230922.csv.
I compared the two csv files. There where a lot of differences. After that I compared both files while ignoring white space. Only the first line differed.
After I wrote mc230922.csv to my radio I didn't have the problem quoted above. Buttttttt.....
All the channels of the two banks are in bank 00. AR Memory Data Editor shows that there are 2 banks.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I created two banks from scratch with two frequencies each with AR Memory Data Editor
I generated the memory channel file and wrote it to my radio. After that there where two banks with two frequencies each in my radio.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
This is what I found. I hope it helps. Too tired now to go on with it and draw conclusions:


Because of MC0,05,08 in the second line of your CSV file the radio starts at bank 5 channel 8.
The AOR tool starts at bank 0 channel 0

AOR tool: all banks and all channels in the CSV file

MC2,0,0,0,0,1,1… means that the channel is in use
MC2,0,0,0,0,1,0… means that the channel is NOT in use
 

digiman1

Member
Joined
Aug 9, 2018
Messages
127
This is what I found. I hope it helps. Too tired now to go on with it and draw conclusions:


Because of MC0,05,08 in the second line of your CSV file the radio starts at bank 5 channel 8.
The AOR tool starts at bank 0 channel 0

AOR tool: all banks and all channels in the CSV file

MC2,0,0,0,0,1,1… means that the channel is in use
MC2,0,0,0,0,1,0… means that the channel is NOT in use
Thank you for this.. I will go and have a dig and see how I get on.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I changed the CSV file generated with David's tool.
Generated with David's tool:
SD-BACKUP,MEM CH,AR-DV10,2305AT 2023/09/22 10:42:04
MC0,05,08

I changed it to:
SD-BACKUP,MEM CH,AR-DV10,2305AT,2023/09/22 10:42:04
MC0,00,00

Note the comma after the firmware version. Probably these changes are not important.
But what is important is that David's tool generates
MC2,0,0,0,0,1,1…
for channels that are not in use.
That should be
MC2,0,0,0,0,1,0…

In the attached screenshot you see the file generated with the AOR tool at the left side, and the file generated with David's tool at the right side with the first 2 lines edited.
 

Attachments

  • Screenshot 2023-09-22 at 11.42.30.png
    Screenshot 2023-09-22 at 11.42.30.png
    80.9 KB · Views: 15

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
In the attached screenshot you see the file generated with the AOR tool at the left side, and the file generated with David's tool at the right side with the first 2 lines edited.
Because the image in my previous post was small I post 2 images.
Generated with the AOR tool. Two channels in bank 00.Screenshot 2023-09-22 at 11.57.38.png

Generated with David's tool. First 2 lines in the CSV file edited. Also two channels in bank 00.
Screenshot 2023-09-22 at 11.57.57.png
 

digiman1

Member
Joined
Aug 9, 2018
Messages
127
I changed the CSV file generated with David's tool.
Generated with David's tool:
SD-BACKUP,MEM CH,AR-DV10,2305AT 2023/09/22 10:42:04
MC0,05,08

I changed it to:
SD-BACKUP,MEM CH,AR-DV10,2305AT,2023/09/22 10:42:04
MC0,00,00

Note the comma after the firmware version. Probably these changes are not important.
But what is important is that David's tool generates
MC2,0,0,0,0,1,1…
for channels that are not in use.
That should be
MC2,0,0,0,0,1,0…

In the attached screenshot you see the file generated with the AOR tool at the left side, and the file generated with David's tool at the right side with the first 2 lines edited.
Brilliant observations. I honestly couldn't have went through that, we need more people in the world like you haha. My brain just went numb.

Hopefully David can look at this and implement a fix :)
I was going to go down the AR DATA EDITOR Route to fill up my DV10 but it is by far the absolute worst tool I have ever used for programming, this little Excel that has been created will be an absolute saviour to DV10 owners.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
Maybe there should also always be a valid frequency, step, et cetera in the data of unused channels.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I was going to go down the AR DATA EDITOR Route to fill up my DV10 but it is by far the absolute worst tool I have ever used for programming, this little Excel that has been created will be an absolute saviour to DV10 owners.
I just took some time to understand the help of the AOR tool. Now that I understand what can be done with the AOR tool I think it is a great tool. You can import a CSV file, import a frequency list and use a template file. It has everything I need. I should have taken some time to understand their poorly written help file before. I will use their tool from now on.
 

digiman1

Member
Joined
Aug 9, 2018
Messages
127
I just took some time to understand the help of the AOR tool. Now that I understand what can be done with the AOR tool I think it is a great tool. You can import a CSV file, import a frequency list and use a template file. It has everything I need. I should have taken some time to understand their poorly written help file before. I will use their tool from now on.
Ahh, didn’t realise they had csv import, that’s handy. Will have a look as a stop gap. Cheers
 
Status
Not open for further replies.
Top